Videos

It’s back to lighter fog-friendly clothes as the ship pulls into San Francisco and I answer your questions from https://pollgab.com/room/brento. Here’s what we discussed: 00:00 Start 01:16 Pozzolan: Hey Brent, My companies budget for SQL licensing is small. In such situations, does it make sense to switch or start all new development on something like…

I stopped piloting the ship long enough to answer your top-voted database questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00:42 Dirty_Pages: You mentioned recently how much you swear, what is your favorite swear word(s) and why? Any favorite insults? 02:38 SQLCircus.Clown: What is your go to/default SQL datatype for storing a run of…

Thankfully, we didn’t hit any icebergs or glacier droppings, so I put my comfiest coat on to answer your top-voted questions from https://pollgab.com/room/brento. Here’s what we discussed: 00:00 Start 01:29 gb DBA: Hi Brent, I have over 200 threads with BROKER_RECEIVE_WAITFOR type when I execute sp_whoisactive and some of trx have high numbers on reads…

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…

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…

A lot of today’s questions from https://pollgab.com/room/brento have a common theme, but it’s just a coincidence: Here’s what we covered: 00:00 Start 07:40 Maciej: Hi Brent, when you are working on the course/training how do you know that the current version is “good enough”? I am asking because my friend has a tendency to spend…

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.…

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…

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…

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…

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…

Post your questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me answer. Here’s what we discussed today: 00:00 Start 01:40 prasad: Hi Brent, I want to become a full fledged database architect. I have been reading and practising lot of stuffs here and there, but no certain path. I also subscribed once…

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:…

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…

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:…

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…

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…

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…