Posts by Brent Ozar

[Video] Office Hours: Almost Back in San Francisco

Videos
1 Comment
It’s back to lighter fog-friendly clothes as the ship pulls into San Francisco and I answer your questions from https://pollgab.com/room/brento. Here’s what we discussed: 00:00 Start 01:16 Pozzolan: Hey Brent, My companies budget for SQL licensing is small. In such situations, does it make sense to switch or start all new development on something like…
Read More

[Video] Office Hours at Sea: Leaving Juneau

Videos
0
I stopped piloting the ship long enough to answer your top-voted database questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00:42 Dirty_Pages: You mentioned recently how much you swear, what is your favorite swear word(s) and why? Any favorite insults? 02:38 SQLCircus.Clown: What is your go to/default SQL datatype for storing a run of…
Read More

[Video] Office Hours in Glacier Bay, Alaska

Videos
2 Comments
Thankfully, we didn’t hit any icebergs or glacier droppings, so I put my comfiest coat on to answer your top-voted questions from https://pollgab.com/room/brento. Here’s what we discussed: 00:00 Start 01:29 gb DBA: Hi Brent, I have over 200 threads with BROKER_RECEIVE_WAITFOR type when I execute sp_whoisactive and some of trx have high numbers on reads…
Read More

Announcing 30-Day Free Trials for SQL ConstantCare®. Check Your SQL Servers Now.

SQL ConstantCare
3 Comments
You’re responsible for the health and performance of your company’s SQL Servers. You can’t afford most monitoring products because they’re priced per-server. Your manager just can’t justify spending tens of thousands of dollars. Besides, monitoring tools just spam you. You end up with an Outlook rule that dumps all their emails into a folder, and…
Read More

[Video] Office Hours at Sea: SQL Server Q&A

Videos
0
En route from San Francisco to Juneau aboard the Ruby Princess, I stopped to hit a few of your questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00:46 DBACAT: Hi Brent, what statistics impact occurs when a transaction is rolled back? The query’s exec plan didn’t change but duration and CPU jumped 10X. Stats…
Read More
Office Hours Podcast

[Video] Office Hours: Azure & SQL Server Q&A

Videos
0
Y’all post questions at https://pollgab.com/room/brento, and I go through the top-voted ones on my Twitch channel streams.   Here’s what we covered today: 00:00 Start 01:56 Manoj: Where do you see artificial intelligence having the most impact on DBA’s? 03:25 It’s ‘a me: Hi Brent, is it still “best practice” to have databases split into…
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:   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 T-SQL? I tried a few randomly from Google search, they are useless.…
Read More

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

SQL Server 2022
29 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.   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 SQLquery and it’s performance. We have queries where we analyse about…
Read More