3 ms·

They already have the SQL Server Management Studio[1], which seems to cover similar ground? I'm assuming they might want to move SSMS to VSCode in time, so try

They already have the SQL Server Management Studio[1], which seems to cover similar ground? I'm assuming they might want to move SSMS to VSCode in time, so trying it out by covering new ground, PostgreSQL, makes sense to me. [1]: https://learn.microsoft.com/en-us/ssms/sql-server-management-studio-ssms https://learn.microsoft.com/en-us/ssms/sql-server-management...

pier25 1y ago
But it's only for Windows
- magicalhippo 1y ago
  In my experience, MSSQL shops are far more likely to be using Windows already than PGSQL shops, so that's just yet another reason for why PGSQL was a good first choice for a VSCode plugin IMHO.
v5o 1y ago
[dead]
AdrianB1 1y ago
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.
- codeulike 1y ago
  SSMS is also for Development, I've been using it for that for 20 years
  - robertlagrant 1y ago
    Yes, it's good!
  - pjmlp 1y ago
    Same here, much better than the VS tooling for SQL Server, including all the Transact-SQL support.
    - petepete 1y ago
      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/august/tools-of-the-trade-sql-server-profiler-and-query-analyzer https://learn.microsoft.com/en-us/archive/msdn-magazine/2005...
      - tomnipotent 1y ago
        Those features/tools are still part of SSMS today.
        petepete 1y ago
        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.
        codeulike 1y ago
        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
        petepete 1y ago
        Query Analyzer was eventually superseded by SSMS but there was an overlap period IIRC.
- cerved 1y ago
  SSMS is what my nightmares are made of

pier25 1y ago

But it's only for Windows

magicalhippo 1y ago
In my experience, MSSQL shops are far more likely to be using Windows already than PGSQL shops, so that's just yet another reason for why PGSQL was a good first choice for a VSCode plugin IMHO.

v5o 1y ago

[dead]

AdrianB1 1y ago

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.

codeulike 1y ago
SSMS is also for Development, I've been using it for that for 20 years
- robertlagrant 1y ago
  Yes, it's good!
- pjmlp 1y ago
  Same here, much better than the VS tooling for SQL Server, including all the Transact-SQL support.
  - petepete 1y ago
    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/august/tools-of-the-trade-sql-server-profiler-and-query-analyzer https://learn.microsoft.com/en-us/archive/msdn-magazine/2005...
    - tomnipotent 1y ago
      Those features/tools are still part of SSMS today.
      - petepete 1y ago
        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.
        codeulike 1y ago
        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
        petepete 1y ago
        Query Analyzer was eventually superseded by SSMS but there was an overlap period IIRC.
cerved 1y ago
SSMS is what my nightmares are made of