Microsoft SQL Server Reviews & Product Details

As a user of the Express edition, the best feature of Microsoft SQL Server lays in my ability to scale up if needed. There are so many free SQL Servers, but the benefit of this offering is the flexibility to move between servers and even scale up by pushing the server to Azure SQL, or an Azure VM. There are more options available to me with Microsoft's SQL Server. Review collected by and hosted on G2.com.

One downside to the express edition I use is the restrictions that are put in place for memory and CPU usage. In some cases, this benefits me in that I don't want to be hosting my database on a super computer, but under a heavy load I know my free version will not hold up. However, looking back at the positives, I can easily scale up! Review collected by and hosted on G2.com.

One of the things we like most about sql server is being able to work in client-server mode, which allows the information and data to be hosted on the server and for clients or network terminals to only access the information. Also, thanks to the fact that it is a tool that has been on the market for many years, it offers a powerful graphical administration environment, giving us a tool to perform ddl and dml commands graphically. It is very stable and secure and has a good community around it. Review collected by and hosted on G2.com.

What to my point of view I see more unfavorable of this database tool is its high use of RAM memory in the use of the software, also for this reason it becomes slow at the time of installation if you do not have adequate resources. Also its price taking into account its competitors makes it a more expensive solution. Review collected by and hosted on G2.com.

SQL Server is best database server to working with microsoft technologies like MVC, Dotnet, WCF and etc.

It Is provide the verious functionalities like create database and tables to create stored procedure, functions and views etc. It is also provide SSRS and SSIS features. Review collected by and hosted on G2.com.

Microsoft SQL Server is made to support millions of records across an enterprise. Because of its robust technology, it also comes with a high price.

Users also need to learn different language to setup microsoft sql environment.

SQL Server requires the .NET framework installed on a machine, which is a separate component used by developers.

Review collected by and hosted on G2.com.

SQL Sever supports multiple users in one setup which make it a multi-user system. SQL Profiler tracks the background queries and helps with the debugging and management of SQL queries. Moreover, by analyzing estimated and actual test plans, it helps to make queries more optimized. Review collected by and hosted on G2.com.

In terms of resource utilization, there is room for improvement for SQL Server, so that it can cost less CPU usage. Also, there are lot of third party services like SQL Search and SQL Code Guard. Why is there a need for these if SQL itself can implement these necessary functionalities inbuilt? Review collected by and hosted on G2.com.

add on tools with export and ease of creation of views and queries (i.e intellisense). The product is able to be used to many connection and the security with windows and SQL server authentication is useful. Review collected by and hosted on G2.com.

date format syntax should be more flexible and types of date and character manipulation should be much easier to figure out. I also feel that there must be some features to allow macro recordings and automation for jobs and /or functions ans procedures. Review collected by and hosted on G2.com.

Microsoft SQL is an extremely easy-to-use database that it simple to learn for even people with non-technical backgrounds. It is a good way to manage databases as it is something that can be easy to take on for the simplest of beginners, and it is easily integratable with other softwares. Most consultants I know have been able to pick up SQL in less than 3 months. Review collected by and hosted on G2.com.

It can feel a little less "sexy" that some other database softwares at times. The ease of use and accessibility however make up for what it lacks in design. I think oftentimes companies tend to rely on the use of it too much as well when some more advanced activities in other coding languages can be combined with Microsoft SQL. Review collected by and hosted on G2.com.

It is one the very few databases which gives continuous performance even though the data size is increase beyond 1TB. It supports Always on Clustering in Its Enterprise edition which gives flexibility to shard your database and with no downtime and it service is uniform across multiple platforms i.e on-premise and cloud.

Review collected by and hosted on G2.com.

This database is not suitable for running analytical queries as well as aggregations. The results for queries like rank and partitioning over a field takes a lot of time. Review collected by and hosted on G2.com.

• Just like other Microsoft products; SQL Server is by far the most User-friendly Database Server - best IDE

• Lots of wizard features from import, export, backup, query builder etc that anyone can easily learn and do just with few clicks!

• Built-in execution plan viewer which is nice enough to start with.

• Intellisense (like visual studio) to complete code while typing and showing common mistakes before you even execute

• Integrates very well with other MS products. Full MS BI stack includes SSIS ETL, SSRS BI Tool, SSAS etc.

• Free Plugins and third-party tools available to make your life even easier like: Poorman SQL Formatter, SentryOne Plan Explorer etc Review collected by and hosted on G2.com.

• No considerable cons. Maybe Microsoft should consider offering built-in features/tools for which developers use third-party tools and plugins. Like builtin execution plan viewer is not as great as SentryOne Plan Explorer.

• With so many built-in features one little must have to include is One click code indentation. Until Microsoft can add this feature, we can live with Poorman SQL formatter. Review collected by and hosted on G2.com.

it is easy to integrate with microsoft services like .Net and visual studio. moreover it can be easily integrated with C# applications Review collected by and hosted on G2.com.

It is basically a SQL based relational database system. so we cannot do stuffs which use NoSQL. and real time processing with a software is also difficult Review collected by and hosted on G2.com.

I enjoy the packed toolkit it provides. T-SQL is also a very powerful scripting language which comes with Microsoft SQL and is a delight to use. SQL Profiler helps me keep track of database modifications and plan my actions accordingly. Review collected by and hosted on G2.com.

I don't like its query optimizer. Sometimes it messes up the execution plans and what should have been a simple query can hang the server. It happens very rarely, though, so, it's fine. Review collected by and hosted on G2.com.