Microsoft SQL Server

1) We had a set-up where the ERP application and the servers were in-house and Microsoft SQL Server is perfect to query the data and troubleshoot the error reported by user. 2) The Microsoft SQL Server is taught to students from high school and this is like a baseline for students from IT. So it makes it easy to use at organization level since individual had already gained lot of experience in querying in previous projects at college level or otherwise. 3) In case of Cloud architecture, there is stiff competition and every software enterprise need to re-version itself for betterment. Otherwise, its- no less than any product out there.

Microsoft SQL is ubiquitous, while MySQL runs under the hood all over the place. Microsoft SQL is the platform taught in colleges and certification courses and is the one most likely to be used by businesses because it is backed by Microsoft. Its interface is friendly (well, as pleasant as SQL can be) and has been used by so many for so long that resources are freely available if you encounter any issues.

Support for any data set that has relational or repetitive data is a good place for Microsoft SQL Server. It scales well and has the instructions to do almost anything you need it to do. It is also extremely scriptable.

Microsoft SQL Server is ideal for highly available SQL workloads by using SQL Server Always On availability groups. Microsoft SQL Server might not be appropriate for solutions which require a very low resource footprint, since it requires significant CPU cores and RAM memory as well as high IOPS, always depending on the usage scenario.

MSSQL Server is excellent for most organizations that have database needs. Typically businesses will be either a "Microsoft" or "Oracle" shop and it tends to boil down to the software used, as many require SQL Server to begin with. In my experience mostly small to medium sized business use MSSQL Server. For ETL, I find SQL Server the way to go as SSIS is better than Informatica, but that's my opinion.