Courses

TSQL for Beginners (Redgate University)

The Idempotent TSQL SQLChallenge (28 minutes)

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

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

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

A Dynamic SQLChallenge (32 minutes)

Tune the Peak Years Procedure - SQLChallenge (52 minutes)

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

How to Decode Memory Pressure (4 hours)

Deduplicate Indexes - Level 1 SQLChallenge (56 minutes)

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

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

Index Design SQLChallenge - One Year Wonders (50 minutes)

Learn Indexing by Solving Problems (7 hours 23 minutes)

Read Committed Snapshot and Snapshot Isolation (46 minutes)

Speed Up the Popular Names Query SQLChallenge (46 minutes)

Read Committed is Bonkers - Webcast Recording (46 minutes)

Snapshot Isolation Against Availability Group Secondaries (28 minutes)

Forcing Parallelism SQLChallenge (48 minutes)

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

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

Defuse the Deadlock SQLChallenge (23 minutes)

The Dirty Secrets of NOLOCK (50 minutes)

How Index Keys and Includes Work (1 hour)

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

Repeatable Read and Serializable Isolation Levels (45 minutes)

Indexing for Windowing Functions (45 minutes)

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

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

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

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

Problem Queries in Table Partitioning (1 hour 30 minutes)

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

Copyright (c) 2024, Catalyze SQL, LLC; all rights reserved. Opinions expressed on this site are solely those of Kendra Little of Catalyze SQL, LLC. Content policy: Short excerpts of blog posts (3 sentences) may be republished, but longer excerpts and artwork cannot be shared without explicit permission.