Hacker News new | ask | show | jobs
by DaiPlusPlus 2404 days ago
I’ve been happy doing most tasks in MySQL Workbench that I can do with SSMS.

Oddly, when using SQL Azure instead of on-prem SQL Server, SSMS doesn’t let you use its friendly hand-holding dialogs but instead drops you into a new editor document with cryptic syntax.

The only excuse I can think of is that the user-friendly popups are single-threaded and block window-messages on network IO and would have a very poor UX due to due the chatty TDS protocol.

1 comments

It does sound like SQL Server and SSMS have some very interesting choices in remoting models, based on what I've read of Azure Data Studio's development.

Azure Data Studio's the VS Code-based SSMS-like tool focused on Azure SQL and Cosmos DB. At one point the development blog was talking about it as if Azure Data Studio might some day be the eventual replacement for even SSMS itself, but they seem to have walked that back, at least in part due to how many crazy things SSMS does and how SSMS is one of those tools that certain types of users would possibly go into some sort of costly meltdown if their cheese moved.