I like the look and feel of ADS... did I hear someone say "dark mode"??!! Setting colors is more limited than I'd like but good enough for me and then there's notebooks... those have some serious potential (unrealized for me as of yet, but still serious potential). Jupyter never figured it out but I think MS will and then notebooks will allow multiple languages to be used in different cells and that'll be a game changer (PowerShell, Python, SQL, .Net, DAX, MDX all in one notebook... Can someone say interactive Runbooks?)
I haven't made the switch though... I want to but there are some deal breakers for me... ADS really needs to enable SQLCMD mode (turns out this was added too, yay!), Red-Gate really needs to make SQLPrompt work in ADS (I know they have it available but it also needs to work not just be available), and finally ADS Needs a UI for SQL Server Agent Jobs. Those are really the only hurdles keeping me away from ADS (SQLPrompt being the biggest), everything else is either something I don't use all the time (at which point I'd load up SSMS for those things as needed until they become available in ADS) or they're something I can work around or live without.
ADS still seems very data analyst focused while SSMS seems very DBA focused and too many of us are very much so both as well developer (in which case neither works perfectly) so we need a tool that does at least data analyst and DBA and for now that's still SSMS. If I was one or the other and not both... ADS would be my data analyst hat go-to for sure (pending SQLPrompt of course).
EDIT: I haven't tried SQLPrompt in ADS in a while so this post prompted me to try again and see what if anything has changed... first look says SQLPrompt is working in ADS... That's a big deal for me... I'll be taking another look at the ADS switch sometime before Christmas (I hope anyway).
🙁 no tab history but still very good start