Posts by Brent Ozar

How to Explain What We Do

SQL Server
9 Comments
One of my favorite uses for AI is to ask it to explain a concept using wildly unusual points of view. Well, we’re going to be seeing various family members and friends for the holidays, and we’ll get endless questions of, “So, what is it that you do?” I figured ChatGPT would be the perfect…
Read More
Local project

How to Use Github in SSMS v21

SQL Server Management Studio v21 added native Git support, making it easier to use source control natively inside SSMS. This feature is for developers who are already used to working with Github to manage specific object changes as they work, and who are already accustomed to Git terminologies like branches, commits, pushes, and pulls. This…
Read More

[Video] Office Hours in Zhengzhou, China

Videos
0
For the rest of December, I’m out vacationing in China and Japan. For this episode, I’m coming to you from the People’s Park in Zhengzhou, China, which is kinda like the Chicago of China. It’s in the middle of the US, bigger than people think (13 million people), and has beautiful parks. Here’s what we…
Read More

SQLBits is Coming Back to London in June 2025!

SQLBits
5 Comments
I used to feel bad saying that any one conference is “my favorite” because I worried that other database conference organizers might feel slighted. However, I’ve talked to many of ’em, and they feel the same way I do, hahaha, so I don’t feel guilty about it anymore. SQLBits is my favorite database conference. They try…
Read More

[Video] Office Hours at the Petit Ermitage in LA

Videos
4 Comments
I went to LA for the opening week of Somni, a gorgeous restaurant in LA, and took your questions from the rooftop deck of the adorable Petit Ermitage hotel.   Here’s what we covered: 00:00 Start 00:37 MyTeaGotCold: When was the last time you did something interesting with Extended Events? 01:25 Josef: Our app slows…
Read More

[Video] Office Hours: Car in the Dining Room Edition

Videos
0
What, doesn’t everyone park a convertible in their dining room? I address the pink elephant in the room, and then take your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 01:03 MyTeaGotCold: Have you ever had a client turn off RCSI? 01:31 SportsFan101: Hi! My company uses vmware for production(on-prem). Current wait time…
Read More

[Video] Office Hours: Ask Me Database Questions

Videos
0
I took your top-voted questions from https://pollgab.com/room/brento. At one point, my camera overheats – hang in there, I get it fixed in a few seconds. Here’s what we discussed: 00:00 Start 01:59 MyTeaGotCold: Your HA/DR worksheet mentions a $1,000,000 option for 0/0 RTO/RPO. Where can I learn more about how this? 04:43 Trushit: It was…
Read More

3 Legit Signs It’s Time for Enterprise Edition

SQL Server
7 Comments
Your app is happily humming along on SQL Server Standard Edition. Things are quiet – too quiet. You’re wondering what you’re missing, and whether you should be on SQL Server Enterprise Edition. Here are 3 warning signs to watch out for. Developers say, “Any downtime is unacceptable.” Sure, everybody loves to say that before they…
Read More
WHO IS THIS JASON AND WHY IS HE IN MY TABLES

What’s New in SQL Server 2025

SQL Server 2025
30 Comments
Today at Microsoft Ignite, Microsoft announced SQL Server 2025. The biggest new features focus on AI and bringing the latest Azure SQL DB features down to your own servers. Here are the top features: Call AI services like ChatGPT directly from T-SQL – using T-SQL commands and sp_invoke_external_rest_endpoint Vector searches, a native vector data type,…
Read More

Help Me Help You.

Company News
20 Comments
In my PollGab room where y’all can ask questions, Chocolate Thunder wrote: I do genuinely wish that I could do two things at the same time: Give y’all everything for free, and Pay for the roof over my head and put food on my table I haven’t figured out how to do both of those…
Read More

Office Hours: Guess the Theme Edition

Videos
3 Comments
There’s a secret theme to the questions I hand-picked from the queue at https://pollgab.com/room/brento. Normally I just take the top-voted ones, but today, see if you can spot the thing they all have in common:   Here’s what we covered: 00:00 Start 01:51 Tivan: Hi Brent, I’m facing a deadlock in MS SQL Server with…
Read More

SSMS v21: Dark Mode, Git, Vertical Tabs, and More

Tools
10 Comments
SQL Server Management Studio v21 Preview 1 is out and let’s give it a quick whirl. It’s installed with the Visual Studio installer. That doesn’t mean Visual Studio is installed or required – it’s not – it’s just that the SSMS team is leveraging the work that the VS folks have put in over the years.…
Read More

[Video] Office Hours: SQL Server Questions and Answers

Videos
0
That face I’m making in the video thumbnail is priceless. YouTube randomly picks these, and I laughed out loud at this one. Anyhoo, let’s get to answering your top-voted questions from https://pollgab.com/room/brento: Here’s what we covered: 00:00 Start 00:59 Mohit: Hello Brent, What options does a DBA have in terms of performance tuning when managing…
Read More