--- title: Microsoft SQL Server Reviews meta_title: 'Microsoft SQL Server Reviews 2026: Details, Pricing, & Features | G2' meta_description: Filter 2284 reviews by the users' company size, role or industry to find out how Microsoft SQL Server works for a business like yours. aggregate_rating: rating_value: 4.4 review_count: 2284 scale: '5' date_modified: '2026-07-17' parent_category: name: Database Software url: https://www.g2.com/categories/database-software --- # Microsoft SQL Server Reviews **Vendor:** Microsoft **Category:** [Relational Databases](https://www.g2.com/categories/relational-databases) **Average Rating:** 4.4/5.0 **Total Reviews:** 2,284 ## About Microsoft SQL Server SQL Server 2017 brings the power of SQL Server to Windows, Linux and Docker containers for the first time ever, enabling developers to build intelligent applications using their preferred language and environment. Experience industry-leading performance, rest assured with innovative security features, transform your business with AI built-in, and deliver insights wherever your users are with mobile BI. ## Microsoft SQL Server Pros & Cons **What users like:** - Users appreciate the **ease of use** of Microsoft SQL Server, enjoying its intuitive GUI and powerful capabilities. (32 reviews) - Users appreciate the **robust database management** of Microsoft SQL Server, enabling effective data handling and user administration. (29 reviews) - Users value the **exceptional performance** of Microsoft SQL Server, noting its powerful capabilities and ease of use. (25 reviews) - Users appreciate the **enterprise-grade security and powerful features** of Microsoft SQL Server, enhancing peace of mind and usability. (23 reviews) - Users appreciate the **easy integrations** of Microsoft SQL Server, enhancing their data management and analytics workflows seamlessly. (22 reviews) - Users love the **seamless integration** of Microsoft SQL Server with other Microsoft products, enhancing productivity significantly. (21 reviews) - Reliability (18 reviews) - Users appreciate the **ease of data management** with Microsoft SQL Server, enjoying its simplicity and flexibility for various applications. (16 reviews) - Setup Ease (13 reviews) - Users appreciate the **incredible efficiency** of Microsoft SQL Server, making it the go-to standard for database management. (12 reviews) **What users dislike:** - Users find Microsoft SQL Server's **high licensing costs** prohibitive, particularly affecting smaller businesses and startups. (21 reviews) - Users struggle with the **high licensing costs** of Microsoft SQL Server, making it challenging for smaller businesses. (12 reviews) - Users note that the **high licensing costs** of Microsoft SQL Server can be challenging for smaller businesses and projects. (12 reviews) - Users find the **licensing costs to be prohibitively high** , especially for small businesses and projects. (11 reviews) - Users find **performance issues** with SQL Server, particularly regarding tuning, scaling, and resource consumption on older systems. (11 reviews) - Users experience **slow performance** with SQL Server, especially when running alongside other software and during data searches. (11 reviews) - Users find the **user interface complex** and not intuitive, leading to a steeper learning curve for newcomers. (8 reviews) - Difficult Learning (7 reviews) - High Hardware Requirements (7 reviews) - Technical Difficulties (7 reviews) ## Microsoft SQL Server Reviews ### 1. SQL is a good database application, but it can be tricky **Rating:** 4.0/5.0 stars **Reviewed by:** Aaron A. | Network Technician II, Defense & Space, Mid-Market (51-1000 emp.) **Reviewed Date:** October 22, 2019 **What do you like best about Microsoft SQL Server?** SQL is a good database application, but it can be tricky. Scripts and solutions are mostly easy enough to find online. Most things can be figured out without a DBA degree. **What do you dislike about Microsoft SQL Server?** It can run out of space. Sometimes it's hard to figure out what's wrong. If you don't have the right login for the right database, you won't be able to manage it. **What problems is Microsoft SQL Server solving and how is that benefiting you?** Database solutions for VMWare applications, WSUS, and Sharepoint. A standard across the board. ### 2. Easy to set up and comes with many features. **Rating:** 4.0/5.0 stars **Reviewed by:** Giorgi T. | Software Engineer, Telecommunications, Enterprise (> 1000 emp.) **Reviewed Date:** October 18, 2019 **What do you like best about Microsoft SQL Server?** MsSQL has some of the best standart libraries I've ever had the pleasure of working with in a database management tool. It's scripting language - T-SQL is super strong and versatile. **What do you dislike about Microsoft SQL Server?** It takes up a lot of resources and it's hard to get support sometimes. **Recommendations to others considering Microsoft SQL Server:** It's a versatile tool for all your data storage needs. It's also free, so you can give it a try and see for yourself. **What problems is Microsoft SQL Server solving and how is that benefiting you?** MSSQL helps me integrate and consolidate lots of different data sources into a all-encompassing data warehouse. It was easy to set up and MSSQL has had all the tools I needed. It greatly enhanced the revenues of the company and helped sales team earn more profit. ### 3. Great application to store large DB **Rating:** 4.5/5.0 stars **Reviewed by:** vijay s. | Co-Founder & CTO, Computer Software, Small-Business (50 or fewer emp.) **Reviewed Date:** September 22, 2019 **What do you like best about Microsoft SQL Server?** I worked on SQL Server for the last 6 years. I found that SQL Server is the best application for storing the DB with an nth level of data and also it's functionality like SP, Views, Indexes that gives developer to work faster than anything else. It is the best app for Microsoft developer who is working with visual studio. **What do you dislike about Microsoft SQL Server?** I work on SQL Server 2008, 2012 now I am working on 2017 there was a common issue is the intelligence of Table and field name manily new added data. For that, we must restart the application once. **Recommendations to others considering Microsoft SQL Server:** Strongly recommended **What problems is Microsoft SQL Server solving and how is that benefiting you?** I solve many problems with SQL Server but the major problem I solve is inserting the large data in a few seconds like sling slot. ### 4. Big data for big companies **Rating:** 5.0/5.0 stars **Reviewed by:** Osmani D. | Software QA Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** July 31, 2019 **What do you like best about Microsoft SQL Server?** The management studio for this engine is simply complete. It has everything you may need of a database manager. This is the best choice if you are to work with projects that will manage big data from the start or on the future. One of the features that I appreciate more is the diagraming tool. After visually creating your diagrams, you can translate that into your SQL queries to create those tables with their respective relationships. **What do you dislike about Microsoft SQL Server?** This is not your average database engine. It is very heavy, so don't expect that your pc will handle it while playing a game or doing your every day tasks. This engine is awesome but it does take some resources off of your pc. **What problems is Microsoft SQL Server solving and how is that benefiting you?** Besides manual testing, we do need to install the software's database in order for it to work locally, and the management studio is great to review any of the data changes that we do on the app to ensure it is working properly. ### 5. One of the best databases available on the market **Rating:** 5.0/5.0 stars **Reviewed by:** Davit K. | Software Engineer, Information Technology and Services, Enterprise (> 1000 emp.) **Reviewed Date:** September 19, 2019 **What do you like best about Microsoft SQL Server?** I love the functionality it offers. MSSQL comes with a huge bundle of built-in functions which helps with increasing my productivity and enhancing my workflow. It's also quite stable and has an easy syntax which I picked up easily. **What do you dislike about Microsoft SQL Server?** It is a performance hog and without a strong server to run it on, it can really slow down your systems. Also, customer support is quite slow as well. **Recommendations to others considering Microsoft SQL Server:** It's a great multi-purpose DBMS which will give you a lot of features. It's a delight to work with it. I recommend trying MSSQL out. **What problems is Microsoft SQL Server solving and how is that benefiting you?** We use Microsoft SQL as a part of a data warehouse. I have to make sure my app forms interact well with our database. MSSQL makes it easy. ### 6. The best in database **Rating:** 5.0/5.0 stars **Reviewed by:** Christopher R. | Manager Development, Small-Business (50 or fewer emp.) **Reviewed Date:** July 29, 2019 **What do you like best about Microsoft SQL Server?** A fundamental pillar in databases is the security of the information stored there. Usually these are sensitive data that should not be accessed by unknown persons. SQL Server integrates tools that allow data encryption to prevent external attacks or any malware or virus. It also allows to protect the data of registered users for its use, activating the use of alerts in the case of previously established policy violations. **What do you dislike about Microsoft SQL Server?** It uses a lot of RAM for installations and software utilization.It has many page-level locks, a fixed page size and too small, a lousy implementation of variable data types. **Recommendations to others considering Microsoft SQL Server:** Always use a good server with good performance performance. **What problems is Microsoft SQL Server solving and how is that benefiting you?** If we work in a social network it allows us to add other SQL Server servers. For example, two people working with SQL Server, one of them can connect to the server of his other partner and so you can see the databases of the other partner with SQL Server. ### 7. Best enterprise level database for development. **Rating:** 5.0/5.0 stars **Reviewed by:** Joseph L. | Information Technology Manager, Mid-Market (51-1000 emp.) **Reviewed Date:** May 13, 2019 **What do you like best about Microsoft SQL Server?** MS SQL has been around long enough and has enough distribution that there is a tremendous amount of information out there for any situation that you might encounter. If you can ask the correctly you can find the answer. It's relatively tolerant to crashes and can be scaled to any size or cluster configuration needed. Lots of add ons available as well as tools for optimization and troubleshooting. **What do you dislike about Microsoft SQL Server?** Microsoft's pricing has become borderline esoteric in it's level of complexity. SQL is now priced by CORE (not Proc), which can make it very expensive and confusing to license. It also needs proper tuning in order to work well - a small tweak can have huge performance issues. **Recommendations to others considering Microsoft SQL Server:** Consider full price of ownership - you may need a consultant or full time administrator. Don't skimp on the hardware portion - you may need powerful machines to run the implementation - depending on your user load and type of implementation. **What problems is Microsoft SQL Server solving and how is that benefiting you?** We run our ERP system on it and because it's SQL we have been able to customize the system to the level we need. Not a painless process, but it works. Because of the simplicity in connecting outside data I'm able to write connections to our Salesforce CRM to keep the two systems in sync. It's relatively easy to virtualize and run through cloud platforms as well. ### 8. One of the Secured SQL Database **Rating:** 5.0/5.0 stars **Reviewed by:** SOURAV KUMAR D. | Full Stack Developer & RPA Developer, Small-Business (50 or fewer emp.) **Reviewed Date:** February 19, 2020 **What do you like best about Microsoft SQL Server?** The best thing in Microsoft SQL Server is that we can easily process the SQL query. **What do you dislike about Microsoft SQL Server?** The dislike about the SQL Server is gets hanged or stucked. **Recommendations to others considering Microsoft SQL Server:** Useful tool **What problems is Microsoft SQL Server solving and how is that benefiting you?** The benefits of using the SQL Server is that we can easily create, edit, update the data's ### 9. Best DBMS for large and small scale enterprise **Rating:** 5.0/5.0 stars **Reviewed by:** Surender B. | Technical Lead at tecHangouts, Small-Business (50 or fewer emp.) **Reviewed Date:** April 24, 2019 **What do you like best about Microsoft SQL Server?** We are using SQL Server from 2014 and highly impressed with its simplicity and how its growing its capability with every version. server is a great database server with lots of features that are must for small or large scale companies. part is its user interface and simple to use.It is enabling developers to build their logic with intelligent window as well. **What do you dislike about Microsoft SQL Server?** We are not using any training for now as most of the features are free. Thank you Microsoft. I loved this platform. I dislike the only one thing is that licencing is too costly for small companies. **Recommendations to others considering Microsoft SQL Server:** We are very satisfied with software and we recommend it for completely safe and secure DBMS architecture. **What problems is Microsoft SQL Server solving and how is that benefiting you?** We have over 2500 web pages and all have dynamic data and all are running on top of SQL Server . We also run some automatic jobs that SQL server agent is handling with ease. ### 10. Control your server's SQL databases on Windows and Linux operating systems. **Rating:** 4.0/5.0 stars **Reviewed by:** Willie R. | Software Developer, Small-Business (50 or fewer emp.) **Reviewed Date:** November 14, 2019 **What do you like best about Microsoft SQL Server?** Mainly the compatibility with Windows and Linux, my SQL bases control them efficiently with this system, Microsoft SQL generates error reports constantly to be aware of any inconvenience generated by the server. **What do you dislike about Microsoft SQL Server?** I have no problems with this service, everything works great. **Recommendations to others considering Microsoft SQL Server:** Use this program with compatibility of any Linux or Windows operating system, several use of programming languages is compatible for more convenience when working. **What problems is Microsoft SQL Server solving and how is that benefiting you?** With Microsoft SQL I control and modify all my SQL databases from any operating system, this makes my job easier when I change the operating system or PC. ### 11. Good Relational Database Management System **Rating:** 4.0/5.0 stars **Reviewed by:** Ricardo L. | Data Engineering Coordinator, Enterprise (> 1000 emp.) **Reviewed Date:** January 09, 2020 **What do you like best about Microsoft SQL Server?** Good features for query optimization, good performance overall, plenty of documentation available on the internet. **What do you dislike about Microsoft SQL Server?** Some system procedures are undocummented. **What problems is Microsoft SQL Server solving and how is that benefiting you?** Data integration using Integration Services. Data Warehousing, data analytics. ### 12. Good Trusted database - Microsoft SQL **Rating:** 5.0/5.0 stars **Reviewed by:** Smith M. | Software Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** July 24, 2019 **What do you like best about Microsoft SQL Server?** The good feature of this Microsoft SQL is their installation process. We don't need to install the pre dependent software forcefully it automatically gets installed during their update process so it's a quite easy way to install then any other databases. It also provides the facility of auto updation so by doing so their maintenance cost also get decreased then manually updating the whole system. **What do you dislike about Microsoft SQL Server?** Microsoft SQL can be used in a large scale company to a small scale business also so if there is a person who owns a small business then he/she may find it too much complex as it has higher functionality as compared to that business and also it's cost seems to be very high from them. **Recommendations to others considering Microsoft SQL Server:** If a person owns a large company and if he/she had to use the database then Microsoft SQL is the best **What problems is Microsoft SQL Server solving and how is that benefiting you?** The another good feature Microsoft SQL provides is the security which is quite required more in now a days to protect us from many online threat that misuses the data in many ways . It provides only access to a limited authorised person only so there would be no issue of misuse of the data. It also had a feature of encryption also so if a person also knows about the data then it would be in a encrypted format rather then in a simple text format so that it if anyone knows the data then also they would not a able to figure out what's the actual data is ### 13. Best and Secured Database - Microsoft SQL **Rating:** 5.0/5.0 stars **Reviewed by:** Naqeeb S. | Software Engineer , Mid-Market (51-1000 emp.) **Reviewed Date:** July 23, 2019 **What do you like best about Microsoft SQL Server?** The biggest advantage of the Microsoft Sql is their installation process which is quite simple as compared to many other databases servers. This is installed through the setup vizard and the primary things needed for their installation are detected automatically and then installed during this process so don't need to explicit install the dependency. **What do you dislike about Microsoft SQL Server?** The main disadvantage of using the Microsoft Sql is it's price which is very high.The person needs to first buy the license for this database then only then can use and price of license is very much high and in other databases this license is not required for using it so that seems to be the biggest disadvantage of using the Microsoft Sql **Recommendations to others considering Microsoft SQL Server:** If one wants to use the secure database from their company then he/she must use the Microsoft Sql **What problems is Microsoft SQL Server solving and how is that benefiting you?** The another great thing about the Microsoft Sql is it's security purpose. Only the authorised person have the access the database so their is no problem of data being misused or being sent to another person. If any thing is found then he/she can be easily caught because only few have this access and it would be easy for catching the people if they are found guilty for this.The one thing Management needs to keep on a eye is their Virtual Machine Configuration should be quite matchable with the standards setup by the Microsoft Sql then only this will work in a good and efficient way. ### 14. SQL for storage Large amount data **Rating:** 4.5/5.0 stars **Reviewed by:** Hitesh P. | Mr, Small-Business (50 or fewer emp.) **Reviewed Date:** September 19, 2019 **What do you like best about Microsoft SQL Server?** SQL database have too good speed. It has a large database storage. SQL provides SQL corn job, Store procedure, Scheduling for create the report in shows data as per requirements. Data security is great. **What do you dislike about Microsoft SQL Server?** It's Installation process long and complex. Database backup can not restore if SQL version different. **What problems is Microsoft SQL Server solving and how is that benefiting you?** My client need to the web page speed issue at that time I used the SQL store procedure and it's resolved. Also I can manage more report with different parameter in single table. ### 15. Your solid database solution **Rating:** 4.5/5.0 stars **Reviewed by:** Taveras P. | Software Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** July 17, 2019 **What do you like best about Microsoft SQL Server?** When you're working with MS SQL on its management studio, you do have this enterprise feeling, which is great because it gives you a secure notion that it sure is a solid solution. I use it every day at my job and we have a nice development workflow using the solution explorer that keeps your queries organized and neat. **What do you dislike about Microsoft SQL Server?** It is heavy. Be ready for that. You do need a development machine for this, not a personal laptop. Maybe your personal desktop PC is properly equipped, but I do not recommend having this on a low spec machine because you will feel a performance hit. **What problems is Microsoft SQL Server solving and how is that benefiting you?** For the type of application that we are developing on my job, we do need an engine that can work with big data, and MS SQL has proven to be a good fit. It works great, but you do need to optimize the way you work with the data, because if you don't, it will fail like any other engine. But with MS SQL optimized for performance, you'll love it. ### 16. Microsoft SQL Server EXPRESS **Rating:** 5.0/5.0 stars **Reviewed by:** Tom H. | Developer, Computer Software, Small-Business (50 or fewer emp.) **Reviewed Date:** July 16, 2019 **What do you like best about Microsoft SQL Server?** As a user of the Express edition, the best feature of Microsoft SQL Server lays in my ability to scale up if needed. There are so many free SQL Servers, but the benefit of this offering is the flexibility to move between servers and even scale up by pushing the server to Azure SQL, or an Azure VM. There are more options available to me with Microsoft's SQL Server. **What do you dislike about Microsoft SQL Server?** One downside to the express edition I use is the restrictions that are put in place for memory and CPU usage. In some cases, this benefits me in that I don't want to be hosting my database on a super computer, but under a heavy load I know my free version will not hold up. However, looking back at the positives, I can easily scale up! **Recommendations to others considering Microsoft SQL Server:** Unless you need one of the features of the more advanced versions, start with SQL Server Express, and upgrade if needed. I have been working with Express for my small sites for years, and using the paid versions at work, there are no noticeable differences. **What problems is Microsoft SQL Server solving and how is that benefiting you?** Microsoft SQL gives me peace of mind because I can develop my entire application at a low level (with low cost!) and then scale up when I hit production IF NEEDED. ### 17. my experience with sql server has been very good and productive **Rating:** 3.5/5.0 stars **Reviewed by:** jose b. | Mechatronic Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** May 01, 2019 **What do you like best about Microsoft SQL Server?** One of the things we like most about sql server is being able to work in client-server mode, which allows the information and data to be hosted on the server and for clients or network terminals to only access the information. Also, thanks to the fact that it is a tool that has been on the market for many years, it offers a powerful graphical administration environment, giving us a tool to perform ddl and dml commands graphically. It is very stable and secure and has a good community around it. **What do you dislike about Microsoft SQL Server?** What to my point of view I see more unfavorable of this database tool is its high use of RAM memory in the use of the software, also for this reason it becomes slow at the time of installation if you do not have adequate resources. Also its price taking into account its competitors makes it a more expensive solution. **Recommendations to others considering Microsoft SQL Server:** What I would recommend to other users is that if you want to implement a robust and reliable database and have a good team and the budget is not a problem, do not hesitate to use sql server **What problems is Microsoft SQL Server solving and how is that benefiting you?** The project in which we implemented this database manager was the migration of some data from Oracle database and its interface to create ddl and dml commands in a graphical way and the ease of use allowed us to reduce considerably the time of execution of the migration. ### 18. Best Database server for Microsoft technologies like DotNet, MVC,and Webservices etc **Rating:** 5.0/5.0 stars **Reviewed by:** DILEEP P. | Dileep Prajapat, Mid-Market (51-1000 emp.) **Reviewed Date:** April 30, 2019 **What do you like best about Microsoft SQL Server?** SQL Server is best database server to working with microsoft technologies like MVC, Dotnet, WCF and etc. It Is provide the verious functionalities like create database and tables to create stored procedure, functions and views etc. It is also provide SSRS and SSIS features. **What do you dislike about Microsoft SQL Server?** Microsoft SQL Server is made to support millions of records across an enterprise. Because of its robust technology, it also comes with a high price. Users also need to learn different language to setup microsoft sql environment. SQL Server requires the .NET framework installed on a machine, which is a separate component used by developers. **Recommendations to others considering Microsoft SQL Server:** I recommend SQL server to all the programmers who are working on microsoft technologies like DotNet, WCF, MVC and Webservices and wherever they need to interact with database. It provide various functionality to working with data. It provide the better security of data also. **What problems is Microsoft SQL Server solving and how is that benefiting you?** I almost use sql server in all my project and it is very easy to use for the programmers. it help us to manage large amount of data in a normalized manner. it help us to create reports easily using SSRS tool. ### 19. A decent RDBMS system for general use **Rating:** 4.0/5.0 stars **Reviewed by:** Giorgi K. | Data Analyst, Enterprise (> 1000 emp.) **Reviewed Date:** July 14, 2019 **What do you like best about Microsoft SQL Server?** SQL Sever supports multiple users in one setup which make it a multi-user system. SQL Profiler tracks the background queries and helps with the debugging and management of SQL queries. Moreover, by analyzing estimated and actual test plans, it helps to make queries more optimized. **What do you dislike about Microsoft SQL Server?** In terms of resource utilization, there is room for improvement for SQL Server, so that it can cost less CPU usage. Also, there are lot of third party services like SQL Search and SQL Code Guard. Why is there a need for these if SQL itself can implement these necessary functionalities inbuilt? **Recommendations to others considering Microsoft SQL Server:** MS SQL is well suited for every organization using databases at the back-end to store data. This has been improving every year and addressing the need of growing data. It is a very consistent and reliable tool. Very easy to import and export data to external tools like Excel and other files. Easy to bulk copy data from tables to files and from files to tables. **What problems is Microsoft SQL Server solving and how is that benefiting you?** We use it to train interns and do classes about databases and SQL. ### 20. Good solid platform for SQL/ T- SQL **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Government Administration | Enterprise (> 1000 emp.) **Reviewed Date:** September 24, 2019 **What do you like best about Microsoft SQL Server?** add on tools with export and ease of creation of views and queries (i.e intellisense). The product is able to be used to many connection and the security with windows and SQL server authentication is useful. **What do you dislike about Microsoft SQL Server?** date format syntax should be more flexible and types of date and character manipulation should be much easier to figure out. I also feel that there must be some features to allow macro recordings and automation for jobs and /or functions ans procedures. **Recommendations to others considering Microsoft SQL Server:** more intuitive interface is desired with quick response time for non-large size databases. Also a form generator is desired to work with data and create easy to use form and easy methodology to create access-like interface and reports from within the same platform. **What problems is Microsoft SQL Server solving and how is that benefiting you?** I use the SQL platform to create adhoc queries and ETL to load data to 3rd party and to create views that can be used for data evaluations and reporting within my organization and to others outside the department. ### 21. An Easy Database Experience **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** September 24, 2019 **What do you like best about Microsoft SQL Server?** Microsoft SQL is an extremely easy-to-use database that it simple to learn for even people with non-technical backgrounds. It is a good way to manage databases as it is something that can be easy to take on for the simplest of beginners, and it is easily integratable with other softwares. Most consultants I know have been able to pick up SQL in less than 3 months. **What do you dislike about Microsoft SQL Server?** It can feel a little less "sexy" that some other database softwares at times. The ease of use and accessibility however make up for what it lacks in design. I think oftentimes companies tend to rely on the use of it too much as well when some more advanced activities in other coding languages can be combined with Microsoft SQL. **Recommendations to others considering Microsoft SQL Server:** I think, if your organization is in need of a database software, Microsoft SQL is the way to go. The integration with all of Microsoft's partner products as well as Microsoft's own products (should your organization also use those) is well-worth it. **What problems is Microsoft SQL Server solving and how is that benefiting you?** Microsoft SQL is an integratable business solution, meaning you can just use it on its own, but you can also combine it with other softwares. UiPath and Automation Anywhere both have these database integration capabilities, which is super helpful when multiple softwares must be used to solve a problem. ### 22. A Good Enterprise Transactional Database With Support For Replication And Clustering **Rating:** 4.0/5.0 stars **Reviewed by:** Nitin Kumar S. | Cloud Architect, Mid-Market (51-1000 emp.) **Reviewed Date:** July 06, 2019 **What do you like best about Microsoft SQL Server?** It is one the very few databases which gives continuous performance even though the data size is increase beyond 1TB. It supports Always on Clustering in Its Enterprise edition which gives flexibility to shard your database and with no downtime and it service is uniform across multiple platforms i.e on-premise and cloud. **What do you dislike about Microsoft SQL Server?** This database is not suitable for running analytical queries as well as aggregations. The results for queries like rank and partitioning over a field takes a lot of time. **Recommendations to others considering Microsoft SQL Server:** Customer need to be careful of which license to buy i.e it offers multiple licenses with different feature set and prices also vary with the same. Hence customers has to be careful before purchasing i.e what features that they are going to use and in which category it will fall into i.e Express, Standard or Enterprise license. **What problems is Microsoft SQL Server solving and how is that benefiting you?** This solution replaces a older Oracle Transaction Database and Time to Query and Uptime of this database was better with better performance as compared to old legacy system with less overhead to manage. ### 23. Best Database server I have ever worked with **Rating:** 5.0/5.0 stars **Reviewed by:** Anuj S. | Data Engineer, Computer Software, Enterprise (> 1000 emp.) **Reviewed Date:** July 05, 2019 **What do you like best about Microsoft SQL Server?** • Just like other Microsoft products; SQL Server is by far the most User-friendly Database Server - best IDE • Lots of wizard features from import, export, backup, query builder etc that anyone can easily learn and do just with few clicks! • Built-in execution plan viewer which is nice enough to start with. • Intellisense (like visual studio) to complete code while typing and showing common mistakes before you even execute • Integrates very well with other MS products. Full MS BI stack includes SSIS ETL, SSRS BI Tool, SSAS etc. • Free Plugins and third-party tools available to make your life even easier like: Poorman SQL Formatter, SentryOne Plan Explorer etc **What do you dislike about Microsoft SQL Server?** • No considerable cons. Maybe Microsoft should consider offering built-in features/tools for which developers use third-party tools and plugins. Like builtin execution plan viewer is not as great as SentryOne Plan Explorer. • With so many built-in features one little must have to include is One click code indentation. Until Microsoft can add this feature, we can live with Poorman SQL formatter. **Recommendations to others considering Microsoft SQL Server:** Highly recommended - The Best RDBMS Package I have worked so far. **What problems is Microsoft SQL Server solving and how is that benefiting you?** Reporting and Analytics services for Data driven companies + Backend Database for web applications ### 24. a good database management system for developers **Rating:** 3.0/5.0 stars **Reviewed by:** prabodha m. | Developer, Small-Business (50 or fewer emp.) **Reviewed Date:** November 10, 2019 **What do you like best about Microsoft SQL Server?** it is easy to integrate with microsoft services like .Net and visual studio. moreover it can be easily integrated with C# applications **What do you dislike about Microsoft SQL Server?** It is basically a SQL based relational database system. so we cannot do stuffs which use NoSQL. and real time processing with a software is also difficult **Recommendations to others considering Microsoft SQL Server:** I would recommend microsoft SQL for the developers who use microsoft services mostly **What problems is Microsoft SQL Server solving and how is that benefiting you?** When using microsoft services it is difficult to use other data base management systems. so MSSQL is the best database management system to use . ### 25. One of the greatest databases I've used **Rating:** 4.0/5.0 stars **Reviewed by:** Demetre B. | Network Specialist, Telecommunications, Enterprise (> 1000 emp.) **Reviewed Date:** August 12, 2019 **What do you like best about Microsoft SQL Server?** I enjoy the packed toolkit it provides. T-SQL is also a very powerful scripting language which comes with Microsoft SQL and is a delight to use. SQL Profiler helps me keep track of database modifications and plan my actions accordingly. **What do you dislike about Microsoft SQL Server?** I don't like its query optimizer. Sometimes it messes up the execution plans and what should have been a simple query can hang the server. It happens very rarely, though, so, it's fine. **Recommendations to others considering Microsoft SQL Server:** It's a great multipurpose database and it wont hit your wallet too much. I recommend using it. **What problems is Microsoft SQL Server solving and how is that benefiting you?** I used MSSQL to set up a data warehouse for a major telecommunication company. It is stable, has great support and easy to learn for beginners. Comes with a lot of useful tools, so you don't have to reinvent the wheel. ### 26. Enterprise database engine **Rating:** 5.0/5.0 stars **Reviewed by:** Alex U. | QA Analyst, Enterprise (> 1000 emp.) **Reviewed Date:** July 31, 2019 **What do you like best about Microsoft SQL Server?** SQL Server is probably the most used database engine for big data projects. It has a free version which is the express version, though only use it for personal projects, because it is meant for that. The management studio is great, you can schedule SQL jobs, create diagrams, manage execution plans, you name it. **What do you dislike about Microsoft SQL Server?** It is very heavy. This engine is meant for production projects. So if you're thinking of having it installed on your PC, try to count on a very powerfull PC if you don't want it eating some of your resources. **What problems is Microsoft SQL Server solving and how is that benefiting you?** For a project like the one we are doing at my job, the table indexes are the key (no pun intended). It is a big project and the client is focused on performance, so it is a must on our project! ### 27. the best database manager for projects **Rating:** 5.0/5.0 stars **Reviewed by:** norberto b. | ing norberto, Small-Business (50 or fewer emp.) **Reviewed Date:** April 15, 2019 **What do you like best about Microsoft SQL Server?** It is a quite complex and complete database manager, it is robust and can store a large amount of data and records, it is compatible with windows application projects with visual basic and php web projects, it has a high level of security for databases. data and access to information, also has help assistants for the elaboration of queries between related tables and is able to perform stored procedures that is very important for large projects as this allows the generation of reports. **What do you dislike about Microsoft SQL Server?** It is very complex and difficult to install since you have to configure a variety of servers and tools so that it can work properly, besides that the consumption of hardware in the equipment that is installed is high margin, so it can not be installed in a basic features such as access and mysql, and the configuration for use must be done by a trained staff in the area which also limits its use to basic users, and if the software is not connected, work on it in a intuitive it can turn out to be very long and complicated **Recommendations to others considering Microsoft SQL Server:** It is highly recommended to work on a large scale it is very safe and reliable but it is recommended to be well advised for the installation and configuration of this software since it is not easy to do **What problems is Microsoft SQL Server solving and how is that benefiting you?** It is very good software and I use it frequently in the development of the most important administrative systems since it has a high data storage capacity and a high level of security, I have used it for the development of the company's inventory system since It has programming elements that are coupled to the system's needs such as the elaboration of stored procedures for the generation of reports and reports and also queries of tables at a high level of response to be displayed on the forms. ### 28. Best for the data base mangement **Rating:** 4.5/5.0 stars **Reviewed by:** Jithma S. | Internship Trainee, Mid-Market (51-1000 emp.) **Reviewed Date:** November 02, 2019 **What do you like best about Microsoft SQL Server?** Easy to use beacuse it has many functions to save our time. You can use it as both graphical user intreface and coded user interface. I like it because it is the easiest software to use. **What do you dislike about Microsoft SQL Server?** When it comes to scalability this software is not the best. Also it is kinda large software so it will lag your computer . **Recommendations to others considering Microsoft SQL Server:** Best for the data base management **What problems is Microsoft SQL Server solving and how is that benefiting you?** I have used it for a stock management softeare and I had benefits because it is a best method for gather data ### 29. Very Good Database software **Rating:** 4.0/5.0 stars **Reviewed by:** Prerana B. | Sr.Consultant, Enterprise (> 1000 emp.) **Reviewed Date:** June 27, 2019 **What do you like best about Microsoft SQL Server?** I am working from SQL server 2008 versions onwards and observed that the tool is improving a lot. I used the versions 2008,2012 and now using 2016 version. I am also user of SSRS and SSIS in SQL Server.They are very good tools and used by many clients.I like the intuitiveness in the usage. It is very easy to use. Management studio is easy to use. I like management studio to work with. Also I like the SSRS and SSIS very much.ETL is easy with SSIS it shows the flow of different tasks. Allot the reporting tools have SQL server driver connectivity which is great. Dynamic Data masking is very helpful feature in 2016 version. Also Always Encrypted feature is very good to be used. **What do you dislike about Microsoft SQL Server?** The tool needs improvement a lot. As compared to other tools the improvement needs to be there in the tools.The security part need to improved. Also the performance needs to be improved.There are so many databases and ETL tools in the market, SQL server should be able to compete with them to provide more and more usability features for the clients / users. **Recommendations to others considering Microsoft SQL Server:** Great software to use as DB / Reporting and ETL complete suite is available. I would recommend it to other users too. **What problems is Microsoft SQL Server solving and how is that benefiting you?** We are using Microsoft SQL as backend for our reporting tool. We are storing the data. Also we are suing SSRS and SSIS for reporting and ETL processes. It is pretty good and consistent tool.Client is happy with software. ### 30. Microsoft SQL **Rating:** 4.5/5.0 stars **Reviewed by:** Teresa P. | Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** October 18, 2019 **What do you like best about Microsoft SQL Server?** It is fast, easy to use, intuitive, ideal for creating relationships between tables, massive searches of records, data details, is now available with recent updates for operating systems, Gnu linux **What do you dislike about Microsoft SQL Server?** I have no complaints about microsoft sql, it is the best there is, it also has features that surpass the other database drivers **Recommendations to others considering Microsoft SQL Server:** Request trial versions for the verification of the tool, but it is the best in terms of database management, I recommend them **What problems is Microsoft SQL Server solving and how is that benefiting you?** Perform work in client-server mode, administration through ddl commands, integration with other tools developed by microsoft such as azure ### 31. TSQL the sql used for Sqlserver-programming **Rating:** 5.0/5.0 stars **Reviewed by:** Michel S. | Datawarehouse Architect/Developer, Enterprise (> 1000 emp.) **Reviewed Date:** September 03, 2019 **What do you like best about Microsoft SQL Server?** I like the fact that TSQL has a lot of windows functions that for instance PLSQL does not has. **What do you dislike about Microsoft SQL Server?** TSQL can only be used with sqlserver databases. Would be nice if it would be adopted by more database engines. **Recommendations to others considering Microsoft SQL Server:** this is the future of a market leader in database software for enterprise companies **What problems is Microsoft SQL Server solving and how is that benefiting you?** I build datawarehouses in TSQL. It is fast and efficient. There is also a lot of demand on the job market for this skill. ### 32. SQL use for automations **Rating:** 5.0/5.0 stars **Reviewed by:** Trinity A. | Database Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** September 19, 2019 **What do you like best about Microsoft SQL Server?** Microsoft SQL Server can be integrated with Automation Anywhere, to develop automation contents. Also can utilize SQL Server for its Microsoft support and native Automation Anywhere functions that allow us to work with this Database. **What do you dislike about Microsoft SQL Server?** Nothing to say bad, licensing cost is little bit high. **What problems is Microsoft SQL Server solving and how is that benefiting you?** Microsoft SQL allows the developer to use a managed programming language, such as C# or VB.NET, to define queries, rather than using SQL statements. ### 33. Microsoft SQL **Rating:** 5.0/5.0 stars **Reviewed by:** Carlo L. | Implementation Specialist, Small-Business (50 or fewer emp.) **Reviewed Date:** October 03, 2019 **What do you like best about Microsoft SQL Server?** I have been using SQL for over 10 years and I love it. It's a very secure database management system and easy to use! **What do you dislike about Microsoft SQL Server?** SQL uses a large amount of system resources so the systems I run it on have to be more solid to be able to handle the workload. **What problems is Microsoft SQL Server solving and how is that benefiting you?** My company uses SQL for our software application back end. ### 34. Best Database system I've used **Rating:** 4.5/5.0 stars **Reviewed by:** Thidasa Pankaja P. | Senior Software Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** August 17, 2019 **What do you like best about Microsoft SQL Server?** MS SQL provides the SQL management studio which helps easy to write and integrate SQL database and SQL queries. It has almost all the features which a database management studio should have. So, I think it's the best database system out there. **What do you dislike about Microsoft SQL Server?** On the first startup, it asks for username and password all time even though I've set it as 'Remember me'. Tried to fix that (let it start with saved username and password) but couldn't figure it out. That's the only issue I'm having with it. Other than that I haven't had any issue when using MS SQL. **What problems is Microsoft SQL Server solving and how is that benefiting you?** I use Microsoft SQL as it's the database system which is used by our company. I use it for writing SQL queries. ### 35. A quick Database server for all CRUD operations **Rating:** 4.5/5.0 stars **Reviewed by:** Shubam K. | Project Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** June 04, 2019 **What do you like best about Microsoft SQL Server?** Microsoft SQL is one of the most reliable software for all the database operations. The best feature of it is the object explorer, where all the master tables, stored procedures are detailed properly. While coding in C#, it's the best database server, as there are multiple .Net framework related functionalities inbuilt in it. **What do you dislike about Microsoft SQL Server?** The graphical user interface of Microsoft SQL could be improved in certain aspects. Though, its getting updates regularly, which improves various backend functionalities but the Interface can be improved which can make the processing smoother. **Recommendations to others considering Microsoft SQL Server:** Interface can be improved to make it more usable and easy for the user. **What problems is Microsoft SQL Server solving and how is that benefiting you?** I use it for various daily create, read, update and delete (CRUD) operations that I use in coding. ### 36. Best Tool for Database **Rating:** 5.0/5.0 stars **Reviewed by:** mohan r. | Software Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** January 10, 2020 **What do you like best about Microsoft SQL Server?** Easily learn learn the database side. dont have lot of experience any one can learn easily. **What do you dislike about Microsoft SQL Server?** once user login passwort is forgot. complicate to change that one. **Recommendations to others considering Microsoft SQL Server:** This the basic for learing the database side. Query are so simple. Anyone can easily learn. **What problems is Microsoft SQL Server solving and how is that benefiting you?** Data correction at database side ### 37. my overall experience with sql server **Rating:** 4.5/5.0 stars **Reviewed by:** manikumar A. | Software Developer, Small-Business (50 or fewer emp.) **Reviewed Date:** October 23, 2019 **What do you like best about Microsoft SQL Server?** Easy to use, we can very easily write complex queries and stored procedures and in sql server,we can easy to take backup and easy to restore the DB and also performing the joins and all are easy. **What do you dislike about Microsoft SQL Server?** As of my experience, I didn't face many issues but installation will take more time for beginners.installation may confuse and rollback and commit options are not there when compared with other DBS. **What problems is Microsoft SQL Server solving and how is that benefiting you?** I have been used the Microsoft sql server to store and manage the data for web applications ### 38. Microsoft SQL Server always at the top of the egde. **Rating:** 5.0/5.0 stars **Reviewed by:** Victor A. | IT Manager, Information Technology and Services, Enterprise (> 1000 emp.) **Reviewed Date:** June 13, 2019 **What do you like best about Microsoft SQL Server?** I like the best the way you can integrate different solutions and build hybrid database instances with all the tools that Microsoft SQL gives, starting from Microsoft Azure Cloud servers to on premise servers the option to have the best of both world and reduce the time gap of query´s and request from end users. I really enjoy to Manage SQL by using the suite of options that offers like SMSS, and the integration with Visual Studio is a priceless resource. **What do you dislike about Microsoft SQL Server?** I really don't like the lack of options to the steps taken to deploy, build query´s and promote updates, also is kind of complex to assign roles and security access to users, I would recommend to step up with the development of wizards to build up fast roles and security profiles. **Recommendations to others considering Microsoft SQL Server:** Microsoft SQL is an amazing tool that will allow to your business drive the consults and backend processing of your ERP, CRM, B2B software to next generation of building solid structures considering that MS SQL has endless options to mergue platforms and build complex to certified clean deployments of on premise software and also build up your own SaaS backed up by one of the strongest vendor in the tech market Microsoft. **What problems is Microsoft SQL Server solving and how is that benefiting you?** I'm currently solving query issues, dependencies issues and stored procedures that are not normalized, so them users will have the option to have a better consults and response times during the extraction of reports. ### 39. MS SQL: The go to solution for all your DB needs **Rating:** 5.0/5.0 stars **Reviewed by:** Scott W. | I.T., Small-Business (50 or fewer emp.) **Reviewed Date:** July 11, 2019 **What do you like best about Microsoft SQL Server?** What I like the most about MSSQL is that it integrates seamlessly in corporate environment. With the use of Visual Studio, we were able to extend SQL's reach and monitor so much more of what is going on in our environment. **What do you dislike about Microsoft SQL Server?** I can not find anything that I dislike about MS SQL. **What problems is Microsoft SQL Server solving and how is that benefiting you?** Our company is using MS SQL to solve what is going on with our work personnel. By analyzing what they are doing and how long it takes for them to do their task, we are finding ways to increase productivity by curbing certain behaviors. ### 40. Excellent Software application to Maintain and Manipulate Data. **Rating:** 5.0/5.0 stars **Reviewed by:** ujwal I. | Software Engineer, Information Technology and Services, Enterprise (> 1000 emp.) **Reviewed Date:** June 06, 2019 **What do you like best about Microsoft SQL Server?** Best thing about SQL is to store any kind of data and perform data manipulation with taking minimum effort and provide more data security than other Software's. Provide huge flexibility to integrate with over thousand of Application. Provide ease for data storage, maintenance and monitoring of data. Using Single software we can store huge amount of data in at one place. Also provide high business level functionality like SSIS and SSRS. **What do you dislike about Microsoft SQL Server?** Nothing to dislike every thing is already above expectation. **Recommendations to others considering Microsoft SQL Server:** Excellent Software for Data storage and Security, Also providing flexibility to integrate with almost all kind of software application, Easy to use and understand, Support service is very efficient and quick. **What problems is Microsoft SQL Server solving and how is that benefiting you?** We are working on automation project using automation anywhere tool is integrated with Microsoft SQL , we are using Microsoft SQL as database for storing our processing transactions. It reduces our error for maintain processing data. Also reduce the coding complexity because it is quite easy to perform operation in SQL and get required data. Improve our process execution time and reduce complexity. ### 41. Review - Microsoft SQL **Rating:** 4.0/5.0 stars **Reviewed by:** Natasha P. | Business Analyst, Enterprise (> 1000 emp.) **Reviewed Date:** May 01, 2019 **What do you like best about Microsoft SQL Server?** SQL server is one of the most efficient RDBMS to handle and store data. It provides a nice Graphical user interface for all components like query editor, profiler, sql resource optimizer etc. Service Updates and installation is easy. and Plug in third party utility is generally very convenient. Configuring sql server is very easy with a minimum support of technical resources. Creating reports from the query result is easy in day to day tasks. **What do you dislike about Microsoft SQL Server?** When you run large insert/upadtes, SQL server enterprise edition is quiet heavy sometime on the production server. **Recommendations to others considering Microsoft SQL Server:** One of the excellent database to efficiently manage the data and provides excellent support when used with web application. **What problems is Microsoft SQL Server solving and how is that benefiting you?** Better handling over the data management an data replication. SQL server has been above out expectations all the time. ### 42. My experience of using Microsoft SQL **Rating:** 4.0/5.0 stars **Reviewed by:** Samriti K. | Senior Software Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** July 25, 2019 **What do you like best about Microsoft SQL Server?** Microsoft SQL is a database management software product used for the retrieval, manipulation, deletion of data stored in the database. Sql Jobs provides a great option to alter data at particular time. Sql Profiler and multiple instances connection is useful. One of the most important feature is Sql agent. **What do you dislike about Microsoft SQL Server?** Starting of services is not included in the Sql server itself. Backup and restoration sometimes takes time. **What problems is Microsoft SQL Server solving and how is that benefiting you?** Sql server is used in our products for data manipulation. Our products backend totally handled by Sql server. ### 43. Best Amoung All **Rating:** 4.5/5.0 stars **Reviewed by:** Unsa S. | RPA Developer, Small-Business (50 or fewer emp.) **Reviewed Date:** November 20, 2019 **What do you like best about Microsoft SQL Server?** I'm using this software from a long time is just amazing.Microsoft SQL Server primarily serves as the back end of our core business system **What do you dislike about Microsoft SQL Server?** There is no built-in statistical formulas for this we have to make our own. **Recommendations to others considering Microsoft SQL Server:** Just awesome! **What problems is Microsoft SQL Server solving and how is that benefiting you?** we used it to clean the data by reducing the unwanted rows and removing the delimited values and repeating record goes off . ### 44. Implementation Of Sql Server **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Telecommunications | Enterprise (> 1000 emp.) **Reviewed Date:** May 16, 2019 **What do you like best about Microsoft SQL Server?** SQL Server I like more than others for the tools it brings in the box itself. The free, express version has a management studio express available. Additionally in my opinion it is a very open system, you have drivers to connect via oldedb, ODBC, ado, .. and in general in the clients you will not have to install anything to connect if it is Windows (in express you will only have to enable it to listen in the server). **What do you dislike about Microsoft SQL Server?** It uses a lot of RAM memory for installations and software use. It can not be used as practices because many things are forbidden, it has restrictions on the particular **Recommendations to others considering Microsoft SQL Server:** Before committing to a SQL server, you must understand the compatibility requirements and the hardware platform. The installation of SQL Server 2014 has prerequisites for the operating system and the hardware platform. These requirements vary slightly between editions of SQL Server 2014. For example, the operating system requirements of SQL Server 2014 are specific to each edition. You must install both the operating system and the specified version of the service pack (SP) **What problems is Microsoft SQL Server solving and how is that benefiting you?** Load databases with different structures through ETL, bring Control Record of the Sale to obtain as final result the Savannah of Management of the Call. ### 45. My daily driver **Rating:** 4.0/5.0 stars **Reviewed by:** Abhishek G. | Software Developer , Mid-Market (51-1000 emp.) **Reviewed Date:** February 05, 2019 **What do you like best about Microsoft SQL Server?** I have been using Microsoft sql for 3 years. Its simple and relaible. Help is available immediately. **What do you dislike about Microsoft SQL Server?** I wish the UX can improve a lot. Competetors have better ux **What problems is Microsoft SQL Server solving and how is that benefiting you?** We are solving Insurance companys day to day problems ### 46. good experience **Rating:** 5.0/5.0 stars **Reviewed by:** hassan a. | system design engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** April 29, 2019 **What do you like best about Microsoft SQL Server?** I like how easy it is to perform all the functions on it. I can easily handle all the sql jobs and make changes to the database. learning sql language is very easy and there is a lot of online help available. I can easily search all the issues online. Backing up the data from sql server is very easy and it helps us in case of shut down as it has the ability to recover files not closed properly. **What do you dislike about Microsoft SQL Server?** I am not very familiar with their debugging capabilities. it would be nice I can easily learn those skills. or if that capability becomes more handy to me. **What problems is Microsoft SQL Server solving and how is that benefiting you?** gathering data. creating reports. data analysis. business intelligence connection/interface ### 47. Awesome Tool **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** October 16, 2018 **What do you like best about Microsoft SQL Server?** SQL server is simply so staggeringly amazing, most clients likely don't have a clue the amount it can do, or the amount it can deal with. It is my most loved software to utilize on the grounds that the potential outcomes for query-writing are perpetual. It gives reinforcement to all your put away information into it, by this there is no stress of loosing your information. **What do you dislike about Microsoft SQL Server?** Versitality is brilliant, however not the best, as other new databases in the market. The memory utilization of the CPU is in every case more than ordinary in the creation explicitly by the SQL server. Extent of improvement in the profile generator for the most utilized choices. **Recommendations to others considering Microsoft SQL Server:** Highly recommended as very efficient database tool. **What problems is Microsoft SQL Server solving and how is that benefiting you?** SQL is used in the background of applications that I use at work. Simply being able to utilize the venture from assists with speed and having the capacity to give a quicker reaction to specific queries. For secure and dependable database condition this is a standout amongst the best software right now present in industry. ### 48. One of the best DB player in the market **Rating:** 4.5/5.0 stars **Reviewed by:** Sumit K. | Software Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** May 04, 2019 **What do you like best about Microsoft SQL Server?** There are various versions of the tool which can be purchased based on your acquirement. Also it is easy to use and provides vast majority of features. Triggers and task scheduling are one of the most favoured features of mine . Also, data recovery mechanism of the tool is great. Through the use of logs, caching it provides confidence good disaster recovery system **What do you dislike about Microsoft SQL Server?** Tool is quite costly. Also it is best suited for windows based servers so posses a challenge where user may want to use UNIX based server. **Recommendations to others considering Microsoft SQL Server:** Microsoft SQL is a great tool managing your relational data effectively. It provides vast features that will help you in reporting analysis other that CRUD operations. It connects easily with various type of applications. T SQL can be used as an extension for the same. **What problems is Microsoft SQL Server solving and how is that benefiting you?** Analysis and reporting services of the tool has helped us a lot in creating and maintaining the reports and analysing the data quite effectively for the purpose of improvement in our business. ### 49. Microsoft SQL is a terrific option for database management **Rating:** 4.5/5.0 stars **Reviewed by:** Francis R. | Web Developer, Enterprise (> 1000 emp.) **Reviewed Date:** May 04, 2019 **What do you like best about Microsoft SQL Server?** As far as data management goes Microsoft did a great job with this SQL client. Its fast, the language is clear and easy to learn, there are tons of tools to use, its already a great product. **What do you dislike about Microsoft SQL Server?** There is a scheduler service that needs to run to perform backups, restores etc. that I have a lot of trouble with for some reason, its always not running. I wish I can perform these task without relying on that service. **Recommendations to others considering Microsoft SQL Server:** Great for data hosting and using as the back end for web based and desktop applications **What problems is Microsoft SQL Server solving and how is that benefiting you?** We use SQL to host our database, to hold our data for web and desktop applications to access. ### 50. SQL server is one of the great products from Microsoft **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** January 23, 2020 **What do you like best about Microsoft SQL Server?** Ms SQL it is reliable and easy to use software.It is supports most of the data types.we can store and process large amount of data. **What do you dislike about Microsoft SQL Server?** Ms SQL it is very great and reliable software.I have no any negative comments on ms SQL.It is easy to use. **What problems is Microsoft SQL Server solving and how is that benefiting you?** It is easy to use.very easy to learn its programming language. ## Microsoft SQL Server Discussions - [how did you import a MySQL database?](https://www.g2.com/discussions/how-did-you-import-a-mysql-database) - 3 comments, 2 upvotes - [How can I work on the same query if the connection is lost (timeout) and then I reconnect?](https://www.g2.com/discussions/15675-how-can-i-work-on-the-same-query-if-the-connection-is-lost-timeout-and-then-i-reconnect) - 4 comments, 2 upvotes - [What is Microsoft SQL Server used for?](https://www.g2.com/discussions/microsoft-sql-server-what-is-microsoft-sql-server-used-for) - 2 comments, 1 upvote - [Best features in SQL](https://www.g2.com/discussions/24528-best-features-in-sql) - 2 comments, 1 upvote - [How to handle duplicate data from a database and a course on related databases](https://www.g2.com/discussions/como-manejar-datos-duplicados-de-base-de-datos-y-un-curso-sobre-base-relacionadas) - 1 comment, 1 upvote - [View Microsoft SQL Server pricing details and edition comparison](https://www.g2.com/products/microsoft-sql-server/reviews?login_required=true&page=9§ion=pricing&secure%5Bexpires_at%5D=2026-07-18+12%3A33%3A49+-0500&secure%5Bsession_id%5D=c46c954c-59c4-463d-97a5-16cb8760937c&secure%5Btoken%5D=7aa7422bd2fd85cddd9b0be0392ab679c3f68136d8a4d883f0e53b3ff9d11c0d&format=llm_user) ## Microsoft SQL Server Integrations - [Agentforce Sales (formerly Salesforce Sales Cloud)](https://www.g2.com/products/agentforce-sales-formerly-salesforce-sales-cloud/reviews) - [Azure Databricks](https://www.g2.com/products/azure-databricks/reviews) - [Azure Data Factory](https://www.g2.com/products/azure-data-factory/reviews) - [Azure Functions](https://www.g2.com/products/azure-functions/reviews) - [Azure Pipelines](https://www.g2.com/products/azure-pipelines/reviews) - [Azure Portal](https://www.g2.com/products/azure-portal/reviews) - [Azure SQL Database](https://www.g2.com/products/azure-sql-database/reviews) - [Azure Virtual Machines](https://www.g2.com/products/azure-virtual-machines/reviews) - [Databricks](https://www.g2.com/products/databricks/reviews) - [Docker](https://www.g2.com/products/docker-inc-docker/reviews) - [Informatica Cloud Data Integration](https://www.g2.com/products/informatica-cloud-data-integration/reviews) - [IntelliJ IDEA](https://www.g2.com/products/intellij-idea/reviews) - [Internet Information Services (IIS) for Windows Server](https://www.g2.com/products/internet-information-services-iis-for-windows-server/reviews) - [JAMS](https://www.g2.com/products/jams-software-llc-jams/reviews) - [Jet Analytics](https://www.g2.com/products/jet-analytics/reviews) - [Microsoft Defender for Cloud](https://www.g2.com/products/microsoft-defender-for-cloud/reviews) - [Microsoft Excel](https://www.g2.com/products/microsoft-excel/reviews) - [Microsoft Fabric](https://www.g2.com/products/microsoft-fabric/reviews) - [Microsoft Power Apps](https://www.g2.com/products/microsoft-power-apps/reviews) - [Microsoft Power Automate](https://www.g2.com/products/microsoft-power-automate/reviews) - [Microsoft Power BI](https://www.g2.com/products/microsoft-microsoft-power-bi/reviews) - [Microsoft SQL Server Integration Services to Alation](https://www.g2.com/products/microsoft-sql-server-integration-services-to-alation/reviews) - [monday AI Work Platform](https://www.g2.com/products/monday-com/reviews) - [MuleSoft Anypoint Platform](https://www.g2.com/products/mulesoft-anypoint-platform/reviews) - [Node.js](https://www.g2.com/products/node-js/reviews) - [NodeJS Web Stack](https://www.g2.com/products/nodejs-web-stack/reviews) - [Oracle Java Downloads](https://www.g2.com/products/oracle-java-downloads/reviews) - [Popdock](https://www.g2.com/products/popdock/reviews) - [Redis Software](https://www.g2.com/products/redis-software/reviews) - [Salesforce Headless 360 Platform (formerly Salesforce Platform)](https://www.g2.com/products/agentforce-360-platform-formerly-salesforce-platform/reviews) - [SQL Management Studio for SQL Server](https://www.g2.com/products/sql-management-studio-for-sql-server/reviews) - [Umbraco](https://www.g2.com/products/umbraco/reviews) - [Visual Studio](https://www.g2.com/products/visual-studio/reviews) - [Visual Studio Code](https://www.g2.com/products/visual-studio-code/reviews) ## Microsoft SQL Server Features **Management** - Data dictionary - Data Replication - Query Language - Data Modeling - Performance Analysis **Management ** - Data Schema - Query Language - ACID - Complaint - Data Replication **Database** - Real-Time Data Collection - Data Distribution - Data Lake **Maintenance** - Data Migration - Backup and Recovery - Multi-User Environment **Support ** - Text Search - Data Types - Languages - Operating Systems **Integrations** - Hadoop Integration - Spark Integration **Security** - Data Encryption - User Access Control **Security** - Database Locking - Access Control - Encryption - Authentication **Platform** - Machine Scaling - Data Preparation - Spark Integration **Performance ** - Disaster Recovery - Data Concurrency - Workload Management - Advanced Indexing - Query Optimizer **Processing** - Cloud Processing - Workload Processing **Building Reports** - Data Transformation - Data Modeling - WYSIWYG Report Design - Integration APIs **Database Features** - Storage - Availability - Stability - Scalability - Security - Data Manipulation - Query Language **Platform** - Mobile User Support - Customization - User, Role, and Access Management - Internationalization - Sandbox / Test Environments - Performance and Reliability - Breadth of Partner Applications ## Top Microsoft SQL Server Alternatives - [Teradata Autonomous Knowledge Platform](https://www.g2.com/products/teradata-autonomous-knowledge-platform/reviews) - 4.3/5.0 (357 reviews) - [SAP HANA Cloud](https://www.g2.com/products/sap-hana-cloud-2025-10-01/reviews) - 4.3/5.0 (521 reviews) - [Google Cloud SQL](https://www.g2.com/products/google-cloud-sql/reviews) - 4.5/5.0 (354 reviews)