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 …
SQL Server Permissions Manager Updates – January 2019
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 Speaking Review
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 …
Speaking At Adobe ColdFusion Summit East 2019
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 …
Using dbatools PowerShell Module To Set MAXDOP And Max Memory
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 …
Using dbatools PowerShell Module To Configure SQL Server
The more I use the dbatools PowerShell module, the more I like it. It really is a solid set of scripts that allow you to easily manage your SQL Servers via PowerShell. …
Getting Started With The dbatools PowerShell Module
If you are looking for a super easy way to start using PowerShell to manage your SQL Servers, then the dbatools PowerShell module is for you! For those that aren’t familiar, …
Slides From Scenic City Summit 2018
The slides and code from my session, Exploring The New JSON Features In SQL Server, are attached here. As I mentioned in my presentation, I am using the Stack Overflow …