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)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)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)Learn to tune parallelism and interpret CXPACKET waits in SQL Server. |
|
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)
Want a built-in assistant performance tuner in SQL Server? |