[Video] Office Hours at Sea: Heading to Jamaica
I’m on a boat! I’m on a 10-day Panama Canal cruise, and I stopped (well, not the boat) […]
brentozar.com
Better Keep Up: More Free PowerShell Videos This Week.
We’re almost halfway through the month. How’s it coming? You keeping up? Or are you having a tough […]
Who’s Hiring in the Microsoft Data Platform Community? March 2023 ...
Is your company hiring for a database position as of March 2023? Do you wanna work with the […]
I’m Coming to Boston for SQLSaturday!
I’m coming back to Boston for SQLSaturday this October 14th! On Friday the 13th (muhaha), before the event, […]
It’s Monday. Get Back to Learning PowerShell.
You’re a production database administrator responsible for the health, security, and uptime of many database servers. You’ve been […]
I’m Coming to Gothenburg and Oslo This Fall!
Back in 2020 before the wheels came off the world, I’d scheduled visits to Gothenburg and Oslo for […]
Learn PowerShell in 30 Minutes a Day, Free, Starting Now.
The clock starts now! You’re a production database administrator responsible for the health, security, and uptime of many […]
Can You Nest Transactions in SQL Server?
To find out, let’s set up a simple status log table: DROP TABLE IF EXISTS dbo.StatusLog; CREATE TABLE […]
Find 40 Problems in This Stored Procedure.
Aaron Bertrand posted a challenge: We’re going to use the AdventureWorks sample database (get your copy here), where […]
Office Hours: Short Text Answers Edition
Not all of the questions y’all post at https://pollgab.com/room/brento require long-winded responses. Brandon: Do you seen a rise […]
Updated First Responder Kit and Consultant Toolkit for February 2023
Thanks to this technique to run SQL Server on Apple Silicon chips, I’m now developing exclusively on my […]
[Video] Office Hours Brought to You by Quest Software
Today’s episode of Office Hours is brought to you by Quest Software. I went through your top-voted questions […]
Who’s Hiring in the Microsoft Data Platform Community? February 2023 ...
It’s Valentine’s day – let’s do some matchmaking! Is your company hiring for a database position as of […]
[Video] Office Hours: Quiet Sunday Edition
While waiting for the dry cleaner to open, I went live to stream a quiet session going through […]
Free Training Coming Up! March is PowerShell Month.
You’re a production database administrator responsible for the health, security, and uptime of many database servers. You’ve been […]
[Video] Office Hours: Snowy Michigan Edition
We went up to Michigan to see my dad’s side of the family, and the snow came down […]
[Video] Office Hours: 22 Good Questions and a Stinker
Lots of good questions on today’s broadcast! If you’d like to submit one, go to https://pollgab.com/room/brento and upvote […]
[Video] Office Hours: Quickie Before Dinner
Before heading out to dinner, I went through your highly-upvoted questions from https://pollgab.com/room/brento. Here’s what we covered in […]
Office Hours, ChatGPT Edition: AI Answers 4 of Your Questions
In a recent Office Hours post, David Reabow suggested letting ChatGPT answer a few of the questions y’all […]
[Video] Office Hours: Ten Minutes of SQL Server Answers
ChatGPT, Resource Governor, manually created stats, Always Encrypted, and as always, fragmentation: let’s answer your questions from https://pollgab.com/room/brento. […]
Bite-Sized Office Hours: Q&A on TikTok
Wanna learn about SQL Server and the Microsoft data platform, but you don’t wanna sit through long videos? […]
The 20th Anniversary of the SQL Slammer Worm
Twenty years ago this month (next Wednesday to be exact), sysadmins and database administrators started noticing extremely high […]
[Video] Office Hours: Back Live on Twitch Again
After I stopped selling live classes, I took some time off all live broadcasting period. It was a […]
How to Install SQL Server and the Stack Overflow Database ...
To follow along, you’ll need: An Apple Mac with an Apple Silicon processor (M1, M2, etc – not an […]
[Video] Office Hours: Bad Hair Edition
I am waaaay overdue for a haircut, but instead of being a responsible adult, I stopped to take […]
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: […]