Posts by Brent Ozar

How to Make Database Changes Without Breaking Everything

Development
8 Comments
You’ve got an existing application with a database back end. You’re thinking about changing the database, and you don’t wanna break stuff. The most important thing to understand is difference between constructive and destructive changes, also known as additive and destructive changes, or non-breaking and breaking changes. Constructive change examples: adding a new table or…
Read More

It’s Friday. I’m Not Answering These 14 Office Hours Questions.

Sometimes, I don’t care if questions get a lot of upvotes at https://pollgab.com/room/brento – I just don’t wanna answer ’em. They’re not necessarily bad questions, but I’m just not interested in them, or I’ve answered them repeatedly, or I don’t have a good answer. Maybe y’all do, though, so I’ve numbered these. If you want…
Read More
Office Hours Podcast

[Video] Office Hours: Github Copilot in Azure Data Studio

Videos
1 Comment
I start today’s Office Hours by playing with the very underwhelming Github Copilot in ADS, then take your questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 04:06 Github Copilot in Azure Data Studio 24:36 Byron: Seeing plan cache queries for a long since retired table. What is best way to track down the app…
Read More

Updated First Responder Kit and Consultant Toolkit for June 2023

This one’s a pretty quiet release: just bug fixes in sp_Blitz, sp_BlitzLock, and sp_DatabaseRestore. Wanna watch me use it? Take the class. To get the new version: Download the updated FirstResponderKit.zip Azure Data Studio users with the First Responder Kit extension: ctrl/command+shift+p, First Responder Kit: Import. PowerShell users: run Install-DbaFirstResponderKit from dbatools Get The Consultant…
Read More

[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