Videos

I went live on TikTok and took your top-voted questions from https://pollgab.com/room/brento: Here’s what we covered: 00:00 Start 00:23 Andrea Hardesty: Do you have any recommendations for reproducing parameter sniffing issues? I have a copy of a production DB. I want @param=222 to use the plan compiled with @param=111 like it did in production. In…

Last week, we had an abrupt intro, and this week, we have an abrupt ending when my camera overheats, hahaha: We went through your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00:43 cha2rg: We have an OLTP table size of 4TB and rows of 6 billion. Scheduled an old data deletion job…

Today’s Office Hours had a ton of technical difficulties because it was my first live stream on both Twitch and TikTok. The first few minutes were cut off, and you can’t see the questions onscreen. Nonetheless, there are good answers in here, so let’s do it:   Here’s what we covered: 00:00 Start 00:03 LivingTheDream:…

I was supposed to be on a flight to Mexico, but had to cancel at the last minute. While waiting for my favorite bagel shop to open, I went through your professional development questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 03:25 Asking for a friend: As a prod dba, should I know what…

I took your top-voted questions from https://pollgab.com/room/brento, including a few career-oriented ones: Here’s what we covered: 00:00 Start 01:10 Trushit: You mention in your career internals guide that you focused on high value things for which business are willing to pay. How did you control the temptation of trying to learn everything & focus on…

I was busy, so I asked a friend to fill in for me and answer your top-voted questions from https://pollgab.com/room/brento. He did a pretty good job:   Here’s what we covered: 00:00 Start 00:52 Confused: Who uses differential backups, really? I don’t get the point. 02:20 Chris: Are third-party tools a necessity or a luxury…

What a comfy morning to sit down with a breakfast margarita and tackle your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00:36 DBA_Mufasa: When we restore a DB from a prod source to a different server, does the DB come with the index usage stats from the original source server or do…

While taking a dip in Cabo, I went through your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 01:00 OpportunityKnocking: What are your thoughts on when to implement a NoSQL strategy over traditional RDBMS for large enterprise-wide database platform solutions? I see scalability advantages in using NoSQL but do you see this becoming…

On a pleasantly mild morning, I sat down on the patio and took your top-voted questions from https://pollgab.com/room/brento.   Here’s what we covered: 00:00 Start 00:56 MyTeaGotCold: When going in to a database blind, do you worry at all about its compatibility level? I see a lot of unloved databases that are still on 2008’s…

I went through your top-voted questions from https://pollgab.com/room/brento while in front of the National Gallery for Foreign Art in Sofia.   Here’s what we covered: 00:00 Start 03:12 MyTeaGotCold: If all of my columns are nvarchar, is there a performance benefit to always wrapping strings in N”? My tests have been inconclusive. 03:50 SadButTrue: Hey…

I was honored to speak at the Present to Succeed conference in Sofia, Bulgaria, run by a former SQL Server MCM. Sofia is a beautiful city, and the gorgeous Patriarchal Cathedral of St. Alexander Nevsky (Wikipedia) was close to my hotel, so I dragged my tripod over there for an Office Hours session.   Here’s…

When I went through the top-voted questions at https://pollgab.com/room/brento, I didn’t have all the answers today: Here’s what we covered: 00:00 Start 00:48 MyTeaGotCold: I increased my RAM from 16 GB to 32 GB and my buffer pool has grown, but my PAGEIOLATCH_SH waits went up by two percentage points. What might that indicate? 01:46…

I went through your top-voted questions from https://pollgab.com/room/brento before heading out to PGConf.dev in Vancouver. Here’s what we covered: 00:00 Start 01:43 Poul J: Hi Brent. Can you give some examples of how a CHECK() constraint is used by the optimizer. Is it similar to a filtered index… Or is there more to it? 03:54…

While in a hotel room in Vancouver for PGconf.dev, I strapped on my Apple Vision Pro headset to take your top-voted questions from https://pollgab.com/room/brento. Somehow, the latest Vision OS update gave me a 1980s 3rd Bass haircut. Here’s what we covered: 00:00 Start 01:03 MyTeaGotCold: Have you ever seen SSISDB migrated on to a new…

While in Nashville for a creators conference, I went through your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00:38 Bisal Basyal: What is the best way to manage roles in sql server in Azure VMs (multiple). We want separate logins for each users but it should be same on all Azure SQL…

Like Sixteen Candles, but different: I go through your top-voted questions from https://pollgab.com/room/brento. Strangely, my video and audio is ever so slightly out of sync in this episode. 00:00 Start 01:26 GuaroSql: Hey Brent! How are you? It is necessary to enable ADR in sql 2019 in order to row versioning work better? Or it…

I started with audio problems, then had video problems halfway in. It’s amusing because we also discuss feeling like a SQL amateur! Here’s what we covered: 00:00 Start 01:52 Does Time Really Exist: Hi Brent! What is the best way to ETL? web application, SSIS, linked server, … 03:55 MyTeaGotCold: What is your vision for…

Y’all post questions and upvote the best ones at https://pollgab.com/room/brento, and I discuss ’em in my home office before tackling a client’s performance issues: Here’s what we covered: 00:00 Start 00:45 Eve: When should you/should you not execute the SSMS recommended Missing Index in the execution plan? 02:42 MyTeaGotCold: Logging sp_WhoIsActive and sp_BlitzFirst to a…

Back at home in the office, time to settle in with a nice caffeine-free Diet Coke and go through your top-voted questions from https://pollgab.com/room/brento. Why caffeine-free? Because I slug multiple coffees first thing in the morning when I wake up (usually around 3am-4am), and by the time I stream with y’all, I don’t need any…

As my time in Hong Kong came to an end, I sat inside on a foggy morning and hit your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 01:32 MyTeaGotCold: Are there any signs of brain drain from SQL Server to Postgres? It seems that every SQL Server guru agrees that Postgres is…