SQL Examiner Suite 2023.1 release notes

April 17, 2023

After the major SQL Examiner Suite 2023 release, several feature updates have been added. All interim features are available free to users who already own the 2023 version. Here we list features implemented in 2023.1. The rest are available in SQL Examiner Suite 2023.2 release notes. The primary SQL Examiner Suite 2023 Release Notes contain all features planned for version 2023.

Version 2023.1 includes SQL Examiner and SQL Data Examiner with version numbers 9.1.x.x.

In this interim release, we have implemented support for SQL Server 2022 features, support for which we did not implement at the time of release of the 2023 version, including:

• Ordered clustered columnstore indexes:
  https://learn.microsoft.com/en-us/sql/relational-databases/indexes/columnstore-indexes-what-s-new?view=sql-server-ver16
• Compression of XML columns and indexes:
  https://learn.microsoft.com/en-us/sql/relational-databases/xml/xml-data-sql-server?view=sql-server-ver16
• AUTO_DROP option for statistics
• IS [NOT] DISTINCT FROM language element:
  https://learn.microsoft.com/en-us/sql/t-sql/queries/is-distinct-from-transact-sql?view=sql-server-ver16
• SELECT ... WINDOW clause:
  https://learn.microsoft.com/en-us/sql/t-sql/queries/select-window-transact-sql?view=sql-server-ver16
• Ledger tables:
  https://learn.microsoft.com/en-us/sql/relational-databases/security/ledger/ledger-overview?view=sql-server-ver16
• GENERATED ALWAYS AS argument of the CREATE TABLE statement with TRANSACTION_ID and SEQUENCE_NUMBER parameters:
  https://learn.microsoft.com/en-us/sql/t-sql/statements/create-table-transact-sql?view=sql-server-ver16
• Azure Active Directory authentication for SQL Server:
  https://learn.microsoft.com/en-us/sql/relational-databases/security/authentication-access/azure-ad-authentication-sql-server-setup-tutorial?view=sql-server-ver16