Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Pluralsight

SQL Server: Myths and Misconceptions

via Pluralsight

Overview

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.

Syllabus

  • 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

Taught by

Paul Randal

Reviews

4.8 rating at Pluralsight based on 350 ratings

Start your review of SQL Server: Myths and Misconceptions

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.