[Video] Office Hours in My Vegas Backyard

I took 5 of your top-voted questions from https://pollgab.com/room/brento while hanging out in the backyard on my second gin & tonic. I, uh, might have lost my temper on the last one.

Here’s what we covered:

• 00:00 Start
• 02:38 Frozt: are you familiar with SQL Server assemblies? and if they can cause assertion or IAM corruptions? Thank you Happy New year Brent
• 04:41 SQL_Linux: Hey Brent, My company is wanting to use AI for data analytics. What common misconceptions have you seen companies hold concerning using AI to find “insights”?
• 07:12 Culloden: my company is small and we don’t have devs for reporting. Finance team use prod for report development bc data is near real-time. I want to move them to a dev instance, but data can only be a few hours old. What are options for this? we only use simple recovery model in prod.
• 09:38 App Developer At Crossroads: When did you decide to stick with SQL Server? After 3 jobs over 8 years all with quite different tech stacks I’m feeling like its time to become an expert in something (tech and business domain)/have a long stay at a company so I can become more and more senior/have a big impact.
• 11:24 MyTeaGotCold: Did resumable online index rebuilds change any of your opinions on or approaches to index maintenance? I love them too much.

Source: View source