Randolph West takes a look at my favorite activity: deleting code:
The following statements are true:
– SQL Server 2019 does not have any deprecated features, but does have discontinued features
– SQL Server 2017 does not have any discontinued features, but does have deprecated features
– SQL Server 2016 has both deprecated and discontinued featuresLet’s discuss the difference between deprecated and discontinued features, and explain how this affects database administrators looking to move to SQL Server 2016 or newer. My current advice is to target SQL Server 2019 with at least Cumulative Update 2 (CU2).
Read on for more details.
Current advice should be NOT target SQL Server 2019 CU2 at least due to this – https://www.brentozar.com/archive/2020/03/breaking-news-sql-server-2019-cu2-breaks-agent/
Yeah, that’s a good point. This particular CU is worth sitting out on and waiting for the next.