Microsoft SQL Server Reviews & Product Details

I like the easy to understand user interface. Database hierarchy on the left, and any scripting or other windows on the right. It's easy to code stored procedures, see the layout of databases, and other information at my fingertips. I use it all the time in conjunction with SQL Management Studio. It was superbly easy to set up and use. Review collected by and hosted on G2.com.

I've never been a fan of the intricacies of database security - I leave that for the database administrators. Review collected by and hosted on G2.com.

Security: SQL Server offers comprehensive security features, including encryption, row-level security, dynamic data masking, and integration with Microsoft Entra ID (formerly Azure Active Directory), ensuring data protection from unauthorized access. Review collected by and hosted on G2.com.

Cost and Licensing Complexity: SQL Server can be expensive, particularly for large-scale deployments or those requiring advanced features. The licensing models can also be intricate and challenging to navigate, leading to higher total cost of ownership compared to open-source alternatives. Review collected by and hosted on G2.com.

The capabilities to manage not only relational data, but documents like XML or JSON. Great for DR, with nice RTO and RPO. Awesome for replication like read replicas with log shipping. Flexible for user administration and robust permission sets. Great integration with OS, Windows, obviously. Review collected by and hosted on G2.com.

I only dislike the prices and the integration with Linux, no capabilities to execute commands. Review collected by and hosted on G2.com.

Its robustness to handle all kind of data for effective storage and presentations in form of analytics. I like it for automated backup and restoration. Have nicest menus. Review collected by and hosted on G2.com.

It a heavy taking a lot of computer space and resources for which old machines can be frustrating. Review collected by and hosted on G2.com.

I like Microsoft SQL Server for its reliability, strong performance, easy integration with other Microsoft tools, and powerful features for managing and analyzing data Review collected by and hosted on G2.com.

At times, it can feel a bit heavy, and the licensing costs may be quite high, particularly for smaller teams or projects. Review collected by and hosted on G2.com.

The user-friendly, GUI, dedicated SQL dialect for more advanced queries. Review collected by and hosted on G2.com.

To see the output, we have to select the entire query and click execute. The syntax is not straight forward like MySQL. Review collected by and hosted on G2.com.

It seamlessly integrates with my ASP.NET and PHP applications, making it my preferred choice for development. Review collected by and hosted on G2.com.

I don't like that it takes a long time to load. Review collected by and hosted on G2.com.

What I like best about Microsoft SQL Server is its robust performance, scalability, and advanced security features. The platform offers excellent tools for data management, backup, and recovery, along with seamless integration with other Microsoft products. Its intuitive interface and strong support for complex queries make it ideal for large enterprises managing high volumes of data. Review collected by and hosted on G2.com.

What I dislike about Microsoft SQL Server is its high licensing costs, which can be a barrier for smaller businesses or startups. Additionally, it can be resource-intensive, requiring significant hardware and infrastructure for optimal performance, especially in large-scale environments. Review collected by and hosted on G2.com.

Everything. It is the easiest to use, the most powerfull in the market, it allow you manage the database, the users, etc. Review collected by and hosted on G2.com.

One of the worst thing about Microsoft SQL Server is that you need to pay to use it in all of their functions Review collected by and hosted on G2.com.

It’s an all‑in‑one data platform. Performance tuning is powerful and surprisingly friendly.High availability options are mature.It plays nicely with the Microsoft ecosystem Review collected by and hosted on G2.com.

Licensing costs can be steep.Windows‑centric roots still show. High availability can be complex. Scaling out is harder than scaling up Review collected by and hosted on G2.com.