Microsoft SQL Server Reviews & Product Details

Microsoft SQL Server is a hard one to put in a box. Yes, it is a database, but there are so many more aspects of it when expanded into the business intelligence and reporting space. In the early days I did a lot of work in MS Access and when moving into SQL Server 2000 appreciated the matured database platform and also having experience in Oracle also was relieved to find that SQL Server wasn't that weak sibling that many in the DB world framed it as. Over the years with new versions of SQL Server we now have an enterprise worthy database which is the core of businesses around the world. The administrative nature as well as agile development features make SQL Server an easy to use platform for application as well as analytic purposes. Review collected by and hosted on G2.com.

Out of the box I was always wishing that there were native form building features like in Access, but now with Sharepoint there is the capability, but for smaller organizations it isn't feasible to staff and administer Sharepoint. A .NET/Access type of forms creation in the base of SQL Server would be great for the small to midsize companies, but that said understanding that there are complexities with surfacing forms through a browser or as an app. Review collected by and hosted on G2.com.

The link functions are very versatile. They allow you to visualize the combination of datasets and what is used to connect them with boxes and arrows, not just written syntax. Review collected by and hosted on G2.com.

I don't think I dislike anything about it, particularly. Review collected by and hosted on G2.com.

Appreciate the high flexibility it provides & speed in which it is able to manipulate valuable data within complex processes Review collected by and hosted on G2.com.

The interface is a bit clunky - while I am able to get what i need done, the ease of navigating through the platform could definitely be improved / more organized. SImply making it more aethetically pleasing to the eye would be an improvement Review collected by and hosted on G2.com.

Majority of the Business functionalities can be obtained using the components available in SSIS. All components can be leveraged for implementing core business logic with out custom coding.

Apart from this , this SSIS supports all types of Source and destinations file formats and one of the best transformation component is Slowly changing dimension which can save a lot of time for developer.

Event handling and error logging are few of the best features available in SSIS Review collected by and hosted on G2.com.

Debugging is not enabled completely .

During processing of large number of records , this becomes clumsy Review collected by and hosted on G2.com.

I like the ability to manage relationships between data this software facilitates Review collected by and hosted on G2.com.

Often errors occur with multiple users and data are duplicated Review collected by and hosted on G2.com.

IntelliSense

Better GUI

Coloured keywords Review collected by and hosted on G2.com.

Long Installation process for microsoft visual studio

Little slow sometimes Review collected by and hosted on G2.com.

- SQL Management studio for example gives you all tools that you need as a developer, and it is a very easy to work with it.

- SQL Express is a free version, which is sufficient for a lot of cases with small / medium size projects.

- Very common and well supported Review collected by and hosted on G2.com.

It is not backward compatible with other versions of SQL Server versions when you try to backup from SQL 2014 to restore it on SQL 2008 version. Review collected by and hosted on G2.com.

Being new to the whole ETL side of our product, using SSIS was fast and efficient to implement. I would definitely recommend this product to someone who is attempting to create ETL solutions or a beginner in the area. SSIS also scales well with huge databases, so given that your company may grow in size in the following years, SSIS is a very suitable choice. Review collected by and hosted on G2.com.

Connecting multiple databases raises some difficulty with the Query Window because the interface is uniquely designed, since there are multiple endpoints that could be connected between endpoints. Review collected by and hosted on G2.com.

It's flexibility to integrate with ontologies Review collected by and hosted on G2.com.

It is not light weight like mongoDB and requires significant client side application Review collected by and hosted on G2.com.

It allows me to do apects of my job without the assistance of others Review collected by and hosted on G2.com.

sometimes technology gets a tad confusing to me. Review collected by and hosted on G2.com.