Microsoft SQL Server Reviews & Product Details

easy to use, excellent proven track, reliable Review collected by and hosted on G2.com.

eats a bit ram at times, other than that its perfect Review collected by and hosted on G2.com.

The ease of use of the program is a plus. Review collected by and hosted on G2.com.

Program is not compatible with Mac operating system. Review collected by and hosted on G2.com.

If your shop is already using SQL Server, the there is no reason why you willl not use SSIS to automate some process and get your data into their respective tables on a daily basis with the freshest, or almost real time data. Create a package than looks in a folder for a text file that is dropped into it from your legacy system every evening, and load the data into a table. Join that table to another look up table, get the data you want and create your report with SSRS(also free with SQL Server) Review collected by and hosted on G2.com.

I dislike the small bugs that you encounter sometimes when you are trying to complete a task. You can easily google the issue you are experiencing and fix it, however. Review collected by and hosted on G2.com.

- Integrates well with numerous data sources, ranging from Oracle, MySQL, Excel, Access, Postgreg, etc.

- Integrates well into the Microsoft stack of tools

- Very flexible in the ability to extract and transform data into a single unified source

- Ability to automate workflows - especially around updating data in a multi dimensional cube

- Ability to integrate alerts, fuzzy logic and audits right within the ETL process

- Does not require any additional licenses other than MS SQL

- Included tasks and templates to make it easy to start developing processes Review collected by and hosted on G2.com.

- Has a steep learning curve, unless you are familiar with the Microsoft suite of tools

- Requires additional software (but no license) - works best when running with Visual Studio

- Requires experienced developers to utilize full powers of the tool - new developers might find certain components Review collected by and hosted on G2.com.

This is the best tool for the data transfer and data migration. It is lots of inbuilt tools which helps the work done very easily and equivalent less time Review collected by and hosted on G2.com.

It could been improved more with the tools that it is providing. The configuration of the product can be better . and the tools that it is providing can be better espically for the data migration. Review collected by and hosted on G2.com.

easy to use interface

great compatibility with other MS software and other packages Review collected by and hosted on G2.com.

a long list of table and queries can be confusing

hope they are color coded Review collected by and hosted on G2.com.

I work with Microsoft SQL Server since early 2000. The product is stable and mature, and the best is the "integration". Integration with Visual Studio, with Reporting Services, Analysis Services, Integration Services. Having your db on SQL Server you can easily creates OLAP cubes with Sql Server Analysis Services, you can create your reports with MS Reporting Services and your DWH/datamart structures with MSSQL Integration Services. Fantastic product for your business, excellent the AlwaysOn functionality and in-memory tables. Review collected by and hosted on G2.com.

The price over all. Also, the alwayson functionality comes only with enterprise version of SQL Server. Too much slow with xml data type, for that nosql document database (json-mongodb) are for now the best choice, I have to say. It's also a little bit "huge" in installation, and requires really a lot of hardware resources to get the best (CPU/RAM), and so the cost is high for the licenses. Review collected by and hosted on G2.com.

I'm used to it, access and ease of use which transfers easily Review collected by and hosted on G2.com.

intially complex system to learn and took classes to understand at begining. Review collected by and hosted on G2.com.

The SQL Editor together with the object explorer are the features I use the most Review collected by and hosted on G2.com.

The Visual Query builder is a bit outdated and could be improved Review collected by and hosted on G2.com.

It can generate the code for you. It can be installed using "setup wizards". It has very good performance features built into it. It is also very secure with strong authentication and access protection. Review collected by and hosted on G2.com.

No complains. I really like Microsoft Sql. It is cheaper to use than Oracle products. Review collected by and hosted on G2.com.