sqlschool.gr logo

articles

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 για την νέα έκδοση και τα περιεχόμενα του είναι τα παρακάτω 

MISSION CRITICAL PERFORMANCE

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

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 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

HYPERSCALE CLOUD

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

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

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

/*antonch*/

Antonios Chatzipavlis

Antonios Chatzipavlis

Antonios Chatzipavlis is a highly experienced Data Solutions Consultant and Trainer. He has been working in the IT industry since 1988, holding various roles such as senior developer, IT Manager, Data & AI Solutions Architect and Consultant.

Since 1995, Antonios has focused on modern technologies and software development tools, primarily by Microsoft. He has specialized in Data & AI since 2000, with expertise in Microsoft Data Platform (SQL Server, Azure SQL Databases, Azure Synapse Analytics, Microsoft Fabric, Power BI, AI) and Databricks.

Antonios is also a Microsoft Certified Trainer (MCT) for over 25 years, has been recognized as a Microsoft Most Valuable Professional (MVP) in Data Platform since 2010 and he is in the Data Expert 40 Powerlist 2024 by Boussias. He is the co-founder and visionary behind XLYTiCA, a company dedicated to Data & AI solutions.

Episode

Task Flows in Microsoft Fabric

image

More Episodes...

Tip

Get Certified: Become a Fabric Data Engineer

More Tips...

Become a member

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

Connect

Explore

Learn

sqlschool.gr © 2010-2025 All rights reserved

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