Videos

I sat down with Microsoft’s Kasper de Jonge this month for an hour-long conversation about how I got started speaking, careers, and the future of SQL Server: You can also listen on Spotify and Apple Podcasts. In the podcast, we talk about my Epic Life Quest – that’s over here. If you’ve got followup questions,…

Free Video: Deadlocks: Let’s Do One, Understand It, and Fix It

Last Updated May 10, 2021

Deadlocks, Videos

You keep getting warnings and emails about deadlocks, but let’s be honest: you’re not really sure how they happen or what to do about it. In this one-hour session from the SQLBits conference, I will show one, use sp_BlitzLock to analyze it, then fix it. If you like this video, check out the SQLBits YouTube…

Updated First Responder Kit and Consultant Toolkit for January 2021

Last Updated January 21, 2021

First Responder Kit Updates, Videos

You know how a lot of app release notes say “bug fixes and improvements”? We’re not gonna lie: this one’s all bug fixes. Huge shout out to the community contributors for catching stuff and contributing fixes. New behavior for SQL Server 2008 & R2 users: sp_BlitzLock has never worked on SQL Server 2008, but starting…

[Video] Office Hours: SQL Server Career Q&A, Part 3

Last Updated December 28, 2020

Here’s the last video in my vacation series with the answers to your most-upvoted professional development questions. Enjoy! I won’t be taking new questions in the comments, but I’m leaving the comments open on this post so that y’all can discuss the video together with each other. Just be mindful that your name will be publicly…

[Video] Office Hours: SQL Server Career Q&A, Part 2

Last Updated December 16, 2020

Last week, I posted a call for questions about SQL Server careers and professional development, and y’all asked a lot of good ones. Here’s the next video with the questions you upvoted the most, and I’ll post the last round of ’em next week. I won’t be taking new questions in the comments, but I’m leaving…

[Video] Office Hours: SQL Server Career Q&A, Part 1

Last Updated December 16, 2020

I posted a call for questions about SQL Server careers and professional development, and y’all asked a lot of good ones. Here were the questions you upvoted the most, and I’ll post another round of ’em next week. The audio on this isn’t up to my usual home-studio quality, of course! I won’t be taking…

New Class: Fundamentals of TempDB – Instant Replays Ready Now

Last Updated December 7, 2020

TempDB, Videos

Yesterday, I taught my first Fundamentals of TempDB class, and as always, you can watch the Instant Replays right after class completes. Here’s the abstract: You’ve been working with Microsoft SQL Server for a couple of years, and you know a little bit about TempDB. You’ve heard that temp tables and table variables have different…

What It Takes To Write Two Blog Posts

Last Updated November 19, 2020

Blogging, Videos

This week, I published two blog posts: How Bad Statistics Cause Bad SQL Server Query Performance How Scalar User-Defined Functions Slow Down Queries Let’s talk about the process of writing ’em. A couple I was putting together this week’s First Responder Kit release, I realized sp_BlitzIndex didn’t have URLs for a couple of common families…

[Video] How to Troubleshoot Someone Else’s Temp Table Contents

Last Updated November 12, 2020

TempDB, Videos

Let’s say you need to troubleshoot someone’s query performance, and they’re using temp tables. You want to peek in at their temp table contents from another session while their query is running. SQL Server makes that a little bit challenging. Nic Neufeld showed how to use DBCC PAGE to do this, but today I’m going…

Free Live Fundamentals Classes, Registration Open Now

Last Updated November 30, 2020

Update Oct 29th – classes are over. Thanks for joining in! Well, this quarantine just isn’t letting up, so it’s time for another round of free training. I’m running 3 free live classes on October 26-28: October 26: Fundamentals of Index Tuning – 9AM-5 Eastern – iCal October 27: Fundamentals of Query Tuning – 9AM-5 Eastern– iCal October 28: How I Use the First Responder…

Woohoo! We Hit 25,000 YouTube Subscribers.

Last Updated October 10, 2020

As I finished this weekend’s live stream, I noticed that we crossed a big number. The Brent Ozar Unlimited YouTube channel now has over 25,000 subscribers. Well, that’s kinda awesome. I’ve had a great time doing all kinds of free live streams during the quarantines, and it’s been super fulfilling seeing so many folks show…

The 4 Presentations I’m Proudest Of, and What Inspired Them

Last Updated September 24, 2020

Videos, Writing and Presenting

I was thinking back about the presentations I’ve been the most proud of over the years. I’ve written and performed a *lot* of stuff over time, but here are some of the free public presentations I’m the most proud of, and the stories of how they came to be. #4: Watch Brent Tune Queries (2014)…

[Video] Office Hours: Open Q&A About SQL Server

Last Updated September 3, 2020

Office Hours Podcast For those of you who miss our old Office Hours webcasts and feel lonely during the quarantines, I’m doing my part to help with free weekend webcasts. For the next couple of Saturday & Sunday mornings from 6AM-8AM Pacific (iCal), you can catch me on my Twitch, YouTube, or Facebook channels. I’ll be: Live coding in the First…

Watch Brent Tune Queries at SQLSaturday Oslo

Last Updated August 29, 2020

Execution Plans, Videos

This morning, I had the honor of presenting virtually at SQLSaturday Oslo. The session title, Watch Brent Tune Queries, explains it all. Enjoy! In the session, I used the 2018-06 Stack Overflow database, but any recent full-sized copy (not the 2010-2013 copies) will work. Here’s the query I worked with: /* Watch Brent Tune Queries:…

Date Tables are Great for Users, but Not So Great for Performance

Last Updated August 5, 2020

Execution Plans, Videos

Date tables help users filter data based on day of week, holiday, this year vs last year, and other kinds of filters that business users usually wanna add to their reports. If you haven’t used a date table before, here are a couple of primers on how to create one and use it: Creating a…

[Video] The Top 10 Developer Mistakes That Won’t Scale on Microsoft SQL Server

Last Updated July 30, 2020

Development, Videos

You’re a C# or Java developer building an application that stores data in Microsoft SQL Server, and you want to avoid common pitfalls that will cause you scalability problems down the road. In this session from my live stream, you’ll learn why you probably want to avoid triggers, SELECT *, user-defined functions, dynamic SQL, big…

[Video] How to Think Like Clippy (Subtitle: Watch Brent Wear Another Costume)

Last Updated July 27, 2020

Indexing, Videos

Remember Clippy, the Microsoft Office assistant from the late 1990s? He would pop up at the slightest provocation and offer to help you do something – usually completely unrelated to the task you were trying to accomplish. Sadly, the Office team told Clippy that he didn’t make the stack rankings cut, so he relocated over…

Announcing Saturday & Sunday Office Hours.

Last Updated July 20, 2020

During the quarantines, I’m doing free training. It looks like we’re going to be stuck inside here for another long while, so for the next couple of months, I’m bringing back Office Hours, but on a different schedule. Every Saturday & Sunday morning from 6AM-8AM Pacific (iCal), you can catch me on my Twitch, YouTube, or Facebook…

[Video] How to Find Queries Using OPTION RECOMPILE (And Their Parameters)

Last Updated June 23, 2020