|
2012
|
Description
|
|
Web development and BI enhancements
|
Power pivot drilling through
|
|
BI Semantic Model centralizing BI applications
|
Improvements in reporting services, SharePoint and excel
|
|
Master Data Services
|
|
|
SQL data quality services
|
|
|
SQL server always on
|
High availability
|
|
Power view
|
|
|
SSDT enhancements
|
Brings together azure and SQL server
|
|
Better full text searching
|
|
2014
|
Description
|
|
In memory OTLP
|
Improves response time for frequently accessed data
|
|
Azure integration
|
Integration with azure including backing up SQL databases in to the cloud
|
|
Power view for cubes
|
Support queries using DAX, create tables, charts, maps
|
|
Power BI for office 365
|
Can be used in the cloud
|
|
Buffer pool extensions
|
|
|
Updatable column store indexes
|
|
|
SSDT-BI
|
|
|
Backup encryption
|
|
2016
|
Description
|
|
In-memory OLTP enhancements
|
Support foreign key, unique, check constraints, OR, NOT, outer join, subqueries, select distinct.
|
|
Query store
|
Stores execution plants, performance matrices, query texts.
Dashboard showing query efficiency
|
|
Temporal tables
|
History log tables recording data changes with date/time
|
|
JSON Support
|
JSON imports and exports
|
|
PolyBase
|
Integrates SQL server with Hadoop
|
|
Stretch DB
|
|
|
Row level security
|
Allow users to see only the records that are relevant to them
|
|
Dynamic data masking
|
Only users with unmask permission can view masked data
|
|
Always encrypted
|
Only applications having the application key can access the encrypted data
|
|
R Services
|
Integrate with R
|
|
Direct query
|
Queries live external data without importing it
|
|
New DAX functions
|
|
|
SSIS – incremental package development
|
|
|
Web report portal
|
|
|
Mobile report publisher
|
Shalini's Knowledge Share 
Leave a comment