# 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 praise the **ease of use** of Microsoft SQL Server, highlighting its intuitive interface and powerful capabilities. (29 reviews) - Users appreciate the **robust database management** of Microsoft SQL Server, enabling effective data handling and streamlined administration. (24 reviews) - Users highlight the **exceptional performance** of Microsoft SQL Server, appreciating its power and ease of use. (24 reviews) - Users value the **easy integrations** of Microsoft SQL Server with various Microsoft products, enhancing productivity and workflow. (22 reviews) - Users appreciate the **enterprise-grade security** of Microsoft SQL Server, ensuring customer data safety and compliance effortlessly. (21 reviews) - Users love the **seamless integration** of Microsoft SQL Server with other Microsoft products, enhancing productivity significantly. (21 reviews) - Reliability (18 reviews) - Setup Ease (13 reviews) - Users appreciate the **ease of data management** with Microsoft SQL Server, enjoying its simplicity and flexibility for various applications. (12 reviews) - Security (11 reviews) **What users dislike:** - Users find the **high licensing costs** of Microsoft SQL Server a barrier for smaller businesses and startups. (21 reviews) - Users find the **high licensing costs** of Microsoft SQL Server challenging, especially for smaller businesses and projects. (12 reviews) - Users find the **high licensing costs** of Microsoft SQL Server challenging, especially for small businesses and teams. (12 reviews) - Users find the **licensing costs high** , making Microsoft SQL Server less accessible for small businesses and projects. (11 reviews) - Users experience **slow performance** with Microsoft SQL Server, particularly when handling large datasets and global searches. (10 reviews) - Users face **performance issues** with SQL Server, struggling with costly licensing and complex scaling of large workloads. (9 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. Microsoft SQL Server review **Rating:** 4.5/5.0 stars **Reviewed by:** Alfonso José A. | Profesor Particular de Violoncello, Small-Business (50 or fewer emp.) **Reviewed Date:** November 07, 2023 **What do you like best about Microsoft SQL Server?** Microsoft SQL Server is a powerhouse for handling data. It can take on massive amounts of info, and it's like a speed demon with its parallel processing mojo. If you're dealing with a ton of data, this is like having a superhero in your tech toolkit to keep things running smoothly. **What do you dislike about Microsoft SQL Server?** Windows-centric systems may restrict adaptability and mobility for organizations employing various operating systems. For SQL Server, frequent software updates and upgrades are crucial to uphold security and performance. This can prove labor-intensive and resource-demanding, particularly for organizations managing extensive and intricate database deployments. **What problems is Microsoft SQL Server solving and how is that benefiting you?** Big Data Management: SQL Server simplifies the handling of vast data volumes through Big Data Clusters. It enables organizations to efficiently store, process, and analyze both structured and unstructured data, including log files and social media data. This empowers businesses to extract valuable insights about their operations and customer behavior. ### 2. Good scalable RDBMS **Rating:** 4.5/5.0 stars **Reviewed by:** Ahmed A. | Imaging and Printing Business unit manager, Retail, Mid-Market (51-1000 emp.) **Reviewed Date:** April 04, 2024 **What do you like best about Microsoft SQL Server?** I'm using SQL Server on dailiy bases, It's very powerfull RDBS. it can be easly integrated with other databases. very easy to implement as long as you are familer with it. the customer support team is very profissional and capable. **What do you dislike about Microsoft SQL Server?** Nothing can't be found to mention. it's just perfect **What problems is Microsoft SQL Server solving and how is that benefiting you?** I use it as a backend database for my custom developed applications. to store the software data, report the query data. ### 3. Perfect database for SME **Rating:** 5.0/5.0 stars **Reviewed by:** Vijaay Kumar S. | Finance head, Financial Services, Small-Business (50 or fewer emp.) **Reviewed Date:** February 10, 2024 **What do you like best about Microsoft SQL Server?** Most important feature is it's from microsoft and it got pretty much every thing a business would require. It's a lot easy to update, fetch, delete and edut data fir my clients and for internal uses. We use it as a backup of database from quickbooks so that we can query the database to create reports and dashboard. **What do you dislike about Microsoft SQL Server?** Nothing much, just lack of mobile app and non availability on linux system. **What problems is Microsoft SQL Server solving and how is that benefiting you?** We have been using quick books for a long time and we use SQL server on Azure to store all the transaction of our clients who are in lending industry. We then push a copy to QBO. Now reconciliation between the two We are doing with Power BI snd it's a lot easy, no need to do reconciliation between the two manually. ### 4. Microsoft SQL Server : A comorehensive review **Rating:** 4.5/5.0 stars **Reviewed by:** Lovey A. | Associate Business Analyst, Mid-Market (51-1000 emp.) **Reviewed Date:** May 17, 2024 **What do you like best about Microsoft SQL Server?** The thing that I like the most about the microaoft SQL server is that it supports a wide range of data types. Also advance analytics are supported. When I was working on Machine learning, it helped a lot. **What do you dislike about Microsoft SQL Server?** Sometimes there are issues when connecting with non microsoft products. Also it's a bit expensive. **What problems is Microsoft SQL Server solving and how is that benefiting you?** It provided a platform to store and efficiently manage large relational data. It hwlpwd with advance anlytics which ia very important for data analysts & data scientists. ### 5. Comprehensive Platform **Rating:** 4.0/5.0 stars **Reviewed by:** Nikhil V. | Data Analyst, Food & Beverages, Mid-Market (51-1000 emp.) **Reviewed Date:** April 16, 2024 **What do you like best about Microsoft SQL Server?** It's a robust RDBMS for best reliability,performance and comprehensive features. Ease to use Performance optimization Advanced analysis and bi Flexibility and support **What do you dislike about Microsoft SQL Server?** It still tends to be more optimised for windows environments then non windows environments may feel some limitations. Trouble when trying to mitigate or upgrade data between different versions. **What problems is Microsoft SQL Server solving and how is that benefiting you?** Data storage and management. Data integrity with other Microsoft products is seamless. Complex querying is easier to analyse and interpret data fir business insights. Rich features and performance. It's overall provides a comprehensive platform for data management and analysis. ### 6. Suitable SQL server and management for working proffesionals **Rating:** 5.0/5.0 stars **Reviewed by:** Mohammad Mateen M. | Software Developer, Small-Business (50 or fewer emp.) **Reviewed Date:** February 28, 2024 **What do you like best about Microsoft SQL Server?** Its UI and the features it's provides and for faster execution of the queries also helps in managing database very conveniently. Very good for business purposes and big projects **What do you dislike about Microsoft SQL Server?** Sometimes some server or locl servers/instances are difficult to connect if some thing is missed while installation or while creating a instance a user. But again it can be avoided with some simple checks and you are good to go **What problems is Microsoft SQL Server solving and how is that benefiting you?** It's UI and some shortcuts to execute the queries and creating tables helps in faster development and much simple and easy management of tables also allows simple queries and does not have strict syntax unlike command propmts or command line apps. ### 7. World's Number One **Rating:** 5.0/5.0 stars **Reviewed by:** Serhat C. | Senior Software Developer, Enterprise (> 1000 emp.) **Reviewed Date:** May 03, 2023 **What do you like best about Microsoft SQL Server?** It is very easy to create store procedures, at the same time it is simple to use triggers and jobs, easy to access within the Intranet, working with multiple users is smooth, Shirink transactions are a feature that makes it easy for me. **What do you dislike about Microsoft SQL Server?** I use it for my personal work both in my company and at home, and I haven't found any aspect of my menu that I don't like. **What problems is Microsoft SQL Server solving and how is that benefiting you?** We use it to store and report ATM error records in the bank. Since it is relational database management, we can easily write sql script with more than one database, convert it to sore procedure and use it either in a job or in a cursor. We also work fully integrated with Visual Studio products. We can make software effortlessly. ### 8. Microsoft SQL Server the Database of Choice **Rating:** 5.0/5.0 stars **Reviewed by:** Arabinda D. | VP - Technology Services and Engineering, Mid-Market (51-1000 emp.) **Reviewed Date:** January 23, 2024 **What do you like best about Microsoft SQL Server?** When Application required most important aspect its the performance which is directly propotional to large volume of Transaction . In that area Microsoft SQL Server stands best once you choose the Right DB , rest effortlessly SQL server handles all .Also it is best of breed in analytics sector which helps me to tell my Data as story where to improve . Hence I like the most . **What do you dislike about Microsoft SQL Server?** Scalability has some configration challenges but with stiff learning curve this can be overcome . During consistency check of Transaction , it may have certain challenges like other Relational Databases . **What problems is Microsoft SQL Server solving and how is that benefiting you?** Mostly my Transaction realibility Analytics support Ease of Data export and import are the main features which SQL Server effortlessly handled ### 9. Perks of using MS SQL server **Rating:** 4.0/5.0 stars **Reviewed by:** Kapil K. | Graduate Data Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** September 11, 2023 **What do you like best about Microsoft SQL Server?** First thing I really like about MS SQL server is how we can run a part of the query by just selecting that part and just running it. In MS SQL server it's really easy to switch databases, and it's really convenient to upload files on SQL server. It conveniently handles different types of files. **What do you dislike about Microsoft SQL Server?** Downside of Microsoft SQL server is that some functionalities does not work like openJson and similar that works in Mysql. Also while handing bigger data like (100 gbs) it becomes slower and it makes other processes slow as well. **What problems is Microsoft SQL Server solving and how is that benefiting you?** Whether it is handling of large databases and efficiently storing data into tables or creating views SQL is doing it pretty well. By using stored procedure we are getting benefitted as it is easier for us to just run a stored procedure and it will do the extracting, transform and load for us. ### 10. data management **Rating:** 5.0/5.0 stars **Reviewed by:** carlo d. | diseñador de software, Enterprise (> 1000 emp.) **Reviewed Date:** April 25, 2024 **What do you like best about Microsoft SQL Server?** Being able to make queries in different tables to cross-reference information **What do you dislike about Microsoft SQL Server?** The SQL backup takes a long time and slows down the system. **What problems is Microsoft SQL Server solving and how is that benefiting you?** data validation through cross-referencing information extracted from the internet. ### 11. A reliable SQL sever for your enterprise application **Rating:** 3.5/5.0 stars **Reviewed by:** Shridhar H. | Software Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** December 22, 2023 **What do you like best about Microsoft SQL Server?** There are multiple versions of SQL servers like Developer and Express which can be separately used for development and production making it easy to enable advanced flags and features using development for debugging. **What do you dislike about Microsoft SQL Server?** There is no inbuilt High Availability and Disaster Recovery mechanism. So we have to manually set this causing us to maintain multiple servers. **What problems is Microsoft SQL Server solving and how is that benefiting you?** Microsoft SQL Server provides free and reliable SQL Relational databases for applications that can either be self-hosted or cloud-based. This enables developers to concentrate more on the business use case than look for infrastructure-related problems. ### 12. Any Data Analyst should know Microsoft SQL **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Logistics and Supply Chain | Enterprise (> 1000 emp.) **Reviewed Date:** March 09, 2023 **What do you like best about Microsoft SQL Server?** I think any furture Analyst should know how to use the SQL. It is not difficult to learn how to write an query. SQL help us to track and organize data from big database quickly. **What do you dislike about Microsoft SQL Server?** it does not have an AI to help us to create queries or write an optimized query. **What problems is Microsoft SQL Server solving and how is that benefiting you?** Get big data from the database logistically. Then, it is easy to connect Visualization tools for analysts and make decisions. ### 13. Review on Microsoft SQL Server **Rating:** 5.0/5.0 stars **Reviewed by:** Shivam M. | Product Evangelist, Mid-Market (51-1000 emp.) **Reviewed Date:** January 11, 2024 **What do you like best about Microsoft SQL Server?** Microsoft SQL server enable user to easily implement datawarehousing and machine learning it has n number of features like sealization,snapshot,backup it also allows to integrate data from multiple sources which helps in analysing and process data at one place there customer support team always stand by your side if you face any challanges. They provide good platform for beginners which increases the frequncy of use .Its disk management and partitioning algorithms makes it very ease to use for data management. **What do you dislike about Microsoft SQL Server?** Sometimes we face challenge to run microsoft SQL servers on multiple processor so we generally give one strong processor. **What problems is Microsoft SQL Server solving and how is that benefiting you?** It helps in storing and processing my big data in real time. ### 14. Microsoft SQL Server Integration **Rating:** 4.0/5.0 stars **Reviewed by:** DEEP R. | Senior Manager IT, Financial Services, Mid-Market (51-1000 emp.) **Reviewed Date:** March 27, 2024 **What do you like best about Microsoft SQL Server?** Microsoft SQL server also have a free option for small applications. **What do you dislike about Microsoft SQL Server?** Performace issue occur when use with bigger databases. **What problems is Microsoft SQL Server solving and how is that benefiting you?** Our company using Microsoft SQL server for integration with Microsoft Power Bi ### 15. Microsoft SQL server is the OG GOAT **Rating:** 4.5/5.0 stars **Reviewed by:** Raj S. | Billing Operations Analyst, Mid-Market (51-1000 emp.) **Reviewed Date:** February 03, 2024 **What do you like best about Microsoft SQL Server?** ●Ease of Implementation ●Easier learning platform for queries ●Much secured than others ●A Microsoft original product which is still trusted even after 40 years **What do you dislike about Microsoft SQL Server?** The biggest issue is it's slowness with large dataset **What problems is Microsoft SQL Server solving and how is that benefiting you?** I use Microsoft SQL server for extracting data from data lake source of ERP and web services product of company ### 16. Review for sql server **Rating:** 5.0/5.0 stars **Reviewed by:** Chirag D. | Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** March 30, 2024 **What do you like best about Microsoft SQL Server?** Ease of data handling and software integration. **What do you dislike about Microsoft SQL Server?** Support required for patch installations. **What problems is Microsoft SQL Server solving and how is that benefiting you?** It is helping me managing the data of teacmenter unified application. ### 17. SQL Server **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Mechanical or Industrial Engineering | Enterprise (> 1000 emp.) **Reviewed Date:** August 16, 2024 **What do you like best about Microsoft SQL Server?** Incredibly efficient and the go to standard for databases **What do you dislike about Microsoft SQL Server?** Some aspects are not intuitive and the software is showing its age **What problems is Microsoft SQL Server solving and how is that benefiting you?** Storing company data ### 18. It's is easy to use and provide high security and reliable database management system **Rating:** 5.0/5.0 stars **Reviewed by:** Amit V. | Software Developer, Mid-Market (51-1000 emp.) **Reviewed Date:** December 04, 2023 **What do you like best about Microsoft SQL Server?** Customer Support,its versatility and scalability and user friendly interface easy to understand these feature i like best about MIcrosoft SQL Server **What do you dislike about Microsoft SQL Server?** Concerns about the licensing costs it is expensive more memory used i dislike these things in Microsoft SQL Server **What problems is Microsoft SQL Server solving and how is that benefiting you?** it's solve my data security problem it help me in data analysis and managing database it supports advanced analytics and reporting tools that help me in software development ### 19. SQL gives me control over my data **Rating:** 5.0/5.0 stars **Reviewed by:** Aakash T. | Senior Data Analyst, Mid-Market (51-1000 emp.) **Reviewed Date:** June 02, 2023 **What do you like best about Microsoft SQL Server?** What I like best about Microsoft SQL Server is its robustness and scalability, allowing it to handle large and complex databases easily, and integration with other Microsoft products and services, such as Azure, provides a seamless experience. **What do you dislike about Microsoft SQL Server?** Microsoft SQL Server's licensing model is complex and expensive for specific deployments. Another drawback is the limited compatibility with non-Microsoft platforms. While SQL Server offers a wide range of features, some advanced functionalities may require additional licensing or higher editions, limiting access for users on lower budgets. **What problems is Microsoft SQL Server solving and how is that benefiting you?** Microsoft SQL Server solves various data management challenges by providing a robust and scalable platform for storing, organizing, and analyzing data. It enables efficient data retrieval and manipulation, ensuring data integrity and security. By leveraging SQL Server's capabilities, I can effectively manage and derive valuable insights from large datasets, improving decision-making processes and driving business success. Its language (queries) is simple to write which benefits a beginner too. ### 20. The best database management tool I have ever used. **Rating:** 5.0/5.0 stars **Reviewed by:** Akanksha S. | Data Analyst (Quality Assurance), Enterprise (> 1000 emp.) **Reviewed Date:** May 23, 2023 **What do you like best about Microsoft SQL Server?** I recently had the opportunity to work extensively with Microsoft SQL Server, and I must say that it has exceeded my expectations as a comprehensive and robust database management system. Here's my review of this outstanding software. First and foremost, the installation process was smooth and hassle-free. Microsoft SQL Server provides clear and user-friendly installation wizards that guide you through the setup, making it easy for even those with limited technical knowledge to get started. The documentation and online resources available are also extensive, enabling quick troubleshooting and learning. One of the standout features of Microsoft SQL Server is its exceptional performance. It handles large and complex databases with remarkable speed and efficiency. Whether it's executing complex queries or handling a high volume of concurrent transactions, SQL Server consistently delivers optimal performance, ensuring minimal downtime and maximum productivity. **What do you dislike about Microsoft SQL Server?** I don't really dislike anything about Sql. Sometimes the interface seems little old and boring. You can work towards making some changes to the UI, it will be more convinent for using. **What problems is Microsoft SQL Server solving and how is that benefiting you?** SQL Server addresses the challenge of managing large volumes of data efficiently. It offers robust data storage capabilities, enabling businesses to securely store and organise vast amounts of information. This is particularly advantageous for companies dealing with massive datasets and complex relational databases. SQL Server's ability to handle such data with speed and reliability ensures smooth operations and enhanced productivity. ### 21. SQL Server - a very popular RDBMS **Rating:** 5.0/5.0 stars **Reviewed by:** Saurabh K. | Software Engineering Associate Manager, Enterprise (> 1000 emp.) **Reviewed Date:** December 01, 2023 **What do you like best about Microsoft SQL Server?** SQL Server is very convenient to use for writing queries, Stored Procs, Views, Triggers and is very easy to debug **What do you dislike about Microsoft SQL Server?** There is nothing to be disliked in SQL server as per me **What problems is Microsoft SQL Server solving and how is that benefiting you?** SQL Server helps in storing and managing data in tabular format that helps in quering the data in structured way ### 22. SQL server integration with Data Factory **Rating:** 4.0/5.0 stars **Reviewed by:** Ravindra J. | Consultant, Enterprise (> 1000 emp.) **Reviewed Date:** June 11, 2023 **What do you like best about Microsoft SQL Server?** SQL server is really helpful when we want to query the data. If one is in data domain SQL is something that will be required and used most frequently. SQL server is I feel very easy to learn once one learn the basics. It ca be used for querying and manipulating the data. **What do you dislike about Microsoft SQL Server?** I have found any downsides so far using SQL server. It s just that there are many versions that are released which can cause trouble sometimes as those become incompatible but other than that everything looks fine to me. **What problems is Microsoft SQL Server solving and how is that benefiting you?** We use data for querying, manipulating as well as modeling the data. Sometimes we have to integrate the on-premise data with the customer's database we use that and there are many other problems like getting insights, finding out bad data, and all. ### 23. The best Database Management tool- SQL **Rating:** 5.0/5.0 stars **Reviewed by:** ARINDAM R. | Consultant, Enterprise (> 1000 emp.) **Reviewed Date:** September 25, 2023 **What do you like best about Microsoft SQL Server?** The best thing about SQL is its user friendly interface. Very easy to get insights from a large number of data elements. Highly effective as it can also interpret results from languages like DDL and DCL. It is also scalable as it can store a huge amount of data. **What do you dislike about Microsoft SQL Server?** I feel that it is a bit slower as compared to Oracle and due to that reason only, many companies are using Oracle nowadays. Moreover the licence cost is also too high which makes it uneconomical for a lot of users. **What problems is Microsoft SQL Server solving and how is that benefiting you?** For me, it is very helpful in giving meaningful insights from large database and queries. I am able to use that for interpretation of large data in my workplace. ### 24. User friendly and helpful **Rating:** 5.0/5.0 stars **Reviewed by:** Prajwal K. | Enterprise (> 1000 emp.) **Reviewed Date:** December 18, 2023 **What do you like best about Microsoft SQL Server?** A lot of my friends use it. good number of features. **What do you dislike about Microsoft SQL Server?** Its now become legacy. There is less customer support. **What problems is Microsoft SQL Server solving and how is that benefiting you?** We have a lot of data at hand. it is helping us analyze it and maximise our business goals. ### 25. Day To Day Deliver - MS SQL Server **Rating:** 4.0/5.0 stars **Reviewed by:** Mohanbabu S. | Small-Business (50 or fewer emp.) **Reviewed Date:** May 04, 2023 **What do you like best about Microsoft SQL Server?** It has the capacity to handle and control all of my data from a single location due to its combined and potent engine. Its high configuration and setup settings are responsible for its flexible construction. The ability to analyze relational data is quite great, and the language structure can be altered based on geographic regions. The control over backups, data filtering, reporting, and view structures, along with the management of extremely complex database structures, makes it simple to give quicker feedback. **What do you dislike about Microsoft SQL Server?** MS SQL is not for relational database newbies. To fix initial setup issues, establish users, set up permissions, etc., programming abilities are required. Particular mistakes can be difficult to comprehend. Finding the best remedy could depend on the specific situation, even though there is a tonne of advice available online. An experienced user can prevent these, but a novice may struggle to fix database problems. **What problems is Microsoft SQL Server solving and how is that benefiting you?** Automated tracking is made possible by special views and cached server operations. It guarantees consistent information and duplication based on the predetermined main key through preset circumstances. Very practical for CRUD operations and cloud deployment apps. Strong RDBMS to get data from several sources and combine it. By obtaining data from other sources, using a data recovery and restoration process, and checking the quality of the data (Adobe campaign). ### 26. Your Data Is Much Safer Now **Rating:** 5.0/5.0 stars **Reviewed by:** Turan A. | Uzman, Mid-Market (51-1000 emp.) **Reviewed Date:** January 05, 2023 **What do you like best about Microsoft SQL Server?** Thanks to its integrated and powerful engine, it has the ability to control and manage all my data from a single point. It has a flexible structure thanks to its high installation and configuration settings. The language structure that can be adjusted according to geographical locations, the ability to process relational data is quite high. You can easily provide faster feedback thanks to the management of high-dimensional database structures, backups, data filtering, reporting and view structures. **What do you dislike about Microsoft SQL Server?** The configuration and configuration required during installation can take a very long time. An error to be made here may cause a difficult configuration to return. **What problems is Microsoft SQL Server solving and how is that benefiting you?** We combined all the data we stored in other dispersed environments in a single database, thanks to deduplication. We also saved time and resources from business processes and reporting processes. Likewise, a much safer and easier backup structure of data was organized. ### 27. Microsoft SQL server for scalable solution **Rating:** 4.5/5.0 stars **Reviewed by:** Happy S. | Software Engineer II, Mid-Market (51-1000 emp.) **Reviewed Date:** July 30, 2023 **What do you like best about Microsoft SQL Server?** When I'm using SQL I always wonder how will I scale it to my application that will be used at scale but I came across Microsoft SQL Server and all my problems got solved. **What do you dislike about Microsoft SQL Server?** As of now I'm using it since few months so I don't have any particular dislike bit SQL is little bit complex and defined schema over key value pairs like MongoDB or in DynamoDB is simpler I think. **What problems is Microsoft SQL Server solving and how is that benefiting you?** Fast execution of query gives faster response to application is the biggest problem solved by SQL server and it is easily scalable so you don't need to worry about it. ### 28. My experience **Rating:** 4.5/5.0 stars **Reviewed by:** Hélio S. | Agente de qualidade, Enterprise (> 1000 emp.) **Reviewed Date:** January 16, 2024 **What do you like best about Microsoft SQL Server?** The convenience that the platform provides me is incredible, the data extraction is excellent, it helps me a lot in my daily routine and optimizes my time. **What do you dislike about Microsoft SQL Server?** Sometimes there are system crashes, and this causes stress but nothing that can't be resolved **What problems is Microsoft SQL Server solving and how is that benefiting you?** The extraction of results helps me a lot in my daily life. ### 29. Easy to integrate and Access for API's to alter access data **Rating:** 4.5/5.0 stars **Reviewed by:** Sheheryar A. | Test Automation Consultant, Small-Business (50 or fewer emp.) **Reviewed Date:** November 24, 2023 **What do you like best about Microsoft SQL Server?** Doesn't take much space to start with, Easy to create queries that can implement data set that are needed. The connection establishment with automation testing is also easy to use requiring the host url username and password **What do you dislike about Microsoft SQL Server?** Nothing till now. Using Sql server for 3 years now **What problems is Microsoft SQL Server solving and how is that benefiting you?** Relationship databases are easy to use. The building of query is really helpful for me specially when building a new query with good time constraints ### 30. Overall Experience with Microsoft SQL server **Rating:** 4.5/5.0 stars **Reviewed by:** Tarannum m. | Assistant Manager, Enterprise (> 1000 emp.) **Reviewed Date:** October 02, 2023 **What do you like best about Microsoft SQL Server?** It is very good RDBMS database MS SQL database is easy to use and can be installed at a laptop. It provides a real RDBMS and ACID transaction management. It is very understandable and manageble the data in Database. **What do you dislike about Microsoft SQL Server?** There is nothing dislike for me because MS SQL Server has evolved into a reliable, stable, and full-function enterprise grade database system.it really helped me alot while working. **What problems is Microsoft SQL Server solving and how is that benefiting you?** Microsoft SQL Server has been used within our organization for many years. We are using this for storing the data of our application and to perform different operations on that. ### 31. Excellent for Database purpose with A360 in RPA **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Construction | Enterprise (> 1000 emp.) **Reviewed Date:** November 23, 2023 **What do you like best about Microsoft SQL Server?** Database connection and its operations are very quick and all sorts of complex queries and stored procedure can be used quite well to sort the data. **What do you dislike about Microsoft SQL Server?** While sorting the data with Date query in Microsoft SQL Server which contains date gets difficult and sometimes even data doesn't get filtered as required. **What problems is Microsoft SQL Server solving and how is that benefiting you?** Microsoft SQL server executes stored procedure very well and the filtered data is easily used for further processing. ### 32. SQL Server is one of my favorites **Rating:** 5.0/5.0 stars **Reviewed by:** Wandy r. | business analyst, Enterprise (> 1000 emp.) **Reviewed Date:** May 03, 2023 **What do you like best about Microsoft SQL Server?** It is robust, secure, fast, and can help you manage your databases for almost any project. The write and read speed is awesome even for enormous databases, all you have to do is index your tables properly, and you will have no issues. **What do you dislike about Microsoft SQL Server?** When managing enormous amounts of data, it can get slow if you don't index your tables properly. This is more like an issue on the administrator side, as the technology can give a lot of resources if you handle them properly. **What problems is Microsoft SQL Server solving and how is that benefiting you?** It is managing our server side database for all the products build and distributed to our customers and for internal use. With SQL Server we build the structure for our systems, automated procedures, triggers, functions and everything needed to handle our system's data. ### 33. Scalable storage system for structured data **Rating:** 4.5/5.0 stars **Reviewed by:** Rajat P. | Director, Enterprise (> 1000 emp.) **Reviewed Date:** November 03, 2023 **What do you like best about Microsoft SQL Server?** The best thing I Like about Microsoft SQL service is that even a novice Sql developer could administer the server without much help and having basic understanding of severs and Structured query language. **What do you dislike about Microsoft SQL Server?** The Sql server help section should have more content for new administrators. **What problems is Microsoft SQL Server solving and how is that benefiting you?** The problem Microsoft sql server solved was that we were able to store large amount of structured data including data from GIS and achieved an SLA of 99% on availability. ### 34. SQL Server -the database of choice **Rating:** 3.0/5.0 stars **Reviewed by:** Abbas M. | Marketing Consultant, Small-Business (50 or fewer emp.) **Reviewed Date:** October 16, 2023 **What do you like best about Microsoft SQL Server?** The GUI was at a time when good things were without graphics. It was easy to use and configure and enjoyed working with it. With Visual studio, connecting to .NET is relatively easy. **What do you dislike about Microsoft SQL Server?** It is not lightweight and you don't have many choices without the GUI. I mean with shell programming, not so flexible. Secondly is not open source. Microsft should reconsider. You guys were not beside us when we developers were struggling.(2003..). **What problems is Microsoft SQL Server solving and how is that benefiting you?** Providing an easy-to-use database quickly. ### 35. SQL server review **Rating:** 5.0/5.0 stars **Reviewed by:** Sanjeev P. | Data Analyst, Enterprise (> 1000 emp.) **Reviewed Date:** August 28, 2023 **What do you like best about Microsoft SQL Server?** SQL server is easy to use we can manage the database through ssms in a graphical manner. We can use tsql for data manipulation and all. It has different version for the different usecase like developer enterprise and standerd. **What do you dislike about Microsoft SQL Server?** I am working since last three year all looks good . I have not found any major think that I can include in dislike overall it is good for managing the databases. **What problems is Microsoft SQL Server solving and how is that benefiting you?** SQL server is solving the database maintinance problem we can easily maintain the database with the help of SQL server. We have different version we can use as per the requirement. ### 36. one of the secured DB in the market **Rating:** 4.5/5.0 stars **Reviewed by:** Abhiraj R. | Mid-Market (51-1000 emp.) **Reviewed Date:** August 08, 2023 **What do you like best about Microsoft SQL Server?** it is very user friendly and too easy to understand conepts of SQL DB. a beginner can easily operate on this and can write and execute queries. even you dont know the syntax, you can easily build queries with it's user friendly options. **What do you dislike about Microsoft SQL Server?** The main disadvantage of microsoft SQL is it's cross platform compatability. The feature of windows microsoft SQL differs from LINUX and it uses more memory and CPU. **What problems is Microsoft SQL Server solving and how is that benefiting you?** It saves so much time for me because of it's user friendly options. You don't have to remember all the syntaxes as it helps to execute queries with it's inbuilt functions. you only have to put the values in it. ### 37. Microsoft SQL Server Review **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** May 19, 2023 **What do you like best about Microsoft SQL Server?** There are quite a few things that are so great about Microsoft SQL Server. It has great performance while working with complex and high-volume data. It is well known for providing reliability through ACID properties. It is highly scalable and hence as business grows, server size can be expanded. Apart from this, it works great with other Microsft products and frameworks. **What do you dislike about Microsoft SQL Server?** A few things which go south for Microsft SQL Server are its complexity and cost. The user will be required to learn SQL to work with a Microsoft SQL server and all the versions are not free hence based on the requirements, the user might to required to pay for a few of the services. Also, its mainly compatible with Microsoft platforms and hence does not as efficiently as Windows, with other platforms like Linux. **What problems is Microsoft SQL Server solving and how is that benefiting you?** As a person working on Microsoft technologies, maintaining relational data with RDBMS like Microsoft SQL Server is much helpful to main the data seamlessly. It is a go-to choice for any database requirements irrespective of the size of the business. The profiler feature helps to check for the various operations performed and can be used to perform load on the server when various operations are triggered together. For ease of use, IDE like the Microsoft SQL server provides flawless working with the Microsoft SQL Server. ### 38. Relational Database Management System for storing as well retrieving data **Rating:** 5.0/5.0 stars **Reviewed by:** Susanta Kumar P. | Senior Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** March 21, 2022 **What do you like best about Microsoft SQL Server?** 1. It's very well equipped with features for RDBMS. 2. Storing and retrieving data with ease 3. Development using SSMS is a good experience for backend developers like me. 4. Multi-language support, BLOB data storage. 5. Writing DB queries and their proper analysis for query optimization is easy with the use of SQL Server Profiler. 6. Many more features like DB backup, monitoring and SQL server job creation features are also used and liked. **What do you dislike about Microsoft SQL Server?** Compared to Oracle, the SQL server is a bit on the slower side in terms of performance. But support is excellent from Microsoft team. **What problems is Microsoft SQL Server solving and how is that benefiting you?** Query writing, query optimization, DB backups, DB job creation etc As a backend developer, I used the features mentioned in my day-to-day life for rapid enterprise application development. ### 39. Perfect Database Solution **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Pharmaceuticals | Enterprise (> 1000 emp.) **Reviewed Date:** March 06, 2024 **What do you like best about Microsoft SQL Server?** Integration-friendly with various platforms, SQL is also user-friendly and easy to troubleshoot. **What do you dislike about Microsoft SQL Server?** Low code no code should be followed from the very beginning to avoid complexity in the future. **What problems is Microsoft SQL Server solving and how is that benefiting you?** SQL helps build custom PowerBI reports as per complex business requirements. ### 40. One Stop Resolution for all data needs **Rating:** 5.0/5.0 stars **Reviewed by:** Naveen P. | Senior Business Intelligence Analyst, Consumer Electronics, Mid-Market (51-1000 emp.) **Reviewed Date:** September 18, 2023 **What do you like best about Microsoft SQL Server?** SQL server is easy to use to store huge amount of data. **What do you dislike about Microsoft SQL Server?** SQL server licencing model is little expensive. **What problems is Microsoft SQL Server solving and how is that benefiting you?** It's really useful to store data in structured format. also we can retrive that easily by writing query language. and it's simple to learn in less span of time ### 41. Useful for better growth. **Rating:** 3.5/5.0 stars **Reviewed by:** Vivek G. | Analyst, Enterprise (> 1000 emp.) **Reviewed Date:** November 30, 2023 **What do you like best about Microsoft SQL Server?** It's easy to use in implementation, integration and frequecy of use also it provides a better customer support. **What do you dislike about Microsoft SQL Server?** Need of integartion with openai, grok, bard, perplexity.ai like platform, for better and smoth productivity. **What problems is Microsoft SQL Server solving and how is that benefiting you?** It gives better inbuilt functionality to do required server side programming for the business or people. ### 42. SQL Server is mostly useful to keep your data in mannered structure **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Mechanical or Industrial Engineering | Small-Business (50 or fewer emp.) **Reviewed Date:** January 29, 2024 **What do you like best about Microsoft SQL Server?** It has lots of features like easy to use, good portability, high security etc. **What do you dislike about Microsoft SQL Server?** It has some limited scalability. Also, for some features it may require high costing. **What problems is Microsoft SQL Server solving and how is that benefiting you?** For me, I can store for each environments like DVLP,QA and PROD on different servers or connection strings. So, that they can be easily manageable. ### 43. Ms SQL server **Rating:** 4.5/5.0 stars **Reviewed by:** Chetan B. | Small-Business (50 or fewer emp.) **Reviewed Date:** August 18, 2023 **What do you like best about Microsoft SQL Server?** It's is software tool it used to enter query and manage data base and it is easy to use the software were handled large data set query was similar to mys SQL only so it was very helpful to have **What do you dislike about Microsoft SQL Server?** Because nowdays every company uses Oracle and my sql so the demand was less and managing cloud in very difficult so some how it dislike **What problems is Microsoft SQL Server solving and how is that benefiting you?** It solves complex problem when we handled large database and tools was so easy to learn it is way capture by fresher and installation process are also so easy ### 44. Data In Your Hands - Most Secured Database **Rating:** 4.5/5.0 stars **Reviewed by:** sowdepalli s. | Business Intelligence Analyst, Enterprise (> 1000 emp.) **Reviewed Date:** September 18, 2023 **What do you like best about Microsoft SQL Server?** MS SQL server is user friendly and Easy to understand from ground level **What do you dislike about Microsoft SQL Server?** The main concern is its License too expensive to buy **What problems is Microsoft SQL Server solving and how is that benefiting you?** Data Optimising,Data base Backups,I used the features mentioned in my day-to-day life for extracting historical data . ### 45. Working with RDBMS makes easier **Rating:** 5.0/5.0 stars **Reviewed by:** Mamata K. | Technical Lead, Enterprise (> 1000 emp.) **Reviewed Date:** May 19, 2023 **What do you like best about Microsoft SQL Server?** It is best suited for RDBMS structures. Performing DDL, DML, DCL queries are easy if you have SQL knowledge. Gives privileges to have store procedures, views, functions, triggers makes easier. Good for small or medium scale applications. **What do you dislike about Microsoft SQL Server?** If you are dealing with large number of data then fetching records are slow. So, normalisation is key but if not done properly then performance hits. **What problems is Microsoft SQL Server solving and how is that benefiting you?** Installation and making setup is not that difficult and good fit for small and medium applications. Less complex then non-sql databases. ### 46. MS SQL- Microsoft's Redemption **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Hospital & Health Care | Enterprise (> 1000 emp.) **Reviewed Date:** August 10, 2023 **What do you like best about Microsoft SQL Server?** The robust and resilient structured query language box that never ceases to amaze you in your quest to data sanity and digital transformation journey. Worth every penny. **What do you dislike about Microsoft SQL Server?** The learning curve associated with the tool. The syntax and semantics of the queries is often hard to grasp and apply in day to day activities of your company/service. **What problems is Microsoft SQL Server solving and how is that benefiting you?** Querying data for creating digital roadmap of the company transformational journey. Provision of views and tables that enable reporting and envisioning data sets. ### 47. Awesome Database management Tool **Rating:** 5.0/5.0 stars **Reviewed by:** Alok P. | AR Analyst, Mid-Market (51-1000 emp.) **Reviewed Date:** August 01, 2023 **What do you like best about Microsoft SQL Server?** Microsoft SQL Server is best Database Management tool I have been using.It is best tool which reduces time and efforts and comprehensive and robust database management.It's installation process is very smooth. **What do you dislike about Microsoft SQL Server?** Micrsoft SQL Server is best tool for Database management and classifies the Data into multiple segments.I don't really dislike about this product. **What problems is Microsoft SQL Server solving and how is that benefiting you?** Microsoft SQL Server is best tool for Database management and best for Big data processing on Platform.Very smooth for Integration and works on relational databases . ### 48. Get data faster from database **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Food & Beverages | Small-Business (50 or fewer emp.) **Reviewed Date:** January 02, 2024 **What do you like best about Microsoft SQL Server?** Get execution graph for better performance.can do multiple join to get data from different tables **What do you dislike about Microsoft SQL Server?** Doea not supported unstructured data like json data **What problems is Microsoft SQL Server solving and how is that benefiting you?** Get data from different tables which will be used for important reporting purposes ### 49. Big data machine **Rating:** 5.0/5.0 stars **Reviewed by:** Jessica S. | Founder/CEO, Hospital & Health Care, Enterprise (> 1000 emp.) **Reviewed Date:** July 20, 2023 **What do you like best about Microsoft SQL Server?** Thus is super fast and handles an immense amount of data using the Server Database Engine. It is super secure with much storage for relational data. **What do you dislike about Microsoft SQL Server?** It is too complex a process to setup than other software and is best used by larger companies. Too complicated for smaller enterprises. **What problems is Microsoft SQL Server solving and how is that benefiting you?** We have a tremendous amount of data and many similar data sets but the UNIQUE constraint allows us to just a similar language without duplicate entries removing many errors. ### 50. SQL Server: The road to anaytics **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Chemicals | Mid-Market (51-1000 emp.) **Reviewed Date:** June 20, 2023 **What do you like best about Microsoft SQL Server?** SQL Server is very ease to use. The installation process is really user friendly. SQL Server interface is very user friendly. We can run multiple queries in different pages at a time. The performance is very good. **What do you dislike about Microsoft SQL Server?** There are very little suggestions provided when writting any queries in the Microsoft SQL Server via the SSMS tool. Connecting to different connections at a single time compromises the performance of the query execution. **What problems is Microsoft SQL Server solving and how is that benefiting you?** We execute different types of queries before creating dashboards or reports in the business analytics tools . We try to create joins between different tables and check the performance of the queries in the database. Creating Materialized views and stored procedures as part of the data model for business analytics tool. ## 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?page=3§ion=pricing&secure%5Bexpires_at%5D=2026-06-08+23%3A52%3A51+-0500&secure%5Bsession_id%5D=b601fc1f-c6bd-4f86-9832-b933944c1099&secure%5Btoken%5D=e5d2ccda0652159de4d09dfef4b331e19a80e7bf4d0e062a25084dafb99c785a&format=llm_user) ## Microsoft SQL Server Integrations - [Agentforce 360 Platform (formerly Salesforce Platform)](https://www.g2.com/products/agentforce-360-platform-formerly-salesforce-platform/reviews) - [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 Work Management](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) - [Tableau](https://www.g2.com/products/tableau/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 (355 reviews) - [SAP HANA Cloud](https://www.g2.com/products/sap-hana-cloud-2025-10-01/reviews) - 4.3/5.0 (522 reviews) - [Google Cloud SQL](https://www.g2.com/products/google-cloud-sql/reviews) - 4.5/5.0 (354 reviews)