Speaking At SQL Saturday Tampa 2020
In just a little over 3 weeks I’ll be speaking at SQL Saturday Tampa 2020! This event will be held on Feb 29 2020 at USF MUMA College of Business, …
In just a little over 3 weeks I’ll be speaking at SQL Saturday Tampa 2020! This event will be held on Feb 29 2020 at USF MUMA College of Business, …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 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 …
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 …
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 …
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 …
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 …
I recently made some updates to my SQL Server Permissions Manager project on GitHub. These updates mainly consisted of bug fixes and documentation updates, although I did also add the …
2018 was a good year for my conference speaking schedule, I spoke at some new events as well as some of my old favorites. I decided to cut down on …
I am pleased to announce that I have once again been invited to speak at the Adobe ColdFusion Summit East conference in Washington, D.C., which will be held on April …
As I continue my blog series on using the dbatools PowerShell module, today I want to discuss using it to set MAXDOP and Max Memory on your SQL Server. This builds directly …