I’m excited to have a session accepted to GroupBy, a free online conference targeting the Microsoft data platform community. The conference is sponsored by Brent Ozar Unlimited, and sessions are chosen by community votes.
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.
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.
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.