Hacker News new | ask | show | jobs
by wvbdmp 459 days ago
* Express is free and will take you a very long way.

* SSMS is great.

* T-SQL is great.

* Integration with .Net is great.

* It’s cross platform (I’ve only ever done Windows though).

* Windows auth is pretty sweet, no passwords in your configs/repos.

* It Just Works™ for real. You can have multiple instances on the same system, different versions and editions, and never worry about anything. Backup and restore are a breeze. Installation, uninstall, updates and upgrades are a breeze. Everything is a breeze. It’s unbelievable how little you need to worry about MSSQL instances.

1 comments

> It’s cross platform (I’ve only ever done Windows though).

I've tried it on Linux and simply couldn't get it working. The Microsoft package manager repos are out of date or contain buggier versions of the software. I wanted all the other benefits you've listed, but ultimately Postgres has been easier for me.