Category DBA

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

  2 Lessonsin DBA, SQLChallenges

  

  Event Notifications have pros and cons -- learn 'em both in this challenge.

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

  2 Lessonsin DBA, SQLChallenges

  

  Take a crack at writing a DDL Trigger to track schema changes.

• How to Decode Memory Pressure (4 hours)

  1 Lessonin DBA

  

  In this 4 hour webinar recording, I put a SQL Server under memory pressure.

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

  3 Lessonsin DBA, SQLChallenges

  

  Whoops, we've got a problem with our Query Store! Can you set up an XEvents trace to get details?

• How To Decipher CXPACKET Waits and Control Parallelism (4 hours)

  12 Lessonsin DBA

  

  Learn how to configure parallelism and how to interpret tricky CXPACKET waits.