Videos

[Video] Office Hours: Waiting for the Hot Tub to Fill

Videos
2 Comments
While waiting for my Husavik hot tub to fill up, I took your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 01:28 1440×1080: always on with 2 nodes 1db, readable secondary. I’ve optimized both nodes to a point where the primary can withstand both workloads.i want to downgrade licensing from enterprise to standard.…
Read More

Office Hours: Unusual Beach Chair Edition

Videos
0
When you think ‘beach chair’, this probably isn’t what you think. I’m at a black sand beach on the south coast of Iceland, answering your top-voted questions from https://pollgab.com/room/brento. 00:00 Start 02:28 BoBo: Let us rate Brent’s shirts – I will start. “Morally flexible” and “Maybe today, Satan” are my top picks. Which one is…
Read More

[Video] Office Hours: We’ve Got the (Honda) Beat

Videos
3 Comments
Meet my latest toy, a 1991 Honda Beat! I introduce it, then take your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 02:17 Pro: Are sessions sleeping during transactions harmful, and do they prevent the transaction log from truncating? If so, how can’t I prevent them server-side? 03:35 sqlknitter: We have high IO…
Read More
Office Hours: Hawaiian Edition

[Video] Office Hours: Hawaiian Edition

Videos
0
I took your top-voted questions from https://pollgab.com/room/brento and answered ’em from my balcony at Disney’s Aulani Resort in Hawaii. I’m not really a Disney guy – we were there for a friend’s birthday celebration – but I tell ya what, that’s my new favorite resort in the world. The water park, food, beach, and nearby…
Read More
[Video] Office Hours and an AI-Generated Sweatshirt

[Video] Office Hours and an AI-Generated Sweatshirt

Videos
1 Comment
I originally took these questions from https://pollgab.com/room/brento poolside at the Trixie Motel (really), but I forgot to use the good microphone, so I re-recorded ’em from my home studio when I got back: Here’s what we covered: 01:04 NeedMoney: What’s the fastest/easiest way to make money as SQL Server Consultant (Production work, performance, health check,…
Read More
[Video] Office Hours in My Vegas Backyard

[Video] Office Hours in My Vegas Backyard

Videos
7 Comments
I took 5 of your top-voted questions from https://pollgab.com/room/brento while hanging out in the backyard on my second gin & tonic. I, uh, might have lost my temper on the last one. Here’s what we covered: 00:00 Start 02:38 Frozt: are you familiar with SQL Server assemblies? and if they can cause assertion or IAM…
Read More

[Video] Office Hours: Long Answers Edition

Videos
1 Comment
Today’s questions from https://pollgab.com/room/brento require a little bit longer answers: Here’s what we covered: 00:00 Start 03:20 Josef: What is table partitioning, and can it improve performance? Does its effectiveness depend on the underlying storage? In what scenarios is it most useful? 05:10 DBAMatt: If there was a new Mt. Rushmore with the heads of…
Read More

[Video] Office Hours in Tokyo, Japan

Videos
0
For the last Office Hours of the year, I’m coming to you from Tokyo, the last stop on my 3-week tour of China and Japan. This was a big Epic Life Quest task for me, for sure, something I’ve wanted to do for decades. Let’s bring you along and go through your top-voted questions from…
Read More

[Video] Office Hours in Kyoto, Japan

Videos
0
My Asian vacation continues in Kyoto, the City of a Thousand Temples. They’re not playing around – the town is chock full of gorgeous historic temples, and it was tough to pick a scene for today’s Office Hours. Let’s go through your top-voted questions from https://pollgab.com/room/brento: Here’s what we covered: 00:00 Start 01:35 SQL_Linux: Brent!…
Read More

[Video] Office Hours in Osaka, Japan

Videos
9 Comments
Kon’nichiwa! My vacation tour continues in Osaka, Japan, a city famous for its street food, nightlife, and host and hostess clubs. I’m usually the kinda guy who does classy dinners at 5PM and then hits the sack by 9PM at the latest, so you might wonder how I got here. The answer is that Yves…
Read More

[Video] Office Hours in Zhengzhou, China

Videos
0
For the rest of December, I’m out vacationing in China and Japan. For this episode, I’m coming to you from the People’s Park in Zhengzhou, China, which is kinda like the Chicago of China. It’s in the middle of the US, bigger than people think (13 million people), and has beautiful parks. Here’s what we…
Read More

[Video] Office Hours at the Petit Ermitage in LA

Videos
4 Comments
I went to LA for the opening week of Somni, a gorgeous restaurant in LA, and took your questions from the rooftop deck of the adorable Petit Ermitage hotel.   Here’s what we covered: 00:00 Start 00:37 MyTeaGotCold: When was the last time you did something interesting with Extended Events? 01:25 Josef: Our app slows…
Read More

[Video] Office Hours: Car in the Dining Room Edition

Videos
0
What, doesn’t everyone park a convertible in their dining room? I address the pink elephant in the room, and then take your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 01:03 MyTeaGotCold: Have you ever had a client turn off RCSI? 01:31 SportsFan101: Hi! My company uses vmware for production(on-prem). Current wait time…
Read More

[Video] Office Hours: Ask Me Database Questions

Videos
0
I took your top-voted questions from https://pollgab.com/room/brento. At one point, my camera overheats – hang in there, I get it fixed in a few seconds. Here’s what we discussed: 00:00 Start 01:59 MyTeaGotCold: Your HA/DR worksheet mentions a $1,000,000 option for 0/0 RTO/RPO. Where can I learn more about how this? 04:43 Trushit: It was…
Read More

Office Hours: Guess the Theme Edition

Videos
3 Comments
There’s a secret theme to the questions I hand-picked from the queue at https://pollgab.com/room/brento. Normally I just take the top-voted ones, but today, see if you can spot the thing they all have in common:   Here’s what we covered: 00:00 Start 01:51 Tivan: Hi Brent, I’m facing a deadlock in MS SQL Server with…
Read More

[Video] Office Hours: SQL Server Questions and Answers

Videos
0
That face I’m making in the video thumbnail is priceless. YouTube randomly picks these, and I laughed out loud at this one. Anyhoo, let’s get to answering your top-voted questions from https://pollgab.com/room/brento: Here’s what we covered: 00:00 Start 00:59 Mohit: Hello Brent, What options does a DBA have in terms of performance tuning when managing…
Read More

Office Hours in the Valley of Fire

Videos
1 Comment
I took the Graffiti Gulf 356 out to the Valley of Fire State Park to exercise it, and took your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 01:39 mailbox: Hey Brent! I’m really enjoying your prerecorded training classes. Quick question,I’m running sp_BltizCache @SortOrder = ‘reads’ on our DW server and receiving a…
Read More

[Video] Office Hours: Let’s Have a Drink

Videos
3 Comments
I was making myself a drink to film Office Hours and I realized I should just film it in my home bar. I mixed myself a gin & tonic and took your top-voted questions from https://pollgab.com/room/brento: Here’s what we discussed: 00:00 Start 00:50 MyTeaGotCold: Can you name anyone who radically disagrees with you? After nearly…
Read More

[Video] Office Hours: Salem Witchcraft Edition

Videos
0
It’s spooky time again! I visited Salem, Massachusetts again this year, this time for a friend’s wedding. I ended up in the same spot next to the Charter Street Cemetery that I filmed at last year! I went through your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 01:28 Dumped_on_DBA: How would you…
Read More