sqlschool.gr logo


Articles of SQLschool.gr Team

SQL Server 2016 datasheet

Antonios Chatzipavlis
Monday 04 May 2015

Σήμερα ο Satya Nadella , CEO της Microsoft στα πλαίσια του keynote του Microsoft Ignite ανακοίνωσε την έλευση του SQL Server 2016. Φυσικά αμέσως υπήρχαν και οι απαραίτητες αναρτήσεις στο msdn / TechNet όπου πλέον υπάρχει το datasheet για την νέα έκδοση και τα περιεχόμενα του είναι τα παρακάτω 


New Performance Enhancements

  • 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 to JSON
  • Temporal Database: Track historical changes

Security Upgrades

  • 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

Even Higher Availability

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

Improved Scalability

  • Enhanced Database Caching: Cache data with automatic, multiple TempDB files per instance in multi-core environments
  • Support for Windows Server 2016


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 visualization on mobile devices with native apps for Windows, iOS and Android
  • Enhanced Reporting Services: New modern reports with rich visualizations

Built-in Advanced Analytics

  • Built-in Advanced Analytics: Bringing predictive analytic algorithms directly in SQL Server.  Expand your “R” script library with Microsoft Azure Marketplace


Hybrid Solutions

  • Stretch Database: Stretch operational tables in a secure manner into Azure for cost effective historic data availability 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 and 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


  • 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


  • 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

Όλα τα παραπάνω μπορείτε να τα δείτε από το επίσημο link http://www.microsoft.com/en-us/server-cloud/products/sql-server-2016/


Antonios Chatzipavlis

Antonios Chatzipavlis

Antonios is a Data Solutions Consultant and Trainer. He has been working in IT since 1988. In his career, he has worked as senior developer, IT Manager, Solutions Architect and IT Consultant. Since 1995 he has been devoted on new technologies and software development tools, mainly by Microsoft, either by training company staff and colleagues or assisting them in design, development and implementation as a consultant or chief developer. He has focused in Databases and Data Science since 1995. He specialized in Microsoft SQL Server since version 6.0 in areas like SQL Server Internals, Database Design and Development, Business Intelligence and in 2010 he has started working with Azure Data Platform, NoSQL databases, Big Data Technologies and Machine Learning. He is an active member of many IT communities in Greece, answering colleagues' questions and writing articles in his web site. He is the owner of SQLschool.gr which is a community portal with a lot of information about Microsoft SQL Server. He has been a Microsoft Certified Trainer (MCT) since 2000. Microsoft honored him as MVP on Data Platform due to his activities in SQL Server since 2010. He holds a large number of Microsoft Certifications and Microsoft SQL Server Certifications since version 6.5.


What's New in SQL Server 2022 - Episodes

More Tips...

Become a member

If you want to receive updates from us become a member to our community.




sqlschool.gr © 2010-2024 All rights reserved

This site uses cookies for operational and analytics purposes only. By continuing to browse this site, you agree to their use.