Category Archives: develop

Dot.Net and PowerShell

PS C:\Users\IBM_ADMIN> [IO.Path]::GetTempPath() C:\windows\TEMP\

Posted in develop | Tagged , | Leave a comment

SQL Connectivity Behavior

Connecting over the Network By default, the default protocol for SQL Server clients is TCP/IP. If the connection cannot be made using TCP/IP, the other enabled protocols are attempted. A shared memory connection cannot be made over a network. Use … Continue reading

Posted in develop | Tagged , | Leave a comment

Set an environment variable to the current working directory

The current directory is in the “shadow” variable cd called var. set “var=%cd%” set var

Posted in develop | Tagged , | Leave a comment

Remotely setting network credentials using cmdkey

https://powershell.org/forums/topic/remotely-setting-network-credentials-using-cmdkey/ I have a task to automate the build on Azure VM with custom extension scripts. One of the tasks of the custom extension scripts is to map network drives [and save its credentials]. The custom extension scripts are automatically … Continue reading

Posted in develop | Tagged , , , , | Leave a comment

C# Fundamentals

https://www.pluralsight.com/courses/csharp-fundamentals-csharp5

Posted in develop, Uncategorized | Tagged , , , | Leave a comment

SQL Server 2016 SP1

https://blogs.msdn.microsoft.com/sqlreleaseservices/sql-server-2016-service-pack-1-sp1-released/   Understanding Incremental Servicing Model for SQL Server A CLONED database always contains the schema and the default clone also contains the statistics and query store data. For more information refer KB 3177838. How to determine the version, edition and update level … Continue reading

Posted in develop, Uncategorized | Tagged , , | Leave a comment

Update assemblyinfo.cs for a maintenance release

Function update_assemblyinfo_cs($path) { #[Console]::OutputEncoding = [Text.UTF8Encoding]::UTF8 LogWrite “#####################################################” LogWrite “### Update the assemblyinfo.cs files              ###” LogWrite “#####################################################” $stanzaToFind = “BUILD_TSM_V” + $global:version + $global:release + $global:level $oldStanzaToFind = “BUILD_TSM_V” + $global:previousVersion + $global:previousRelease + $global:previousLevel Get-ChildItem $path -Recurse -Filter “assemblyinfo.cs” … Continue reading

Posted in develop | Tagged , , | Leave a comment