4 ms·
> Also curious, what made you decide not to use PostgreSQL (or EnterpriseDB if you need entreprise solution)? Keep in mind that MSSQL enterprise comes with a l
by matwood 8y ago
> Also curious, what made you decide not to use PostgreSQL (or EnterpriseDB if you need entreprise solution)?
Keep in mind that MSSQL enterprise comes with a lot of tools beyond just a RDBMS. That was always the hangup when I have tried to move companies from MSSQL to something like PG.
- pdimitar 8y agoCan you give example of several useful tools in the MSSQL garden?
- matwood 8y agoSure. Two of the main ones I used were MSSQL Analysis Services and Integration Services. I built and managed a data warehouse/internal reporting system for a fairly large telecom. I used ~100 ETL packages built in SSIS to pull in data from systems all over the company, SSAS to process the data and SSRS to build reports. It worked pretty well at the time 10+ years ago.