00:00:00Intro
00:00:25Start
00:02:00DBAInAction: Hi Brent, our goal is to shrink the 25 tb db. With archive and shrinking the db isn’t feasible without perf impact, does building a fresh db seeded with just the last two years of data (considering business is ok) and cutting over sound
00:04:51racheld933: My role is slowly changing from a traditional DBA to developmental DBA (mostly mssql on Azure) and I’m wondering if there are any specific folks in the SQL world you recommend I look at for that type of content.
00:06:00mpasharp: Hi Brent, now that AI is used in developing software, do you think we will see more frequent release of SQL server in future?
00:09:34DGWinOK: How does pricing compare (off the top of your head) between Azure SQL and Oracle cloud database for say a 100 GB instance?
00:11:26Trying_To_Keep_Production_Up: Hi Brent! CDC falls behind under load. DB is ~5 TB with high transaction volume. After load drops, `sp_cdc_scan` stays hours behind with low-ms disk waits, then suddenly catches up fast. `maxtrans=5000` helped slightly.
00:12:44Watching the pilot board the ship
00:14:01Proof as a Proxy: You've mentioned the great importance of reading documentation. I've long had a goal to read **all** of the SQL Server documentation. Is that crazy? Doing it for availability groups took a long time.
00:16:12Detroit DadJoker: With Microsoft not shipping SSRS in SQL2025, what are the paths forward? Are there solution for both SQL and PG?
00:17:31Wrap-up & BrentOzar.com