SQL Scripts: How To Find Filtered Indexes
Filtered indexes are one of those neat little SQL Server features that a lot of people don’t seem to know about, or if they do they don’t use them very …
Blog
SQL Scripts: How To Find A Database’s Compatibility Level
One thing that a lot of DBAs, especially Accidental DBAs such as myself, don’t seem to realize is that just because a database is sitting on a specific version of …
Speaking At SyntaxCon 2018
This June I will have the honor of speaking at SyntaxCon 2018! If you’ve never heard of it, SyntaxCon is labeled as Coastal South Carolina’s premier developer event, and focuses on providing …
Speaking At Adobe ColdFusion Summit East 2018
I am pleased to announce that I have been invited to speak at the Adobe ColdFusion Summit East in Washington, D.C. This is a free, one day conference which will …
Music City Data Call For Speakers
One of the conferences that I’m looking forward to this year is Music City Data, which takes place May 31-June 2, at Vanderbilt University in Nashville, TN. I’m especially excited …
Starting A New Chapter
Today begins a new chapter in my career, and I am excited to announce that I am starting a new position as a Database Development Manager for Centauri Health Solutions! I have …
Notes From A SQL 2017 Azure Install – Automatic Seeding Of An Availability Group TDE Database
One of the neat features introduced with SQL Server 2016 was the automatic seeding of availability groups. And while it seems to work pretty well in most cases, if you …
Speaking At CodeStock 2018
I am happy to announce that I have been selected to speak at CodeStock 2018, in Knoxville TN! I will be giving my “Building Better SQL Server Databases” session, which is …
Extended Event To Track Data And Log File Size Changes
One of the things that a DBA tries to avoid/prevent are automatic file growths in data and log files. We generally like to plan for these things and size the …
Corruption With Backup Compression And TDE In SQL 2017
Last week I spent a good bit of time dealing with a corruption issue, and as it turns out I may actually have found a bug in SQL Server 2017. …