Category Archives: develop

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

https://social.msdn.microsoft.com/Forums/vstudio/en-US/5e3e21ca-c9e6-494f-8b57-51158b6db0f6/any-fix-for-the-msb3491-could-not-write-lines-to-file?forum=msbuild How do i fix the error MSB3491    Could not write lines to file “D:\code\..\tools\optimized\obj811\amd64\Tools\Tools.tlog\Tools.lastbuildstate”. Could not find a part of the path ‘D:\some-path\tools\optimized\obj811\amd64\Tools\Tools.tlog\Tools.lastbuildstate’ ? C:\Program Files (x86)\MSBuild\Microsoft.Cpp\v4.0\V140\Microsoft.CppBuild.targets    312 Indeed Tools.tlog does not exist. Solution: It looks it works after … Continue reading

Posted in develop | Tagged , , | Leave a comment