3 ms·
I use MS-SQL for my day job, and Postgres for personal projects. Pros of MS-SQL are mainly 1) easy integration with the universe of Microsoft dev tools, framewo
by mr_overalls 7y ago
I use MS-SQL for my day job, and Postgres for personal projects. Pros of MS-SQL are mainly 1) easy integration with the universe of Microsoft dev tools, frameworks, and infrastructure, and 2) great database tooling in itself:
* SSMS - SQL Server Management Studio
* The MS BI stack: SSRS (reporting), SSAS (analysis), SSIS (integration)
- wongarsu 7y agoThe tooling is indeed sweet, and in a big company I could see it paying for itself in saved dev time.
- h1d 7y agoSounds like a victim of vendor lock in. I assume you will bleed hard to get out of it.
- mr_overalls 7y agoHow is this any different from the sunk cost that's a consequence of going with _any_ particular technology stack? I mean, if you chose Python/Postgres/etc., presumably, you'd have to rewrite/retool everything if you went to a different stack. If you're talking about open vs closed source: the C# compiler (Roslyn) is completely free and open source, as are a number of .NET components: CoreFX - Core foundational libraries, CoreCLR - runtime. As well as PowerShell, VS Code, Typescript, ASP.NET Core, MVC, Blazor, F#, Z3 Theorem Prover, etc. And that's from just the first few pages of their Open Source page: https://opensource.microsoft.com/ https://opensource.microsoft.com/