[Video] Office Hours in Cartagena, Colombia

Videos
1 Comment
Before heading out to Old Town for sightseeing, I went through your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00:44 Haydar: Is there a good way to suppress part of TSQL batch from showing the query plan in SSMS but having the rest of the batch show the query plan? 02:13 Mike:…
Read More

[Video] Office Hours at Sea: Heading to Jamaica

Videos
0
I’m on a boat! I’m on a 10-day Panama Canal cruise, and I stopped (well, not the boat) off the coast of Florida to answer questions y’all posted at https://pollgab.com/room/brento. 00:00 Start 00:56 DBe: In several places I’ve worked, it’s been “policy” to automatically restart heavy-use SQL servers off-hours on a regular cadence. Usually monthly…
Read More

[Video] Office Hours Brought to You by Quest Software

Videos
2 Comments
Today’s episode of Office Hours is brought to you by Quest Software. I went through your top-voted questions from PollGab.com/room/brento, and, uh, kinda looked like I was sponsored by Fendi while doing it, hahaha: Wow, those logos are bigger than I thought. Here’s what we covered: 00:00 Start 01:20 reluctantly_tolerant : I used FCI instead…
Read More

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

Videos
0
Y’all post and upvote questions at https://pollgab.com/room/brento, and I stream sessions on my Twitch.tv channel where I answer ’em and chat with the audience. 00:00 Start 02:09 Chad Baldwin: Hey Brent! “a friend told me” MSSQL will use an index’s stats to generate a plan, but not use the index itself. 03:25 Jeremiah Daigle: Hey…
Read More

[Video] Office Hours: Quiet Sunday Edition

Videos
2 Comments
While waiting for the dry cleaner to open, I went live to stream a quiet session going through a bunch of y’all’s questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 01:45 Rollback is single threaded: Hi Brent! In microservices application architecture, Using a database per service or a shared database? I asked this because…
Read More

[Video] Office Hours: Snowy Michigan Edition

Videos
3 Comments
We went up to Michigan to see my dad’s side of the family, and the snow came down just in time for our arrival. Always love the fresh snow look. So I stood outside and took your top-voted questions from https://pollgab.com/room/brento. Let’s see what y’all came up with today: Here’s what we covered: 00:00 Start…
Read More

[Video] Office Hours: 22 Good Questions and a Stinker

Videos
4 Comments
Lots of good questions on today’s broadcast! If you’d like to submit one, go to 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 01:05 Testing123: When inserting or updating data into a table, from a concurrency perspective, does it make sense to break up the…
Read More

[Video] Office Hours: Quickie Before Dinner

Videos
0
Before heading out to dinner, I went through your highly-upvoted questions from https://pollgab.com/room/brento. Here’s what we covered in this episode: 00:00 Start 00:20 Mert: Hi Brent, what is the relation between AlwaysOn and Windows Failover Cluster? Is WFC an obligation or a choice for creating an Always On availability group? It will be nice if…
Read More

[Video] Office Hours: Ten Minutes of SQL Server Answers

Videos
2 Comments
ChatGPT, Resource Governor, manually created stats, Always Encrypted, and as always, fragmentation: let’s answer your questions from https://pollgab.com/room/brento. Here’s what we covered today: 00:00 Start 01:13 Timbalero: Hi Brent. my friend knows your view on rebuilding indexes. He also thinks that external index fragmentation affects pretty much only readahead scans. For scientific purposes, what metrics…
Read More
Office Hours - ask me anything.

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

Videos
3 Comments
Y’all just never run out of interesting questions at https://pollgab.com/room/brento! I’m impressed, got another great round today. Here’s what we covered: 00:00 Start 00:25 Chrisbell: Recently we’ve been facing thread starvation issues. How can we troubleshoot it when even sp_whoisactive ( even with DAC ) is unresponsive and takes forever to return a result set…
Read More

[Video] Office Hours: Back Live on Twitch Again

Videos
3 Comments
After I stopped selling live classes, I took some time off all live broadcasting period. It was a nice couple of months over the holidays, had a good time with the family, and now I’m starting to fire up my Twitch channel again. I’m not setting a schedule yet, just broadcasting when I have time…
Read More

[Video] Office Hours: Bad Hair Edition

Videos
8 Comments
I am waaaay overdue for a haircut, but instead of being a responsible adult, I stopped to take your questions from https://pollgab.com/room/brento. 00:00 Start 00:43 Mike: We have 3 Dell PowerEdge R630 servers with SQL Server installed. Everything functions for 3.5 years straight. How long is it expected to work? 01:30 Shalom: What are the…
Read More

Office Hours: Bad Questions Edition

Videos
4 Comments
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 up. 00:00 Start 00:47 SQLKB: Hi, according to sp_BlitzCache I usually have more than 260k plans in cache, created in the past 1 hour, is it a big number? Comparing number of plans from exec_query_stats vs exec_cached_plans…
Read More

[Video] Office Hours: Holiday Speed Round

Videos
0
Beep beep! Here’s a speed round of Office Hours where I rip through a dozen questions in under ten minutes. Want to see your own questions answered? Post ’em and upvote the ones you like at https://pollgab.com/room/brento. 00:00 Start 00:22 DB-A-Team: Love and appreciate your work and please don’t make fun of my question. I…
Read More
Brent Ozar Webcast

[Video] Office Hours: Ham Pillow Edition

Videos
2 Comments
Y’all post questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me discuss, and then I artfully dodge giving you answers. At least, that’s how it feels sometimes, hahaha: Here’s what we discussed in today’s episode: 00:00 Start 00:20 Piotr: Do many of your clients disable SA account for security? What are your…
Read More

[Video] Office Hours: Great Questions, Part 2

Videos
2 Comments
Every time I think, “There can’t be any more SQL Server questions left,” y’all post more great ones at https://pollgab.com/room/brento! Here’s what we covered: 00:21 MattC: Hi Brent. Have you check out ChatGPT’s ability to write SQL code. VERY impressive and in some cases faster than a stackoverflow question. In fact stackoverflow have had to…
Read More

[Video] Office Hours: Great Questions, Part 1

Videos
0
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: Hi Brent We recently migrated to SQL MI General Purpose, and I noticed that the default blob storage per .mdf /.ndf file is 128Gb container with 500 IOPS! This is terribly slow! Would splitting the database into…
Read More

[Video] Office Hours: Speed Round Edition

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

[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

[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