Slides From Scenic City Summit 2017
The slides from my session, Building Better SQL Server Databases, are attached here. This was my first time at Scenic City Summit, and I really enjoyed it. The venue was …
Speaking At Adobe ColdFusion Summit 2017
I have been selected to speak at the Adobe ColdFusion Summit again! This year’s event will be held November 16–17, 2017, at The Mirage in Las Vegas. I’m really excited to …
SQL Scripts: How To Find Data And Log File Information
As a DBA, one of the things I routinely need to check is how much space is available in my database data and log files. In this post of my ongoing SQL …
Speaking At NCDevCon 2017
NCDevCon 2017 is just a few months away, and I will once again be returning as a speaker. NCDevCon is always a fun conference, I really enjoy it. Not only …
SQL Scripts: How To Find Index Usage
This post is part of an ongoing SQL Scripts series, in which I list useful queries that I use in my day to day database administration. If you are interested in code …
Slides From SQL Saturday Chattanooga 2017
The slides from my session, How To Be The DBA When You Don’t Have A DBA, are attached here. In this particular presentation there are a lot of links to …
SQL Scripts: How To Find Index Fragmentation
This is the first post in an ongoing SQL Scripts series, in which I list useful queries that I use in my day to day database administration. What Is Index Fragmentation? …
Encrypting Passwords Using EncryptByPassPhrase
While storing passwords in a database may be a common practice, storing them properly usually isn’t so common. This is part of a storing passwords blog series where we will examine …
Speaking At SQL Saturday 624 In Chattanooga
I am excited to announce that I have been selected to speak at SQL Saturday 624, in Chattanooga, TN! It looks like it’s going to be an awesome event, they …
Storing Passwords In A SQL Server Database
While storing passwords in a database may be a common practice, storing them properly usually isn’t so common. This is the first of a series of posts where we will …
Speaking At Scenic City Summit 2017
I’m happy to announce that I have been selected to speak at Scenic City Summit 2017! The conference, which covers a variety of topics for Developers and IT professionals (JavaScript, …
Fixing “Possible Date Calculation Spin For Schedule” Error
I recently ran into a strange error when trying to modify a SQL Agent job. This was an existing job that had been created a year or so ago, and …
Slides From SQL Saturday Birmingham 2017
The slides from my session, How To Be The DBA When You Don’t Have A DBA, are attached here. As always, I try to put a good deal of …
Calling PowerShell From SQL Agent Gives Syntax Error
One cool thing that you can do in SQL Server that a lot of people don’t know about is run PowerShell code from a SQL Agent job. However, I recently ran into a …
Persist And Aggregate Index Stats Across Server Restarts
(This script is part of my SQL Server Metrics Pack project that is now available on GitHub. If you like the code below and find it useful, I encourage you to check …
Speaking At SQL Saturday 593
I am excited to announce that I have been select to speak at SQL Saturday 593, in Birmingham, AL! Their schedule isn’t up yet, but if you are planning on attending I …
Getting Alerts From SQL Sentry When You Don’t Have Email
I use SentryOne’s SQL Sentry for my SQL Server monitoring, and it does an excellent job. However I recently had a situation where I was unable to get email alerts …
Change The Isolation Level Of An Availability Group Database
I recently needed to change the Transaction Isolation Level of one of our databases in an Availability Group. As it turns out, this is not as straight forward as you …