Cannot Install Windows SDK :(

  You try to install latest Windows SDK and it does not work. If you look at the setup log file and you see: 8:58:43 AM Wednesday, June 27, 2012: C:\WinSDK\Setup\SFX\vcredist_x64.exe installation failed with return code 5100 Reason for this is you have a newer C++ runtime installed on your machine, for example by Visual…

0

Windows Diagnostics with Windows Azure Issue

  Windows Azure Diagnostics does not work, you see following in the Compute Emulator => [Diagnostics]: Error starting diagnostics: System.FormatException: Invalid account string.    at Microsoft.WindowsAzure.CloudStorageAccount.<Parse>b__0(String err)    at Microsoft.WindowsAzure.CloudStorageAccount.ParseStringIntoSettings(String s, Action`1 error)    at Microsoft.WindowsAzure.CloudStorageAccount.TryParse(String s, CloudStorageAccount& accountInformation, Action`1 error)    at Microsoft.WindowsAzure.CloudStorageAccount.Parse(String value)    at Microsoft.WindowsAzure.Plugins.Diagnostics.DiagnosticsAgentManager.<StartAgent>b__0()   Reason?  The reason is a connecting string parsing bug in Microsoft.WindowsAzure.Plugins.Diagnostics.ConnectionString =>…

0

Enabling Advanced Driver Tracing for the SQL Native Client ODBC Drivers

  If you are using the SQL Native Client ODBC driver, there is built-in high performance very detailed driver tracing, here is how you use it. #1. Create batch file to start tracing (this traces for all three versions of SQL Native Client ODBC Driver) named StartSNACTrace.cmd: @echo off echo Starting SNAC tracing… echo {BA798F36-2325-EC5B-ECF8-76958A2AF9B5}…

2

PowerShell Command Separator Is ; and Not &

  Ahh PowerShell, I still cannot fully embrace your powerful weirdness. With normal NT command prompt I can restart my SQL Server by running => net stop mssqlserver  & net start mssqlserver This does not work in PowerShell, you get the usual cryptic, nonsensical and useless error message: PS C:\> net stop mssqlserver & net…

6

Disabling => CLRDLL: No CLR image loaded (i.e. mscorwks.dll)

I’m debugging using the Debugging Tools For Windows (WinDbg).  Debugging a native C++ process (no CLR loaded). I find with every debugger command I run, I get annoying amounts of debugger logging spew saying “CLRDLL: No CLR image loaded (i.e. mscorwks.dll)”. For example, when I dump a call stack I see: 0:000> kC CLRDLL: No…

0

Calculating read_only_routing_url for AlwaysOn

  When setting up read-only routing for SQL Server AlwaysOn, you have to configure each availability replica with a read-only routing URL. The read-only routing URL is just a “pointer” to the replica and determines what the replica will report back to the client driver when routing to the replica. Suppose you have an AlwaysOn…

9