Editions und Komponenten im Vergleich: SQL Server 2012 bis SQL Server 2022
- Überblick SQL Server Versionen
- Unterschiede Editions, Komponenten, HW/SW Requirements, Scale Limits,
- Licensing im Vergleich
Installation SQL Server 2012/2014/2016/2017/2019/2022
- Installation
- Änderungen in den Installationsroutinen ab 2012
- Installation der Management Tools
- Upgrading and Migrating des SQL Servers
Features SQL Server 2012
- Erweiterungen im SQL Server Management Studio
- Neue und erweiterte Dynamic Management Views
- Transact-SQL Erweiterungen
- Neue Transact-SQL Functions
- Storing and Querying Documents with SQL Server 2012
- Tracing with Extended Events Profiler
- Erweiterungen im Bereich Performance Optimization Tools
- Columnstore Indexe
- Improvements for Table Partitioning
- High Availability with AlwaysOn
- Enhancements to Point in Time Restore and Page Restore
- Neuerungen im Bereich Security und Audit
- Contained Databases
Features SQL Server 2014
- Buffer Pool Extension
- Optimierte Columnstore Indexes in 2014
- Memory-Optimized Tables
- Erweiterungen im Bereich Audits
- AlwaysOn Enhancements
- Incremental Index Rebuild and Lock Priority settings
- Query Optimizer - Cardinality Estimator changes (since 7.0)
- Änderungen im Bereich des Auto Update Statistics Algorithmus
- Backup von Datenbanken auf eine Azure-URL
- Verschlüsselung von Datenbanksicherungen
Features SQL Server 2016
- In-memory OLTP Erweiterungen
- Query data store
- Temporal tables
- Always encrypted
- Row level security
- Dynamic data masking
- Audit Enhancements
- AlwaysOn Availability Group Enhancements
- Polybase
- Stretch Database feature
Features SQL Server 2017
- SQL Server 2017 unter Windows, Linux und Docker container
- Graph databases
- Resumable Online Index Rebuild
- Identity Cache for auto increment values
- New TSQL functions
- Scaling out SSIS
- Adaptive Query Processing
- Automating Tuning – plan choice correction
Features SQL Server 2019
- Hybrid Buffer Pool
- Memory Optimized tempdb Metadata
- Always Encrypted Secure Enclaves
- Availability Groups Enhancements
- Transparent Data Encryption PAUSE/RESUME Certificate Management Resumable Index Operations Online Index Maintenance for Columnstore Index Accelerated Database Recovery Big Data Cluster
- UTF-8 support
- SQL Server Intelligent Performance – Query Processing
Features SQL Server 2022
- Azure related Enhancements
- Contained Availability Groups
- SQL Ledger
- SQL PurView
- Query Store Enhancements
- Parameter Sensitive Plan Optimization
- DOP Feeback
- Azure Arc
- Snapshot Backup
