course-announcements

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’m proud, giddy, and just plain overly excited to be giving a pre conference session at the SQL PASS Summit in Seattle, Washington on November 5, 2018.

This is going to be a fun, demo-packed day which will teach you skills you can use throughout your career as a developer, database administrator, or data professional.

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.

Table Partitioning is Tricky Business

In this new course you will learn why SQL Server’s table partitioning feature won’t make your queries against disk-based rowstore indexes faster– and may even make them slower.

I’m thrilled to have just finished and published a new course on Automatic Tuning in SQL Server. This feature is available in SQL Server 2017+ and Azure SQL Database.

Update: this course is now open and totally free to all.

Woo hoo! I’ve just added a new course: Repeatable Read and Serializable Isolation Levels in SQL Server.

Update: even better news… courses are now open and free for all 😄

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.

As we count down to the end of 2017, I’ve just scheduled a fresh batch of free, live webinars for 2018! Join me on Thursdays at 9 am Pacific / noon Eastern / 4 PM UTC.

PASS Summit sessions have been scheduled, and I’m excited to be giving two sessions this year AND helping judge Speaker Idol!

I’m looking forward to teaching, learning a ton, and connecting with lots of people who love working with data.

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.

SQL Server Management Studio is so full of tiny buttons and options that it can be easy to miss out on secrets that could make your life easier and more fun.

I’ve got a new online course that shows you my favorite secret tricks and goodies in SSMS!.

As of SQL Server 2016 SP1, you can now use partitioning in Standard, Web, and even Express Edition of SQL Server.

Everything’s gonna be fast! Right?

Well, not quite. But no worries, this course is now free.