Microsoft SQL Server

The first database application taught when I was in school was Microsoft SQL Server. Microsoft SQL Server was used where I first started, so I had the opportunity to improve myself in MySQL. SQL is also used in my current workplace. It is widely used in very large projects due to its smooth operation.

We have a few different DB's in the organization, including: Pervasive, Oracle, Db2, MySQL. Many of them are of limited use for one specific application. These don't really compare to MS SQL server. Oracle is heavy and cumbersome and overkill for smaller apps. Pervasive - at least the older version we're one - isn't a great performer and has it's own problems. None of them integrate as well with .net code when compared to MS SQL. DB2 on System i is quite good once you figure out which packages to use - it's very performant and is almost as easy to use as MS SQL. They all have ongoing costs, but MS SQL still comes out ahead with minimal maintenance and reliable performance.

Microsoft SQL Server is a comprehensive solution as transactional database, data warehouse, analytics, reporting, and ETL. It also integrates with the cloud well (Azure). The ease of use and setup makes this better than Oracle Database because the query syntax is also different for that one, and it's harder to support. MongoDB is great for small applications and mobile apps. If you have limited resources to support and maintain the environment this may not be ideal compared to a managed service or SAAS solution such as Snowflake.

Microsoft SQL Server is one of the fastest RDBMS systems available in the market. Pricing is a bit on the higher side but all the features it provides pretty much justifies it. It can be integrated with a large number of frameworks thus enabling to work on multiple frameworks for your application without much worrying about the backend support or compatibility.

I think both tools are really powerful and close to each other but since I moved to Europe I realized that most of the companies have been using SQL Server which in my opinion means something. The support from Microsoft I also consider a bit better and you can also find more information about SQL Server by yourself.

Microsoft was the original creator of the SQL database, and thus, they still rule the market and drive innovation when it comes to data warehousing systems. It's comparable in price and allows you to retain the structured datasets that you lose when you change to a NoSQL database structure.

[Microsoft] SQL Server has a much better community and professional support and is overall just a more reliable system with Microsoft behind it. I've used MySQL in the past and SQL Server has just become more comfortable for me and is my go to RDBMS.

Microsoft SQL Server and Oracle are both extremely powerful and scalable enterprise relational database platforms. Microsoft SQL sets itself apart with its ease of use and licensing and support model. Microsoft is good company to work with and they provide clear and predictable licensing terms. Oracle is difficult to work with, they use vague licensing terms and you're always waiting for the next audit.

MS SQL Server is easier to use compared to other RDBMS which really speeds up development time and relatively easier to find a problem when it happens as well. It's also pretty quick to run a query, especially in a large table make it pretty convenient if we need to monitor the whole data in a table.

It just boils down to why learn anther product when you are going to run across it so seldom. Developers determine what database engine I am going to need so I just tend to pick products for implementation that use a well know product that has lots of support resources available.

The most known and widely used competitor of Microsoft SQL is most probably the open-source MySQL. If given the choice I would personally choose MySQL over Microsoft's SQL Server, mainly because it is totally free and open source, but also because it integrates better with Linux in my opinion. While feature wise I don't see any big difference.

Microsoft SQL Server was our first choice as we are a Microsoft partner.

[Microsoft SQL Server] offers a full solution, Inhouse Applications and hosted application continue to use SQL as backend database. Allows easy creation of development environments and continuous feature release.

We stopped looking at alternatives to Microsoft SQL Server a long time ago simply because it meant only having one DBMS that we needed to learn and to support. If we were to implement other database solutions that don't run on SQL Server, we would have to spend more time moving data around to make it easily reportable.

All of the platforms have their own benefit. I was not the decision maker in selecting Microsoft SQL Server, as it was already being utilized when I joined the company, 7 years ago. I can say that I feel more comfortable with utilizing this platform as opposed to the other ones.

The free version is very powerfull and easy to install and use for small companies.
Going to Professional and Standard, gives you all the support and the flexibility needed. It is known within the Database Administrator crew, and you can get support very easily over the internet from daily users, dealing with real time production roles.

We use both Oracle and Microsoft SQL Server for our entire product line, using the best features of each of them to solve different business requirements and technical challenges. Microsoft SQL Server is simpler to install and use, but lacks some advanced features and has fewer configuration options than Oracle, so we use each of them based on each module requirements.

On this one, I cannot fairly comment as I was not involved in the original decision making behind choosing SQL Server. I am aware that MySQL was a contender, and as mentioned I have some experience but not vast. I am pleased that we didn't go with MySQL at least as I think that SQL Server is overall more powerful and more robust a product, but it is expensive in comparison.

SOL Sever is less expensive than any edition of Oracle database.

Native to Windows and being required for other MS apps puts it above others in terms of usage. If we were not heavily dependent on Microsoft applications or OS, we might have considered other database solutions. It's an expensive solutions but it is a solid reliable solution. Ultimately having a SQL server is a must in any Windows based environment.

I was not too impressed with Oracle. Following the manual prohibited installation. They did provide a phone number and explained the manual was wrong and provided me with the correct information with which I was able to install the product. This was awhile back and I do not know how it works currently.

Microsoft SQL Server is still the industry standard for the type of development we do, and the types of applications that we use. Almost every developer or analyst we hire has at least a reasonable grounding in the use of SQL servers, and it is almost universally compatible with most business tools and apps.

I have not used any other product similar to Microsoft SQL Server

Oracle DB and SQL Server are very much alike. They provide the same quality of service and applications. The difference is only the price and support from them. Development codes and almost similar and can be used either way, which is very favorable for users. They can adopt to other Database with the knowledge of the other. Database Queries wise, they are almost identical. Very useful if your company has both services.