My Humble SQL Tips

A few weeks ago I shared a query for probing the execution plan for the Estimated Subtree Cost value . That query was rather simple but ...

There are quite a lot of great tools and queries available to the DBA that aid in troubleshooting and performance tuning. The list is incred...

SQL Server 2016 Microsoft expanded the range and flexibility of database level configuration settings . There are some new features, as well...

Yes! My company uses Master Data Services or MDS. Yes! It's a pain. And yes! I needed to learn how to use and administer it. For anyone ...

My company is revamping its domain structure and tightening up network security. I am one of the guinea pigs and therefore have been put int...

Cleaning up after someone leaves. We all do it right? Our companies all have water tight policies and procedures to handle that, or maybe th...

SQL Server has offered data compression since SQL 2008. It is a very good feature but, as with almost everything SQL Server, it needs to be ...

I've been deploying a SQL Server auditing solution for our new SQL 2014 estate. I know, we're a few years behind. But if you saw som...

We use Redgate's SQL Monitor to keep an eye on our mission critical servers. I like the product. It is reasonably user-friendly, reliabl...

I've written the script below to easily identify databases that have not had backups taken within a certain amount of time. This could b...