Tag Archives: sql server

Setting Certificate Backup Permissions for an Instance–#SQLNewBlogger

Posted on November 20, 2019 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Recently I was testing some security change, and I made a backup of my certificate from one instance. I … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Setting Certificate Backup Permissions for an Instance–#SQLNewBlogger

New HA Licensing Benefits

Posted on November 11, 2019 by way0utwest

Microsoft announced recently that they were changing the way licensing works for HA and DR situations. I think this is a great change, and the summary is: You can have up to 3 other un-used secondaries for free You can … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on New HA Licensing Benefits

Very Hot Patches

Posted on October 8, 2019 by way0utwest

“At best it would crash” is not a phrase I’d like to have to use as a data professional. That’s a quote from an article that the Azure team wrote about hot patching SQL Server. While this sounds very scary, … Continue reading →

Posted in Editorial | Tagged , , | Comments Off on Very Hot Patches

Fantasy SQL Server

Posted on September 14, 2019 by way0utwest

This past week was the 118th T-SQL Tuesday (hosted by Kevin Chant) and it was a great one. Lots of people participated, with some really interesting entries. Kevin asked people to post their fantast T-SQL (or SQL Server) feature that … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Fantasy SQL Server