際際滷

際際滷Share a Scribd company logo

What's New in SQL Server 2017 since SQL Server 2008 R2

Download as PPTX, PDF
Bill Ramos
Bill Ramos

This slide shows the new features that Microsoft has added to SQL Server since the SQL Server 2008 R2 release.

1 of 1
Enhanced productivity and performance Power View Configurable reporting alerts Reporting as SharePoint Shared Service Build organization knowledge base Connect to 3rd party data cleansing providers Master Data Hub Master Data Services Add-in for Excel Graphical tools in SSIS Extensible object model SSIS as a Server Broader data integration with more sources: DB vendors, cloud, Hadoop Pipeline improvements SQL Server Data Tools Local DB runtime (Express) Data-tier application component project template Data-Tier ApplicationFramework (DAC Fx) Interoperability support (ADO.NET, ODBC, JDBC, PDO, ADO APIs and .NET C/C++, Java, Linux and PHP platforms) Enhanced support for ANSI SQL standards Transact-SQL Static Code Analysis tools Transact-SQL code snippets Intellisense FileTable build on FILESTREAM Remote Blob Storage with SharePoint 2010 Statistical Semantic Search Spatial features, Full Globe and arcs Large user-defined data types Distributed Replay Contained Database Authentication System Center Management Pack for SQL Server 2012 Windows PowerShell 2.0 support Multi-server Management with SQL Server Utility Control Point Data Tier Application Component Automatic Plan Correction Enhanced connectors, new transformations, object-level security, ragged hierarchies** Graph data support Mobile BI Enhanced SSIS Enterprise-grade Analysis Services Advanced tabular models In-memory analytics Enhanced multidimensional models JSON support Enhanced DQS Enhanced MDS Modern Reporting Services Temporal tables Advanced data mining Create mobile reports using the SQL Server Mobile Report Publisher Consume with Power BI mobile apps Azure HDInsight Service Power BI Power Map for Excel Mash up data from different sources, such as Oracle & Hadoop HA for StreamInsight, complex event processing SQL Server Data Tools support for BI Change Data Capture for Oracle Import PowerPivot models into Analysis Services Transparent Data Encryption Always Encrypted Enhanced separation of duty Row-level security Dynamic data masking Enhanced separation of duties Default schema for groups SQL Server Audit SQL Server fine-grained auditing Real-time operational analytics with in-memory OLTP or on disk In-memory for more applications Unparalleled scalability with Windows Server 2016, with 12TB memory and Windows Server 2016 max cores Enhanced AlwaysOn, with 8 secondaries and Replica Wizard Multiple node failover clustering (3 synchronous, up to 8 replicas) In memory OLTP Buffer Pool Extension to SSDs Enhanced query processing Resource Governor adds IO governance SysPrep as cluster level Predictable performance with tiering of compute, network and story with Windows Server 2012 R2 Delayed Durability Clustered Shared Volume support, VHDX support (Windows Server 2012 R2) Manage on-premises and cloud apps (System Center 2012 R2) Query optimization enhancements Recovery Advisor Windows Server Core Live Migration Online operations enhancements Query Store Temporal support Python integration** R built-in to your T-SQL RRE APIs with full parallelism and no memory limits for scale/performance Built-in In-memory Advanced Analytics Advanced tabular model Direct query Advanced data mining SSDT in Visual Studio Stretch database Partitioning for efficient data loading Hybrid scenarios with SSIS Enhanced backup to Azure Easy migration to the cloud Simplified cloud DR with AlwaysOn replicas Simplified backup to Azure Support for backup of previous versions of SQL Server to Azure Cloud back-up encryption support Simplified cloud Disaster Recovery with AlwaysOn replicas in Azure VMs New Azure Deployment UI for SQL Server Larger SQL Server VMs and memory sizes available in Azure SQL Server Data Tools Snapshot backups to Azure via SQL Server Management Studio Adaptive Query Processing Operational analytics In-memory ColumnStore Deployment rights for APS Enhanced In-memory ColumnStore for DW PolyBase for simple T-SQL to query structured and unstructured data Enhanced database caching Up to 15,000 partitions Analytics Platform System **Available for Windows Server only. Linux support Container support W H A T S N E W I N S Q L S E R V E R 2 0 1 7 S I N C E 2 0 0 8 R 2

