Product has been added to your cart.

Videos

[Video] Office Hours: Húsavík Harbor Edition

Last Updated August 11, 2021

Today’s session comes to you from the harbor in Húsavík, the whale watching capitol of Europe. Questions I answered in the video: 00:00 Introductions 00:29 Is SQL Server 2019 ready for prime time now? 02:47 Does WITH NOLOCK cause high CPU usage? 04:53 Is MERGE a good practice or bad? 06:36 OPENROWSET is so easy…

[Video] Office Hours: Arctic Circle Puffins Edition

Last Updated August 2, 2021

Erika and I are on the road in Iceland, roaming around the countryside, and I’m taking you with us. We visited Grímsey, a tiny island on the Arctic Circle, home to gazillions of sea birds like puffins and arctic terns. I took about half an hour to answer your most highly-voted questions from here: Questions…

[Video] Office Hours: Siglufjörður Airport Runway Edition

Last Updated August 1, 2021

Erika and I are on the road in Iceland, roaming around the countryside, and I’m taking you with us. This session was shot in Siglufjörður, a beautiful little oceanfront fishing village in the north. Yes, I’m on the airport runway. No, seriously. Here’s what it looks like from the air in the winter. Questions covered in…

[Video] Office Hours: Ask Me Anything About Professional Development

Last Updated July 28, 2021

Erika and I are on the road in Iceland, roaming around the countryside, and I’m taking you with us. This week, we’re in Siglufjörður, a beautiful little oceanfront fishing village in the north. In the mornings, before Erika wakes up, I’m filming Office Hours videos to answer your questions that you post here. Today’s session…

[Video] Office Hours: Ask Me Anything About SQL Server

Last Updated July 28, 2021

Erika and I are on the road in Iceland, roaming around the countryside, and I’m taking you with us. This week, we’re in Siglufjörður, a beautiful little oceanfront fishing village in the north. In the mornings, before Erika wakes up, I’m filming Office Hours videos to answer your questions that you post here. The first…

Free Video: 500-Level Guide to Career Internals: Building a Brand

Last Updated June 24, 2021

Professional Development, Videos

Last week, I shared my 300-Level Guide to Career Internals post & video. We talked about how the world is changing so quickly, and how it’s a great time to adapt your career to accomplish the things in life that are important to you. One of the possible outcomes that we discussed was working for…

Free Video: 300-Level Guide to Career Internals: Planning Your Career

Last Updated June 17, 2021

Professional Development, Videos

Erika applies a mask to me at the Blue Lagoon Hi. I’m writing this from a cottage in Iceland, in the midst of a 9-month digital nomad stint. I’m teaching classes and doing client work for 1-2 weeks, then Erika and I take off and hit the road for 2-3 weeks at a time, driving…

I’m on the KasperOnBI Podcast Talking About Careers and the Future of SQL Server

Last Updated May 13, 2021

Professional Development, 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

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

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

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

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

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)…

Office Hours

[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…