Posts by Brent Ozar

Announcing My 2021/2022 Training Class Schedule

Company News
0
If you want to attend my live online classes, it’s really easy: just buy a Live Class Season Pass and you can drop in on any class that works for your schedule. I recommend attending ’em in this order: Fundamentals, required, in this order: Index Tuning, Query Tuning, Parameter Sniffing Fundamentals, optional: Columnstore, TempDB (can be…
Read More

Do You Have to License Your Standby SQL Server?

Licensing
20 Comments
Businesses who need high availability and disaster recovery usually want three servers: A primary SQL Server where all the writes & reads take place A high availability SQL Server sitting right next to the primary, in the same data center, keeping up with its writes, and A disaster recovery SQL Server sitting in another city…
Read More
Is that a date I see in that varchar column?

You Captioned This Pic and Won Free Stuff.

Humor
5 Comments
Last week, over 600 of y’all captioned this picture, and we had a lot of laughs: My favorite caption overall was from Aart Bluestoke, who won a Live Class Season Pass for this: The funniest part to me was that I’ve had that exact experience several times with several different data type combinations, and I think…
Read More
Brent Reading Book

9 Signs Your T-SQL Might Fail a Code Review

T-SQL
25 Comments
It’s hard to set absolute rules about, “Feature X should absolutely never be used.” However, there are some features that set off alarm bells when I see them. Usually, when I start asking more questions about when we’re using those particular features, I get answers of, “Oh, I didn’t know that was a problem.” As…
Read More

Announcing Fundamentals Week: May 10-14, $295

Company News
0
You love learning from me. You’ve attended some of my free online streams, read my blog posts, and you use the First Responder Kit. You enjoy my laid-back, humorous approach to sharing what I’ve learned over the years. You love live classes. You’ve tried watching recordings or stepping through demos yourself, but…you just can’t block…
Read More

Free TempDB Training Class Next Monday

TempDB
1 Comment
You’ve been working with Microsoft SQL Server for a couple of years, and you know a little bit about TempDB. You’ve heard that temp tables and table variables have different performance characteristics than regular user database tables, and you’ve heard that you’re supposed to have multiple data files. You’re wondering what exactly goes on behind…
Read More

Azure SQL DB Frequently Asked Questions

Azure SQL DB
20 Comments
I’ve seen your search history. Let’s get you some answers. Is Azure SQL DB PaaS, IaaS, or SaaS? Azure SQL DB is platform-as-a-service (PaaS). Microsoft manages most common database tasks for you, and they act as your DBA. This also means that like a DBA, Microsoft will tell you “no” if you try to implement…
Read More
Brent Reading Book

Your Top 10 Ideas for SQL Server

SQL Server
45 Comments
You’ve submitted thousands of bug reports and feature requests at feedback.azure.com, and here’s what you’ve voted as the top 10 requests right now: #10: MIN/MAX as non-aggregate functions. PostgreSQL and Oracle have the GREATEST/LEAST functions that work like COALESCE, allowing you to pass in a list of values and get the top or lowest. Sounds…
Read More
Eyes up here, kid

Pop Quiz: What Do These Things Cost Today?

Hardware
17 Comments
Price check on Aisle 2021. My main consulting job is a 2-day SQL Critical Care® where I help turn around slow SQL Servers. Companies come to me because they’re not sure if it’s a hardware problem, a database configuration issue, bad app code, or what, and they’ve been getting conflicting answers from different teams. Before…
Read More
Menu