Posts by Brent Ozar

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

Videos
2 Comments
It’s time for the first live Office Hours in my new home studio in San Diego! I took your highest-upvoted questions from https://pollgab.com/room/brento/ and answered ’em: Here’s what we covered: 00:00 Welcome 01:30 Accidental DBA: Hi Brent, do you have a recommended checklist for trubleshooting occasional slow INSERT performance? 03:19 Mark: How do companies deal…
Read More

Behind-the-Scenes Home Studio Tour

Videos
13 Comments
Whenever I move to a new place and set up a new home studio, I give you a walkthrough so you can get a rough idea of how I work. I just finished setting up my new San Diego home base, and here’s a tour of what it looks like both as an attendee, and…
Read More

I’m Not Ready for Maskless Conferences Serving Finger Food.

At a conference in Belgium this week, Steve Jones posted a video: A real conference experience. Excellent crowd at @datamindsbe pic.twitter.com/TGZmw5PdmC — way0utwest ?? (He/Him/His) (@way0utwest) October 11, 2021 My first reaction was, “That’s an awful lot of people in really close proximity, talking loudly at each other, and none of them are wearing masks.”…
Read More

[Video] Office Hours: Ask Me Anything On the Balcony

Videos
4 Comments
Good evening, party people! I finally have my new San Diego home base all set up and unpacked, so I took a champagne break to review your top-rated questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Introductions 00:27 Alex: Hi Brent. For a few hours we got a “Could not continue scan with NOLOCK due…
Read More

Free Classes Start Next Week. Register Now.

Company News
8 Comments
This month & next, I’m going to teach you the fundamentals of SQL Server database performance tuning, live, for free. The first class is my How to Think Like the Engine class. It’s already free online in both video and blog post formats, but this fall I’m updating and expanding it to a 3-hour version.…
Read More

[Video] Office Hours in My New San Diego Apartment

Videos
1 Comment
Just got the keys to the new home base in San Diego, and the furniture isn’t even in yet. I went through your top-voted questions from https://pollgab.com/room/brento before my smoke alarm battery started chirping: Here’s what we covered: 00:00 Introductions 01:10 Yoni – We have 60-100GB DBs on SQL server on windows (VM). Will it…
Read More

What Is a Cost-Based Optimizer?

Execution Plans
0
When you execute a query, the database server has to figure out things like: Which table to process first Which index to use on that table Whether to seek on that index or scan it Which table to process next How to join the data between those two tables When to sort the data For…
Read More

[Video]: Office Hours at Diamond Beach

Videos
2 Comments
I took a break from playing with glacier leftovers at Diamond Beach to answer the questions you upvoted at https://pollgab.com/room/brento/. 00:00 Introductions 1:21 Null Pointer: When we move to Azure SQL DB, should we worry about having all our data and backups in one place? 03:27 Josh: We’re using indexed views, and we have to…
Read More
Menu