Microsoft will announce various new products and capacities. In their This year at the PASS Summit,will announce various new products and capacities. In their official blog the company states,

“We live in the age of data, and the ability to extract actionable intelligence from data is driving a fundamental transformation in how we live, work and play. This year, at the PASS Summit, we have several exciting announcements about new products and capabilities that will drive this transformation even further.”

Community Technology Preview (CTP) 3.0 of SQL Server 2016. In order to experience the new features in Microsoft announces theof. In order to experience the new features in SQL Server 2016, you need to download the preview or use a virtual machine in Microsoft Azure.

The Azure Data Lake which was earlier disclosed at the Strata Conference, offers analytic processing power and an exabyte-scale big data store as a fully managed service. Part of Cortana Analytics Suite, Azure Data Lake new preview is available from today for the store, which include the Analytics service of Azure HDInsight, which is already available.

The company also announces the public preview of In-Memory OLTP, along with the availability of Operational Analytics in Azure SQL Database.

Microsoft states,

“With the upcoming release of SQL Server 2016, our best SQL Server release in history, and the recent availability of the Cortana Analytics Suite, Microsoft is offering unmatched innovation across on-premises and the cloud to help you turn data into intelligent action.”

In the recent Gartner Magic Quadrant for Operational Database Management Systems, Microsoft was positioned as the leader, highest in execution and furthest in vision. Microsoft states,

“SQL Server 2016 builds on this leadership, and will come packed with powerful built-in features.”

For the past six years this database is least vulnerable, no other database can match the security which is offered by SQL Server 2016. It also comes with a data warehouse with the richest price-performance, and which offers end-to-end mobile BI solution. This provides tools which go beyond BI with in-database Advance Analytics, integrating the R language and scalable analytics functions from the recent acquisition of Revolution Analytics.

Image Source: blogs.technet.com

Microsoft states,

“Our cloud-first product development model means that new features get hardened at scale in the cloud, delivering proven on-premises experience. In addition, we offer a consistent experience across on-premises and cloud with common development and management tools and common T-SQL.”

The Always Encrypted feature available in SQL Server 2016 CTP 3.0 is based on the technology from Microsoft Research and helps in protecting the data at rest as well as in motion. By using Always Encrypted, SQL Server easily perform operations on the encrypted data. This offers complete security.

Subhra Bose, CEO, Financial Fabric in a statement said,

“Data protection is fundamental to the financial services industry and our stakeholders, but it can cause challenges with data driven business models. Always Encrypted enables the storage and processing of sensitive data within and outside of business boundaries, without compromising data privacy in both on-premises and cloud databases. At Financial Fabric we are providing DataHub services with “Privacy by Design” for our client’s data, thanks to Always Encrypted in SQL Server 2016. We see this as a huge competitive advantage because this technology enables data science in Financial Services and gives us the tools to ensure we are compliant with jurisdictional regulations.”

The SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS) has been improved, and it would now help the users to deliver faster business insights and also improve the productivity for BI developers and analysts.

SQL Server Reporting Services 2016 offers its users a complete modernized experience for paginated reports and update tools along with new capabilities to design documents.

In the end the company concluded saying,

“Finally, don’t forget to join us, either live or via the livestream feed, at the PASS Summit 2015 keynote and foundational sessions. And be sure to take advantage all the great sessions at the PASS Summit this week.”