On the flip side, every single MSSQL instance that I've encountered has been legacy. For at least five years.

For mid sized businesses, where you're mostly just doing some business reporting, a single mssql instance makes for a great and very cheap 'data warehouse'. All the auth magically works for people to connect with Excel, and powerbi+cloud just works out of the box.

I'd be curious what a better/non-legacy solution is! (as I do this stuff haha, and don't see much else other than full cloud options, sf etc)

▲

chaps 4 days ago | parent [-]

These days I think airtable and other "no code" systems fit this bill well.

▲

trollbridge 4 days ago | parent [-]

MSSQL doesn’t come with usage based pricing.

	▲	chaps 4 days ago \| parent [-]
		Sure, but you're just shifting that cost elsewhere. Not defending the no-code services (they're extremely predatory), just that it's not as simple as cost-vs-no-cost.