Microsoft SQL Server Reviews & Product Details

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.

The interface is extremely intuitive for users with knowledge in both spreadsheets and SQL Review collected by and hosted on G2.com.

The fact that Microsoft SQL differs more from the official standards of SQL than most other varieties of the language Review collected by and hosted on G2.com.

The ease of connection between one app to another. Working on data analysis, it is critical to have collaboration between applications. Review collected by and hosted on G2.com.

Can be challenging to setup among interfaces, but once completed, runs successfully. Review collected by and hosted on G2.com.

Very user friendly. I have a non-Computer background but was able to pick it up very easily... Review collected by and hosted on G2.com.

Help section. Could be useful it is useful Review collected by and hosted on G2.com.

Microsft SQL is easy to understand and work. much similar to MYSQL

Works fine with automation tools as well Review collected by and hosted on G2.com.

Its a bit Pricey. would have liked it to come in low cost package.

Also if more themes can be available tat would be great Review collected by and hosted on G2.com.

If you are working with complex processes to manipulate the valuable data from your company, SSIS can help you to have fast results when your client ask for some integrations. Review collected by and hosted on G2.com.

Is not simple to create a good integration politic and rules. It is necessary to understand very well the business related to create good integration. MS could create some video tutorials explaining best practices of using this tool. Review collected by and hosted on G2.com.

Sql Integration Services is a very easy way to migrate and transform data from many sources to SQL Server, Its easy to use drag and drop creation tool, made it quick and easy to extract and Transform our Oracle data to a data warehouse in SQL Server for our business reports. When running the SSIS code, you get an easy to follow graphical flow of what is happening and its progress. Review collected by and hosted on G2.com.

It took a while to understand the permissions model within SSIS which caused a few headaches with development, and with our environment being Agile, SQL Integration Services does not allow for unit testing or for source control within GIT, this required us to think of a different approach to development to what we are used to. It is more of a Drag and drop development structure which makes it difficult to share and review code, as there is any any code. Review collected by and hosted on G2.com.