Posts by Brent Ozar

Most DBAs Say They’re Encrypting Personally Identifiable Data. Most.

Despite the continuous stream of data breaches, ransomware, and GDPR violations, some companies still aren’t encrypting personally identifiable information (PII) inside our databases or backups. I see this all the time when working with clients, but I can’t exactly talk about that or give numbers, so I decided to take a highly unscientific poll on…
Read More

[Video] Office Hours: Hotel Balcony Edition, Part 2

Videos
0
Post your questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me cover. In today’s episode, I sit down on a quiet hotel balcony and talk through a bunch of interesting questions: Here’s what we covered: 00:00 Introductions 00:59 Haydar: What tools do you like to use when troubleshooting azure sql db query…
Read More

[Video] Office Hours: Hotel Balcony Edition, Part 1

Videos
1 Comment
Post your questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me cover. In today’s episode, I sit down on a quiet hotel balcony and talk through a bunch of interesting questions: Here’s what we covered today: 00:00 Introductions 00:25 Kebros: Hi Brent.My manager wants me to summarize sql health into a number…
Read More
And it looks bad even in shades.

Office Hours, Short Text Answers Edition

Not all of the questions y’all post at https://pollgab.com/room/brento require long, thought-out answers. Some are just one-line specials, like these: F’legend: Hi Brent, in reply to a question talking about database restores for 1TB+ you also touched on scrubbing or synthetic data as a way to populate dev environments. Are there any resources/tools you would…
Read More
And it looks bad even in shades.

PSPO: How SQL Server 2022 Tries to Fix Parameter Sniffing

Parameter sniffing is a notorious problem for Microsoft SQL Server because it tries to reuse execution plans, which doesn’t work out well for widely varying parameters. Here’s a primer for the basics about how it happens. SQL Server 2022 introduces a new feature called Parameter Sensitive Plan optimization. I’m not really sure why Microsoft capitalized…
Read More
Brent Ozar

What’s New in SQL Server 2022 Release Candidate 0: Undocumented Stuff

SQL Server 2022
24 Comments
Microsoft has an official list of what’s new in 2022 overall, but here I’m specifically focusing on system objects that might be interesting to script developers like you and I, dear reader. New stored procedure sp_get_table_card_est_and_avg_col_len – I assume the “card” refers to statistics and cardinality, not Hallmark. SQL Server has historically struggled with memory…
Read More

[Video] Office Hours: Ask Me Anything About SQL Server

Videos
0
Post your Microsoft data platform questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me answer. I sat down by the pool in Cabo with a cup of coffee to go through ’em: Here’s what we covered in this episode: 00:00 Introductions 00:43 MergeItLikeItsHot: Hi Brent, do you have any good resources to…
Read More

Your Turn: I’m Not Answering These 13 Office Hours Questions

Normally, after I do a round of Office Hours of going through the questions that got posted at https://pollgab.com/room/brento, I answer the highly upvoted ones and then clear the queue. If y’all didn’t upvote questions, then I don’t answer ’em. However, today I’m trying something different: I’ll post the non-upvoted questions here for y’all to…
Read More

[Video] Office Hours at the End of the World

Videos
3 Comments
I hopped down to Cabo San Lucas and sat at the End of the World to answer the questions you posted & upvoted at https://pollgab.com/room/brento. Here’s what we covered: 00:00 Intros 00:44 Kirk Saunders: Hey Brent! When did you determine your knowledge/skillset/etc.. was sufficient to teach your various classes? I think I’m doing well at…
Read More