SQL Server MVP Deep Dives, Volume 2

Chapter 17. Top 10 SQL Server admin student misconceptions

Tibor Karaszi

Having trained SQL Server administrators for two decades now, I can anticipate many of the questions and thoughts that arise in a SQL Server admin class. Some misconceptions repeat over and over, and in this chapter I’ll elaborate on some of the most common misconceptions.

Let me start by saying that it’s okay to misunderstand how something works—that allows you to learn something, and learning is fun. I learn stuff all the time! Some misunderstandings are more common than others, and the reason for such common misunderstandings will vary. It might be that how the product works doesn’t seem logical at first glance...or that the product doesn’t work the way you want it ...