![]() ![]() You’re dead-set on doing machine learning & R in SQL Server – I know it’s trendy for data folks to do this, but remember, you’re spending $2,000 to $7,000 per core for SQL Server licensing to do this.Some of the clustering bugs have really made my eyebrows raise. You’re dead-set on running SQL Server on Linux – but seriously, go through the release notes and click on every Cumulative Update to read the bugs that were fixed.You need high performance columnstore queries – because we got a lot of cool stuff for batch mode execution plans.(Prior to this, AG version upgrades are absolutely terrible, and you’re often better off building a new cluster and migrating over to it.) DAGs aren’t too robust or well-documented today, but I like the idea of this as a down payment on easier upgrades when you upgrade down the road. You want easier future upgrades – because starting with 2017, you can have a Distributed Availability Group with different versions of SQL Server in it.You have a zero-RPO goal and financial risks – because 2017 added a new minimum commit replica setting on AGs that will let you guarantee commits were received by multiple replicas.You’re willing to apply patches every 60-90 days – because even though it’s years and years old, there are still regular CUs coming out.Nothing’s getting fixed here, and there certainly aren’t new features coming out for it.Įven in early 2023, SQL Server 2016 is still the #2 most popular version. You hate applying patches – because SQL Server 2016 SP3 is basically the end of the line.People aren’t using it as much as I’d like. If I took a full time DBA job again tomorrow, this (and PowerShell) would be the two skills I’d probably pick up. You need query plan monitoring, and you can’t afford a third party tool – because Query Store gives you some pretty cool capabilities.This grid has a great comparison of what changed with columnstore over the years. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |