January 13, 2023
Database server versions come and go; updates ride in and out like predictable tides. SQL Server 2022 is one of the newer updates in the data world, only recently being released to the general public. Here are 5 update buckets in the SQL Server flagship (all unique only to SQL Server 2022) to keep an eye out for:
Performance and Intelligence
- Data virtualization for any data lake
- S3-compatible Object storage backup and restore
- Buffer pool parallel scan
- Query store – hints and replica support
- Integrated acceleration and offloading
- Hybrid buffer pool with direct write
- Advanced Vector Extension (AVX) 512 extension to improve batch mode operations
Availability
- Optimized Large memory and concurrency scalability
- Multi-write replication
- Link to Azure SQL Managed Instance – bidirectional
- Contained availability group
Security
- Azure Active Directory authentication
- Microsoft Purview Integration data owner policies
- SQL Ledger
- Support for PFX certificates and other cryptographic enhancements
- MS-TDS 8.0 protocol and TLS 1.3
Support
- Bit manipulation functions
- Time series support
New Additions
- Express: Up to 4 cores of CPU, up to 1410 MBs of memory
- Standard: Up to 24 cores of CPU, up to 128 GBs of memory
- Enterprise: Unlimited cores of CPU, unlimited memory
Solvaria is a neutral neighbor – we’ll send our DBAs out to work with any data platform. If your business wants to make the transition to SQL Server 2022, whether from a different version of SQL, a different data company, or as a migration from the Cloud, Solvaria’s got you covered.
Latest Posts
Ep. 20 – From Analyst to CEO
Ep. 19 – Jimmy Walicek
Ep. 18 – JJ White
Ep 17 – John Toler
Solvaria Unveils New Database Security Solution: CIS SecureSuite® Assessments
Partitioning Strategies: Optimizing Database Performance
Disaster Recovery Runbooks: Proactive Crisis Management
Understanding and Resolving ORA-12154: TNS Connect Identifier Error
Inspiring Future STEM Leaders at GiSTEM’s Thinking Big 2024
Improving Database Performance with Caching Strategies
Visit Our Blog
Share This Post