SQL Server: Myths and Misconceptions

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

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.

• Introduction 9mins
• Performance Myths and Misconceptions 51mins
• Transaction Log Myths and Misconceptions 41mins
• Indexing Myths and Misconceptions 18mins
• Locking Myths and Misconceptions 21mins
• Transact-SQL Myths and Misconceptions 19mins
• Backup Myths and Misconceptions 18mins
• Restore Myths and Misconceptions 14mins
• Corruption Myths and Misconceptions 21mins
• High-Availability Myths and Misconceptions 17mins