Posts by Brent Ozar

After consuming waaaay too much coffee, I went through your top-voted questions from https://pollgab.com/room/brento: Here’s what we covered: 00:00 Start 03:53 It’s ‘a me: Is there a feature in SQL that Microsoft abandoned that you wish they had perfected? 05:43 TheEveryDayDBA: My friend asks, he is using sp_blitzIndex on a OLAP db workload. Quite a…

Today’s webcast featured an awful lot of questions from one particular person who was super-active at https://pollgab.com/room/brento: Here’s what we covered: 00:00 Start 00:03 Miles: Hi Brent, I am aware of “sp_statement” completed and sp_batch_completed events in trace and extended events. But, what is the use of rpc_completed event? How this event will be helpful…

Today, I need your help with some of the top-voted questions from https://pollgab.com/room/brento. Chime in in the comments: 00:00 Start 00:52 Accidental DBA: Hello Brent. Thank you for keeping your Q& A sessions entertains and informative. My question is non-technical…Have you ever said this to your client? You keep using that word. I don’t think…

Today’s batch of questions from https://pollgab.com/room/brento requires some really long answers, and some are right to the point. 00:00 Start 02:13 Eh? Aye…: As DBAs, how can we best prepare for the AI world in terms of data? Should we start with AI as a concept fundamentals, or what ua the ‘data type’ we should…

We headed up to the mountains to get away from the Vegas heat. Before the sun rose, I took your top-voted questions from https://pollgab.com/room/brento.   Here’s what we covered: 00:00 Start 00:36 Ozan: Hi Brent, how should Volume Snapshot Backups (VSS) be configured correctly that it will not freeze the database’s IO for a couple…

I took a break from packing my bags long enough to answer your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 02:42 T-man: Hi BO. A friend has multiple Distributed AGs (on separate business division servers) but needs to share ODS data with each of the DAG DBs. Any near-real time architecture ideas…

I went through the top-voted questions from https://pollgab.com/room/brento and discussed ’em live on my Twitch channel.   Here’s what we covered: 00:00 Start 00:39 tanchenglai: Hi Brent! We bought your Level 2 Bundle last year. Recently, we went into frequent thread pool issues; we suspect it is due to high CPU utilization. Our IT manager…

Y’all posted so many good questions at https://pollgab.com/room/brento that I went longer than usual this time: Here’s what we covered in this episode: 00:00 Start 02:17 Tanchenglai: Hi Brent, recently we always ran into thread pool issue. I checked Performance Dashboard and found that CPU spiked over 80% occasionally. I suspect apps can’t connect after…

I step away from the backyard long enough to take y’all’s questions from https://pollgab.com/room/brento. Here’s what we covered in this episode: 00:00 Start 02:23 Stockburn: Hi Brent, we are using distributed always on AGs, with a node in AWS for DR. We are thinking of using this to quickly migrate the work load to the…

There are only a couple weeks left in this summer’s marathon of Office Hours sessions, which means there’s limited time left to ask your toughest database problems (not trivia questions) at https://pollgab.com/room/brento. Here’s what we covered in this episode: 00:00 Start 03:22 tanchenglai: Hi Brent, I have implemented a system that records data in another…

I took your questions from https://pollgab.com/room/brento before heading out to pick up my Cadillac from the mechanic. Here’s what we covered: 00:00 Start 04:50 JudgeDredd: Hi Brent, have you ever been asked for opinion/expertise (as a database specialist) in a court trial? If yes, could you share some details? 07:10 Aart Bluestoke: A maximum of…

Post your SQL Server and Azure SQL DB questions at https://pollgab.com/room/brento and upvote the ones you’d like to hear me discuss. Here’s what we discussed in this episode: 00:00 Start 02:47 therealprodDBA: In the last webcast, I heard you cite that majority of your clients are on AWS. I got curious now that my shop…

Seriously, how do y’all keep coming up with so many great questions? I went through your top-voted questions from https://pollgab.com/room/brento/ on a live stream on my Twitch channel, like I do on most Wednesdays & Thursdays, and really enjoyed these: Here’s what we covered: 00:00 Start 04:14 Groove_timer: Hey Brent, Trying to convince my employer…

Stack Overflow was down, so y’all posted questions at https://pollgab.com/room/brento and I gave ’em my best shot. Here’s what we covered: 00:00 Start 04:33 Amir: Does Az-900 worth the effort and money? What about other microsoft certifications? 06:16 Mr. M: Hi Brent. Which feature in SQL Server you like the most? 08:43 Q-Ent: Hi Brent,I…