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

read more

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

read more

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 better job of going...

read more

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

read more

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

read more

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

read more

Do you have filestream files?

I probably should have known There are times when the #SQLlife and working as a DBA isn’t all that. Take for instance, the other night. I’m the on call for the week so after hour changes fall to me. Not a big deal, I was well aware of the pending change to one of our...

read more

Sometimes you just have to shrink

"Never go in against a Sicilian when death is on the line" In my career, I’ve heard my fair share of the things you’re never suppose to do in it. Never hang up on a caller, never reboot production without lots of communication, never work off of a network drive, etc....

read more

SQL Restore: Trust, but Verify…

Son of a ... Have you ever noticed how there are those days? You know, where the simple tasks just rear up and bite you square in the ass. Leaving you sitting/standing there thinking to yourself “Well that was really stupid….I can’t believe I didn’t I double...

read more