[Video] Office Hours: 21 Good Questions
This one is a 3-part episode: I take 21 questions from https://pollgab.com/room/brento and then later, work on First Responder Kit pull requests.
https://youtu.be/MNwCDQX8zl4
Performance Monitoring and Server Tuning
Diagnosing instance performance through waits, resources, monitoring, and baselines.
405 associated posts180 primary posts
[Video] Office Hours: Wrong Side of the Bed Edition
I woke up on the wrong side of the bed after a nap. How does that even happen?!? To take the edge off, I poured myself a gin & tonic and went through your top-voted questions from https://pollgab.com/room/brento.
https://youtu.be/5lF0RtdBPP8
[Video] Office Hours: Brent’s Cursed Technology Edition
I first answered these while standing at a harbor in Maine, but upon arriving home, I realized my camera had failed to record any audio. Doh! So I took the list of questions from https://pollgab.com/room/brento and streamed 'em from my home office in Vegas instead.
https://youtu.be/IwAz7lCZK_Y
[Video] Office Hours in Camden Harbor
On an overcast morning in scenic Camden, Maine, I stood on the docks and took your top-voted questions from https://pollgab.com/room/brento.
https://youtu.be/OFRjC6D7vTs
[Video] Office Hours Off the Coast of Norway
Come join me in my cabin aboard the Hurtigruten Nordlys, sailing up the coast of Norway, and we'll cover your top-voted questions from https://pollgab.com/room/brento.
https://youtu.be/E_JNbimkUb0
[Video] Office Hours at Dyrhólaey Overlooking Puffins & Black Sand Beach
Got Azure SQL DB and SQL Server questions? Post them at https://pollgab.com/room/brento and I'll answer the top-voted ones. This episode comes to you from Dyrhólaey, where I was completely surprised to find puffins at this time of year.
https://www.youtube.com/watch?v=vIVKXZfAzwE
[Video] Office Hours: All About Miles Edition
Today's webcast featured an awful lot of questions from one particular person who was super-active at https://pollgab.com/room/brento:
https://www.youtube.com/watch?v=dKngk_OIwB4
[Video] Office Hours: I Need Your Help with These
Today, I need your help with some of the top-voted questions from https://pollgab.com/room/brento. Chime in in the comments:
https://youtu.be/RatZKWnDMGI
[Video] Office Hours: Stump Me On SQL Server
I went through the top-voted questions from https://pollgab.com/room/brento and discussed 'em live on my Twitch channel.
https://youtu.be/tyu0JN7H_hQ
[Video] Office Hours: Extended Answers Edition
Y'all posted so many good questions at https://pollgab.com/room/brento that I went longer than usual this time:
https://www.youtube.com/watch?v=f3sFkvgPPFQ
[Video] Office Hours: Overheating Cadillac Edition
I took your questions from https://pollgab.com/room/brento before heading out to pick up my Cadillac from the mechanic.
https://youtu.be/B02i8Ldgy_4
[Video] Office Hours: Lots of Good SQL Server Questions
At https://pollgab.com/room/brento, post the questions you'd like to get my opinion on, and I'll take a break every now and then at the office and go through 'em.
https://youtu.be/YkruJLmhAmU
[Video] Office Hours: Github Copilot in Azure Data Studio
I start today's Office Hours by playing with the very underwhelming Github Copilot in ADS, then take your questions from https://pollgab.com/room/brento.
https://youtu.be/vOkE8bfdOMU
[Video] Office Hours in Glacier Bay, Alaska
Thankfully, we didn't hit any icebergs or glacier droppings, so I put my comfiest coat on to answer your top-voted questions from https://pollgab.com/room/brento.
https://www.youtube.com/watch?v=ZIUbZvtPsrc
How to Go Live on a New Version of SQL Server (Like 2025 or 2022)
You're planning to migrate to a new version of SQL Server, and you want your databases to be faster after the migration. This is NOT a blog post about how to migrate - that's the same as it's been for a long time. Go build the new 2025 servers, and use log shipping or database…
[Video] Office Hours: Live Q&A
This one's broken up into two parts because I took a bio break mid-stream:
https://www.youtube.com/watch?v=ZhFG3LllLug
What Does Setting the SQL Server Compatibility Level Do?
Your queries won’t tune themselves. My 2027 Live Class Season Pass is $995 (normally $4,395), with live Fundamentals and Mastering classes plus recordings. Register by October 31 to join Fundamentals Week, November 2–6. See the pass.
If you right-click on a database in SQL Server Management Studio, you get an option to set Compatibility Level at the database level:
[Video] Office Hours Speed Round: 21 Answers in 15 Minutes
HONK HONK! It's time for a fast round of answers to concise questions y'all posted and upvoted at https://pollgab.com/room/brento.
https://youtu.be/DhTqXJ1fTBw
[Video] Office Hours: Ask Me Anything About SQL Server in Costa Rica
Off the coast of Costa Rica, I went through your top-voted questions from https://pollgab.com/room/brento.
https://youtu.be/lYetyzn4hkQ
[Video] Office Hours in Cartagena, Colombia
Before heading out to Old Town for sightseeing, I went through your top-voted questions from https://pollgab.com/room/brento.
https://www.youtube.com/watch?v=5x1SwTkBpFk
