Data-Platform-AirLift-SQL-Server-2016-New-Innovations.pdf

(3114 KB) Pobierz
SQL Server 2016
New innovations
César Mendes
cmendes@microsoft.com
Partner Technical Consultant
Data Platform Airlift
21 de Outubro \\ Microsoft Lisbon Experience
Data differentiates today's leading companies
Speed
Source: IDC & Microsoft, April 2014
Microsoft platform leads the way on-premises and cloud
Leader in 2014 for Gartner Magic Quadrants
Operational
Database
Management
Systems
Data
Warehouse
Database
Management
Systems
Business
Intelligence
and Analytics
Platforms
x86 Server
Virtualization
Cloud
Infrastructure
as a Service
Enterprise
Application
Platform as a
Service
Public Cloud
Storage
Do more. Achieve more.
Mission-critical performance
Performance
Operational analytics
Insights on operational data;
Works with in-memory OLTP and
disk-based OLTP
Security
Always encrypted
Sensitive data remains encrypted
at all times with ability to query
Availability
Enhanced AlwaysOn
Three synchronous replicas for
auto failover across domains
Scalability
Enhanced database
caching
Cache data with automatic,
multiple TempDB files per instance
in multi-core environments
In-memory OLTP
enhancements
Greater T-SQL surface area,
terabytes of memory supported,
and greater number of parallel
CPUs
Row-level security
Apply fine-grained access control
to table rows
Round robin load balancing of
replicas
Automatic failover based on
database health
DTC for transactional integrity
across database instances with
AlwaysOn
Dynamic data masking
Other enhancements
Real-time obfuscation of data to
prevent unauthorized access
Audit success/failure of database
operations
TDE support for storage of in-
memory OLTP tables
Enhanced auditing for OLTP with
ability to track history of record
changes
Query data store
Native JSON
Support for SSIS with AlwaysOn
Monitor and optimize query plans
Expanded support for JSON data
Temporal database
support
Query data as points in time

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin