Free SQL Server Training Videos for Developers

You can find some interesting videos (about 30 minutes each) on Brent Ozar website.

Here’s a list:

INDEX DESIGN

• Index Basics – Kendra Little
• The Okapis of Indexes – Jes Schultz Borland
• Heaps (Tables Without Clustered Indexes) – Kendra Little

BLOCKING AND ISOLATION LEVELS

• There’s Something About Nolock – Kendra Little
• Five Ways to Fight Blocking – Kendra Little

QUERY DESIGN AND TUNING

• Let’s Talk About Joins – Jeremiah Peschka
• Developer’s Guide to Dangerous Queries – Jeremiah Peschka
• How to Measure T-SQL Improvements – Kendra Little
• Windowing Functions in SQL 2012 – Jeremiah Peschka

TROUBLESHOOTING IN PRODUCTION

• First Responders Kit – Kendra Little
• What’s Going On in My SQL Server? – Kendra Little
• The Mystery of Query Timeouts – Kendra Little

SQL SERVER SETUP & USAGE

• How Does SQL Server Store Data? – Brent Ozar
• Developers and the Transaction Log – Kendra Little
• Completely Legal Performance Enhancements – Jeremiah Peschka
• SSMS: More than Meets the Eye – Jes Schultz Borland