Netherlands: Software

Microsoft SQL Server 2016 datasheet

Issue link:

Contents of this Issue


Page 0 of 1

In-memory enhancements Operational analytics and enhanced performance Advanced Analytics In database analytics at massive scale 30X In-memory OLTP As the biggest leap forward in Microsoft's data platform history, SQL Server 2016 delivers breakthrough mission critical performance, deeper insights across any data on many devices and enables the power of hyperscale cloud to unlock new hybrid scenarios. Performance Enhanced in-memory performance with up to 30x faster transactions, more than 100x faster queries than disk based relational databases and real-time operational analytics. Security Upgrades Always Encrypted technology helps protect your data at rest and in motion, on-premises and in the cloud, with master keys sitting with the application, without any application changes. High Availability Even higher availability and performance than SQL Server 2014 with AlwaysOn secondaries with the ability to have up to 3 synchronous replicas, DTC support and round-robin load balancing of the secondaries. Scalability Enhanced database caching across multiple cores & support for Windows Server 2016 that efficiently scale compute, networking and storage in both physical and virtual environments. MISSION CRITICAL PERFORMANCE DEEPER INSIGHTS ACROSS DATA Access Any Data Query relational and non-relational data with the simplicity of T-SQL with PolyBase. Manage document data with native JSON support. Scale and Manage Enhanced performance, scalability and usability across SQL Server Enterprise Information Management tools and Analysis Services. Powerful Insights on any device Business insights through rich visualizations on mobile devices. Native apps for Windows, iOS and Android. New modern reports for all browsers. Advanced Analytics at massive scale Built-in advanced analytics provide the scalability and performance benefits of running your "R" algorithms directly in SQL Server. Expand your analytics library with Microsoft Azure Marketplace. HYPERSCALE CLOUD Breakthrough hybrid scenarios Stretch Database technology keeps more of your customers' historical data at your fingertips by transparently stretching your warm and cold OLTP data to Microsoft Azure on- demand without application changes. Simplicity New tools that make SQL Server migration to Microsoft Azure and hybrid scenarios even easier. Consistency Consistent experience from on-premises to Microsoft Azure IaaS & PaaS. Hardware and Software Requirements for Installing SQL Server 2016 Once the public preview is released you will be able to find hardware and software requirements at the link below: sqlserver2016 0100101010110 Real-time operational analytics Example Solutions • Fraud detection • Sales forecasting • Warehouse efficiency • Predictive maintenance Data Scientist Interact directly with data Data Developer/DBA Manage data and analytics together Microsoft Azure Marketplace New R scripts 01001 10010 0101 01001 10010 0101 01001 10010 0101 Built-in to SQL Server Extensibility 100X In-memory ColumnStore ? R Integration R Analytic Library Relational Data T-SQL Interface 01001 10010 0 01001 10010 0 © 2015 Microsoft Corporation. All rights reserved. This document is provided "as-is." Information and views expressed in this document, including URL and other Internet Web site references, may change without notice. You bear the risk of using it. This document does not provide you with any legal rights to any intellectual property in any Microsoft product. You may copy and use this document for your internal, reference purposes. You may modify this document for your internal, reference purposes.

Articles in this issue

Links on this page

Archives of this issue

view archives of Netherlands: Software - Microsoft SQL Server 2016 datasheet