PolyBase, a data virtualization feature for SQL Server, allows users to seamlessly query data from various external sources directly using T-SQL (Transact-SQL) without the need for separate client ...

SQL Server Data Tools has upgraded from Microsoft.Data.SQLClient 3.0 to 5.0. The new version has support for TDS 8.0, support for specifying Server SPN and Failover Server SPN on the connection.

While ledger is a game-changer for security, SQL Server 2022 also introduced new functionality around Dynamic Data Masking (DDM), T-SQL enhancements and more.