Boring Is Stable, Stable Is Good – SQL Server Best Practices In Practice

Have you ever wondered why there are so many, sometimes contradictory, best practices for SQL Server available on the internet? Have you considered creating your own but don’t know what to include? Then this is the session for you.

Best practices are like standards – most everyone has them. But why do they look like they do? Why would you use a specific set of “best practices” that someone else has put together? This session goes through the set of best practices that I’ve accumulated over 20 years of DBA work. We will disassemble each and every one of them to see how they came about and discuss why I still use them – or not.

There is no such thing as the “ultimate” set of best practices. I aim to provide the attendee with as much food for thought as possible in order to let each and everyone decide on their own path forward. The session covers primarily SQL Server 2012 to 2016, with SQL Server 2017 and 2019 thrown in for good measure.

The following two tabs change content below.
, ,
Previous Post
SQL Server Hates You(?) – What the DBAs Never Told the Developers
Next Post
The Force Awakens – Azure SQL Server for the On-premises DBA

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.

Menu