Microsoft SQL Server Reviews & Product Details

The upsides of using microsoft sql is that it is easy to use, and has a lot of unique but great features. Review collected by and hosted on G2.com.

I think i dislike how it looks a little outdated, they need to make the software look more modern for a cleaner fit. Review collected by and hosted on G2.com.

It's supported by nearly everyone and everything. The admin console is usable, old looking, but it get's the job done. Review collected by and hosted on G2.com.

It's heavy, it's expensive, it's not as intuitive to use as newer solutions. Review collected by and hosted on G2.com.

The newer features for writing queries including in memory statements, along with the added features of SSIS, SSAS, and SSRS. The ability to create ETL packages, manage dbs and run reporting analytics is a huge win for me. Review collected by and hosted on G2.com.

I really do not have any dislikes on this product. Review collected by and hosted on G2.com.

MS SQL is best database server.Data handling with this database is so much ease.MS SQL is great working with asp.net programming for data storage.MS SQL is with management studio is best data handling with graphical user interface. Review collected by and hosted on G2.com.

Database backup files strictly version dependent. Review collected by and hosted on G2.com.

Microsoft sql is a multi-platform option. It has an in-built group functionality. It has enhanced security for your databases. It also allows you to recover your data in case of a disaster. Review collected by and hosted on G2.com.

Microsoft sql takes large memory on your computer. It also slows down when you are dealing with large databases. Its installation is very tome taking. It does not auto-backup and save the query window. Review collected by and hosted on G2.com.

the usability and ease of use is very good in comparison to other sql environments. Review collected by and hosted on G2.com.

Need add ons for formatting and SQL search. Initial setup may be tedious for some people. should have temples for automatic formatting of SQL code. Review collected by and hosted on G2.com.

I can work with various types of data, easy to do bacup and restore, if used with great applications respond with a lot of speed. Review collected by and hosted on G2.com.

Due to having several functionalities it is necessary to have a professional qualified for the installation and maintenance of the system, often exclusive to this solution. It is also necessary a machine with enough resources due to the large use of RAM Review collected by and hosted on G2.com.

I really like how SQL has made a lot of our data mgmt, "hands free". With just a few clicks, we are able to import data and have it pushed to other systems after SQL does a bunch of complex calculations and table joins Review collected by and hosted on G2.com.

Often times if the query errors out, it can be difficult to figure out what exactly is causing the error. Review collected by and hosted on G2.com.

Its very user friendly and light weight as compared to oracle.

Most of the basic commands n scripts can be run at mouse click Review collected by and hosted on G2.com.

I need to learn different syntax as i was used to of oracle db. Review collected by and hosted on G2.com.

Overall experience with SQL server 2016 is very nice and excited in my perceptions due to Better support for memory optimzed tables, Built in JSON support, Stretch DB concepts, Query Store and dynamic temp db according to size and presence of CPU in the databases.

Another appealing aspect of SQL Server is the integration with other Microsoft products that are probably already running in an organization. SQL Server interfaces with Active Directory allowing for easy user management so appropriate levels of database access can be allotted via group membership. This is useful because even something simple like user access management in another RDBMS may present a learning curve for anyone that is not a DBA. With SQL Server a general IT resource could manage user access with an existing knowledge of Active Directory providing more time to focus on core database design. Review collected by and hosted on G2.com.

SQL Server carries a high cost subscription based licensing cost. The user assistance features provide a great introduction to relational databases, but there is still a significant and continuous learning curve. Databases continue to evolve with industry need. Anyone that interacts significantly with SQL Server during day to day database or application design may need to consider yearly training to keep up with all the changes. Review collected by and hosted on G2.com.