[Video] Office Hours: Cabo Balcony Edition

Videos
1 Comment
Post your questions at https://pollgab.com/room/brento and upvote the questions you’d like to see me discuss. The light balance on this video is all over the place, getting brighter and darker constantly, so you might wanna leave this one playing in the background and just listen to it rather than watch. Here’s what we covered: 00:00…
Read More

[Video] Office Hours: Cabo Pool Edition

Videos
0
You posted SQL Server  questions and upvoted the ones you’d like to see at https://pollgab.com/room/brento, and before the Cabo Clasico finals start for the day, I sat by the pool to talk through ’em: Here’s what we covered: 00:00 Introductions 00:53 Neil: Does putting up a giant monitor on the wall with SQL Server info…
Read More

[Video] Office Hours: New Las Vegas Home Office Edition

Videos
2 Comments
It’s the first webcast I’ve done from my new Vegas pad. You posted questions at https://pollgab.com/room/brento/ and I discussed the highest-upvoted ones: 00:00 Introductions 02:15 Jim D: Should I use full backups or log shipping for migrations? 03:53 Sev A: What are the top misuses of SQL Server that are better accomplished without SQL Server?…
Read More

[Video] Office Hours: Last San Diego Balcony Edition

Videos
0
It’s the last San Diego balcony edition of Office Hours! You posted your questions at https://pollgab.com/room/brento and upvoted the ones you’d like to see. Here’s what we covered this week: 00:00 Introductions 00:50 Steve E: Hi Brent, How are you enjoying the Porsche 944? 01:55 Midwest DBA: Hey Brent, The wife says my DBA oncall…
Read More

[Video] Office Hours Speed Round: SQL Server Q&A

Videos
0
You posted questions at https://pollgab.com/room/brento and I picked the fastest ones to answer: Here’s what we covered: 00:00 Introductions 00:16 Disgruntled App Developer: Hi Brent a friend was recently reprimanded for running a trace in production. The rationale was perf impact and other ‘potential issues’ that weren’t forthcoming. Any thoughts on why traces have an…
Read More
Office Hours - ask me anything.

[Video] Office Hours: San Diego Office Edition

Videos
2 Comments
I’m back in the US at my home studio in San Diego, so I did a live Office Hours session. Post your questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me cover. Here’s what we covered today: 00:00 Introductions 00:41 WTF_SQLServer!?!: I have a some dbs that take nearly 6 hours each…
Read More

[Video] Office Hours: Ask Me Anything at Sunset on the Balcony

Videos
0
Ah, sunset – time to kick back on the balcony, watch the ocean, and discuss SQL Server. You post questions at https://pollgab.com/room/brento/, upvote the ones you’d like to see me answer, and I discuss ’em: 00:00 Introductions 00:30 iAmGroot: Hello Brent, my friend has a VLDB and he’s asking what is a good strategy to…
Read More

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

Videos
0
Ask me questions at https://pollgab.com/room/brento and upvote the ones you’d like to see covered. I can pretty well guarantee that your favorite question this time is going to be the last one I answered. Here’s what we discussed today: 00:00 Introductions 00:57 Sean W: New app with data model TBD; what is the thought process…
Read More

[Video] Office Hours: Morning in Mexico Edition

Videos
2 Comments
Got SQL Server questions? Post ’em at https://pollgab.com/room/brento and upvote the questions you’d like to see me discuss. Here’s what we covered this morning: 00:00 Introductions 00:45 SQL Simian: Everybody loves free advice, but we want war stories. I have heard your 174 indexes story twice now during recorded classes. Got any more? What are…
Read More

[Video] Office Hours: Cabo Home Studio Edition

Videos
0
Got questions about SQL Server? Post them at https://pollgab.com/room/brento and upvote the ones you’d like to see me cover. This episode was the first live one I shot in my home studio in Cabo: Here’s what we covered: 00:00 Introductions 02:19 Nullpointer: What are your thoughts on temporal tables, I don’t hear you talk much…
Read More

[Video] Office Hours: Q&A on the Beach at Sunset

Videos
0
You posted and voted on questions at https://pollgab.com/room/brento and I answer ’em on the beach. It’s not your eyes: the camera’s hunting for focus a lot in this video. Here’s what we covered: 00:00 Introductions 01:01 RoJo: Please comment on the Cloud. Too much push at my company to the Cloud without backing to do…
Read More

[Video] Office Hours at Sunrise (No Really)

Videos
0
I’ve got a really sensitive lens (Sigma 16mm f/1.4) on my camera, so often when I record these at sunrise, it’s already too bright for you to see the sun. This time, I went down to the beach a little earlier, and through the video, you can see the light really pick up. Here’s what…
Read More

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

Videos
0
You ask questions at https://pollgab.com/room/brento and I answer ’em from the beach in Cabo San Lucas: Here’s what we covered: 00:00 Introductions 00:27 Paul: What are your thoughts on being a Microsoft MVP? 04:33 Lance: I have a Server running SCCM that gets ‘unsafe assembly’ errors. Are unsafe assemblies something that needs to be worried…
Read More
Office Hours - ask me anything.

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

Videos
4 Comments
I watched the sun rise from my balcony in Cabo this morning and answer your questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Introductions 00:42 Student: Hi Brent! Why is full backup sometimes slow and sometimes fast in similar situations? This problem will be resolved after restarting the server but it comes back again. 02:58…
Read More

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

Videos
1 Comment
Let’s pick up right where we left off yesterday. I’ve got more time and champagne, so let’s keep going through your top-voted questions from PollGab.com/room/brento. Here’s what we covered: 00:00 Introductions 00:39 Wilma: Poor code & tuning issues. Evidence = Database Performance Analyzer & sp_blitz. App is the customer’s idea. The dev has got golden…
Read More
Office Hours - ask me anything.

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

Videos
0
I’m back in San Diego, so let’s sit out on the balcony, enjoy a tasty beverage, and go through your top-voted questions from PollGab.com/room/brento. Here’s what we covered: 00:00 Carl: Hi Brent, what is your opinion of the graph db support starting in SQL2017? Is this another doomed SQL feature? 02:06 Bob: Brent, sometimes when…
Read More

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

Videos
3 Comments
Let’s get together at sunrise in Cabo San Lucas, Mexico and talk through your highest-upvoted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Introductions 00:33 AtHomeWithCOVID: Historical advice is to spread multiple datafiles/filgroups across disks. Now, storage is allocated from a balanced SAN as one drive, e.g “D” data, “L” Logs Are there any gains…
Read More
Office Hours - ask me anything.

[Video] Office Hours: SQL Server at Sunset

Videos
0
Let’s kick back with a tasty beverage and go through your highest-upvoted questions from https://pollgab.com/room/brento on the beach: Here’s what we covered: 00:00 Introductions 00:49 Alexander Speshilov: How to determine amount of memory (RAM) used by query store? 02:23 Aslan: Merhaba Brent, in your opinion, what are the top 4 databases to administer by DBA…
Read More

[Video] Office Hours: SQL Server Q&A in Cabo at Sunrise

Videos
4 Comments
Let’s watch the sun rise at Land’s End and cover your top-voted questions from https://pollgab.com/room/brento/. Here’s what we covered: 00:00 Introductions 01:04 Jr Wannabe DBA: Hi Brent, a colleague wants to upgrade from Standard to Enterprise purely for performance gains on several regular servers (up to 8 CPU, 128GB of RAM, SQL 2016 or 2019).…
Read More
Menu