Posts by Brent Ozar

It’s a beach day! Let’s hang out at Silver Strand State Beach and I’ll take your highly voted questions from https://pollgab.com/rooms/brento. Here’s what we covered: 00:00 Introductions 00:45 Dylan: Why does an UPDATE on a 2nd key column in an index (100% FF) cause a “bad” page split; the first column is 100% unique. I…

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…

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…

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…

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…

On a very chilly morning, I went through your highly-upvoted questions from here and talked through ’em: Here’s what we covered: 00:00 Introductions 01:02 Johnny: Good morning, Brent! VARCHAR or NVARCHAR; which one to use in our Western world? One could say that disk space is cheap so it doesn’t matter. But with SQL Server’s…

I stopped at a waterfall in Iceland to answer your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Introductions 00:28 Accidental DBA: How do I determine if SQL Server instances are licensed? 02:22 Jose: What activities do I need to do if I sell managed SQL Server as a service? 03:23 Mr. Griffith: How…

I drove up the volcano Hekla in central Iceland – also known as the Gateway to Hell – and parked the Defender here: While my travel companions hiked up higher (and took that photo), I set up the tripod and camera, then went through your highly-upvoted questions from https://pollgab.com/room/brento. Here are the questions I covered:…

The beach at Vestrahorn mountain looks different every time we’ve visited: high tide, low tide, sun, clouds. Always a fun side trip when we’re out in the southeast of Iceland. I took a break to answer the questions you upvoted here. Questions we covered: 00:00 Introductions 00:38 Scott M: When do you recommend sp_BlitzWho vs…

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…