r/programming • • Nov 16 '14

PostgreSQL vs. MS SQL Server - A comparison of two relational databases from the point of view of a data analyst

http://www.pg-versus-ms.com/
171 Upvotes

321 comments sorted by

View all comments

Show parent comments

2

u/[deleted] Nov 17 '14

Have you used SQL Server in the past decade? It's had intellisense in SSMS since 2008 R2 (admittedly it was pretty rough there, but it has steadily improved with each version). That being said, I'd argue RedGate's SQL Prompt is a must if you're going to do a lot of development in SQL Server - it has really good statement completion, let's you define autocomplete code snippets, code formatting, etc.

One thing I really like about SSMS is the plugin system - got something you want to do? You can just write a plug in for it to automate it (for instance, I got tired of having to go into Excel or a text editor to add quotes around lists of items to use in ad-hoc queries, so I wrote an add-in that lets me select the list and with a key shortcut automatically adds single quotes and comma separates any list (line delimited).

1

u/Eirenarch Nov 17 '14

I have used it a lot. If someone told me to use an IDE on this level for C# I would laugh at them for hours in any given year