Free Courses

Database administration (6 ) Index design and tuning (7 ) Locking and blocking (8 ) Partitioning (3 ) Query tuning (10 ) Sqlchallenges (12 ) Ssms and user tools (1 ) Writing tsql (5 )

A Dynamic SQLChallenge (32 minutes)

A Query Writing SQLChallenge: The Most Unique Names (23 minutes)

Auto Tuning with Automatic Plan Correction in Query Store (1 hour 8 minutes)

Deduplicate Indexes - Level 1 SQLChallenge (56 minutes)

Defuse the Deadlock SQLChallenge (23 minutes)

Execution Plans: Partitioned Tables and Columnstore Indexes (1 hour 30 minutes)

Forcing Parallelism SQLChallenge (48 minutes)

How Index Keys and Includes Work (1 hour)

How to Decipher CXPACKET Waits and Control Parallelism (4 hours)

How to Decode Memory Pressure (4 hours)

Index Design SQLChallenge - One Year Wonders (50 minutes)

Indexing for Windowing Functions (45 minutes)

Learn Indexing by Solving Problems (7 hours 23 minutes)

Problem Queries in Table Partitioning (1 hour 30 minutes)

Query Tuning with Hints & Optimizer Hotfixes (2 hours 15 minutes)

Read Committed is Bonkers - Webcast Recording (46 minutes)

Read Committed Snapshot and Snapshot Isolation (46 minutes)

Repeatable Read and Serializable Isolation Levels (45 minutes)

Snapshot Isolation Against Availability Group Secondaries (28 minutes)

Speed Up the "Popular Names" Query SQLChallenge (46 minutes)

SQL Server Management Studio Shortcuts and Secrets (1 hour 30 minutes)

The Case of the Slow Temp Table: A Performance Tuning Problem (50 minutes)

The Dirty Secrets of NOLOCK (50 minutes)

The Idempotent TSQL SQLChallenge (28 minutes)

Troubleshooting Blocking and Deadlocks for Beginners (2 hours 10 minutes)

TSQL for Beginners (Redgate University)

Tune the 'Peak Years' Procedure - SQLChallenge (52 minutes)

Tuning a Stored Procedure - SQLChallenge (1 hour 10 minutes)

Who Made That Schema Change? A DDL Trigger SQLChallenge (28 minutes)

Who Made That Schema Change? An Event Notification SQLChallenge (27 minutes)

Why Creating an Index Can Slow Down a Query (1 hour 30 minutes)

Why Table Partitioning Does Not Speed Up Query Performance - With One Exception (52 minutes)

XEvents SQLChallenge: Create an Extended Events Trace (55 minutes)

I’m a database nerd who lives in Maine, in the USA. I love learning about database engines, making quilts, and carrying on long conversations with my dogs.