Just a quick one this morning. I’m on the road and haven’t worked up a full blog post, apologies. I’ve been using the preview for SQL Server Management Studio 21 for a little over a week now. You should check it out. It’s been mostly stable (I got a crash. I didn’t report it because I couldn’t replicate it). I think the most interesting thing has been how much it’s largely the same. It’s in a new home within Visual Studio. However, the majority of the behaviors I’ve hit so far have been normal. Heck, Redgate SQL Prompt is working for me and my team told me we don’t support SSMS 21 yet.
I’ve spent most of my time in Extended Events and the Live Data Window. So much of it is identical. In fact, so identical that the opening screen on the Create Session window still hides “Track Causality” and you have to resize the window to see it. That’s how close the new behavior matches the old behavior. Get out in front and make sure the things you need the most out of this tool are working for you while it’s still in Preview. That way you’re more likely to get stuff fixed.
My blocker, at the moment, is lack of SSIS support. It’s something we use a lot of at the office and as much as I would like like to use it daily, and test, it got a little frustrating to keep swapping back to SSMS 20 for SSIS stuff.
I admit, my initial thoughts were good though. It being 64-bit is a great boon, as it native dark mode. I look forward to its fill release.
Ooh, yeah, I don’t work at all in SSIS, so not surprising I missed that. I’m sure it’s coming.