11 ms·
Honest question as I have never worked with MS-SQL: in which use-cases would it be a better fit than PostgreSQL?
by sfilargi 10y ago
Honest question as I have never worked with MS-SQL: in which use-cases would it be a better fit than PostgreSQL?
- danzig13 10y agoNot sure if this is a great answer, but many COTS solutions have chosen it as the only DBMS they support for one thing. Also, purchasing SQL Server does not just get you a DBMS, but several serviceable business intelligence tools. SQL Server integration, analysis and reporting services. Analysis services allows users to look at data in various ways and is integrated with everyday MS tools like Excel so to me that in particular seems like a unique offering. I do not know about scaling issues and all that, because I deal with a small deployment for an internally used ERP system. Edit: I would also say I'm stuck in SQL Server 2008 land. The reporting in 2016 looks amazing.
- combatentropy 10y agoI mainly work with PostgreSQL but have had to write some web applications that use Microsoft SQL, because it was already in place. I see no benefit to Microsoft SQL. Instead it is more limited than PostgreSQL and 100 times harder to work with. Indeed, it is analogous to asking why do businesses use Microsoft Internet Explorer instead of Firefox, or Microsoft Windows instead of Linux? I expect that the answer is the same for all three.