Posts by Brent Ozar

[Video] Office Hours in Kyoto, Japan

Videos
0
My Asian vacation continues in Kyoto, the City of a Thousand Temples. They’re not playing around – the town is chock full of gorgeous historic temples, and it was tough to pick a scene for today’s Office Hours. Let’s go through your top-voted questions from https://pollgab.com/room/brento: Office Hours: Database Q&A in Kyoto, JapanWatch this video…
Read More
"Sir, this is a Wendy's"

The Ebb and Flow of AI

Processes and Practices
10 Comments
It’s the end of the year. Everybody’s coasting and looking back. Let’s kick our heels up, get comfortable, and talk big picture industry stuff. You and me, our weirdo jobs involve: Databases – which is already unusual, and most people you run into on the street have never heard of it, even though it touches…
Read More

[Video] Office Hours in Osaka, Japan

Videos
9 Comments
Kon’nichiwa! My vacation tour continues in Osaka, Japan, a city famous for its street food, nightlife, and host and hostess clubs. I’m usually the kinda guy who does classy dinners at 5PM and then hits the sack by 9PM at the latest, so you might wonder how I got here. The answer is that Yves…
Read More

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. Office Hours: Answering…
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. Office Hours at the Petit Ermitage in LAWatch this video on YouTube   Here’s what we covered: 00:00 Start 00:37 MyTeaGotCold: When was the last time…
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. Office Hours: Car in the Dining Room EditionWatch this video on YouTube Here’s what we covered: 00:00 Start 01:03 MyTeaGotCold: Have you ever had a client turn off RCSI?…
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. Office Hours: Ask Me Database QuestionsWatch this video on YouTube 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…
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