Office Hours in Cabo San Lucas

Let's hang out in the pool in Cabo and go through your top-voted questions from pollgab.com/room/brento.
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 more of a preferred go-to solution for organizations over time?
01:57 SwissDBA: In a table with 8M rows, 2 GB data + 4GB indexes, Clustered ix on a GUID column. INSERTs are slow bc SQL has to squeeze them in between existing rows. I would switch the clustered ix to a new IDENTITY column, so new records can be added at the end of the tbl. How would you do it?
03:01 MyTeaGotCold: You recently said that your Hekaton clients are trying to get off. The faults of Hekaton are well-known, so what changed between when they started using it and now?
03:54 Tim Rogers: 90 TB database in AWS, all data active. Tables partitioned across 100 filegroups (4 files each) for ease of index maintenance. Would like to consolidate to a single "data" filegroup with ~100 files, because we don't do anything that benefits from multiple filegroups. Thoughts?
06:30 Kevin M: Would like to learn Amazon Aurora despite current company not using Amazon stack. What's the best / cheapest way to learn Amazon Aurora?
07:47 SadButTrue: Hey Brent! Who's the "Brento" in Postgres community?
08:26 RadekG: When was the last time that you faced a query so poorly written that you had to have a drink before fixing it? What was so bad about it?
11:19 Jökull: What are the top issues you see when storing / searching XML/JSON in SQL Server?

[@FlaggedStar]

11:23 sp_BlitzCache must be far more impressive than I thought. It should be slow.

[@BrentOzarUnlimited]

Not really - it's only going through 10 rows of XML by default.

[@BrentOzarUnlimited]

It’s true! sp_BlitzCache is fast while analyzing XML - but here’s why. #sqlserver

[@FlaggedStar]

@@BrentOzarUnlimited Wow! A video response? Haven't seen one of those since the early days of TH-cam. We used to have a button for it!

[@BrentOzarUnlimited]

@@FlaggedStar I just found out they still work too!