Transact-SQL Scripts for Webinar How to Conduct a SQL Server Configuration Review

In mid-May 2021, I presented a webinar on How to Conduct a SQL Server Configuration Review. If you missed it, you can watch the webinar now on demand <How to Conduct a SQL Server Configuration Review (>. This session encapsulates the sort of content I would share with my own Dev teams back when I was lead of a large database estate and helped us all improve our personal skills and overall institutional knowledge.

During the webinar, I used assorted Transact-SQL scripts to expose lots red flags with the way the SQL Server is configured, from the OS to hardware allocations to database file composition to preventative maintenance, and much more.

I've had many requests for the scripts via email and social media, so I'm posting it here for your convenience. I'd love to hear your feedback if you have similar queries of your own that I haven't otherwise covered or if you have suggestions for improving the script.

By the way, this is one in a series of how-to webinars I’ve presented over several weeks in 2021. Other how-to sessions include:

  • How to Design and Normalize a Database (great for Devs and accidental DBAs!)
  • How to Conduct a Database Code Review
  • How to Conduct a SQL Server Configuration Review

For each of the "How-to" webinars, you'll also get a Transact-SQL file to help you identify the red flags in each area. Meanwhile, if you're kicking yourself for having missed the live experience of the webinar, you can subscribe to the SentryOne (now a part of SolarWinds) events calendar <SentryOne Webinar Events Newsletter> towards the bottom of the webpage.

I look forward to seeing you at an upcoming webinar soon! Cheers,


P.S. Please leave a comment if you’d like to see a session called How to Conduct a SQL Server Security Review. I haven’t settled on whether I’ll do that one. So, I’d like to hear your feedback to see whether it’d be a worthwhile addition. Thanks!

KKline - SQL Server Config