Tag Archives: SQL Server 2014

Upgrading SQL Server using Availability Groups – Checklist

Posted on October 17, 2019 by thomasrushton

This is a checklist put together and followed for an upgrade of a pair of physical SQL Server 2012 servers which hosted a single availability group of several terabytes of data with minimal downtime. The availability group was configured with … Continue reading →

Posted in Uncategorized | Tagged , , , , , , | 3 Comments

The TImes, They Are A-Changing

Posted on March 10, 2016 by thomasrushton

No, not the song. Nor the reference in Watchmen. But the clocks. Y’know, that primitive thing where we have to put the clocks back an hour in the winter and push them forward an hour in the spring? That. What … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , | 1 Comment

SQL Server TempDB, Azure Virtual Machines, and the D: Drive

Posted on November 3, 2015 by thomasrushton

Why put the TempDB on the D: drive? In the wonderful world of Azure Virtual Machines, for certain VM types, the D: drive is hosted on SSDs – great for performance. However, in this world, the D: drive is “non-persistent … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , | 1 Comment

Possible SQL Server Trace Flag Gotcha

Posted on October 31, 2015 by thomasrushton

I was trying to turn on Traceflag 3226 in order to suppress the swarm of successful transaction log backup messages that floods the SQL Server (Error) Logs (& Windows Application logs). After all, if you’ve got more than a few … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , | 1 Comment