100 SQL Server Mistakes and How to Avoid Them cover
welcome to this free extract from
an online version of the Manning book.
to read more



Thank you for purchasing 100 SQL Server Mistakes and How to Avoid Them. I hope you enjoy reading it as much as I have enjoyed writing it. To get the very best experience from this book, however, I suggest that you do have some prior knowledge of SQL Server. For example, I would suggest that you:

  • Know how to write basic queries, to read data from tables, and update data in tables
  • Understand fundamental SQL Server concepts, such as Instances, Databases and Tables
  • Understand the concept of encryption
  • Know how to perform a basic installation of SQL Server, using the GUI

I have been working with SQL Server for nearly two decades, and in that time, I have seen lots of mistakes, that have led to problems. In this book, I will share many of the mistakes that I have encountered and provide advice on how to avoid making them yourself.

The primary audience for this book is the accidental SQL Server professional, who has been thrown in the deep end, and found themselves either developing T-SQL or administering SQL Server instances, or both! Therefore, this book covers a range of mistakes that are made in multiple areas, including development, administration, availability, and security.