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.
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. If your user re-runs their report or reloads their screen, the data may look right the second time… but after this happens, your customer feels that they can’t trust your data.
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 :smile:
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.
Copyright (c) 2025, Catalyze SQL, LLC; all rights reserved. Opinions expressed on this site are solely those of Kendra Little of Catalyze SQL, LLC. Content policy: Short excerpts of blog posts (3 sentences) may be republished, but longer excerpts and artwork cannot be shared without explicit permission.