New No-Longer-Features In SQL Server 2016

Bob Pusateri acts as SQL grim reaper:

32-bit SQL Server. SQL Server 2016 is 64-bit only. If for whatever reason you’re running on a 32-bit architecture, sadly you’re now out of luck – 2014 is the end of the road. On the bright side, there’s probably some new hardware in your future!

Compatibility Level 90. If you’re using compatibility level for backwards compatibility, the oldest available version in SQL Server 2016 is 100, which corresponds to SQL Server 2008. Compatibility level 90, SQL Server 2005, is no longer an option.

Bob also covers a few deprecated features, none of which (hopefully) are in regular use in your environment.

Related Posts

Platform Compatibility and SSDT

Ed Elliott walks us through platform compatibility in SQL Server Data Tools: Sometimes you don’t have the perfect development environment for SQL Server, sometimes you deploy to things like SQL Azure and want to test locally, for various reasons it is possible that you want to deploy to one version of SQL Server but set […]

Read More

SQL Server Versions: Choose Your Own Adventure

Brent Ozar has a guide to help you choose which version of SQL Server to install: Wait! Before you install that next SQL Server, hold up. Are you sure you’re using the right version?I know, management wants you to stay on an older build, and the vendor says they’ll only support older versions, but now’s […]

Read More

Categories

June 2016
MTWTFSS
« May Jul »
 12345
6789101112
13141516171819
20212223242526
27282930