[Video] Office Hours: Bad Hair Edition
I am waaaay overdue for a haircut, but instead of being a responsible adult, I stopped to take […]
brentozar.com
Office Hours: Bad Questions Edition
Normally, y’all post and upvote great questions at https://pollgab.com/room/brento, but in today’s episode, y’all upvoted some stinkers. Buckle […]
3 Ways to Debug T-SQL Code
Writing new code = bugging. That part’s easy. Taking those bugs back out, that’s the hard part. Developers […]
How to Find Missing Rows in a Table
When someone says, “Find all the rows that have been deleted,” it’s a lot easier when the table […]
The SQL Server Posts You Read the Most in 2022
Here’s what I wrote in 2022 that gathered the most views: #10: Who’s Hiring in the Database Community? […]
Announcing the 2023 Data Professional Salary Survey Results.
Are your peers being paid more this year? Are they switching job roles? Are they planning on leaving […]
Who’s Hiring in the Microsoft Data Platform Community? January 2023 ...
Was your New Year’s resolution to get a new job? Heads up: the comments in this post are […]
[Video] Office Hours: Holiday Speed Round
Beep beep! Here’s a speed round of Office Hours where I rip through a dozen questions in under […]
SQL ConstantCare® Population Report: Winter 2022
Ever wonder how fast people are adopting new versions of SQL Server, or what’s “normal” out there for […]
[Video] Office Hours: Ham Pillow Edition
Y’all post questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me discuss, and then I […]
Should You Use SQL Server 2022’s GREATEST and LEAST?
If you’ve been following along with this week’s posts on DATETRUNC and STRING_SPLIT, you’re probably going to think […]
Should You Use SQL Server 2022’s STRING_SPLIT?
SQL Server 2022 improved the STRING_SPLIT function so that it can now return lists that are guaranteed to […]
Should You Use SQL Server 2022’s DATETRUNC?
SQL Server 2022 introduced a new T-SQL element, DATETRUNC, that truncates parts of dates. For example: SELECT DATETRUNC(year, […]
[Video] Office Hours: Great Questions, Part 2
Every time I think, “There can’t be any more SQL Server questions left,” y’all post more great ones […]
Updated First Responder Kit and Consultant Toolkit for December 2022
Santa’s elves took a break from building toys and shipped a new version of the First Responder Kit. […]
[Video] Office Hours: Great Questions, Part 1
Wow, y’all have been posting some great questions at https://pollgab.com/room/brento lately! Here’s what we covered today: 00:59 Gustav: […]
Who’s Hiring in the Microsoft Data Platform Community? December 2022 ...
Is your company hiring for a database position as of December 2022? Do you wanna work with the […]
The Black Friday Sale Has Been Extended!
I got a *lot* of last minute emails this year from companies whose purchasing processes were moving slowly. […]
Slow “Having” Query? Try Pre-Filtering.
I was helping a client with a query, and I’m going to rework the example to use the […]
[Video] Office Hours: Black Friday Edition
My Black Friday sale is in its last days, so most of my time at the moment is spent […]
Contest: Guess the Next SQL Server Release Date
When will Microsoft officially release SQL Server 2023 (or 2024, or whatever it’ll be) for download? The dust […]
Are You Underpaid? Let’s Find Out: The 7th Annual Data ...
Whew. This is a crazy time, isn’t it? The aftermath of the pandemic is kicking in, and there […]
Looking Back at the 2022 #PASSDataCommunitySummit in Seattle
I’m back home in Vegas, back down to Inbox Zero, and I’ve had some time to think about […]
#PASSdataCommunitySummit Keynote Day 3 Live Blog
Today at the PASS Data Community Summit in Seattle, Kimberly Tripp is doing the first-ever in-person community keynote. […]
#PASSdataCommunitySummit Keynote Day 2 Live Blog
I’m in Seattle for the PASS Data Community Summit, and the day 2 keynote is about to start. […]
SQL Server 2022 Paid Editions Require a Licensing Key.
For the final release of SQL Server 2022, Microsoft popped a surprise that wasn’t in the release candidates: […]
SQL Server 2022 Release Date: November 16, 2022
Microsoft released SQL Server 2022 today, November 16, 2022. The footnotes indicate: SQL Server 2022 free editions (Developer […]
Join #TeamHugo and Help Fight Leukemia.
If you’ve been reading this blog for a while or subscribed to my email newsletters, you’ve learned something […]
#PASSdataCommunitySummit Keynote Day 1 Live Blog
I’m in Seattle for the biggest annual gathering of Microsoft data platform professionals, the PASS Data Community Summit. […]
Office Hours: Read This, Watch This Edition
This week, a lot of the questions you posted at https://pollgab.com/room/brento just need pointers to resources at other […]
[Video] Office Hours: Sponsored By Black Friday Edition
Y’all post questions at https://pollgab.com/room/brento, upvote the ones you’d like to see me cover, and then I talk […]
[Video] Office Hours: Surprise Edition
Y’all post questions at https://pollgab.com/room/brento, upvote the ones you’d like to see me cover, and then I talk […]
Is There a Bug in SQL Server’s MAXDOP Calculation?
I think I’ve found a bug in SQL Server setup’s MAXDOP calculation, and I need you to take […]
Who’s Hiring in the Microsoft Data Platform Community? November 2022 ...
Is your company hiring for a database position as of November 2022? Do you wanna work with the […]