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

Videos
2 Comments
It’s time for the first live Office Hours in my new home studio in San Diego! I took your highest-upvoted questions from https://pollgab.com/room/brento/ and answered ’em: Here’s what we covered: 00:00 Welcome 01:30 Accidental DBA: Hi Brent, do you have a recommended checklist for trubleshooting occasional slow INSERT performance? 03:19 Mark: How do companies deal…
Read More

Behind-the-Scenes Home Studio Tour

Videos
13 Comments
Whenever I move to a new place and set up a new home studio, I give you a walkthrough so you can get a rough idea of how I work. I just finished setting up my new San Diego home base, and here’s a tour of what it looks like both as an attendee, and…
Read More

[Video] Office Hours: Ask Me Anything On the Balcony

Videos
4 Comments
Good evening, party people! I finally have my new San Diego home base all set up and unpacked, so I took a champagne break to review your top-rated questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Introductions 00:27 Alex: Hi Brent. For a few hours we got a “Could not continue scan with NOLOCK due…
Read More

[Video] Office Hours in My New San Diego Apartment

Videos
1 Comment
Just got the keys to the new home base in San Diego, and the furniture isn’t even in yet. I went through your top-voted questions from https://pollgab.com/room/brento before my smoke alarm battery started chirping: Here’s what we covered: 00:00 Introductions 01:10 Yoni – We have 60-100GB DBs on SQL server on windows (VM). Will it…
Read More

[Video]: Office Hours at Diamond Beach

Videos
2 Comments
I took a break from playing with glacier leftovers at Diamond Beach to answer the questions you upvoted at https://pollgab.com/room/brento/. 00:00 Introductions 1:21 Null Pointer: When we move to Azure SQL DB, should we worry about having all our data and backups in one place? 03:27 Josh: We’re using indexed views, and we have to…
Read More

[Video] Office Hours at the Seltjarnarnes Lighthouse

Videos
0
You posted and upvoted SQL Server questions at https://pollgab.com/room/brento, and I went out for a walk on the Seltjarnarnes peninsula to the lighthouse to answer ’em. Here’s what we covered: 00:00 Introductions 00:58 Gio: Any known gotchas from using Windows Update to apply CUs to SQL 02:17 AlwaysLearningDBA: Hello Brent. A friend of mine wanted…
Read More

[Video] Office Hours: Ask Me Anything in the Reykjavik Harbor

Videos
0
You posted and upvoted questions at https://pollgab.com/room/brento to pick what you’d like to see covered in a Q&A session: Here’s what we covered: 00:00 Introductions 00:26 Mehdi: Hi Brent! What is the first step when SQL Server is overloaded? But we can still connect to SQL Server by SSMS. 02:36 Allan: Do you think learning SSIS…
Read More

[Video] Office Hours: Ask Me Anything About SQL Server at Hallgrímskirkja

Videos
6 Comments
I hang out by Hallgrímskirkja, the modern church in Reykjavik, and take your highly-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Introductions 00:18 __normally_weird (Sean C): Can you dispel the now prevailing myth that you and your wife are the only8 people in Iceland at the moment? 01:33 Andy Leonard: What “bugs” exist in…
Read More

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

Videos
2 Comments
Before Fjöruborðið opens for lunch, I answer a few of your questions from https://pollgab.com/room/brento including: 00:00 Introductions 00:29 Peter: What is your opinion about the SQL generated by Entity Framework? 02:00 Peter: When would you switch from EF to stored procedures? 02:45 Always Learning DBA: What are free resources to help me transition into an…
Read More

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

Videos
1 Comment
I sit on the porch and discuss your highly voted questions from https://pollgab.com/room/brento. Today’s discussion includes: 00:00 Introductions 00:27 DK: What was your Gordian Knot problem? 03:25 George: How exactly does locking work on INSERT INTO…SELECT FROM? 05:48 Michael: Can I tell if hyperthreading is turned on or off? 07:25 Party People: What are the…
Read More

[Video] Office Hours: Ask Me Anything at the Westman Islands Harbor

Videos
4 Comments
You upvoted questions at https://pollgab.com/room/brento, and today I’m at the harbor in Heimaey to cover ’em. Questions we talked through: 00:00 Introductions 01:00 Zach: What happens when I change a VARCHAR(MAX) to VARCHAR(2500)? 04:26 Scott: What tools do you recommend for tracking down locks involved in blocking? 07:23 Pointing out the beluga whale sanctuary 07:58…
Read More

[Video] Office Hours at the Eldfell Volcano Crater

Videos
2 Comments
You posted and upvoted questions at https://pollgab.com/room/brento, and I ascended – well, drove into – the Eldfell Volcano in the Westman Islands to answer ’em: Questions we covered in the video: 00:00 Introductions 01:55 Do you notice big improvements for physical servers over virtual servers? 05:14 Why aren’t my SQL Servers using all of the…
Read More

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

Videos
1 Comment
You’ve got questions, I’ve got answers. Welcome to another edition of Office Hours, where you post your questions here, upvote the ones you’d like to see me talk through, and I do your bidding: Questions we covered this week: 00:00 Introductions 01:30 Are DBAs transitioning to other roles, and why? 04:48 Why is it hard…
Read More
Menu