Wednesday 4 May 2016

Microsoft foretells next SQL Server database with new analytics, big data, encryption features

SQL Server 2016 will bring new features to protect data in motion and at rest, visual reports, the first features and analysis of large amounts of data in cloud tools.
 
Microsoft said Monday that hospitals and other departments must hope that the next generation of its database that will be available on June 1st Called SQL Server 2016, the next iteration brings a focus on the analysis, cloud capacity , data encryption and security, as well as the usual raft of features of database vendors typically sell as mission critical.

The company was upping the emphasis on health care recently, with the new feature of Windows 10 that allows physicians to visualize an EHR interface to the health of home applications, for example, and adding privacy account data 2016 office and Skype search for telehealth consultations.

A new feature of SQL Server 2016 that will be most important for many hospitals IOC and security chief of information - particularly as they face the continuous influx of data breaches - is what Microsoft calls always encrypted

Always encryption protects data at rest and in motion so that even users with administrative access can view the data unless it receives specific credentials to do so, the company said. SQL Server also weapons healthcare organizations with tools for granting such access by the row-level security and masking sensitive data using dynamic data masking.

In the analysis of large volumes of data across business intelligence, Microsoft has added new features for creating visual reports with new chart types, tools to convert complex data sets in confidence data models, and multivariate models in SQL Server Analysis services.

The company also said that SQL Server 2016 has capabilities in the cloud that allows first a more consistent experience between the hosted versions of the database and installed on the site, including what is said to be a "base stretching data "as information moves back and forth, as well as backup and recovery in the cloud.

Time and nourishes: The new database can be expanded to 12 TB of memory and 640 logical processors, perform transactions 30 times faster than the previous iteration and return and see 100 times faster, the operation of analysis of transactional data targeting and better load balancing, according to Microsoft.

SQL Server 2016 will be available in four editions: Enterprise, Standard, and Developer Express.