SQL Server 2016: What’s Going Away
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.
Hopefully these changes didn't catch anyone off guard. To help better prepare for the removal of features in future versions, Microsoft maintains a list of deprecated features in the next version of SQL Server. Here's a few highlights of what's most likely going away in SQL Server vNext:
Backup/Restore WITH PASSWORD. This one has been bad news for a long time. Stop using it years ago! If you didn't, stop using it TODAY :)
Encryption with the RC4 or RC4_128 Algorithms. Better options have been available for a while, hopefully you're using them for any new development at this point.
Remote Servers. Architect them out. If you really can't, use linked servers instead.
SET ROWCOUNT. I doubt this one will ever really go away, but it's nice to dream. The
TOP keyword has been available for quite some time now.
HOLDLOCK table hint (without parenthesis). This one's easy, put
HOLDLOCK in parenthesis. Like this:
(HOLDLOCK). See? It's easy! Start doing it!
Database Safety Bear says: "Don't delay, start planning for deprecated features TODAY!"