A couple of good reasons to use SQL 2016:
- Temporal Tables - Use instead of Tomb tables/highlander tables.
- Row Level Security - specify access to a row for users and groups
- Always encrypted - encrypts data at rest on a column (don't confuse with column level encryption)
- Read data from queries in JSON object format - nice
- Performance - The jump to using SQL 2016 is massive. I've even heard people recon double the performance on the same kit as SQL 2012. Multiple Temp DB tables is a big part of this. And ultimately the best reason.
No comments:
Post a Comment