SQL Server

SQL Server 2022 BI and integration updates are mostly performance related, and some bring new opportunities for using SQL Server with Power BI and Azure.

SQL Server 2022 introduces new availability and backup options that ease management and reduce risk but bring new limitations and changes.

SQL Server 2022 use of Azure Active Directory for user authentication reaches general availability in most scenarios, except for SQL Server in Azure VMs.

SQL Server 2022 introduces new Azure-connected features that offer unique benefits, but they also bring additional costs, trade-offs, dependencies, and risks.

Illustration shows likely SQL Server version releases and retirements.

SQL Server 2022 introduces new Azure-connected features, but also important incremental updates to core performance, availability, and security features.

SQL Server IoT 2022 is a specially licensed variant of SQL Server 2022, designed for OEMs to embed in physical devices like manufacturing equipment.

Power BI Pro supports paginated reports, providing the same report features (and limitations) as the pricier Power BI Premium platforms, removing a barrier to adopting the service.

SQL Server 2022 can use Azure Active Directory authentication directly, supporting new forms of authentication and removing dependencies on Windows domain controllers.

SQL Server 2022 performance updates can help automate query tuning and improve throughput in most scenarios, although some require rearchitecting deployments and new hardware.