Courses by Topic

#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)

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.

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.

Try the course quiz anytime.

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?

Try the course quiz anytime.