Videos

Home
Videos

Updated First Responder Kit and Consultant Toolkit for January 2021

Last Updated January 21, 2021

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

Brent Ozar

Professional Development, Videos

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

Brent Ozar

Professional Development, Videos

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

Brent Ozar

Professional Development, Videos

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

Brent Ozar

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

Brent Ozar

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

Brent Ozar

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

Brent Ozar

Videos

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

Brent Ozar

Videos

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

Brent Ozar

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

Brent Ozar

Videos

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

Brent Ozar

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

Brent Ozar

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

Brent Ozar

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

Brent Ozar

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

Brent Ozar

Videos

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

Brent Ozar

Development, Videos

For years, I hated troubleshooting servers with high CPU usage caused by queries constantly asking for new execution plans. Hated it. SQL Server just doesn’t make it easy to find queries with recompile hints. Then Erik Darling’s sp_HumanEvents came along. And now troubleshooting frequent compilations is as easy as this: Transact-SQL EXEC dbo.sp_HumanEvents @event_type =…

[Video] Top 3 Pitfalls of Managing Your Azure SQL DB Costs

Last Updated June 23, 2020

Brent Ozar

Azure SQL DB, Videos

You manage servers, not invoices. Your company has started to move their databases into Azure, and they’re asking questions that you’re just not ready to answer. How big does your server need to be when you’re moving an existing database up to the cloud? How are servers measured? How do you measure to know if…

SQL ConstantCare® Population Report: Spring 2020

Last Updated June 1, 2020

Brent Ozar

SQL Server Population Report, Videos

Ever wonder what’s “normal” out there for SQL Server adoption rates, hardware sizes, or numbers of databases? Let’s find out in the spring 2020 version of our population report. Our SQL ConstantCare® service lets users send data in about their SQL Servers and get health & performance advice via email. Users can opt in to…

[Video] Watch Brent Write Queries

Last Updated June 23, 2020

Brent Ozar

Videos

This morning, I wanted to write a few new “background noise” queries for my Mastering classes. In those classes, the students run live workloads against the Stack Overflow database and troubleshoot performance issues, and the more of a varied workload I’ve got running, the more realistic it feels. For this session, I specifically wanted to…

Videos

Save your cart?