Microsoft SQL Server Reviews & Product Details

Very good documentation, nice software with intuitive user interface. Review collected by and hosted on G2.com.

I did not experience anything I disliked, for my purpuses it was perfect Review collected by and hosted on G2.com.

Graphic interfaz, easy to view N databeses, easy backup and restore, easy install, easy configurate, view and execute a transac sql is fast to view, manteniance plans is fast to create Review collected by and hosted on G2.com.

Price, the databases are instable, lost the index, repair the databases is not confiable Review collected by and hosted on G2.com.

The best things about this product are

-> This product is free of cost with SQL Server database.

-> The product is designed more keeping a developer in mind and has a steep learning curve.

-> It can connect and retrieve data from multiple other databases/flat files.

-> Has an extensive list of connectors Review collected by and hosted on G2.com.

Dislikes

-> Very developer friendly. Sometimes I wish if there was an easier way to do things.

-> Does not provide an option to auto sort after a joiner transformation. A manual sort has to be performed for the result-set in memory to be rejoined with other tables.

-> No option for pre and post sql commands. Another transformation that runs a SQL command needs to be added.

-> HELP online or on the Microsoft website is not easily available

-> SSIS works purely with SQL Server. If an organization is planning to migrate from SQL Server to another Database a lot of investment would go into re-engineering with a new ETL tool. Review collected by and hosted on G2.com.

The sheer flexibility is worth the price of admission. Yes, there is a learning curve, but it is the easiest "language" you will ever learn. Review collected by and hosted on G2.com.

While I may have been using an older version, it can be very easy for a user to corrupt a dataset if they don't know what they are doing. Review collected by and hosted on G2.com.

Rock solid stability and great ease of use (and installation). Integration with the operating system makes some automation tasks and maintenance flow much easier Review collected by and hosted on G2.com.

As a previous user of mySQL server sometimes I miss the peace of mind and the option of having access to "under the hood" variables and being able to peruse the source code of the application. Review collected by and hosted on G2.com.

To start with, I really like how easy it is to attach datasources to a process flow, and then map the results to an output. SSIS makes it incredibly easy to pull in data, especially from an extract, process/transform it, and then send it to an output of some sort (in our case, a different database). Review collected by and hosted on G2.com.

While the tooling isn't bad, it does feel a little arcane to work with sometimes. Not everything is obvious and it's sometimes tough to follow what a flow is doing. Review collected by and hosted on G2.com.

I like the import functionality SQL Server Management Studio provides. It's easy to import data and tables. Review collected by and hosted on G2.com.

There's not much to dislike. I think for beginning programmers, it could be nice to have a visual query builder. Review collected by and hosted on G2.com.

easy to create and execute, stored procedures to automate tasks. I think it's the best one in the market, at the moment Review collected by and hosted on G2.com.

It takes up a huge amount of memory and space on a server. Review collected by and hosted on G2.com.

Easy to use, especially with big data, very fast in comparison with xls Review collected by and hosted on G2.com.

Well, everything is ok, but for new users it is somehow hard to use it. For the first time I tried SQL, I thought I would never be able to use it, but then I started to work with the tool more and now it is very simple. I would recommend to prepare more materials on how to use it for beginners Review collected by and hosted on G2.com.

I love SQL Server Integration Services (SSIS) it's the best ETL tool I know. One of the main features I like so much, is it's ability to create the data flows visually. It's nice to see a running package and see all the green boxes lighting up.

Not only, you can create the data flows visually, but also you can create code scripts using C# or VB.NET in the back end, making it super powerful, as you can even use existing code.

I also love the parallel processing capabilities, which allows you to run tasks simultaneously making it very fast. Review collected by and hosted on G2.com.

For very large packages, something the screen gets a little hard to manage, you are either too zoomed in or too zoomed out, sometimes you even lose where the package went, and have to scroll until you find it. Review collected by and hosted on G2.com.