[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

[Video] Office Hours: Húsavík Harbor Edition

Videos
6 Comments
Today’s session comes to you from the harbor in Húsavík, the whale watching capitol of Europe. Questions I answered in the video: 00:00 Introductions 00:29 Is SQL Server 2019 ready for prime time now? 02:47 Does WITH NOLOCK cause high CPU usage? 04:53 Is MERGE a good practice or bad? 06:36 OPENROWSET is so easy…
Read More
Menu