Simple play icon Course
Skills Expanded

SQL Server: Myths and Misconceptions

by Paul Randal

Learn how common SQL Server myths and misconceptions can lead to performance, availability, and other problems. Applicable from SQL Server 2005 onwards.

What you'll learn

There is so much information online about SQL Server, however much of it is inaccurate to some degree. In this course, you will learn the truth behind more than 80 myths and misconceptions about SQL Server that can cause you performance and availability problems - from someone who wrote the SQL Server code. This course is perfect for developers and DBAs who have been struggling to make sense of conflicting information about SQL Server. The information in the course applies to all versions from SQL Server 2005 onwards.

Table of contents

About the author

Paul is the CEO of, a Microsoft Regional Director and a SQL Server MVP. He worked on the SQL Server Storage Engine team at Microsoft from 1999 to 2007. Among other things, he wrote DBCC CHECKDB/repair for SQL Server 2005 and was responsible for the Core Storage Engine during SQL Server 2008 development. Since leaving Microsoft, Paul has been a full-time consultant and trainer on SQL Server around the world, including authoring and teaching the prestigious Microsoft Certified Mast... more

Ready to upskill? Get started