Posts by Brent Ozar

[Video] Office Hours: Black Friday Edition

Videos
0
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…
Read More

#PASSdataCommunitySummit Keynote Day 3 Live Blog

SQL Server
1 Comment
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…
Read More

#PASSdataCommunitySummit Keynote Day 2 Live Blog

#SQLPass
0
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…
Read More

SQL Server 2022 Paid Editions Require a Licensing Key.

SQL Server 2022
9 Comments
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,…
Read More

Join #TeamHugo and Help Fight Leukemia.

#SQLPass
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…
Read More

SQL Server 2022 Release Date: November 16, 2022

SQL Server 2022
7 Comments
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…
Read More

Office Hours: Read This, Watch This Edition

SQL Server
1 Comment
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 /…
Read More

[Video] Office Hours: Sponsored By Black Friday Edition

Videos
2 Comments
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…
Read More

[Video] Office Hours: Surprise Edition

Videos
6 Comments
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…
Read More

[Video] Office Hours: Nine Minutes of Answers

Videos
3 Comments
Post your questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me discuss during my live streams. This week, I took a break from working on my PASS Summit sessions in order to chat: Here’s what we covered: 00:00 Start 00:32 Jeremy: We have an older web app we’re going to be rewriting…
Read More