Check for corruption

If you work, or have worked, in a shop with lots of SQL servers then you either have, or will, experience an issue with storage. Like for instance you’re storage controllers go down, knocking down your SQL instances. As we all know, this is a good way to corrupt...

SQL 2017 and the future

WOW. That’s all I have to say after watching Microsoft’s 4/19 Data AMP Presentation. SQL 2017 is the official name of SQL vNext, otherwise known as SQL on Linux. We knew about SQL on Linux last year, so this isn’t some new revelation. That is, until...

Reflection, Goals, and Moving Forward

It’s amazing how time seems to fly, especially between blog posts. I’ve known I needed to post a blog for awhile, I’ve even thought of a few different topics. Alas, the execution has not been very good on my part. One of those things I hope to do a...

Tempdb Saga

Tempdb and AAGs I have been working on standing up about a multi-node Availability Group “cluster” (I put quotes around cluster, because…well…AGs aren’t really clusters are they?).  Now that the big node is stood up, I noticed some alerts about tempdb contention....