r/programming • u/squareproton • 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
r/programming • u/squareproton • Nov 16 '14
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).