Microsoft SQL Server Reviews & Product Details

1. Robustness, scalability and integration with all other s/w products

2. Ease of configuration as per business needs

3. Minimal training for resources to adapt and use it Review collected by and hosted on G2.com.

1. High initial investment cost

2. Need set-up and special skills to maintain the RDBMS functionality Review collected by and hosted on G2.com.

I like Sql ability to scale, its replication support, as well as its integration with Microsoft Visual studio. This integration between Visual studio and Sql has saved me important development time, and provides me with more powerfully stored procedures. Review collected by and hosted on G2.com.

Asides from the pricing , I think I am okay with most part of my SQL experience . Review collected by and hosted on G2.com.

My favorite thing about this software is how robust of a tool it is. It has been the database engine of choice for many of the business systems I've used in my career: from PDM and ERP systems to design automation tools. The usage of this platform by the developers of those systems goes well beyond what I can create on my own. Yet, I have found the architecture of the interconnected tables used in these systems intuitive, giving me a shallow learning curve should I ever need to audit or retrieve data from those systems.

For a novice user such as myself, I have further found value in utilizing SQL as a leaner, faster version of Microsoft Excel. In some business roles, I've found that companies use Excel for databases, which grow slow and cumbersome as the volume of data increases. By storing data and doing basic calculations in SQL tables, I've been able to leverage SQL's significantly more efficient calculation abilities and read data in a fraction of the time. I have found this true to the extent that I've even used SQL outside of work for use in fantasy sports. Review collected by and hosted on G2.com.

I'm not well versed enough in data architecture to comment on how effective SQL is compared to it's competitors (Oracle and MySQL). There have been times when I've wished there was more robust error tracking when there's an issue with a query that I wrote, but that's the only thing I've had struggles with that wasn't attributable to my own lack of expertise. Review collected by and hosted on G2.com.

Powerful Database application, user friendly.

IntelliSense feature, easy database data and logs configuration.

Query and database optimization features. Review collected by and hosted on G2.com.

Platform dependency and expensive license.

Database replication, mirroring and table portioning features still need improvement and to be made easier for users. Review collected by and hosted on G2.com.

Nice and easy to use. Good tool for data storage and easy accessible Review collected by and hosted on G2.com.

Not really, could be upgraded for better reporting and Intergration with other tool Review collected by and hosted on G2.com.

How easy it is to manage your database with the Microsoft Database suite of applications. Review collected by and hosted on G2.com.

My own personal preference is towards MySQL due to having being taught that in university, therefore I make syntax errors fairly frequently. Review collected by and hosted on G2.com.

Ability to store, Update, retrieve data using queries

Low cost of Ownership

More Secure in terms of security

Flexibility to connect with other analytical tools Review collected by and hosted on G2.com.

Slightly complex interface

Some versions come at a high cost

Sometimes processing is slow due to various issues Review collected by and hosted on G2.com.

Speed, Ui, Friendliness, Connecting options, ease of access Review collected by and hosted on G2.com.

FOr new people, lots of options on windows might be confusing Review collected by and hosted on G2.com.

Easy to learn,

Easy to use &

User friendly Review collected by and hosted on G2.com.

Sometimes it might take huge time to respond when we work with larger size databases. Review collected by and hosted on G2.com.

Evrry single concept, however conceptually difficult, is made easy... Profiler, Executing plan, data import (with or without data), every single thing that would take at least 5 minutes in Oracle is a 1 minute job here. I guess that's a microsoft thing, that not always works so well. But with SQL Server it works. Review collected by and hosted on G2.com.

One thing I can think of right now is that I always have a hard time finding the SQL Server Manager. It should have been an option in the menu of SQL Management I think. Security is one other thing that might be made a little more intuitive. Logins can be operating system logins, and I don't really understand how and where they are (really) configured. Review collected by and hosted on G2.com.