What's new in SQL Tools

on YouTube ↗50m

" summary

Connections now default to encryption after the move from SQL Client 3→4 and the TDS8/TLS1.3 work in secure-by-default SQL Client can break old connection strings unless you trust server certs; SSMS 19 is GA and SSMS 21 plans a migration to SSMS 21 64-bit on VS2022 shell with a redesigned connection dialog. SQLPackage previews export large-data payloads to Parquet in Azure Blob for multi‑TB imports, Go SQLCMD single-binary supports AAD/managed identity and container quickstart, SDK-style SQL projects (Microsoft.Build.Sql) and Azure Functions SQL bindings are in preview/GA.

AI-written summary · about

" chapters (13)

1. 0:00Introduction
2. 1:10Feedback and support
3. 3:21SQL client security
4. 6:10SQL tools portfolio
5. 6:54SSMS 19 updates
6. 7:59SSMS 21 roadmap
7. 11:27Azure Data Studio enhancements
8. 13:36DACFx and SQL projects
9. 18:15SQLPackage improvements
10. 24:35Azure Functions SQL bindings
11. 28:28Go SQLCMD and containers
12. 32:00Azure portal SQL updates
13. 35:15Q&A

" related talks

• 51mAzure Data Studio and the Surprises InsideErin Stellato · SQLBits 2023
• 40mThe SQL Leadership PanelBob Ward, Sanjay Mishra, Erin Stellato, Asad Khan, Muazma Zahid, Niko Neugebauer · SQLBits 2023
• 01h 02mNot your Father's SQL Server: Developer Innovations in Data StorageJerry Nixon · Visual Studio Live! @ Microsoft HQ 2025
• 45mSQL Projects for Database DevelopmentDrew Skwiers-Koballa · SQL Server Virtual Conference 2021
• 01h 12mNext-gen SQL Projects with Microsoft.Build.SqlDrew Skwiers-Koballa · Visual Studio Live! @ Microsoft HQ 2025
• 51mSQL Server 2022 and the Wheel of PowerBob Ward · SQLBits 2023
• 48mThe Kingdom of AdventureWorks Calls for AidBob Ward, Buck Woody, Sanjay Mishra, Asad Khan · SQLBits 2022
• 20mSQL Server 2022 migrations with dbatoolsJess Pomfret · SQLBits 2022