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.
Latest posts by Alexander Arvidsson (see all)
- Azure Machine Learning for the Absolute Beginner - August 28, 2019
- The Force Awakens – Azure SQL Server for the On-premises DBA - August 28, 2019
- Boring Is Stable, Stable Is Good – SQL Server Best Practices In Practice - August 28, 2019