Microsoft SQL Server Reviews & Product Details

The best thing about SQL Server is the accompanying Management Studio. MSSQLServer Management Studio makes it incredibley easy to administer user roles and permissions, and easy to create stored procedures and user defined functions. The "New Query" view also provides handle autocomplete suggestions for table names, column names, etc, and also highlights the keywords.

I also like that SQL Server is widely supported and documented. Providing drivers for all environments, i.e. Java, and online documentation for quick reference. The failover support in SQL Server is also great - running databases can easily backup to listening databases, and failover to them when/if required. Review collected by and hosted on G2.com.

The fact that SQL Server only really excels with the licensed version is disappointing. Comparing the free version of SQL Server (Express) to other free databases like PostgreSQL, is where you might be better going for the latter. Is money is an important factor for your company, you may want to look elsewhere.

Another downfall of the free version of SQL Server is the lack of database space, only 10 GB is available. Review collected by and hosted on G2.com.

microsoft sql allowed us to run reports quickly Review collected by and hosted on G2.com.

microsoft sql can take a lot of time to learn and use effectively Review collected by and hosted on G2.com.

Ease of use

Debugging and troubleshooting gets really easy

Review collected by and hosted on G2.com.

Interface

a LOT of memory space is used up

Security is another big concern when using this application Review collected by and hosted on G2.com.

Far and away the best query language available. It's such an easy and clean language to learn and expand on. Use it all day, every work day. Review collected by and hosted on G2.com.

Syntax error reporting could be a little more in depth. Review collected by and hosted on G2.com.

simplicity it has the basic of all Microsoft products, If you know how to use words tool bar and excel same basic functionality will be found in that tool bar Review collected by and hosted on G2.com.

its too simple, for large data I would prefer using R Review collected by and hosted on G2.com.

Constant progress and well-aimed improvements in feature over releases.

Huge ecosystem of add-ons / tools. Review collected by and hosted on G2.com.

Follower rather then visionary on terms of new features. Review collected by and hosted on G2.com.

It was easy to convert our current queries to be used into SQL. The login page is a bit finnicky Review collected by and hosted on G2.com.

It takes a bit longer than previous tools Review collected by and hosted on G2.com.

Easy to use, intuitive and fast. I like that I can navigate tables quickly and use less SQL to get the results I need. Review collected by and hosted on G2.com.

I dislike the lack of intervention with Excel without establishing a data connection. I would prefer to have the ability to export directly to excel with dates, numbers and other formats carried over.

I also would like a mobile app to be able to run canned queries with minor changes. Review collected by and hosted on G2.com.

SQL Server management tools is a solid management tool, and MSSQL integrates wonderful with a full MSFT stack. Review collected by and hosted on G2.com.

The management tools don't live update. If run a script to change a table, the database explorer needs to be manually refreshed to see an update. Review collected by and hosted on G2.com.

its tools and can save time in development Review collected by and hosted on G2.com.

tends to be too costly but other than that thats it Review collected by and hosted on G2.com.