[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

[Video] Office Hours: First Post From Cabo

Videos
0
Join me on my balcony in Cabo as I review your top-rated questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Introductions 00:48 md: Hi Brent, as SQL Server works with 8K pages why is the recommended NTFS Unit Allocation Size for SQL volumes 64K? Wouldn’t 8K be a more efficient fit? Sneaking in a second…
Read More
Office Hours Podcast

[Video] Office Hours: SQL Server 2008 R2 Edition, I Guess

Videos
0
I went through your highest-voted questions from Pollgab and talked through ’em, and strangely, there was a bit of a 2008R2 theme! https://youtu.be/3-B5L3Komq4 Here’s what we covered: 00:00 Introductions 02:00 Pete Donnelly: Hi Brent, I have a 7 TB DB and the largest table is 2 TB, has 6 indexes and 6 related Statistics. It…
Read More
Menu