In mid-November 2026, the following updates and
enhancements were made to Azure SQL:
- Fuzzy
string matching enables you to compare strings based on similarity rather
than relying only on exact matches. Using built-in functions, you can
measure the difference or similarity between strings with algorithms such
as Damerau-Levenshtein (OSA) and Jaro-Winkler.
- Regex-based
Dynamic Data Masking extends the built-in DDM feature in Azure SQL
Database with flexible, pattern-based masking using regular
expressions—centrally enforced at the database layer.
- AES
keys support for Transparent Data Encryption (TDE) with customer-managed
keys in Azure SQL Database are now generally available, providing an
alternative to RSA keys for protecting data at rest and helping you
prepare for the evolving quantum threat landscape.
- You
can now customize how numeric values appear in the SSMS results grid
without changing your queries or Windows regional settings. Choose your
preferred digit grouping and decimal symbols, or use your system defaults.
A live preview shows how your selections will look, and changes apply to
open grids without restarting SSMS or rerunning your query.
Learn more: