Ten New Features in SQL Server 2016
Stefano Romiti
![Stefano Romiti]()
Stefano Romiti
Experienced business growth executive with scale-ups and established companies, in Australia and the US. Ex Gartner, IBM & Microsoft, with added experience in the cycling industry.
We always try our best to be clear and comprehensive in how we explain our stuff. Now and then you come across someone that actually explains it as well or better. This piece in Database Journal is a good example.
It covers 10 new features in SQL 2016. Maybe they aren't the full set, maybe there's others that would be considered by some more important. Either way, this is a good quality overview and a worthwhile read for both technical and not-so-technical folk. The latter will still get a good idea of some key features and their application.
My top pics in no particular order:
JSON Support
Polybase
R Server embedded
Strech database
What are yours?
1. Always Encrypted, 2. Improved Columnstore Ix, 3. Improved IM OLTP, 4. Temporal Tables, 5. Query Store, 6. Compress()/Decompress(), 7. NO_PERFORMANCE_SPOOL hint
Performance Specialist at Snowflake - The Data Cloud
9 年1. Polybase, 2. Dynamic Data Masking, 3. R