[Video] Office Hours: Professional Development & Training Questions
A lot of today’s questions from https://pollgab.com/room/brento have a common theme, but it’s just a coincidence: Here’s what […]
brentozar.com
[Video] Office Hours: 45 Minutes of SQL Server Q&A
It’s a long one, folks! I went through almost 30 of your questions from https://pollgab.com/room/brento to get your […]
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 […]
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 […]