It’s Been 6 Months. SQL Server 2022 Still Isn’t Ready ...
Six months ago today, Microsoft announced that SQL Server 2022 was ready. Except it wasn’t. And it still […]
brentozar.com
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 […]
[Video] Office Hours: Testing the First Responder Kit
I tested the April release of the FRK, then answered your questions from https://pollgab.com/room/brento. Here’s what we […]
Free Webcast Next Week! What’s New (and Actually Good) in ...
It’s May 2023, and believe it or not, some of the flagship features in Microsoft’s latest version still […]
[Video] Office Hours: 25 Pretty Good Questions
You post questions at https://pollgab.com/room/brento and upvote the ones you’d like to see, and my job is to […]
Classing Up SSMS is as Easy as 1, 2, 3.
Step 1: go into Tools, Options and set this: Step 2, set this: Step 3, check this box: […]
Happy 21st Anniversary, BrentOzar.com. What’s Coming Next?
It’s pretty cool to look at a blog post and see, “Last updated: 21 years ago.” It’s pretty […]
Updated First Responder Kit and Consultant Toolkit for April 2023
This month’s big changes are performance tuning in sp_BlitzFirst & sp_BlitzLock. Part of the benefits of using the […]
How to Go Live on SQL Server 2022
You’re planning to migrate to SQL Server 2022, and you want your databases to be faster after the […]
[Video] Office Hours: Live Q&A
This one’s broken up into two parts because I took a bio break mid-stream: 00:00 Start 03:04 Clippy: […]
What Does Setting the SQL Server Compatibility Level Do?
If you right-click on a database in SQL Server Management Studio, you get an option to set Compatibility […]
[Video] Office Hours Speed Round: 21 Answers in 15 Minutes
HONK HONK! It’s time for a fast round of answers to concise questions y’all posted and upvoted at […]
Office Hours Speed Round, Easy Text Answers Edition
Some of the questions y’all post at https://pollgab.com/room/brento have easy one-line answers. Let’s knock ’em out: George: Hi […]
[Video] Office Hours: Ask Me Anything About Azure SQL DB ...
Post your questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me answer. Here’s what we […]
SQL ConstantCare® Population Report: Spring 2023
Ever wonder how fast people are adopting new versions of SQL Server, or what’s “normal” out there for […]
Announcing Live Office Hours on Wednesdays & Thursdays
It’s time for summer school! I’m doing live streaming on my Twitch channel on Wednesdays & Thursdays this […]
What SQL Server People Should Know About Amazon Aurora Serverless
You, dear reader, are most likely a Microsoft SQL Server user – either a DBA or developer. Set […]
[Video] Office Hours: Ask Me Anything at Sea
It was a dark and stormy morning, on the last day of my Panama Canal cruise. Before I […]
Who’s Hiring in the Microsoft Data Platform Community? April 2023 ...
Is your company hiring for a database position as of April 2023? Do you wanna work with the […]
[Video] Office Hours: Ask Me Anything About SQL Server in ...
Off the coast of Costa Rica, I went through your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: […]
Is SQL Server 2019 More CPU-Intensive Than SQL Server 2016?
I’m running into something that I’m having a hard time believing. A client was hitting CPU issues during […]
This is the Last Week of Free PowerShell Training.
You’ve been working hard all month to get through our newest class, Fundamentals of PowerShell for DBAs. This week, […]
Office Hours: Questions That Didn’t Make the Cut
Sometimes, y’all post questions at https://pollgab.com/room/brento and they don’t get a lot of upvotes, and reading through ’em, […]
[Video] Office Hours in Cartagena, Colombia
Before heading out to Old Town for sightseeing, I went through your top-voted questions from https://pollgab.com/room/brento. Here’s what […]
It’s Monday. Do You Know Where Your PowerShell Training Is?
You’re over the hump! Just two weeks left to go. All month long, I’m giving away our newest […]
Slow Startup, Failover, and Restore Times with In-Memory OLTP
When In-Memory OLTP came out, I worked with it briefly, and I remember coming away thinking, “Who in […]
[Video] Office Hours at Sea: Heading to Jamaica
I’m on a boat! I’m on a 10-day Panama Canal cruise, and I stopped (well, not the boat) […]
Better Keep Up: More Free PowerShell Videos This Week.
We’re almost halfway through the month. How’s it coming? You keeping up? Or are you having a tough […]
Who’s Hiring in the Microsoft Data Platform Community? March 2023 ...
Is your company hiring for a database position as of March 2023? Do you wanna work with the […]
I’m Coming to Boston for SQLSaturday!
I’m coming back to Boston for SQLSaturday this October 14th! On Friday the 13th (muhaha), before the event, […]
It’s Monday. Get Back to Learning PowerShell.
You’re a production database administrator responsible for the health, security, and uptime of many database servers. You’ve been […]
I’m Coming to Gothenburg and Oslo This Fall!
Back in 2020 before the wheels came off the world, I’d scheduled visits to Gothenburg and Oslo for […]
Learn PowerShell in 30 Minutes a Day, Free, Starting Now.
The clock starts now! You’re a production database administrator responsible for the health, security, and uptime of many […]
Can You Nest Transactions in SQL Server?
To find out, let’s set up a simple status log table: DROP TABLE IF EXISTS dbo.StatusLog; CREATE TABLE […]
Find 40 Problems in This Stored Procedure.
Aaron Bertrand posted a challenge: We’re going to use the AdventureWorks sample database (get your copy here), where […]
Office Hours: Short Text Answers Edition
Not all of the questions y’all post at https://pollgab.com/room/brento require long-winded responses. Brandon: Do you seen a rise […]
Updated First Responder Kit and Consultant Toolkit for February 2023
Thanks to this technique to run SQL Server on Apple Silicon chips, I’m now developing exclusively on my […]
[Video] Office Hours Brought to You by Quest Software
Today’s episode of Office Hours is brought to you by Quest Software. I went through your top-voted questions […]
Who’s Hiring in the Microsoft Data Platform Community? February 2023 ...
It’s Valentine’s day – let’s do some matchmaking! Is your company hiring for a database position as of […]
[Video] Office Hours: Quiet Sunday Edition
While waiting for the dry cleaner to open, I went live to stream a quiet session going through […]
Free Training Coming Up! March is PowerShell Month.
You’re a production database administrator responsible for the health, security, and uptime of many database servers. You’ve been […]
[Video] Office Hours: Snowy Michigan Edition
We went up to Michigan to see my dad’s side of the family, and the snow came down […]
[Video] Office Hours: 22 Good Questions and a Stinker
Lots of good questions on today’s broadcast! If you’d like to submit one, go to https://pollgab.com/room/brento and upvote […]
[Video] Office Hours: Quickie Before Dinner
Before heading out to dinner, I went through your highly-upvoted questions from https://pollgab.com/room/brento. Here’s what we covered in […]
Office Hours, ChatGPT Edition: AI Answers 4 of Your Questions
In a recent Office Hours post, David Reabow suggested letting ChatGPT answer a few of the questions y’all […]
[Video] Office Hours: Ten Minutes of SQL Server Answers
ChatGPT, Resource Governor, manually created stats, Always Encrypted, and as always, fragmentation: let’s answer your questions from https://pollgab.com/room/brento. […]
Bite-Sized Office Hours: Q&A on TikTok
Wanna learn about SQL Server and the Microsoft data platform, but you don’t wanna sit through long videos? […]
The 20th Anniversary of the SQL Slammer Worm
Twenty years ago this month (next Wednesday to be exact), sysadmins and database administrators started noticing extremely high […]
[Video] Office Hours: Back Live on Twitch Again
After I stopped selling live classes, I took some time off all live broadcasting period. It was a […]
How to Install SQL Server and the Stack Overflow Database ...
To follow along, you’ll need: An Apple Mac with an Apple Silicon processor (M1, M2, etc – not an […]