Search Results for “office hours”

At https://pollgab.com/room/brento, post the questions you’d like to get my opinion on, and I’ll take a break every now and then at the office and go through ’em. Here’s what we covered in this episode: 00:00 Start 01:08 #ARRRRRGH: Hi Brent. Have you seen anybody put good visualisations on top of sp_Blitz? Im trying to…

I can finally see the finish line in my backyard renovation, now that the concrete’s going in. I took a break from watching the construction folks to go through your highly upvoted questions at https://pollgab.com/room/brento: Here’s what we covered: 00:00 Start 02:03 Fabricator: Hi Brent, what is your take on the recent lunch of Microsoft…

I start today’s Office Hours by playing with the very underwhelming Github Copilot in ADS, then take your questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 04:06 Github Copilot in Azure Data Studio 24:36 Byron: Seeing plan cache queries for a long since retired table. What is best way to track down the app…

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…