How to Send Email with SQL Server’s sp_send_dbmail
So you’re writing T-SQL code and you’ve decided that you want to send emails to customers, employees, or […]
brentozar.com
SQLBits is Coming Back to London in June 2025!
I used to feel bad saying that any one conference is “my favorite” because I worried that other […]
[Video] Office Hours at the Petit Ermitage in LA
I went to LA for the opening week of Somni, a gorgeous restaurant in LA, and took your […]
Who’s Hiring in the Microsoft Data Platform Community? December 2024 ...
Is your company hiring for a database position as of December 2024? Do you wanna work with the […]
Announcing the Holiday Sale
Our annual Black Friday sale is over, but we’ve got a simple sale for folks who couldn’t get […]
[Video] Office Hours: Car in the Dining Room Edition
What, doesn’t everyone park a convertible in their dining room? I address the pink elephant in the room, […]
Making Your Learning Plan for 2025
This week is my annual Black Friday sale, and over and over, folks buy the Fundamentals & Mastering […]
This Is It! Our Annual Black Friday Sale on SQL ...
You’ve been eyeing my training classes all year long, biting your lip with lustful hunger, wishing you could […]
[Video] Office Hours: Ask Me Database Questions
I took your top-voted questions from https://pollgab.com/room/brento. At one point, my camera overheats – hang in there, I […]
Updated Training Modules for SQL Server 2019 & 2022
At the PASS Summit this month, I presented a 1-day workshop called T-SQL Tuning for SQL Server 2019 […]
3 Legit Signs It’s Time for Enterprise Edition
Your app is happily humming along on SQL Server Standard Edition. Things are quiet – too quiet. You’re […]
What’s New in SQL Server 2025
Today at Microsoft Ignite, Microsoft announced SQL Server 2025. The biggest new features focus on AI and bringing […]
SQL ConstantCare® Population Report: Fall 2024
Every quarter, we publish adoption rate data showing how quickly people are adopting new versions of SQL Server. […]
Help Me Help You.
In my PollGab room where y’all can ask questions, Chocolate Thunder wrote: I do genuinely wish that I […]
Office Hours: Guess the Theme Edition
There’s a secret theme to the questions I hand-picked from the queue at https://pollgab.com/room/brento. Normally I just take […]
SSMS v21: Dark Mode, Git, Vertical Tabs, and More
SQL Server Management Studio v21 Preview 1 is out and let’s give it a quick whirl. It’s installed with […]
Copilot in SSMS is Kinda Like IE in SSMS
You are not ready for how weird my take is. Last week at the PASS Summit conference in […]
[Video] Office Hours: SQL Server Questions and Answers
That face I’m making in the video thumbnail is priceless. YouTube randomly picks these, and I laughed out […]
Office Hours in the Valley of Fire
I took the Graffiti Gulf 356 out to the Valley of Fire State Park to exercise it, and […]
Office Hours at the PASS Summit in Seattle
I’m in Seattle this week for the PASS Data Community Summit. Before the pre-conference sessions started, I sat […]
Who’s Hiring in the Microsoft Data Platform Community? November 2024 ...
Is your company hiring for a database position as of November 2024? Do you wanna work with the […]
Watch Me Stream at the PASS Summit for Free!
This week at the PASS Data Community Summit in Seattle, 15 sessions are getting streamed online for free! […]
Our Annual Black Friday Sale Starts Now!
The wait is over: my annual Black Friday sale has officially launched! If you’ve been eyeing any of […]
[Video] Office Hours: Let’s Have a Drink
I was making myself a drink to film Office Hours and I realized I should just film it […]
Launch Day Bonus: Free Stuff on Friday
Our annual Black Friday sale launches this Friday and runs all month. For those of you who are […]
Who Actually Buys BrentOzar.com Training?
So you’re thinking about picking up some of my training & online services during our annual Black Friday […]
The Countdown is On: Our Black Friday Sale Starts This ...
All year long, when you’re watching my Office Hours sessions, you keep hearing me say, “That topic is […]
[Video] Office Hours: Salem Witchcraft Edition
It’s spooky time again! I visited Salem, Massachusetts again this year, this time for a friend’s wedding. I […]
[Video] Office Hours: Open Q&A About Databases
I’m back in the home office to take your database questions from https://pollgab.com/room/brento. Here’s what we covered in […]
What’s In Your Development Database? The Answer: Production Data.
Are your developers working with live production data, completely made-up synthetic data, or something in between? I posted […]
[Video] SQL Server Always On Availability Groups 101
I got a few closely related Availability Groups questions at https://pollgab.com/room/brento and decided to do a half-hour introduction […]
Updated First Responder Kit and Consultant Toolkit for October 2024
The wording of all of sp_BlitzIndex’s warnings is now much more clear and inclusive thanks to hard work […]
[Video] Office Hours: Back at Home (Briefly)
I took a break from unpacking my SQL Saturday San Diego bags and re-packing for a Boston wedding […]
How Many Indexes Is Too Many?
Let’s start with the Stack Overflow database (any size will work), drop all the indexes on the Users […]
Should That Be One Update Statement or Multiple?
Let’s say we have a couple of update statements we need to run every 15 minutes in the […]
[Video] Consulting Lines
In my consulting work, I often find myself saying the same things to clients – but they’re not […]
[Video] Office Hours on a Calm Sea Day Off Canada
On an unbelievably calm sea day off the shores of Canada, aboard the Norwegian Jewel, I enjoyed a […]
Poll: What’s In Your Development Database?
When your developers work on new queries or testing complaints about existing queries, what database are they working […]
Finished Your Training? Get a Certificate of Completion.
If you want to get a raise or stand out from a crowd of job hunt competitors, you […]
[Video] Office Hours in Haines, Alaska: No Bears Here
While in beautiful Haines, Alaska along the Chilkoot River, I stopped to take your top-voted questions from https://pollgab.com/room/brento. […]
[Video] Office Hours: Icy Strait Point, Alaska
I’m on a boat! We took an Alaska cruise with some friends aboard the Norwegian Jewel. En route […]
Who’s Hiring in the Microsoft Data Platform Community? October 2024 ...
Is your company hiring for a database position as of October 2024? Do you wanna work with the […]
Announcing the Winners of the Biggest Database Regret Contest
I recently asked you to leave a comment with your biggest database regret, and the comments were great! […]
The 2024 Black Friday Sale is Coming Next Month.
Your accounting office Every year during November, we run a big sale all month long. And every year, […]
[Video] Office Hours: Open Q&A on Microsoft Databases
I took your top-voted questions from https://pollgab.com/room/brento while recovering from a late night of partying. Here’s what we […]
Free Webcast: How to Think Like the Engine, Big Data ...
Brent, Big Coat Edition You’ve watched my free How to Think Like the Engine class that focuses on […]
Yes, Cardinality Estimation Keeps Changing After SQL Server 2014.
About 10 years ago, Microsoft made changes to the Cardinality Estimator (CE) which caused some problems for SQL […]
TRY/CATCH Doesn’t Always Work.
If you’re using TRY/CATCH to do exception handling in T-SQL, you need to be aware that there are […]
[Video] Office Hours: Open Q&A About Databases
I went through your top-voted questions from https://pollgab.com/room/brento plus hit live ones from the TikTok viewers. Here’s what […]
Query Exercise Answers: Why Are These 3 Estimates So Wrong?
This week’s Query Exercise challenged you to figure out why these 3 estimates went so badly: SELECT TOP […]