Database Administration

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

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

In this challenge, you get to take a crack at creating an Event Notification to track schema changes.

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

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

In this challenge, you get to take a crack at writing a DDL Trigger to track schema changes.

How to Decode Memory Pressure (4 hours)

How to Decode Memory Pressure (4 hours)

SQL Server doesn’t make it easy to see if your SQL Server is under memory pressure, or if someone goofed when configuring the memory settings on your critical production instances.

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

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

Learn to tune parallelism and interpret CXPACKET waits in SQL Server.

Try the course quiz anytime.

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

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

Build your skills with Extended events in this SQLChallenge.

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

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

WARNING: I do NOT currently recommend enabling the Automatic Plan Correction feature due to issues described in my post, Automatic Plan Correction Could be a Great Auto Tuning Feature for SQL Server. Here’s why it Isn’t.

Want a built-in assistant performance tuner in SQL Server?

Try the course quiz anytime.