Slides From SQL Saturday Nashville 2020
The slides from my presentation “How To Be The DBA When You Don’t Have A DBA” can be downloaded here. In this particular presentation there are a lot of links …
Blog
SQL Scripts: List Databases A Login Can Access
When you are managing your SQL Server database permissions through Active Directory Groups (which you should be!), it can sometimes be difficult to know just which databases a user actually …
Speaking At SQL Saturday Nashville 2020
I am excited to announce that I have been selected to speak at SQL Saturday Nashville in January! The event will be held on January 18th, 2020, at Middle Tennessee …
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 …
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 …