[Video] Office Hours at Sea: SQL Server Q&A

Videos
0
En route from San Francisco to Juneau aboard the Ruby Princess, I stopped to hit a few of your questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00:46 DBACAT: Hi Brent, what statistics impact occurs when a transaction is rolled back? The query’s exec plan didn’t change but duration and CPU jumped 10X. Stats…
Read More
Office Hours Podcast

[Video] Office Hours: Azure & SQL Server Q&A

Videos
0
Y’all post questions at https://pollgab.com/room/brento, and I go through the top-voted ones on my Twitch channel streams.   Here’s what we covered today: 00:00 Start 01:56 Manoj: Where do you see artificial intelligence having the most impact on DBA’s? 03:25 It’s ‘a me: Hi Brent, is it still “best practice” to have databases split into…
Read More

[Video] Office Hours: 45 Minutes of SQL Server Q&A

Videos
3 Comments
It’s a long one, folks! I went through almost 30 of your questions from https://pollgab.com/room/brento to get your learn on:   Here’s what we covered: 00:00 Start 00:30 Jr Wannabe DBA: Hi Brent, recently you talked about linters; do you recommend any for T-SQL? I tried a few randomly from Google search, they are useless.…
Read More
Open source image generated with Stable Diffusion, epiCRealism checkpoint, prompt: professionally color graded photo of ambulance, masterpiece, raw, hard focus, depth of field, nikon d850

[Video] Office Hours: Testing the First Responder Kit

Videos
0
I tested the April release of the FRK, then answered your questions from https://pollgab.com/room/brento.   Here’s what we covered: 00:00 Start 28:37 Make_a_car_and_call_it_a_Brentley: Hi Brent, thanks for everything you do for the community. I was wondering on your opinion on using RegEx within a SQLquery and it’s performance. We have queries where we analyse about…
Read More

[Video] Office Hours: 25 Pretty Good Questions

Videos
1 Comment
You post questions at https://pollgab.com/room/brento and upvote the ones you’d like to see, and my job is to come up with accurate answers on the fly. Let’s see how I did. Here’s what we discussed: 00:00 Start 03:25 SickOf: Brent is there a backup product you can recommend? 04:38 OneEyebrowRaised: I’m noticing three significant shortfalls…
Read More

[Video] Office Hours: Live Q&A

Videos
2 Comments
This one’s broken up into two parts because I took a bio break mid-stream: 00:00 Start 03:04 Clippy: Hey Brent, you are the best!!! Can you share us more about your roots? What’s the origin of your family name and where does it comes from? 04:15 I_ALSO_WANT_A_FERRARI: Hi Brent, first of all thank you for…
Read More

[Video] Office Hours Speed Round: 21 Answers in 15 Minutes

Videos
2 Comments
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. Here’s what we covered: 00:00 Start 00:19 TheyBlameMe: Hi Brent. What is your view on using Dacpac diffs vs “old style” manual update scripts for deploying DB schema changes in dev-test-prod? 00:52 Alex: Hi boss, I…
Read More

[Video] Office Hours: Ask Me Anything at Sea

Videos
0
It was a dark and stormy morning, on the last day of my Panama Canal cruise. Before I perished, I sat down to answer your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: > 00:00 Start 00:36 ClippyTheDBA: Hi Brent. How you keep up-to-date with technology in general and in SQL Server specifically? 02:56 Björk:…
Read More

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

Videos
4 Comments
Off the coast of Costa Rica, I went through your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00:30 gotqn: In SQL Database we have “sp_invoke_external_rest_endpoint”, but in SQL Server 2022 still have not. Is using SQL Server Machine Learning (sp_execute_external_script) a good alternative or nasty hack? 02:19 Chase C: If you had…
Read More

[Video] Office Hours in Cartagena, Colombia

Videos
1 Comment
Before heading out to Old Town for sightseeing, I went through your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00:44 Haydar: Is there a good way to suppress part of TSQL batch from showing the query plan in SSMS but having the rest of the batch show the query plan? 02:13 Mike:…
Read More

[Video] Office Hours at Sea: Heading to Jamaica

Videos
0
I’m on a boat! I’m on a 10-day Panama Canal cruise, and I stopped (well, not the boat) off the coast of Florida to answer questions y’all posted at https://pollgab.com/room/brento. 00:00 Start 00:56 DBe: In several places I’ve worked, it’s been “policy” to automatically restart heavy-use SQL servers off-hours on a regular cadence. Usually monthly…
Read More

[Video] Office Hours Brought to You by Quest Software

Videos
2 Comments
Today’s episode of Office Hours is brought to you by Quest Software. I went through your top-voted questions from PollGab.com/room/brento, and, uh, kinda looked like I was sponsored by Fendi while doing it, hahaha: Wow, those logos are bigger than I thought. Here’s what we covered: 00:00 Start 01:20 reluctantly_tolerant : I used FCI instead…
Read More

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

Videos
0
Y’all post and upvote questions at https://pollgab.com/room/brento, and I stream sessions on my Twitch.tv channel where I answer ’em and chat with the audience. 00:00 Start 02:09 Chad Baldwin: Hey Brent! “a friend told me” MSSQL will use an index’s stats to generate a plan, but not use the index itself. 03:25 Jeremiah Daigle: Hey…
Read More

[Video] Office Hours: Quiet Sunday Edition

Videos
2 Comments
While waiting for the dry cleaner to open, I went live to stream a quiet session going through a bunch of y’all’s questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 01:45 Rollback is single threaded: Hi Brent! In microservices application architecture, Using a database per service or a shared database? I asked this because…
Read More

[Video] Office Hours: Snowy Michigan Edition

Videos
3 Comments
We went up to Michigan to see my dad’s side of the family, and the snow came down just in time for our arrival. Always love the fresh snow look. So I stood outside and took your top-voted questions from https://pollgab.com/room/brento. Let’s see what y’all came up with today: Here’s what we covered: 00:00 Start…
Read More

[Video] Office Hours: 22 Good Questions and a Stinker

Videos
4 Comments
Lots of good questions on today’s broadcast! If you’d like to submit one, go to https://pollgab.com/room/brento and upvote the ones you’d like to see me cover. Here’s what we covered today: 00:00 Start 01:05 Testing123: When inserting or updating data into a table, from a concurrency perspective, does it make sense to break up the…
Read More

[Video] Office Hours: Quickie Before Dinner

Videos
0
Before heading out to dinner, I went through your highly-upvoted questions from https://pollgab.com/room/brento. Here’s what we covered in this episode: 00:00 Start 00:20 Mert: Hi Brent, what is the relation between AlwaysOn and Windows Failover Cluster? Is WFC an obligation or a choice for creating an Always On availability group? It will be nice if…
Read More