Backing Up Databases With The dbatools PowerShell Module
We do a lot of database backups and restores at work, outside of our regular backup routines. A lot! I’ve actually done as many as 40 in one day. Our …
Blog
2020 IDERA ACE
I am super excited to announce that I have been selected to participate in the 2020 IDERA ACE program! IDERA made the announcement last week, and I am honored to …
Recover Deleted Indexes With SQL Server Metrics Pack
In my latest enhancement to SQL Server Metrics Pack , I added a new feature to the index metrics scripts that automatically generates a CREATE INDEX script and stores it …
SQL Server Metrics Pack Update – September 2019
This morning I updated the Index Metrics piece of SQL Server Metrics Pack. This update mainly introduced some new functionality, with a few minor bug fixes. The two big enhancements …
SQL Scripts: Find Queries That Have Missing Index Requests
In a previous article, I went over how SQL Server will recommend an index that it believes will help a query run faster, and I showed how to find missing …
Patching Multiple SQL Servers With Powershell and dbatools
Patching SQL Server can sometimes be a time consuming process, especially when you have multiple servers that need to be patched. Remoting in to each box to run through the …
Music City Data 2019
For the second year in a row, I am happy to be working as part of the team putting together the Music City Data conference in Nashville, TN. Music City …
This Is Not The DBA You’re Looking For!
Over the last couple of months I have been interviewing candidates for a Sr. SQL Server DBA position we had open on my team. And while we ultimately ended up …
Announcing Sp_WhoIsBlocking
This is a tongue in cheek post, basically highlighting a cool feature in sp_whoisactive, and how I created a wrapper for it to make my life easier. I am a …
Configuring Database Data And Log Files
One of the things that Database Administrators typically do is configure the Data and Log file growth settings for the databases on their servers. While these configurations vary by server …