# 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 **Rating:** 4.0/5.0 stars **Reviewed by:** Sonal M. | Programmer Analyst, Information Technology and Services, Enterprise (> 1000 emp.) **Reviewed Date:** March 08, 2019 **What do you like best about Microsoft SQL Server?** Very efficient RDBMS and attractive GUI based database. It allows you to modify almost every interface from the UI. I like the poweful profiler provided by Microsoft sql server that is really amazing tool for debugging the real time production issues. Profiler works as a last resort some time for fixing potentia production issues. **What do you dislike about Microsoft SQL Server?** Does not clear up space directly after deleting the records from table and you will need to perform operations to free up the actual space on the server. Consumer much memory on the database server so designated server is must for MS Sql server. **Recommendations to others considering Microsoft SQL Server:** Sql server is really a efficient RDBMS system to handle middle to large amount of data efficiently. I always recommend it. **What problems is Microsoft SQL Server solving and how is that benefiting you?** Data management for our web application and reporting system. This is fast and excellent database and also has all required functionality. ### 2. Great SQL software with many tools for many purposes **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Real Estate | Mid-Market (51-1000 emp.) **Reviewed Date:** August 30, 2019 **What do you like best about Microsoft SQL Server?** The script generator, tasking options, views/diagrams generator (which includes a visual making of relationships) and backup options. It's easy to connect this database with other tools and apps. **What do you dislike about Microsoft SQL Server?** The lack of design in the interface, it's kind of the same compared with older versions. It has the same problem from older versions: When the session timeout is up, you have to restart the interface in order to connect again and execute queries, because currently if the connection is lost and you reconnect again, the query you were working on will fail. **Recommendations to others considering Microsoft SQL Server:** You should use MS SQL for corporate apps, analytics and datawarehouse, because the connectors it has are easy to use and debug. **What problems is Microsoft SQL Server solving and how is that benefiting you?** Migrating from office tools to web applications, decrease data vulnerabilities, add data administration and centralization. ### 3. Review for SQL to show his strength **Rating:** 5.0/5.0 stars **Reviewed by:** Manoj S. | Mr., Mid-Market (51-1000 emp.) **Reviewed Date:** July 29, 2019 **What do you like best about Microsoft SQL Server?** The best part of this tool to manage database very easily and you can access the data properly, if get some error you check easily using this tool **What do you dislike about Microsoft SQL Server?** Till now I didn't get any drawback using this tool **Recommendations to others considering Microsoft SQL Server:** Yes I will recommended to my friends and other company to use this tool **What problems is Microsoft SQL Server solving and how is that benefiting you?** MicroSoft SQL its a great tool for manage accessing data, manage relationship between tables etc. ### 4. Excellent database RDBMS backed my Microsoft **Rating:** 4.5/5.0 stars **Reviewed by:** Hung V. | Solutions Architect, Enterprise (> 1000 emp.) **Reviewed Date:** April 30, 2019 **What do you like best about Microsoft SQL Server?** Microsoft SQL Server has strong support with .Net and other Microsoft software help to reduce the time for setup application framework and coding effort. It is very reliable, it provides stable performance and behaviour, it provides a wide range of feature and function which may not exist in another database SQL Server could setup quickly on both standalone or cluster and run with little management effort, it supports multi-user mode allow us to use one server for different projects **What do you dislike about Microsoft SQL Server?** Lacking effective client tool to working with database, it requires experience skill for performance tuning, the Documentation is too complex **Recommendations to others considering Microsoft SQL Server:** Strongly recommend for all projects which use .Net framework, Microsoft SQL could fulfil all requirement for performance, scalability and reliable **What problems is Microsoft SQL Server solving and how is that benefiting you?** We use Microsoft SQL on both local and Azure as the primary database for our project which uses .Net framework, it helps to reduce developemnt effort and increases product quality. ### 5. Best Tool-set for Data Management **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Real Estate | Enterprise (> 1000 emp.) **Reviewed Date:** October 02, 2019 **What do you like best about Microsoft SQL Server?** MSFT SQL offers the best range of tools for database management. It integrates well with incomparable number of software. My team and I use it frequently to retrieve data. It's super easy to insert, delete, and update records when I find it necessary. The user interface has that similar Microsoft feel to it. **What do you dislike about Microsoft SQL Server?** It is often difficult for beginners to set up the initial installation, and so I'd recommend having a dedicated IT person or someone who can assist with the initial set up. **What problems is Microsoft SQL Server solving and how is that benefiting you?** With MSFT SQL, we solve the problem of day-to-day database access. MSFT SQL makes the process a breeze once you get the hang of it. ### 6. Multiple databases management made easy **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Education Management | Mid-Market (51-1000 emp.) **Reviewed Date:** July 21, 2019 **What do you like best about Microsoft SQL Server?** SQL server has a good performance which helps to store and retrieve data easily. The user interface is simple and easily adaptable. Adding new databases and integrate it with an application is easy. Easy to write queries as it suggest queries when writing. Multiple databases are running with SQL server and no problem at all. Security is good because data has encrypted. **What do you dislike about Microsoft SQL Server?** SQL server requires high resources to run smoothly. **What problems is Microsoft SQL Server solving and how is that benefiting you?** There are many features that help our developing team. I was able to insert and retrieve data quickly with Microsoft SQL. Using Stored Procedure, I can reduce my repetitive queries. SO it helped me increase my productivity. ### 7. Best database management studio in market. **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Computer Software | Enterprise (> 1000 emp.) **Reviewed Date:** April 24, 2019 **What do you like best about Microsoft SQL Server?** With SQL server it's quite manageable to work with web based applications as the response time is very fast using SQL server . It is equipped with latest security changes related to transactional changes , database partitioning . Advance features like user defined procedures, functions and tables support as well. It integrates well with other Microsoft softwares as well like visual studio using entity framework. Another advance feature includes - Repetitive actions can be managed with SQL server agent (Jobs) . **What do you dislike about Microsoft SQL Server?** When database size increase beyond 200GB it takes a bit time to respond as compared to small database size and second is Microsoft license fees that needs to be considered here. **Recommendations to others considering Microsoft SQL Server:** SQL server is must have back end for web based technologies with its advance features and application integration it's one of the best relational database to be considered. **What problems is Microsoft SQL Server solving and how is that benefiting you?** SQL server acts as a backbone for our all projects, web based solutions are supported by SQL. With SQL complex data is converted to meaningful data. ### 8. Microsoft SQL SERVER - RDBMS tool **Rating:** 4.0/5.0 stars **Reviewed by:** Rahul G. | Software Development & Sales Manager, Small-Business (50 or fewer emp.) **Reviewed Date:** April 24, 2019 **What do you like best about Microsoft SQL Server?** It is a very mind boggling and complete database administrator, it is vigorous and can store a lot of information and records, it is perfect with windows application ventures with visual fundamental, it has high security. information and access to data, additionally has help colleagues for the elaboration of questions between related tables. we can perform debugging by using profiler. **What do you dislike about Microsoft SQL Server?** The primary weakness of Microsoft SQL SERVER is the colossal amount of RAM that it uses to install and utilize the product. For the rest I have nothing negative to confine. **Recommendations to others considering Microsoft SQL Server:** It is data management platform with remote synchronization and management-oriented application execution in offices and small departments. Every company or SME, I recommend using this product.You can connect your teammates on company's network with SQL Instances.This is great product for database manageent. Additionally has help colleagues for the elaboration of questions between related tables. we can perform debugging by using profiler. **What problems is Microsoft SQL Server solving and how is that benefiting you?** Extremely cost is beneath different brands of database handlers. Further more, if we work on a local network we can add other SQL Server ### 9. Secure data storage data base system for Windows applications **Rating:** 5.0/5.0 stars **Reviewed by:** Rosie Z. | Cyber Security Analyst, Mid-Market (51-1000 emp.) **Reviewed Date:** August 29, 2019 **What do you like best about Microsoft SQL Server?** Microsoft SQL is easy to manage and utilize and contained inbuilt tools. Effectively we can take network backups of a database. SQL give administrations to both web and applications. **What do you dislike about Microsoft SQL Server?** Nothing to say as bad, all features functioning well. **Recommendations to others considering Microsoft SQL Server:** Easy to use and manage, all the applications data base in one data base. **What problems is Microsoft SQL Server solving and how is that benefiting you?** I have used Microsoft SQL Server databases from 2013, as well as experience in the development of Mobile, Web and desktop applications in our company. We are developing big data handling applications using SQL server. ### 10. I love microsoft tools **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Hospital & Health Care | Enterprise (> 1000 emp.) **Reviewed Date:** July 30, 2018 **What do you like best about Microsoft SQL Server?** It's Easy to use . The simplicity and integrity of tools result in doing the job easier .SQL is not a programming language, it's a query language which is not difficult to learn, Installation Is Streamlined and you can efficiently manage your log and data files. **What do you dislike about Microsoft SQL Server?** I do not like Microsoft project because of trouble in communication.High CPU usage and it only runs on Windows so it is not cross-platform. It is not free and is not open source. **Recommendations to others considering Microsoft SQL Server:** It is important to maintain an environment which is standardized It’s important to understand that only the required security permissions should be given to the user.You should not give developers administrative permissions. **What problems is Microsoft SQL Server solving and how is that benefiting you?** Business Intelligence - Data Warehouse- Data Integration ### 11. LOVE SQL Server **Rating:** 5.0/5.0 stars **Reviewed by:** Mo Z. | DBA/Sr Analyst, Mid-Market (51-1000 emp.) **Reviewed Date:** August 26, 2019 **What do you like best about Microsoft SQL Server?** Flexibility. Ability to add on most anything we need now and in the future for integration and reporting needs. **What do you dislike about Microsoft SQL Server?** There is nothing I do not like. I love SQL and everything we can do with it. **What problems is Microsoft SQL Server solving and how is that benefiting you?** Data blending, custom reporting. Ability to report from multiple databases across multiple servers. ### 12. Most Common relational DataBase **Rating:** 4.0/5.0 stars **Reviewed by:** Sunil Kumar M. | RPA Developer, Information Technology and Services, Small-Business (50 or fewer emp.) **Reviewed Date:** April 27, 2019 **What do you like best about Microsoft SQL Server?** It gives you up to 10 Gb data storage for free. Above 10 Gb it will Charge you. It fully supports the Microsoft product. It very much compactable with ASP.net ..net application is easily configured with MySQL database. Query syntax can get you from it MSSMS. **What do you dislike about Microsoft SQL Server?** It not that compatible with other languages like node.js, python. For extreme level programmers they can everything; But for a common programmer it quite difficult to handle database with your program. **Recommendations to others considering Microsoft SQL Server:** For small scale business, you can MSSQL as your database. It gives you storage free up 10 GB.For Beginner developer who thinks like that they can do easily configure with their application, It wrong. It is challenging first you have to familiar with MSSQL Then Think about Integration. **What problems is Microsoft SQL Server solving and how is that benefiting you?** Inventory management system with node js and MSSQl.It is a web-based application. All like rest API, Express js and MSSQL Database ### 13. Reliable RDBMS **Rating:** 4.5/5.0 stars **Reviewed by:** Samiksha G. | Business Intelligence Developer, Enterprise (> 1000 emp.) **Reviewed Date:** June 18, 2019 **What do you like best about Microsoft SQL Server?** Microsoft's SQL Server is one of the best RDBMS , when compared to competitors like Postgres, Oracle, MongoDB, Mysql, etc. I have been using this product for more than 5 years, and it's relatively simple interface makes it very easy to use. I like its availability on Azure, which makes it even handier. **What do you dislike about Microsoft SQL Server?** The costing of the product is quite much. Sustainable for big companies, but not for standalone users. Express editions have very limited functionalities **What problems is Microsoft SQL Server solving and how is that benefiting you?** Managing transactional data on the server. We have our institutions' production server as the SQL server. All the data, which is transactional in nature is maintained on this server, the main portals and applications are drawing data from this server. Security provisions are great. ### 14. Data Warehouse Programmer **Rating:** 5.0/5.0 stars **Reviewed by:** Al S. | Data Warehouse Programmer, Enterprise (> 1000 emp.) **Reviewed Date:** January 31, 2019 **What do you like best about Microsoft SQL Server?** Team Microsoft; I cannot thank you enough for the flawless technical support that you’ve given me over the last couple of weeks.The titles that you created (Matthew) for the Power BI presentation were a big hit; and the Power BI dashboard extravaganza unfolded on cue with perfect precision. My colleagues were as impressed with me as I am with you. You also did a marvelous job researching the Vice President and CFO questions (Mark) and I know that I didn’t always give you much to go on and recommending exactly software for their preferences. Without your help, I don’t think I could have met the short but urgent deadline. Regarding all for the SQL Server on Microsoft Azure Public Cloud Platform Provider. I feel much better knowing that I have such a valuable and capable resource a phone call away. Respectfully yours; Thanks, **What do you dislike about Microsoft SQL Server?** Total cost benefit analysis including hidden costs on an annual basis plus options for contractual agreement, e.g. annual agreement / multi-year agreement, technical support included etc. Regarding all for the SQL Server on Microsoft Azure Public Cloud Platform Provider. **What problems is Microsoft SQL Server solving and how is that benefiting you?** Globe access for five Data Regional Setup for Azure Machine Learning Studio Dallas, Sweden, India, China and Brazil setup of Microsoft Azure SQL Server databases. Using software Power BI for Analytics Platform for digital dashboards and SQL Server Reporting Services and SharePoint website access. ### 15. i love to work with Microsoft SQL **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** July 02, 2019 **What do you like best about Microsoft SQL Server?** it's easy to write and easy to understand and does the job really fast and gives an instant result based on my query. storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network **What do you dislike about Microsoft SQL Server?** some times it gets little slow depends on the load of the data but otherwise, somehow some SQL Server services (VSS Worker for example) stops working immediately I have to manually activate it in order to work **Recommendations to others considering Microsoft SQL Server:** if the single data file size of tempdb is 8 GB, and the Log file size is 2 GB, the recommendation is to increase the number of data files to eight (8) (each of 1 GB to maintain equal sizing), and leave the log file as is. Having the different data files on separate disks would be provide additional performance benefit. However, this is not required. The files can co-exist on the same disk volume. **What problems is Microsoft SQL Server solving and how is that benefiting you?** i mostly use it to validate data and extract data from different tables to analyze it. ### 16. Powerful database with a really good and intuitive editor. **Rating:** 4.5/5.0 stars **Reviewed by:** Marko P. | Helpdesk Agent level 2 Managed Services Operations Retail & Hospitality Helpdesk, Information Technology and Services, Enterprise (> 1000 emp.) **Reviewed Date:** January 30, 2019 **What do you like best about Microsoft SQL Server?** Creation, administration and management of the database is really easy, even for beginners. It is fast and stable and it works good with other Microsoft products. I feel right at home when I'm using SQL Server Management Studio. It has a practical UI and of course a really helpful intellisense feature. The problems which my team and I solve require fast response and fast solutions and Microsoft SQL is of great help with that. **What do you dislike about Microsoft SQL Server?** The price of the enterprise package might be too high for smaller companies, but I think that Microsoft's target with this product are large organizations/corporations (like mine). **Recommendations to others considering Microsoft SQL Server:** This is a product aimed at big companies/corporations with a lot of users and big databases. If you are a small company/team, there are some other more practical solutions. It is rather easy to use and highly practical. I need to stress again how fast Microsoft SQL is - that might a be big factor for some teams like mine. **What problems is Microsoft SQL Server solving and how is that benefiting you?** My team handles a major part in administration and management of the database for one of the big US supermarket chains. Without getting into too many details, we run a lot of scripts and queries through thousands of items and transactions in order to find the cause of problems and bugs which happen during customer interactions with the Self checkouts. The speed and ease of use which Microsoft SQL is offering help us a lot and allows us to quickly pinpoint the issues. ### 17. Industry standard for databases **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Banking | Enterprise (> 1000 emp.) **Reviewed Date:** November 14, 2019 **What do you like best about Microsoft SQL Server?** Performance: developers and administrators have the ability to adjust their performance to meet application requirements. **What do you dislike about Microsoft SQL Server?** Required resources: both system resources and other considerations for maintenance and in-house support can be heavier compared to other solutions. **Recommendations to others considering Microsoft SQL Server:** Because internal developers are well informed in SQL Server, little external support is needed **What problems is Microsoft SQL Server solving and how is that benefiting you?** Basically, everything our business does enters this system, giving you a very important access to data. Although SQL Server is a necessary component of NAV, the system needs to run continuously and be reliable. ### 18. SQL is my go to DBMS **Rating:** 5.0/5.0 stars **Reviewed by:** Carlo L. | Integration Analyst, Small-Business (50 or fewer emp.) **Reviewed Date:** August 20, 2019 **What do you like best about Microsoft SQL Server?** I have been using SQL Server since I was 20 years old! It is a very secure database management system and easy to use! **What do you dislike about Microsoft SQL Server?** SQL Server is very resource intensive and requires somewhat of a beefy system to run smoothly. **What problems is Microsoft SQL Server solving and how is that benefiting you?** My company uses SQL for our software application's back end. ### 19. A complete solution for all you database needs. **Rating:** 4.5/5.0 stars **Reviewed by:** Hussain S. | Member Of Technical Staff - 3, Enterprise (> 1000 emp.) **Reviewed Date:** April 12, 2019 **What do you like best about Microsoft SQL Server?** One of the key feature of Microsoft SQL Server is its installation which is very straight Forward nothing fancy which makes the developer or the user aware of whats this going to install and check and uncheck its feature accordingly. Other Microsoft SQL Server which I like the most is its prices which are very competitive and cost efficient. And I can tell you this it will bring down your overall cost of operation. So choose wisely. After all this product come directly from MS performance and security are least concerned issues. **What do you dislike about Microsoft SQL Server?** On the things which personally I don't like is its humongous size which it take during installation on disk. **Recommendations to others considering Microsoft SQL Server:** Yes, as a user of Microsoft SQL I'd Definitely suggest SQL to my peers and colleagues who are looking for solution in that direction. **What problems is Microsoft SQL Server solving and how is that benefiting you?** Due it efficiency and performance the time takes to execute complex operation is comparatively low. Cost effective. ### 20. MSQL : A Daily Tool **Rating:** 4.5/5.0 stars **Reviewed by:** Sohel S. | System Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** April 15, 2019 **What do you like best about Microsoft SQL Server?** The user friendly design with newly added functionalities every year. SSMS is fastest and most popular dbms tool I have used. The most effective functionality for me is add database servers and see all the servers list and execute queruy in different servers at the same time. The SQL server profiler is the best tool to monitor the transactions and we can even view the connection string. Newly even SSMS supports R language integration. **What do you dislike about Microsoft SQL Server?** There is nothing much to dislike about ssms. The only thing is that the software could be more lightweight to maintain more speed. The SQL server profiler could be integrated inside ssms only to maintain user friendliness. **Recommendations to others considering Microsoft SQL Server:** no where else to look for. SSMS will be the best tool to manage your data. SQL server management tool is the best tool where you can even look at the profiler for detailed information regarding all the transaction. **What problems is Microsoft SQL Server solving and how is that benefiting you?** We use ssms to maintain the database while it interacts with our .net application to exchange data. So we use ssms to receive data from webservice, tp put them into our database and vice-versa. ### 21. Microsoft SQL server Management **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Health, Wellness and Fitness | Enterprise (> 1000 emp.) **Reviewed Date:** August 02, 2019 **What do you like best about Microsoft SQL Server?** The aspect that I love the most about MS SQL server Management is the layout and setup of the databases inside the tool and also how the queries are not case sensitive unlike some other softwares. It allows you to query very large datasets within a very short response time. **What do you dislike about Microsoft SQL Server?** The one aspect that I do not enjoy about MS SQL server management is the installation process of the software. The entire installation process is very lengthy and time consuming and requires multiple restarts where is very inconvenient. **Recommendations to others considering Microsoft SQL Server:** I would highly recommend others to use MS SQL server management for data analytics and business intelligence purposes. **What problems is Microsoft SQL Server solving and how is that benefiting you?** I am using MS SQL server management to retrieve and manipulate business data on the back-end to provide insightful information that can help make better business decisions. ### 22. Using the SQL Server **Rating:** 4.0/5.0 stars **Reviewed by:** Sushmitha E. | Associate Software Developer, Small-Business (50 or fewer emp.) **Reviewed Date:** September 15, 2019 **What do you like best about Microsoft SQL Server?** Sql Server is easy to use and write queries, store procedures. Compare to other databases, the db backup is easy and fast. **What do you dislike about Microsoft SQL Server?** Bit confusion while installing this server in machines. **What problems is Microsoft SQL Server solving and how is that benefiting you?** Used in web applications development. ### 23. Best SQL tool from Microsoft family **Rating:** 5.0/5.0 stars **Reviewed by:** YuvaTheja E. | Lead, Development , Information Technology and Services, Enterprise (> 1000 emp.) **Reviewed Date:** April 10, 2019 **What do you like best about Microsoft SQL Server?** MS Sql is one of the best relational databases available in the market currently. As its directly coming from Microsoft its compatible with almost all the applications developed by Microsoft. Its a breeze for .Net developers to make use of it in their applications because of its easy integration capabilities and strong encryption techniques. One would love to write queries in MS sql compared to that of MySQL or Oracle PLSQL. I sincerely recommend it to all .Net developers out there as it eases the pain for integrating another DB because its already embedded in Microsft framework stack. **What do you dislike about Microsoft SQL Server?** Nothing as such but I would suggest Microsoft to improve MS SQL comaptibility with other operating systems as well like Linux and MAC-os. Also, Microsoft SQL doesn not support multiple storage engines as one would need a flexible storage system with growing data it would be a good to have feature. **Recommendations to others considering Microsoft SQL Server:** I would certainly recommend it to all customers and .Net developers for its security and ease of use. **What problems is Microsoft SQL Server solving and how is that benefiting you?** We have used Microsoft SQL in many of our Applications. From simple credential managing solution to complex transaction data storage solution. It can be used in a variety of ways to enable security and boosted performance while used in conjuction with applications developed in Microsoft stack, ex: Microsoft Visual Studio. Being a .Net developer I always used MS SQL because of Security and easy integration with .net framework. ### 24. SQL server - A robust database tool **Rating:** 4.5/5.0 stars **Reviewed by:** Sachin K. | Group Lead, Mid-Market (51-1000 emp.) **Reviewed Date:** January 22, 2019 **What do you like best about Microsoft SQL Server?** To manage all of our data of various customer products, we use sql server. This is a microsoft product, so we are much satisfied with product service. It is very reliable and easy to use tool. We can store, process and execute very large amount of data. Very easy to learn its programming language. Very great features such as SQL server agent, profiler, reporting etc.. One can use for all his needs of database. **What do you dislike about Microsoft SQL Server?** Every good tool has its own limitations. First of all its cost. It is very high. We need good amount of RAM to properly use this. Sometimes query stucks in between. But our organization provides a great RAM, so we don't have any issue with its speed. **What problems is Microsoft SQL Server solving and how is that benefiting you?** I am using this tool from past 8 years. I use to manage data feom various products of my company. It is very easy to learn and manage. I highly recommend this rdbms tool to everyone. ### 25. A powerful all times standard **Rating:** 5.0/5.0 stars **Reviewed by:** Javier Victor M B. | Infrastructure Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** May 01, 2019 **What do you like best about Microsoft SQL Server?** SQL Server was the mos robust scalable database solution for big environment, and small too with the SQL Lite version. We use MySQL as well but as government institution the application growed up very quick and suddenly mysql was too small to handle all the info (20+GB databases). So we went back to ours beginnings and use SQL for internal an web applications. **What do you dislike about Microsoft SQL Server?** May be the biggest disadvantages are the price and that it runs on windows (not all sysadmins likes to run a windows server, less for web services) **What problems is Microsoft SQL Server solving and how is that benefiting you?** All our internal government app, and a big web database ### 26. Does database management very well **Rating:** 5.0/5.0 stars **Reviewed by:** Ryan C. | Project Development Coordinator , Enterprise (> 1000 emp.) **Reviewed Date:** April 23, 2019 **What do you like best about Microsoft SQL Server?** Microsoft SQL is a tool used to manage databases, meaning it stores data for users and applications to be able to retrieve this data. We use SQL as a backend to some of our applications. Setting up databases is very easy, as well as retrieving data via queries. You can also store basically unlimited amounts of data. Connecting to the databases is pretty easy as well and currently supports TLS1.2. **What do you dislike about Microsoft SQL Server?** The speed is usually very fast but I have noticed on some clients with huge databases where there are million of results, no matter how spec'ed out the machine is, retrieving data is bogged down. You have to manage databases to make sure no single table builds up too much data. **Recommendations to others considering Microsoft SQL Server:** Database manage.ment made simple **What problems is Microsoft SQL Server solving and how is that benefiting you?** We use Microsoft SQL as a backend to store and manage data for our applications. ### 27. Review on Microsoft SQL Server **Rating:** 4.5/5.0 stars **Reviewed by:** Gunashekhar K. | Guna, Enterprise (> 1000 emp.) **Reviewed Date:** April 03, 2019 **What do you like best about Microsoft SQL Server?** --> It is a Enterprise - grade management Software --> Miscrosoft SQL server includes professional, enterprice level database management software. --> A few Competetitors, such as MySql, have developed similar software in recent years --> But Microsoft SQL server is easier to use and has more features. --> it has full support for triggers , for instance , are sre supproted in microsoft's product. --> --> **What do you dislike about Microsoft SQL Server?** --> Compare to other relational databases Microsoft SQL server licensing options are pretty pricey. --> it has very limited compatibility, Microsoft SQL Server is only designed to run on windows based servers. for various reasons, including licensing cost and security concerns, developers may opt to host their websites on unix based machines. **Recommendations to others considering Microsoft SQL Server:** if you want your data should be more secure, than i can strongly suggest this relational database to use in your compay. **What problems is Microsoft SQL Server solving and how is that benefiting you?** By Using this Relational database any new comer can easily understand the coding and quarries . except the cost it has very good features. for business point of view our data is more secure than the other relational databases. ### 28. My experience summary with sql server database **Rating:** 4.5/5.0 stars **Reviewed by:** Vittal k. | Sr.Software Developer, Mid-Market (51-1000 emp.) **Reviewed Date:** August 30, 2019 **What do you like best about Microsoft SQL Server?** The best SQL database to use and learn and easy to write queries and SPS and functions and also taking backup is easy when comapre with other databases. **What do you dislike about Microsoft SQL Server?** The installation will confuse for fresher. **What problems is Microsoft SQL Server solving and how is that benefiting you?** Used in web application development. ### 29. MS SQL Server for App Development **Rating:** 5.0/5.0 stars **Reviewed by:** Srinivasa T. | Senior Consultant, Mid-Market (51-1000 emp.) **Reviewed Date:** April 02, 2019 **What do you like best about Microsoft SQL Server?** Microsoft SQL Server is very easy to use and user friendly. Including Data integration and import export are extremely easy. Very good at Execution plan visualization. Based on Execution plan you can review query performance and take necessary actions to improve the query performance. It's easy to use interface will give you provision to create tables with GUI adding keys, Constrains make developer life very easy. Git integration with Visual Studio. **What do you dislike about Microsoft SQL Server?** Altering column name seems bet difficult than using GUI **Recommendations to others considering Microsoft SQL Server:** It is very good for Microsoft Technologies integration, also can be integrated with other technologies as well. Very good RDBMS and easy to use. **What problems is Microsoft SQL Server solving and how is that benefiting you?** It is perfect relation database management target to any kinds of applications. We can leverage On Premises or Cloud environment to use SQL Server. It comes with both Native and Cloud Service. Easy to migrate from one Database SQL Server. Migration from on premises to Cloud also very easy. It's integration with Visual Studio is excellent feature. You can do almost all tasks with the help of Visual Studio. Create Data Base project in Visual Studio and integrate it with Git repository for versioning. Version control for Data Base is bit difficult to maintain but using Visual studio it is very easy to achieve. Data Comparison, Schema comparison, Schema synchronization, data synchronization with SQL Server Data Tools made developers life very easy. One has to try SQL Server Data Tools for Agile development. ### 30. Makes Life Easier **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Retail | Enterprise (> 1000 emp.) **Reviewed Date:** June 17, 2019 **What do you like best about Microsoft SQL Server?** SQL makes looking for data so easy. Once you learn it, it's not difficult at all. You can put in queries and for us all I have to do is modify the query just a little to get basically everything I need. I learned through LinkedIn learning which really helped me. I was not taught on the job but it was not difficult. The best thing is the data is really easy to read. **What do you dislike about Microsoft SQL Server?** There is a lot to learn. If you don't have a class or take the time to learn it can be difficult. You can not just jump right in and start getting data. It takes a lot of time to learn. It has good information but it does take a long time to learn. It is worth it to learn it though. It is the best database. **Recommendations to others considering Microsoft SQL Server:** I would go for it. I dont know of any other good DB. **What problems is Microsoft SQL Server solving and how is that benefiting you?** We can get data quickly especially when we have some sort of issue. That really helps out when we are in a bind. No other site is like this. ### 31. Feature rich, highly tunable **Rating:** 5.0/5.0 stars **Reviewed by:** Ron Beau P. | Architect/Developer, Mid-Market (51-1000 emp.) **Reviewed Date:** January 17, 2019 **What do you like best about Microsoft SQL Server?** The query analyzer is a great tuning tool. The ability to embed really anything in a stored proc or an agent job is nice for integrating other systems or using it to manage workflows. Great tools for diagnosing production issues like deadlocks **What do you dislike about Microsoft SQL Server?** The Intellisense doesn't keep up with your changes in the editor. There should be some kind of really good visual tool for building queries. Permissions management is a real chore. It would be nice to have some way to express business logic as a set of rules rather than just write it as t-sql in sored procs, something more analyst-friendly. **Recommendations to others considering Microsoft SQL Server:** Look at the size you need to scale to, Microsoft SQL gets very expensive at scale. **What problems is Microsoft SQL Server solving and how is that benefiting you?** We use it as the hub to move data across enterprise systems )financials, CRM, ERP, etc.). The SSO database is used to encrypt environment-specific meta data (passwords, logons, addresses, etc.). ### 32. Microsoft Sql Server Review **Rating:** 4.0/5.0 stars **Reviewed by:** Som S. | Senior Programmer, Outsourcing/Offshoring, Enterprise (> 1000 emp.) **Reviewed Date:** April 11, 2019 **What do you like best about Microsoft SQL Server?** I like most the SQL query editor which supports intellisense and provides support of query optimizer and inbuilt sql library. Help(F1) keyboard provides details of selected word. Debugging functionality is wonderful if you have local setup of Microsoft SQL server. Works as back-end for multiple frameworks and programming languages. MS Sql server provides multiple solid tools like SQL Profiler and resource manager. Easy to integrate third party plug ins. **What do you dislike about Microsoft SQL Server?** Installation and Setup is time taking and needs some user intervention to complete. SQL query editor has limitation on maximum size of a variable. Debugging is not possible with remote server as i know. **Recommendations to others considering Microsoft SQL Server:** MS Sql Server is an well organized and efficient RDBMS and it fulfills all kind of database requirement. I like using it in comparison to others. **What problems is Microsoft SQL Server solving and how is that benefiting you?** Database management for our application server. Handling reports and data storage has become efficient. ### 33. Easy to learn, implement and use with haste **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Consumer Electronics | Enterprise (> 1000 emp.) **Reviewed Date:** June 30, 2019 **What do you like best about Microsoft SQL Server?** It runs really fast and it has goodfeatures where you can easily filter and sort. Not to mention its good integration and universality **What do you dislike about Microsoft SQL Server?** There's no actual downside but if I'd name one, I'd go and say that more companies show up in Database services sector and some offer more visual tools and features, not leaving all to SQL query but instead be more user friendly. **Recommendations to others considering Microsoft SQL Server:** For its ease of use and universality, Microsoft SQL is a fine choice **What problems is Microsoft SQL Server solving and how is that benefiting you?** Our company has been using Microsoft SQL for years with happiness. We love its speed and integrity. The fact that its almost universal is the key that makes it unique in terms of integration. We use Microsoft SQL to store data, reach data, create data marts and report them in DWH-manner, analyze data using analytics tools, and advanced analytics for forecasting and prediction. ### 34. Industry standard powerful database **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Banking | Mid-Market (51-1000 emp.) **Reviewed Date:** October 22, 2019 **What do you like best about Microsoft SQL Server?** It’s standard. It’s reliable. We run dozens of MSSQL servers for both internal applications and other vendor software. **What do you dislike about Microsoft SQL Server?** The SQL servers are resource hungry and will take all you give it. Tuning performance has been my biggest headache. **What problems is Microsoft SQL Server solving and how is that benefiting you?** We use SQL extensively for data access and storage. ### 35. Easy Query's with MS Sql **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** April 18, 2019 **What do you like best about Microsoft SQL Server?** Ability to be able to use a visual representation to write a query, Update and Insert Statements and also all the layout of the management studio is easy to navigate round **What do you dislike about Microsoft SQL Server?** it has improved over the years but the older versions only allow you databases for free up to a certain size and to buy sql server if you are hitting the limit on the free edition it out prices it for small companies **Recommendations to others considering Microsoft SQL Server:** if you are going to be using large databases and these can be created using an application like mysql or other alternative then this may be a better way to go if the features are available if you would rather not pay the price to have a sql server instance **What problems is Microsoft SQL Server solving and how is that benefiting you?** Restoreing customer databases and also software can be developed to talk to the sql server ### 36. Great SQL Tool, But Too Costly **Rating:** 2.5/5.0 stars **Reviewed by:** Verified User in Luxury Goods & Jewelry | Mid-Market (51-1000 emp.) **Reviewed Date:** September 29, 2019 **What do you like best about Microsoft SQL Server?** Microsoft SQL is feature rich with lots of pre-defined functions available for quick query building and fetching data as required. The Management Studio that comes with it is a really powerful tool for managing the SQL server visually. **What do you dislike about Microsoft SQL Server?** The biggest drawback would be the cost. Not only the Licensing terms are very confusing the cost associated with server & client licenses can shoot fast and high. **What problems is Microsoft SQL Server solving and how is that benefiting you?** Creating & managing relational database with MSSQL has been a good experience. It works similar to other SQL software, but has that "something extra" when compared to others. ### 37. You can do far better for far less **Rating:** 1.0/5.0 stars **Reviewed by:** Verified User in Consumer Goods | Enterprise (> 1000 emp.) **Reviewed Date:** March 23, 2019 **What do you like best about Microsoft SQL Server?** Microsoft SQL Server is reasonably easy to set up and administer, and the graphical tools for managing it are relatively good. Remote connections, management, and administration also work reasonably well. Creating stored procedures for programmatic requirements also works reasonably well. **What do you dislike about Microsoft SQL Server?** The completely proprietary nature of the platform and the high cost are the biggest drivers away from it. Until very recently you had to run it on Windows, and there are still a lot of quirks to it that make it so that it doesn't support the usual range of standard, and that make it just different enough from administering any other SQL-based platform, that it is difficult to justify choosing it as a platform. **Recommendations to others considering Microsoft SQL Server:** Use something else, if at all possible. There are plenty of other RDBMS platforms on the market - some of them freely-available, some of them commercial - and most of them are much better alternatives than SQL Server. It's over-priced, with classically poor support, and just bloated for the service it provides. There's literally no reason to use it unless you are forced to by a developer that has chosen to develop exclusively to it. **What problems is Microsoft SQL Server solving and how is that benefiting you?** Generally I have never used Microsoft SQL to solve any business problems, I am usually driven to it by the requirements of a particular piece of software that is only written for it. **Official Response from Microsoft Team:** > Thank you for your feedback. We will pass this on to the appropriate teams. Additionally, we have multiple SQL Server editions including SQL Express and SQL Developer that are free. https://aka.ms/AA4o51o ### 38. SQL for creating automatic processes within an organization **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** June 07, 2019 **What do you like best about Microsoft SQL Server?** SQL I like that it is an easy-to-use tool and is manageable in every way. There are many tutorials online to be able to create tables, reports, and stored procedures, which makes streamlining processes more fun. Without a doubt, I would recommend it to my colleagues so that they implement it in their organizations to manage all internal data. **What do you dislike about Microsoft SQL Server?** Many times I struggle creating reports and it is very complex because you need to know a lot to use this tool at a high level and in the way I want to visualize it. At that point, the tool is not very user-friendly and I lose a lot of time. **Recommendations to others considering Microsoft SQL Server:** I recommend using this application for daily use so that the organization has real-time and updated information for the reports generated within each area. SQL is easy to integrate with other applications and relate them to work jointly and updated with all areas of the company. Without a doubt, it is recommended as it is an excellent tool. **What problems is Microsoft SQL Server solving and how is that benefiting you?** The reporting at the regional level, handling of sensitive data, real-time information, stored processes, that's why the tool is working for me to solve all those problems within the organization. Additionally, analyzing the company's risk with the data helps me mitigate it correctly. It is an excellent application. ### 39. Sql review from Asp.net 9 years experienced **Rating:** 4.5/5.0 stars **Reviewed by:** Vikas N. | Senior Group Lead & Product owner at OATI, Computer Software, Mid-Market (51-1000 emp.) **Reviewed Date:** September 03, 2019 **What do you like best about Microsoft SQL Server?** I like the TSql, sql agent, debugging tools like profiler and its memeory management the most. **What do you dislike about Microsoft SQL Server?** I don't like the intelligence as compare to visual studio, sometime intelligence get stopped automatically. I need to restart sql server to get it work. **What problems is Microsoft SQL Server solving and how is that benefiting you?** I am using sql as my database for our products in everywhere. It's debugging tools, performance, its execution plan and all. I love to use it in short. ### 40. Despite it's Costs the Application is Excellent in Database Management **Rating:** 4.5/5.0 stars **Reviewed by:** Joseph G. | Information Technology Specialist, Enterprise (> 1000 emp.) **Reviewed Date:** May 26, 2019 **What do you like best about Microsoft SQL Server?** Data collection, classification, processing and analysis is a significant part of the daily routine of our business. The software has seen us undertake all these roles successfully and we cannot regret having it.. Sure, it has a lengthy process of installing, but we found it meaningful. **What do you dislike about Microsoft SQL Server?** The application is not in any way different from other Microsoft products. It is extremely expensive. Not all people and companies can afford it. **Recommendations to others considering Microsoft SQL Server:** I would ask any person there out to use the program to manage their database. There is high chance of having the best data management system using Microsoft SQL. **What problems is Microsoft SQL Server solving and how is that benefiting you?** The software helps in managing all issues related to database. It helps in data processing, masking, and even analysis. ### 41. Best Software for data management **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** October 09, 2019 **What do you like best about Microsoft SQL Server?** There are many best features which helps us to write queries easliy. Stored Procedures creation is very easy here. it has user friendly interface so begineers can easliy learn the syntax . data authentication is strong here so its vert secure. SQL Profiler is best feature to measure the performance of any query. **What do you dislike about Microsoft SQL Server?** Sometimes it got stuck for big queries. Otherwise this is good for me. **Recommendations to others considering Microsoft SQL Server:** This is good software. So I will recommend it to all. **What problems is Microsoft SQL Server solving and how is that benefiting you?** I am writing queries for data verification purpose, ### 42. I have been working with this software from last 3 years. I like this software and used its features **Rating:** 4.5/5.0 stars **Reviewed by:** Santosh R. | DEVELOPER, Small-Business (50 or fewer emp.) **Reviewed Date:** February 20, 2019 **What do you like best about Microsoft SQL Server?** My whole company uses the Microsoft SQL Server, almost every department and team makes use of the SQL Server. Basically, it is used to manipulate and store data for business purposes. Developers use this to handle data of the products on which they are working. I am using SQL server since I joined the company in 2015. Provides good interface and intelligence help to write queries easily. Helps to store and manipulate data. **What do you dislike about Microsoft SQL Server?** Installation takes more time. Due to many features included in SQL Server, it takes large memory and some times it slows down. You need to refresh many times. **Recommendations to others considering Microsoft SQL Server:** I would recommend to this software for middle size companies, or larger corporations who don't have very high transaction velocity. **What problems is Microsoft SQL Server solving and how is that benefiting you?** Using for the backend database support. ### 43. Must have piece of software for analysts **Rating:** 5.0/5.0 stars **Reviewed by:** Beth May Fairfax S. | Pricing Research and Control Analyst, Mid-Market (51-1000 emp.) **Reviewed Date:** October 11, 2019 **What do you like best about Microsoft SQL Server?** Can get data in a way that no other software we have in work can do Can be tailored to your data network Straightforward once you have learned how to use **What do you dislike about Microsoft SQL Server?** Difficult to pick up if you’re a beginner and not too into coding **What problems is Microsoft SQL Server solving and how is that benefiting you?** Data gathering Pricing research Grouping ### 44. Ideal tool for data reporting and data cleaning with best tech support. **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Enterprise (> 1000 emp.) **Reviewed Date:** September 21, 2019 **What do you like best about Microsoft SQL Server?** Its functionalities are pretty much easy to learn and it processes the big chunk of data very comfortably. We can load the external data in it very easily. **What do you dislike about Microsoft SQL Server?** There are no options of visualizing the data or statistical inbuilt functions are not there. **Recommendations to others considering Microsoft SQL Server:** This is the basic and highly used tool in the industry to solve the data reporting problems. Almost every company uses this tool as it is very easy to use and learn. **What problems is Microsoft SQL Server solving and how is that benefiting you?** We use it for reporting purposes only like select the members or to find the counts or to joining the tables. ### 45. Microsoft SQL Server for Enterprise Applications - Healthcare Domain **Rating:** 4.0/5.0 stars **Reviewed by:** Vivek Y. | Software Development Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** March 19, 2019 **What do you like best about Microsoft SQL Server?** The multiple features in Microsoft SQL Server Management Studio - like Scheduling Jobs , ability to easily access Views and Tables , the various features like online index rebuild and plus the new SQL Server 2017 is available on Linux as well. Microsoft SQL Server Machine Learning is also something new which allows legacy organizations to experiment with the data and add new features to the applications . Abilityt to adds scheduled Jobs in Failover Scenarios, **What do you dislike about Microsoft SQL Server?** SQL Server is slow and prone to error , the SQL Server Management Studio is highly complex in some spaces resulting in failures, Some services have no point as features like Master Data Services , Data Quality Services , etc. The startup time is also very slow for SQL Server Mangament Studio and consumes a lot of Memory. **Recommendations to others considering Microsoft SQL Server:** Develop modern features to enhance memory consumption and increased responsiveness **What problems is Microsoft SQL Server solving and how is that benefiting you?** SQL Server is used as a centralized data repository with medical data which enables us to develop custom workflows and manage the vast amount of realtime data in healthcare sector . SQL Server is able to handle large datasets with multiple connections and Job Scdeuling enables plans to backup in failover scenarios ### 46. Sql, Your data always safe **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Telecommunications | Mid-Market (51-1000 emp.) **Reviewed Date:** April 11, 2019 **What do you like best about Microsoft SQL Server?** I like very much to be able to manage the SQL database because it has a very good flexibility, it is one of the most secure database, it still has an excellent security tool, Baseline Security Analyze that is very good in security. **What do you dislike about Microsoft SQL Server?** some of the problems I noticed in sql, it was connection errors, sometimes it does not connect the database, and also problems with some performance problems, this problem also sometimes happens, I think it should analyze and correct. **Recommendations to others considering Microsoft SQL Server:** I recommend sql for all companies wishing to have a solid database with excellent information storage capacity and a lot of security. **What problems is Microsoft SQL Server solving and how is that benefiting you?** Due to its good information storage capacity, I consider sql one of the best database available, as well as good storage, it still has optimum security, so it makes everyone in the company safer. ### 47. Implementation Of Microsoft SQL Server For Relational Databases **Rating:** 4.5/5.0 stars **Reviewed by:** Julio Cesar C. | Ingeniero Senior de Desarrollo, Enterprise (> 1000 emp.) **Reviewed Date:** May 16, 2019 **What do you like best about Microsoft SQL Server?** Processing capacity and volume of information that can be stored, has the ability to run scheduled tasks, integration with reporting services and has a graphical environment for create database schemas,is an ideal database engine to work with relational models, is optimal, fast, stable, secure and supports large amounts of information **What do you dislike about Microsoft SQL Server?** Queries of a gigantic volume of information cause that the Log of the database is filled considerably **Recommendations to others considering Microsoft SQL Server:** Implement strategies to start working with non-relational databases **What problems is Microsoft SQL Server solving and how is that benefiting you?** Microsoft SQL Server is an ideal database engine to work with relational models, is optimal, fast, stable, secure and supports large amounts of information, has the ability to run scheduled tasks, integration with reporting services and has a graphical environment for create database schemas ### 48. MS SQL Server **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** October 21, 2019 **What do you like best about Microsoft SQL Server?** MS SQL Server is a very robust database platform allowing complex queries to be executed **What do you dislike about Microsoft SQL Server?** SQL Server uses a lot of resources compared to other database applications **What problems is Microsoft SQL Server solving and how is that benefiting you?** MS SQL Server allows us to perform complex calculations on our proprietary software applications. ### 49. Smooth querry transaction and retrieval **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** May 28, 2019 **What do you like best about Microsoft SQL Server?** The read and write scripts along with the stored procedure and the query execution is really well with MS SQL compared to other products. We have been using it since the 2012 version and all of them are going really good. With the regular security patches from Microsoft, it helps keep the DB secure as well **What do you dislike about Microsoft SQL Server?** Sometimes when you have Stored procedures which are written in SQL 2012 version when they are compared in 2014 or the current version we see there is a significant change in IO operations and read write operations processing time, we have to record and verify that and identify which querry is now taking more time compared to native. This should be taken care by Microsoft **Recommendations to others considering Microsoft SQL Server:** Pretty good to go ahead there are not much challenges as with experience Microsoft has been fixing things with patches and giving us more and more features in teh new versions **What problems is Microsoft SQL Server solving and how is that benefiting you?** Having the main primary database using MS SQL for our software development. Since its very commonly used everyone is aware about the querry structure as well as stored procedures structure so we dont have to invest in to training the new joinees about this as most are already having the domain expertise. Also we are fetching and storing data in MS SQL where the data redundancy, integrity, confidentiality of data with proper authorization and authentication is already taken care ### 50. Microsoft SQL On Everything **Rating:** 4.5/5.0 stars **Reviewed by:** John H. | IT Services Contractor, Small-Business (50 or fewer emp.) **Reviewed Date:** December 26, 2018 **What do you like best about Microsoft SQL Server?** Over the years, Microsoft finally figured out that MS SQL should run in more places - not just in Windows Server, but regular Windows and now Linux. So now you can just run whatever your platform is, and put MS SQL on it. It even has support for Macs if you can get through that process too. The management platform is probably one of the most user friendly out there. Click, set this up, add a table, call it a day. **What do you dislike about Microsoft SQL Server?** Some things are still esoteric, and you'll have to start looking up basic things. Like "Why can't I log into the machine and need a Windows account" or "How do I do auto-increment"? It's not difficult to figure out, but it's things that should have a "Hi, if you're using this for the first time, these are some things to look for." **Recommendations to others considering Microsoft SQL Server:** Make sure that you have the instructions laid out. While it's easier than ever to install Microsoft SQL, that doesn't mean if you're running Linux or Mac that everything will just go right. Make sure you have the right versions, patches, and the like before you proceed. **What problems is Microsoft SQL Server solving and how is that benefiting you?** I tend to use it because my clients do. In this case, a client had a custom CRM, and they ran it on SQL. Since there's enough plugins from PHP and C# into MS SQL, it wasn't that hard to make a connection so I could get the data I needed and plug it into the program. ## 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=10§ion=pricing&secure%5Bexpires_at%5D=2026-06-11+08%3A11%3A56+-0500&secure%5Bsession_id%5D=ef8af234-d487-4358-a7e0-98544e62c5d1&secure%5Btoken%5D=d5c3d8e2efd4ac7c6ae9d5a399a494acaccf64da6ebf2b239efc62492dda333f&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)