Posts by Brent Ozar

I’m on a boat! We took an Alaska cruise with some friends aboard the Norwegian Jewel. En route to Icy Strait Point, Alaska, I took your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 01:40 RollbackIsSingleThread: Hi Brent! If a high-quality blog post involves original ideas, T-SQL, a great demo, and images to…

I took your top-voted questions from https://pollgab.com/room/brento while recovering from a late night of partying. Here’s what we covered: 00:00 Start 01:00 VegasDBA: Loved the Always-On Availability Group Episode! You mentioned how awful the dashboard is for monitoring. Can you recommend any scripts, custom alerts, or dashboards to keep a better eye on things? 03:26…

I went through your top-voted questions from https://pollgab.com/room/brento plus hit live ones from the TikTok viewers. Here’s what we covered: 00:00 Start 00:52 chandwich: If SSMS had a dark mode option that was equally as good as the existing light mode, would you use it? Any idea why it doesn’t exist yet? RE: The on-call…

I went live on TikTok and took your top-voted questions from https://pollgab.com/room/brento: Here’s what we covered: 00:00 Start 00:23 Andrea Hardesty: Do you have any recommendations for reproducing parameter sniffing issues? I have a copy of a production DB. I want @param=222 to use the plan compiled with @param=111 like it did in production. In…

Last week, we had an abrupt intro, and this week, we have an abrupt ending when my camera overheats, hahaha: We went through your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00:43 cha2rg: We have an OLTP table size of 4TB and rows of 6 billion. Scheduled an old data deletion job…

Today’s Office Hours had a ton of technical difficulties because it was my first live stream on both Twitch and TikTok. The first few minutes were cut off, and you can’t see the questions onscreen. Nonetheless, there are good answers in here, so let’s do it:   Here’s what we covered: 00:00 Start 00:03 LivingTheDream:…

I was supposed to be on a flight to Mexico, but had to cancel at the last minute. While waiting for my favorite bagel shop to open, I went through your professional development questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 03:25 Asking for a friend: As a prod dba, should I know what…