Microsoft announces SQL Server 2016, which is a new database for Hybrid Transactional and Analytical Processing known as HTAP. The SQL Server 2016 comes with in-memory column-stores, advanced analytics, and integration with the R programming language. With its latest release, Microsoft wants developers to build intelligent applications on-premises and in the cloud with the ability to get real-time insights. Developers can expect to see on Linux the release of SQL Server which will help them not only to build but also deploy apps to more environments. In order to support more programming languages across multiple platforms Microsoft plans in updating the server’s current drivers.
Corporate Vice President of Microsoft’s data group, Joseph Sirosh wrote in a post that software applications can now deploy sophisticated analytics and machine learning models in the database resulting in 100x or more speedup in time to insight, compared to deployments of such models outside of the database. SQL Server 2016 simplifies analytics in the way databases simplified enterprise data management, by moving analytics close to where the data is managed instead of the other way around.
According to Joseph Sirosh, SQL Server 2016 aims to bring a new a pattern of building intelligent applications. They believe in not only allowing developers to update their machine learning models and install new models but also monitor performance within the database instead of other solutions that make them move data out. He wrote thus it eliminates the need to move data out of the database for analytics dramatically reduces the Joseph Sirosh latency for insights. It features PolyBase, Microsoft R Services, R tools for Visual Studio, Always Encrypted technology, JSON support, and end-to-end mobile BI. Sirosh also wrote we provide world-leading data-warehousing capabilities, closely integrated with advanced analytics and machine learning through R. We provide a world-leading business intelligence engine with Tabular and Multidimensional models. We deliver end-to-end mobile BI solutions on any device, and you can add on self-service Power BI for a fraction of the total cost.