Microsoft SQL Server 2016 for Embedded Systems
With SQL Server 2016, you can build intelligent, mission-critical applications using a scalable, hybrid database platform that has everything built in, from in-memory performance and advanced security to in-database analytics. The SQL Server 2016 release adds new security features, querying capabilities, Hadoop and cloud integration, R analytics and more, along with numerous improvements and enhancements.
Features
SQL Server 2016 Analysis Services (SSAS) | SQL Server 2016 Analysis Services provides improved performance, authoring, database management, filtering, processing, and much more for tabular model databases based on the1200 compatibility level. |
SQL Server 2016 Integration Services (SSIS) | • Support forAlways On Availability Groups • Incremental package deployment • Always Encryptedsupport • Newssis_logreaderdatabase-level role • Newcustom logging level • Column names for errorsin the data flow • Newconnectors • Support for theHadoop file system (HDFS) |
SQL Server 2016 Master Data Services (MDS) | • Derived hierarchy improvements, including support for recursive and many-to-many hierarchies • Domain-based attributefiltering • Entity syncingfor sharing entity data between models • Approval workflows viachangesets • Custom indexesto improve query performance • Newpermission levelsfor improved security • Redesignedbusiness rules managementexperience |
SQL Server 2016 Reporting Services (SSRS) | • Microsoft has thoroughly revamped Reporting Services in this release. • Newweb Report Portalwith KPI feature • NewMobile Report Publisher • Redesigned report rendering enginethat supports HTML5 • New treemap and sunburstchart types |