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