3 ms·
As someone who has a decade of professional postgres experience (and built my company on it), and 6 years of SqlServer experience, I couldn't agree more with y
by Tostino 2y ago
As someone who has a decade of professional postgres experience (and built my company on it), and 6 years of SqlServer experience, I couldn't agree more with your comment. I really, really like the TDS wire protocol and what it enables.
I also really miss their query optimizer. It was just so damn smart.
- chasil 2y agoI've only done it once, but doing an "rpm -Uvh" on the SQL Server binaries in Linux, then starting up the database did an immediate upgrade of the database files. Oracle's DBUA is so much more painful.
- whartung 2y agoI'm sorry, not to quibble about the quality of the TDS protocol, but what does it have to do with the upgradability of SqlServer?
- Tostino 2y agoNothing, they're unrelated. However, I agree with OP that SQL Server does have a solid upgrade story and it's generally pain free. They are just two aspects I really wish Postgres could do better on, and I miss working with those parts of SQL Server.