Reitse Eskens shares some thoughts:
It’s been a long time coming, but all of a sudden there were a number of posts from Microsoft announcing the first preview of SQL Server Management Studio 21. This is big as it’s quite the overhaul from the SQL Server Management Studio we’re used to.
To give you some idea, here are my first impressions.
Vlad Drumea also takes a peek:
SQL Server Management Studio 21 Preview 1 was released 2 days ago, so I took it out for a spin and here are my first impressions so far.
Read on to see what’s in the preview today, some of the new functionality, and whether SSMS 21 is faster than SSMS 20.
Dont you love the return of the Debugger?
Since its built on VS 2022 , which has a debugger built -in
No wait…
Maybe I’m the odd one here, but I have never understood the love for SSMS’s debugger. I understand the value of debuggers in general, but a T-SQL debugger already has limitations in that you’re only able to step forward on concrete statements (rather than elements of an execution plan) and you’re blocking everybody else along the way while debugging a stored procedure.
The counter-argument to this is often something like how you can debug against a local database that nobody else is using, which is true. But in that case, you could also run individual stored procedure elements on your own. Debuggers are really helpful for languages in which you can’t do that. I get that there may be local variables that you’d have to manage yourself, and that is an annoyance. But when it comes to concrete value, I don’t really see it with a T-SQL debugger.