Pause SQL Server Service Before Restarting
By pausing the SQL Server service before restarting the instance we allow end users to continue their work uninterrupted and we also stop any new connections to the instance.
microsoft
SQL 2016 Perform Volume Maintenance Task
This is a welcome addition to the install for SQL Server 2016 that I had not seen mentioned previously (you can find lots of posts about the new tempdb options, for example).
HOW TO: Change the Compatibility Level of an Azure SQL Database
Here’s an example of something I came across for Azure SQL Database V12 that I don’t see documented anywhere (yet): You can change the compatibility level of an Azure SQL Database.
The Problem With SQL Azure
The problem with SQL Azure is that it’s not named SQL Azure. It used to be named SQL Azure, but in May of 2012 Microsoft announced that after 2 years of branding efforts they were going to put all their eggs into the Windows Azure basket. In doing so, SQL Azure became known as SQL Database. … Read more
Rebooting the MCM Program Using an RV and an Endless Supply of Chicken Wings
Last week Microsoft killed their Certified Masters program, essentially making my glass trophy as worthless as…well…a trophy in a bookcase. Today there was a phone call with Microsoft Learning and 250 lucky MCM participants. The result of the phone call? Just more frustration for everyone. What I was hoping for was to hear details about … Read more
Microsoft Certified Masters: What Problem Were They Trying To Solve?
I awoke last Saturday morning to see some emails describing a change to the Microsoft Certified Master’s program. I didn’t pay them much mind because I knew the program was changing slightly. They had already played the game of alphabet soup recently by calling us MCSM instead of MCM so I assumed this email was … Read more
