course-announcements

Two Free Sessions Next Week: Fighting Bad Data and Deadlocks

Two Free Sessions Next Week: Fighting Bad Data and Deadlocks

I am excited and honored to be giving two free online sessions next week. Both events are sponsored by the fine folks over at Quest Software. Why is That Data Wrong? How Choosing the Wrong Isolation Level Causes Bad Results Tuesday, June 12, Noon Pacific 24 Hours of PASS, Sponsored by Quest Software If you haven’t thought much about isolation levels in SQL Server, chances are your applications can return inconsistent data to your users: data that looks completely wrong.
New Course: Indexing for Windowing Functions (with preview lesson)

New Course: Indexing for Windowing Functions (with preview lesson)

I’ve just added a fresh new course: Indexing for Windowing Functions. Here’s the rundown: Windowing functions give you great flexibility for analyzing data in SQL Server. But how can you get the best performance for your windowing functions? In this 45 minute, demo-packed course, you will learn index design for windowing functions, when batch mode may be important, and how to compare the performance of Window Spool and Window Aggregate operators.
New Course! Query Tuning with Hints & Optimizer Hotfixes

New Course! Query Tuning with Hints & Optimizer Hotfixes

Want to up your query tuning game? For a limited time, you can snag a free enrollment to the new course, Query Tuning with Hints & Optimizer Hotfixes. Learn the pros and cons of using hints and optimizer hotfixes in SQL Server, and see how hints can give you insight into the optimization process. Sorry, this free giveaway has ended.