Videos

  1. Home
  2. Videos
  3. (Page 2)

[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

[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

[Video] Office Hours Live: Ask Me Anything

Videos
4 Comments
Got a question for me? Post your questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me discuss. Before heading to NYC for vacation, I recorded a live Office Hours on my Twitch channel. Here’s what we covered: 00:00 Start 04:40 neil: are there any ‘band aids’ a DBA can apply for a…
Read More

[Video] Office Hours Silent Edition

Videos
7 Comments
Okay, I, uh, forgot to unmute the microphone for this one: So here are the answers in text form instead. <sigh> Thank goodness it was a speed round! Mike: When Brent Ozar’s certification exams for SQL Server will be available? Looking forward to having exams like “Fundamentals of QT”, “Mastering Server Tuning” etc, so you…
Read More

[Video] Office Hours: Ask Me Anything at the Mediterranean Sea

Videos
0
On the last day of my Israel trip, I went through the highly upvoted questions from https://pollgab.com/room/brento and answered ’em, standing in front of the beach. Here’s what we covered: 00:00 Start 00:37 AllThePartyPeople: On our server, MAXDOP=1 (not my choice); we had a poor performing SP call (called as dynamic SQL; again not my choice);…
Read More

[Video] Office Hours: Six-Minute Speed Round

Videos
1 Comment
The morning after the Data TLV Summit in Tel Aviv, I stood out on the balcony and answered a few of your questions from https://pollgab.com/room/brento, rapid-fire style:   Here’s what we covered: 00:00 Intros 00:47 cyrpl: Hi Brent from PEI, Canada. A support person told me today that when creating a table, an ID column…
Read More

[Video] Office Hours in Tel Aviv, Israel

Videos
2 Comments
Before speaking at the Data TLV Summit, I sat by the Mediterranean Sea and discussed the top-voted questions you posted at https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00:55 Manikandan GS: As postgres being one among the RDBMS lane, do you think postgres is having more features and flexibility compared to MS-SQL Server? 02:46 PaginationWoo!:…
Read More