When did Microsoft add T-SQL querying in Synapse Analytics?

Microsoft first added T-SQL querying capabilities to Azure Synapse Analytics in November 2019. It was initially available only for dedicated SQL pools, but support for serverless SQL pools was added in August 2021.

Since then, Microsoft has been continuously improving the T-SQL support in Azure Synapse Analytics, adding new features and functionalities. As of October 2023, Synapse supports a large subset of the T-SQL features available in SQL Server and Azure SQL Database.

Here are some key milestones in the development of T-SQL support in Azure Synapse Analytics:

• November 2019: General availability of T-SQL querying in dedicated SQL pools.
• March 2020: Support for T-SQL stored procedures and functions.
• June 2020: Support for T-SQL external tables for accessing data in data lakes.
• August 2021: General availability of T-SQL querying in serverless SQL pools.
• October 2022: Support for T-SQL window functions.
• October 2023: Support for T-SQL system views.

Microsoft continues to invest in the development of T-SQL support in Azure Synapse Analytics, making it a more powerful and versatile tool for data analysts and developers.

Here are some resources where you can learn more about the history of T-SQL support in Azure Synapse Analytics:

• Azure Synapse Analytics release notes
• Blog post: Introducing T-SQL querying in Azure Synapse Analytics
• Blog post: Announcing T-SQL support for serverless SQL pools in Azure Synapse Analytics