Change Control

This post maybe a little “ranty”. It seems in the past few months, I seem to have encountered a number of instances where changes to the database were made without a Change Request. Which has sparked a few conversations with developers over why there is a...

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...

SSMS 2016 – Updates

SSMS 2016 By now we all know that with SQL2016, SSMS was broken out and granted a life of its own. Meaning, that now it’ll get updated on a semi regular basis. Unlike the days of old where the only time SSMS might get updated is when a new version of SQL was...

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....

SQL 2016 Data Driven Event

SQL 2016 This morning, Microsoft kicked off a large launch event for SQL 2016 and the information was fabulous. Not only was the information outstanding, but the presentation was outstanding as well. Nope, I wasn’t there. I watched the event via live streaming like a...