Posts by Brent Ozar

[Video] Office Hours: Professional Development & Training Questions

Videos
0
A lot of today’s questions from https://pollgab.com/room/brento have a common theme, but it’s just a coincidence: Office Hours: Writing Presentations, Career AdviceWatch this video on YouTube Here’s what we covered: 00:00 Start 07:40 Maciej: Hi Brent, when you are working on the course/training how do you know that the current version is “good enough”? I…
Read More

[Video] Office Hours: 45 Minutes of SQL Server Q&A

Videos
3 Comments
It’s a long one, folks! I went through almost 30 of your questions from https://pollgab.com/room/brento to get your learn on: Office Hours: 45 Minutes of Fun and AnswersWatch this video on YouTube   Here’s what we covered: 00:00 Start 00:30 Jr Wannabe DBA: Hi Brent, recently you talked about linters; do you recommend any for…
Read More

It’s Been 6 Months. SQL Server 2022 Still Isn’t Ready Yet. (Updated)

SQL Server 2022
37 Comments
Six months ago today, Microsoft announced that SQL Server 2022 was ready. Except it wasn’t. And it still isn’t ready. See, look at the very first hero in their list of 2022’s new features: The very first one is “Business continuity through Azure – Bidirectional DR to Azure SQL.” However, buried way down in the footnotes, Microsoft admitted:…
Read More

How to Configure Ola Hallengren’s Database Maintenance Scripts for Backups

Someone told you that you should be using Ola Hallengren’s Maintenance Scripts. You’ve downloaded his Maintenance Solution.sql, you ran it in the master database, and … now you’re not sure what’s supposed to happen next. In this post, we’ll cover how to configure backups. First, configure the Agent jobs. When MaintenanceSolution.sql ran, it created a…
Read More
Open source image generated with Stable Diffusion, epiCRealism checkpoint, prompt: professionally color graded photo of ambulance, masterpiece, raw, hard focus, depth of field, nikon d850

[Video] Office Hours: Testing the First Responder Kit

Videos
0
I tested the April release of the FRK, then answered your questions from https://pollgab.com/room/brento. Office Hours: Testing the First Responder KitWatch this video on YouTube   Here’s what we covered: 00:00 Start 28:37 Make_a_car_and_call_it_a_Brentley: Hi Brent, thanks for everything you do for the community. I was wondering on your opinion on using RegEx within a…
Read More

[Video] Office Hours: 25 Pretty Good Questions

Videos
1 Comment
You post questions at https://pollgab.com/room/brento and upvote the ones you’d like to see, and my job is to come up with accurate answers on the fly. Let’s see how I did. Office Hours: Ask Me Anything About SQL ServerWatch this video on YouTube Here’s what we discussed: 00:00 Start 03:25 SickOf: Brent is there a…
Read More

[Video] Office Hours: Live Q&A

Videos
2 Comments
This one’s broken up into two parts because I took a bio break mid-stream: Office Hours: Compilations, TVPs, Licensing, and MoreWatch this video on YouTube 00:00 Start 03:04 Clippy: Hey Brent, you are the best!!! Can you share us more about your roots? What’s the origin of your family name and where does it comes…
Read More

[Video] Office Hours Speed Round: 21 Answers in 15 Minutes

Videos
2 Comments
HONK HONK! It’s time for a fast round of answers to concise questions y’all posted and upvoted at https://pollgab.com/room/brento. Office Hours Speed Round: 21 Answers in 15 MinutesWatch this video on YouTube Here’s what we covered: 00:00 Start 00:19 TheyBlameMe: Hi Brent. What is your view on using Dacpac diffs vs “old style” manual update…
Read More

Office Hours Speed Round, Easy Text Answers Edition

Some of the questions y’all post at https://pollgab.com/room/brento have easy one-line answers. Let’s knock ’em out: George: Hi Brent, what recently has been the most challenging/surprising/new-to-you performance issue you have encountered? SQL Server 2019’s slowdowns. I spent days working on that. RoJo: Have you used Distributed AG as a way to upgrade major versions of…
Read More

[Video] Office Hours: Ask Me Anything at Sea

Videos
0
It was a dark and stormy morning, on the last day of my Panama Canal cruise. Before I perished, I sat down to answer your top-voted questions from https://pollgab.com/room/brento. Office Hours: Ask Me Anything at SeaWatch this video on YouTube Here’s what we covered: > 00:00 Start 00:36 ClippyTheDBA: Hi Brent. How you keep up-to-date…
Read More