Netherlands: Software

Microsoft SQL Server 2016 datasheet

Issue link: http://hub-nl.insight.com/i/665830

Contents of this Issue

Navigation

Page 1 of 1

MISSION CRITICAL PERFORMANCE • Operational Analytics: Insights on operational data, works with in-memory OLTP or on disk • In-memory OLTP enhancements: Greater T-SQL surface area, terabytes of memory supported and greater number of parallel CPUs • Query Data Store: Monitor and optimize query plans with full history of query execution • Native JSON: Parsing & storing of JSON as relational data & exporting relational data to JSON • Temporal Database: Track historical changes New Performance Enhancements • Always Encrypted: Help protect data at rest and in motion with the master key residing with the application & no application changes required • Row Level Security: Apply fine-grained access control to table rows based on users rights • Dynamic Data Masking: Real-time obfuscation of data to prevent unauthorized access Security Upgrades • Enhanced AlwaysOn: • Up to 3 synchronous replicas for auto failover across domains • Round-robin load balancing of replicas • DTC & SSIS support • Automatic failover based on database health Even Higher Availability • Enhanced Database Caching: Cache data with automatic, multiple TempDB files per instance in multi-core environments • Support for Windows Server 2016 Improved Scalability HYPERSCALE CLOUD Hybrid Solutions • Stretch Database: Stretch operational tables in a secure manner into Azure for cost effective historic data availability. It works with Always Encrypted and Row Level Security • PowerBI with on-premises data: New interactive query with Analysis Services. Customer data stays behind your firewall • Hybrid Scenarios with SSIS: Azure Data Factory integration with SSIS, package lineage and impact analysis as well as connect SSIS to cloud data source • Enhanced Backup to Azure: X faster restore and 50% reduction in storage, support larger DBs with Block blobs and custom backup schedule with local staging Simplicity • Easy migration of on-premises SQL Server: Simple point and click migration to Azure • Simplified Add Azure Replica Wizard: Simplified hybrid HA & DR with AlwaysOn Consistency • Common Development, Management and Identity Tools: Including Active Directory, Visual Studio, Hyper-V and System Center • Consistent Experience from SQL Server on- premises to Microsoft Azure IaaS and PaaS DEEPER INSIGHTS ACROSS DATA Access Any Data • PolyBase: Manage relational & non-relational data with the simplicity of T-SQL • Power Query for Analytics and Reporting: Pull data from countless sources into data models and reports • Enhanced SSIS: Designer support for previous SSIS versions and support for Power Query Scale and Manage • Enterprise-grade Analysis Services: Enhanced performance and scalability for Analysis Services • Single SSDT in Visual Studio 2015: Build richer analytics solutions as part of your development projects in Visual Studio through a single tool. • Enhanced MDS: Excel add-in 15X faster, more granular security roles, archival options for transaction logs, and reuse entities across models Powerful Insights on any device • Mobile BI: Business insights for your on- premises data through rich visualizations on mobile devices with native apps for Windows, iOS and Android • Enhanced Reporting Services: New, modern reports with rich visualizations Stretch Database • Built-in Advanced Analytics: Bringing predictive analytic algorithms directly into SQL Server. Expand your "R" script library with Microsoft Azure Marketplace Built-in Advanced Analytics Mobile BI Always Encrypted Apps Query @SSN=0x7ff654ae6d Master Columnar key Enhanced ADO.NET Library Jim Gray Name Result Set SELECT Name FROM Patients WHERE SSN=@SSN Result Set Encrypted Columnar key dbo.Customers ciphertext SELECT Name FROM Patients WHERE SSN=@SSN SQL Server Trusted 0x19ca706fbd9a Name 0x21ba906fdb52 Name 1x7fg655se2e SSN USA Country 0x19ca706fbd9a 0x7ff654ae6d USA 1x59cm676rfd8b 0y8fj754ea2c USA @SSN='198-33-0987' Order history Name SSN Date Jane Doe cm61ba906fd 2/28/2005 Jim Gray ox7ff654ae6d 3/18/2005 John Smith i2y36cg776rg 4/10/2005 Bill Brown nx290pldo90l 4/27/2005 Sue Daniels ypo85ba616rj 5/12/2005 Sarah Jones bns51ra806fd 5/22/2005 Jake Marks mci12hh906fj 6/07/2005 Eric Mears utb76b916gi 6/18/2005 Dan Hogan px61hi9306fj 7/1/2005 Sam Johns ol43bi506gd 7/12/2014 David Simon tx83hal916fi 7/29/2014 Mel Burns nb95re926gi 8/10/2014 Reed Dean vc61ira536fe 8/23/2014 Azure Microsoft Azure SQL Server App Query

Articles in this issue

Archives of this issue

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