
Brent Ozar Blog
4,085 FOLLOWERS
The Brent Ozar Unlimited® blog covers SQL server news and free SQL Server training tips about clustering, AlwaysOn, performance tuning, T-SQL, and more.
Brent Ozar Blog
3d ago
I took your top-voted questions from https://pollgab.com/room/brento and answered ’em from my balcony at Disney’s Aulani Resort in Hawaii. I’m not really a Disney guy – we were there for a friend’s birthday celebration – but I tell ya what, that’s my new favorite resort in the world. The water park, food, beach, and nearby ..read more
Brent Ozar Blog
3d ago
I’m coming to Jacksonville, FL on May 2-3 and Raleigh, NC on May 16-17 for SQL Saturdays! In each city, I’m teaching a one-day pre-conference workshop on Friday. Jacksonville Pre-Conference Workshop: Mastering Query Tuning You’ve been working with SQL Server for a few years, and you’re comfortable writing queries and reading execution plans. In this ..read more
Brent Ozar Blog
3d ago
Last week I wrote about the 6 best things Microsoft ever did to SQL Server, but now we gotta pull up a chair and discuss the stinkers. To be fair, I excluded anything that’s basically ANSI standard. I’m sorry that you don’t like functions and cursors, but the reality is that Microsoft adds that stuff ..read more
Brent Ozar Blog
1w ago
Every quarter, we publish adoption rate data showing how quickly people are adopting new versions of SQL Server. Today it’s time for the winter 2025 version of our SQL ConstantCare® population report. SQL Server 2022 is finally seeing some good adoption with about 21% of the market. It’s gradually taking market share from all other ..read more
Brent Ozar Blog
1w ago
Is your company hiring for a database position as of February 2025? Do you wanna work with the kinds of people who read this blog? Let’s set up some rapid networking here. If your company is hiring, leave a comment. The rules: Your comment must include the job title, and either a link to the ..read more
Brent Ozar Blog
1w ago
This entire blog post is driven by the #1 feature in this list. I think about the #1 feature a lot, like at least once a week. I think about it so much that I had to stop and think about what other similar great things Microsoft has done over the years, and be thankful for ..read more
Brent Ozar Blog
2w ago
I originally took these questions from https://pollgab.com/room/brento poolside at the Trixie Motel (really), but I forgot to use the good microphone, so I re-recorded ’em from my home studio when I got back: Here’s what we covered: 01:04 NeedMoney: What’s the fastest/easiest way to make money as SQL Server Consultant (Production work, performance, health check ..read more
Brent Ozar Blog
2w ago
Accelerated Database Recovery (ADR) is a database-level feature that makes transaction rollbacks nearly instantaneous. Here’s how it works. Without ADR, when you update a row, SQL Server copies the old values into the transaction log and updates the row in-place. If you roll that transaction back, SQL Server has to fetch the old values from ..read more
Brent Ozar Blog
2w ago
Let’s get a little nerdy and look at database internals. Create two tables: one with a million unique values, and one with a million identical values: [crayon-679b32ff84cc3026795251/] I’m just using dates here, not strings, numbers, or other values – those are great experiments for you to play around with as well, dear reader, but I ..read more
Brent Ozar Blog
3w ago
I took 5 of your top-voted questions from https://pollgab.com/room/brento while hanging out in the backyard on my second gin & tonic. I, uh, might have lost my temper on the last one. Here’s what we covered: 00:00 Start 02:38 Frozt: are you familiar with SQL Server assemblies? and if they can cause assertion or IAM ..read more