{"id":41160,"date":"2022-06-15T08:00:00","date_gmt":"2022-06-15T15:00:00","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?p=41160"},"modified":"2024-04-19T10:41:44","modified_gmt":"2024-04-19T17:41:44","slug":"recapping-recent-updates-to-client-tools-in-sql-server","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/06\/15\/recapping-recent-updates-to-client-tools-in-sql-server\/","title":{"rendered":"Recapping recent updates to client tools in SQL Server"},"content":{"rendered":"\n

Hello from the SQL Experiences team! As a follow-up to Microsoft Build at the end of May, we thought it was a good time to highlight recent updates for client tools, as we\u2019ve had quite a few.<\/p>\n\n\n\n

SQL Server Management Studio<\/h2>\n\n\n\n

First, in alignment with the announcement of preview for SQL Server 2022, we released SQL Server Management Studio (SSMS) 19 Preview 2<\/a>. <\/p>\n\n\n\n

SSMS 19 is the recommended version of SSMS for SQL Server 2022. The release notes for SSMS<\/a> document current limitations and we will have additional previews in upcoming months with expanded capabilities.<\/p>\n\n\n\n

Developer Tools<\/h2>\n\n\n\n

Second, we continue to support developers working with databases via the latest version of the SQL Database Projects extension in Azure Data Studio. We now have preview support for SDK-style SQL projects<\/a> which benefit developers who work in cross-platform environments or ship applications through CI\/CD platforms. In addition, the SQL Database Projects extension provides a local development environment<\/a> for Azure SQL Database through an emulator. The emulator provides a containerized database to allow for testing and development in an offline and independent environment, thereby reducing resource requirements and increasing developer autonomy. We are working to expand the capabilities of the Azure SQL Database emulator in future releases.<\/p>\n\n\n\n

Further enhancements in the development space include the integration of SQL bindings<\/a> with the mssql extension in VS Code. This enables users to develop Azure Functions with Azure SQL bindings and while the SQL bindings extension currently only integrates with C# Azure Functions, support for JavaScript, TypeScript, and Python have been added to the preview for SQL bindings<\/a> as well.<\/p>\n\n\n\n

We also have a set of driver, library, and command-line interface (CLI) updates to note:<\/p>\n\n\n\n