More Related Content

What's New in SQL Server 2017 since SQL Server 2008 R2

  • 1. Enhanced productivity and performance Power View Configurable reporting alerts Reporting as SharePoint Shared Service Build organization knowledge base Connect to 3rd party data cleansing providers Master Data Hub Master Data Services Add-in for Excel Graphical tools in SSIS Extensible object model SSIS as a Server Broader data integration with more sources: DB vendors, cloud, Hadoop Pipeline improvements SQL Server Data Tools Local DB runtime (Express) Data-tier application component project template Data-Tier ApplicationFramework (DAC Fx) Interoperability support (ADO.NET, ODBC, JDBC, PDO, ADO APIs and .NET C/C++, Java, Linux and PHP platforms) Enhanced support for ANSI SQL standards Transact-SQL Static Code Analysis tools Transact-SQL code snippets Intellisense FileTable build on FILESTREAM Remote Blob Storage with SharePoint 2010 Statistical Semantic Search Spatial features, Full Globe and arcs Large user-defined data types Distributed Replay Contained Database Authentication System Center Management Pack for SQL Server 2012 Windows PowerShell 2.0 support Multi-server Management with SQL Server Utility Control Point Data Tier Application Component Automatic Plan Correction Enhanced connectors, new transformations, object-level security, ragged hierarchies** Graph data support Mobile BI Enhanced SSIS Enterprise-grade Analysis Services Advanced tabular models In-memory analytics Enhanced multidimensional models JSON support Enhanced DQS Enhanced MDS Modern Reporting Services Temporal tables Advanced data mining Create mobile reports using the SQL Server Mobile Report Publisher Consume with Power BI mobile apps Azure HDInsight Service Power BI Power Map for Excel Mash up data from different sources, such as Oracle & Hadoop HA for StreamInsight, complex event processing SQL Server Data Tools support for BI Change Data Capture for Oracle Import PowerPivot models into Analysis Services Transparent Data Encryption Always Encrypted Enhanced separation of duty Row-level security Dynamic data masking Enhanced separation of duties Default schema for groups SQL Server Audit SQL Server fine-grained auditing Real-time operational analytics with in-memory OLTP or on disk In-memory for more applications Unparalleled scalability with Windows Server 2016, with 12TB memory and Windows Server 2016 max cores Enhanced AlwaysOn, with 8 secondaries and Replica Wizard Multiple node failover clustering (3 synchronous, up to 8 replicas) In memory OLTP Buffer Pool Extension to SSDs Enhanced query processing Resource Governor adds IO governance SysPrep as cluster level Predictable performance with tiering of compute, network and story with Windows Server 2012 R2 Delayed Durability Clustered Shared Volume support, VHDX support (Windows Server 2012 R2) Manage on-premises and cloud apps (System Center 2012 R2) Query optimization enhancements Recovery Advisor Windows Server Core Live Migration Online operations enhancements Query Store Temporal support Python integration** R built-in to your T-SQL RRE APIs with full parallelism and no memory limits for scale/performance Built-in In-memory Advanced Analytics Advanced tabular model Direct query Advanced data mining SSDT in Visual Studio Stretch database Partitioning for efficient data loading Hybrid scenarios with SSIS Enhanced backup to Azure Easy migration to the cloud Simplified cloud DR with AlwaysOn replicas Simplified backup to Azure Support for backup of previous versions of SQL Server to Azure Cloud back-up encryption support Simplified cloud Disaster Recovery with AlwaysOn replicas in Azure VMs New Azure Deployment UI for SQL Server Larger SQL Server VMs and memory sizes available in Azure SQL Server Data Tools Snapshot backups to Azure via SQL Server Management Studio Adaptive Query Processing Operational analytics In-memory ColumnStore Deployment rights for APS Enhanced In-memory ColumnStore for DW PolyBase for simple T-SQL to query structured and unstructured data Enhanced database caching Up to 15,000 partitions Analytics Platform System **Available for Windows Server only. Linux support Container support W H A T S N E W I N S Q L S E R V E R 2 0 1 7 S I N C E 2 0 0 8 R 2

Editor's Notes

  1. Complete inventory of features since 2008 R2 by pillar for customers upgrading from SQL Server 2008 R2.