Posts by Brent Ozar

T-SQL

I was helping a client with a query, and I’m going to rework the example to use the Stack Overflow database for easier storytelling. Say we need to: Find all the locations where users have logged in since a certain date, then Return the total count of people who live in those locations One way…

[Video] Office Hours: Speed Round Edition

Last Updated November 25, 2022

I took a break from my Black Friday sale customer support emails to check in on the questions you posted at https://pollgab.com/room/brento and answer the highest-voted ones: 00:00 Start 00:15 Meshulam: What are the top use cases for running SQL Server in a container? Do many of your customers run SQL Server in a container?…

[Video] Office Hours: Black Friday Edition

Last Updated November 25, 2022

My Black Friday sale is in its last days, so most of my time at the moment is spent keeping an eye on the site and answering customer questions. I’m happy to say it’s our best year so far, too! Y’all really like the new access-for-life options. I took a break from the online frenzy to…

Contest: Guess the Next SQL Server Release Date

Last Updated November 19, 2022

SQL Server 2023

215

When will Microsoft officially release SQL Server 2023 (or 2024, or whatever it’ll be) for download? The dust is just barely starting to settle on the 2022 box, so it’s time to guess the next one. Leave one – and only one – comment here in YYYY/MM/DD format with your release date guess. If you…

Are You Underpaid? Let’s Find Out: The 7th Annual Data Professional Salary Survey is Open.

Last Updated November 21, 2022

Salary

Whew. This is a crazy time, isn’t it? The aftermath of the pandemic is kicking in, and there are layoffs happening in Silicon Valley companies, but… the data profession is on fire. I don’t know anyone who’s been out of work for too long because companies are so desperate to get data help. So it’s time…

Looking Back at the 2022 #PASSDataCommunitySummit in Seattle

Last Updated November 21, 2022

I’m back home in Vegas, back down to Inbox Zero, and I’ve had some time to think about last week’s conference in Seattle. I liveblogged the keynotes, but I wanted to talk about the conference overall. This was Redgate’s first time running an in-person Summit after the professional organization folded in December 2020. Redgate bought…

#PASSdataCommunitySummit Keynote Day 3 Live Blog

Last Updated November 18, 2022

SQL Server

Today at the PASS Data Community Summit in Seattle, Kimberly Tripp is doing the first-ever in-person community keynote. Here’s the abstract: Over the 30+ years I’ve been working with SQL Server, I’ve seen an incredible amount of innovation and change. How do we keep up with so many changes and how do we know how…

#PASSdataCommunitySummit Keynote Day 2 Live Blog

Last Updated November 17, 2022

I’m in Seattle for the PASS Data Community Summit, and the day 2 keynote is about to start. This year, now that Redgate owns the Summit event, they’re doing the day 2 keynote. Gotta pay the bills, I suppose! Redgate’s CEO, Jakub Lamik, is leading a team of speakers for the keynote, and here’s the…

SQL Server 2022 Paid Editions Require a Licensing Key.

Last Updated November 17, 2022

SQL Server 2022

For the final release of SQL Server 2022, Microsoft popped a surprise that wasn’t in the release candidates: Your choices are: Install a free edition: Evaluation (which times out after 180 days), Developer (which isn’t allowed to be used for production purposes), or Express (which is limited to small databases & hardware resources) Use pay-as-you-go-billing,…

Join #TeamHugo and Help Fight Leukemia.

Last Updated November 16, 2022

If you’ve been reading this blog for a while or subscribed to my email newsletters, you’ve learned something from Hugo Kornelis. Hugo is the wildly productive and selfless guy behind the Execution Plan Reference, SQLServerFast.com, tons of SQLBits sessions, videos on YouTube, and he’s @Hugo_Kornelis. He’s unbelievably upbeat and positive. He loves what he does, and…

SQL Server 2022 Release Date: November 16, 2022

Last Updated November 16, 2022

SQL Server 2022

Microsoft released SQL Server 2022 today, November 16, 2022. The footnotes indicate: SQL Server 2022 free editions (Developer edition, Express edition) are available to download starting today. SQL Server 2022 paid editions (Enterprise edition, Standard edition) will be available in Volume Licensing (Enterprise Agreement, Enterprise Agreement Subscriptions) customers starting today, which represents the majority of…

#PASSdataCommunitySummit Keynote Day 1 Live Blog: SQL Server 2022 is Out Now.

Last Updated November 16, 2022

I’m in Seattle for the biggest annual gathering of Microsoft data platform professionals, the PASS Data Community Summit. This is the first in-person Summit since the pandemic, and the first since Redgate took over ownership from the old PASS organization. I’m really excited – this is like a family reunion for me. Microsoft’s Rohan Kumar…

Office Hours: Read This, Watch This Edition

Last Updated November 10, 2022

SQL Server

This week, a lot of the questions you posted at https://pollgab.com/room/brento just need pointers to resources at other places. Welcome to the Read This, Watch This series of answers. Don’t Blame Anthony: Our developers prefer writing TSQL queries directly in their .NET code rather than writing sprocs and calling them. What are the pros /…

[Video] Office Hours: Sponsored By Black Friday Edition

Last Updated November 10, 2022

Y’all post questions at https://pollgab.com/room/brento, upvote the ones you’d like to see me cover, and then I talk through ’em. Here’s what we covered today: 00:00 Start 00:22 CKI: Could please give me pointers how to answer the question “Do we need to create a new instance for the new application or can use the…

[Video] Office Hours: Surprise Edition

Last Updated November 6, 2022

Y’all post questions at https://pollgab.com/room/brento, upvote the ones you’d like to see me cover, and then I talk through ’em. There’s a slight problem with this episode: I forgot to hit the Record Questions button in PollGab, so I can’t quickly/easily generate the list of questions we covered. If you asked a highly voted question…

Is There a Bug in SQL Server’s MAXDOP Calculation? (Update: Yes!)

Last Updated November 3, 2022

Configuration Settings

I think I’ve found a bug in SQL Server setup’s MAXDOP calculation, and I need you to take a second look. Setup is recommending MAXDOP 8: Which is odd, because this is running on an AWS i3.16xlarge with 2 sockets, 2 NUMA nodes, 32 logical processors per node, 64 logical processors altogether. In this screenshot, I’ve laid…

Who’s Hiring in the Microsoft Data Platform Community? November 2022 Edition

Last Updated September 18, 2022

Who's Hiring

Is your company hiring for a database position as of November 2022? Do you wanna work with the kinds of people who read this blog? Let’s set up some rapid networking here. If your company is hiring, leave a comment. The rules: Your comment must include the job title, and either a link to the full…

Welcome to the Black Friday Sale of a Lifetime.

Last Updated October 31, 2022

Company News

Every November, we run a Black Friday sale with huge discounts on our training and apps. Sales are open now with deep discounts on bundled subscriptions that give you the training and online services you need to be a top-notch SQL Server professional: Level 1 Bundle$395Normally $1,785SQL ConstantCare®The Consultant ToolkitAll Fundamentals classesSign upLevel 2 Bundle$995Normally…

[Video] Office Hours: Answering Your Microsoft Data Platform Questions

Last Updated October 24, 2022

Ask questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me cover. Here’s what we covered today: 00:00 Start 00:59 neil: is it dangerous/risky to expand a drive in azure with SQL data files on it? sql on azure vm. dont know what happens behind the scenes 02:07 Brett: I am a consultant…

[Video] Office Hours: Nine Minutes of Answers

Last Updated October 22, 2022