Monthly Archives: November 2019

Batch Scripting SQLCMD–#SQLNewBlogger

Posted on November 13, 2019 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I wouldn’t do this anymore, but I ran across a post where someone couldn’t use PowerShell in their organization. … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Batch Scripting SQLCMD–#SQLNewBlogger

Learning from Exercise

Posted on November 12, 2019 by way0utwest

A long time ago I decided to run every day. I did for a bit, in fact, I had a neat milestone along the way and continued on for 1564 days. That was quite a memorable period in my life, … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Learning from Exercise

True HA and DR

Posted on November 11, 2019 by way0utwest

For many years, SQL Server administrators have tried to ensure their systems run smoothly by executing DBCC commands against their production databases. As workloads have grown, this has become an issue with resource contention with production users. Backups have had … Continue reading →

Posted in Editorial | Tagged | Comments Off on True HA and DR

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