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.
![Database team works on applications](https://solvaria.com/wp-content/uploads/2023/02/Illustration.jpg)
Latest Posts
Database Refactoring: Techniques for Improving Database Design
The Critical Role of Disaster Recovery in OCI
Enhancing Performance with SQL Query Optimization Techniques
Celebrating 25 Years of Excellence: Honoring Greg Mays
Monitoring and Observability in Oracle Cloud Infrastructure
GitHub Copilot: Enhancing Efficiency or Diluting Developer Expertise?
Database Compliance Audits: Tackling Regulatory Adherence
Occupational Hazards – Ep. 16 Mark Morton
Database Encryption Best Practices: Essential Data Security
Solvaria at the Squirrels 2024
Visit Our Blog
Share This Post