There is a package introduced by Microsoft in recent conference. It has announced investments in Analysis services, Reporting services, Integration services, and much more.
The entire SQL Server development evaluations community was eager to hear from Microsoft about upgrades over the past few years. The good news comes and has made them glad when Microsoft announced significant on-premises enhancements for SQL server in several presentations at various conferences.
SQL Server Development tools and SQL Server BI tools will be unified in Visual Studio. Experts have worked on the setup and user can now avail better experience and performance for importing from Office 2016 and the designer. The event-based monitoring in SSMS has been extended and the support for the Analysis Services Tabular scripting language is now available in the latest release.
Further, about data warehousing and related things, SQL Server 2016 will bring customizable non-clustered columnstore index support or on-disk row store for easy deployment of operational analytics. Polybase is another interesting feature to talk about. It is one of the incredible features that were only available in Microsoft Analytics Platform System, but now it will be out-of-box in this latest release.
Polybase is a fragmented query capability with which users are able to query unrelated data in Hadoop, files, blobs, and available data in SQL Server without moving data. It also offers accessibility to users to query and use data that is available on-premises or on the cloud for hybrid solutions regardless of the location.
Integration Services (SSIS) followers will be glad to hear this news that previous versions are now supported by the designer. Users can use Power Query as a data source for personal ETL use to e nterprise ETL upgrade scenarios.
If you are user of SQL Server Master Data services, there is something in the treasure box for you- you will experience better performance while working with large models. There is also a better admin interface, added optional row-level compression for every entity, and latest configurable retention settings. MDS add-in for MS Excel is now 15 times faster and SQL Server 2016 will support bulk staging operations (entity-based).
There are lot more things that can be discussed. We will do it in our next post. Till then, keep watching this space to know more about SQL Server development. We would be happy to receive your feedback for this post!