Hacker News Reader

Comment by AdrianB1 | Hacker News Reader

No, it has a different purpose; VS Code extension and the former ADS are targeted for development, while SSMS is for server and database administration. I am a heavy user of SSMS and can do everything I ever need there, I don't use the VS Code extension for MS SQL even if I have it installed and I use VS Code quite a lot. This is because I am also acting as a backup and supervisor for our DBA team, so I am involved in DBA work.

View on HN

SSMS is also for Development, I've been using it for that for 20 years

Same here, much better than the VS tooling for SQL Server, including all the Transact-SQL support.

I still miss the tool it replaced, SQL Query Analyzer/Profiler. To this day it's my favourite SQL 'IDE'.

https://learn.microsoft.com/en-us/archive/msdn-magazine/2005...

Those features/tools are still part of SSMS today.

Yeah, it's specifically the old applications I miss.

They were really well designed, incredibly snappy and responsive. When SSMS was launched it was really slow and clunky on my computer.

I switched to Postgres around that time so I'm 20 years out of touch at this point.

I had forgotten about query analyzer, didn't it exist alongside ssms? I think I used to roll it out when things got really serious

Query Analyzer was eventually superseded by SSMS but there was an overlap period IIRC.

I just said what Microsoft is targeting the tools for, not how they can be used.

I agree, I work on an application with a lot of business logic in SQL and SSMS ends up being my primary development IDE because of that.

Lead PM for SQL in VS Code here. I’m glad to hear SSMS is working well for you! I’d love to better understand why VS Code doesn’t meet your needs in the same way.

We’re actively working to improve the experience, and learning what works for you in SSMS would be incredibly valuable.

Yes, it's good!

SSMS is what my nightmares are made of

Reply on news.ycombinator.com