Microsoft SQL Server Reviews & Product Details

This is one of the best database tools created by Microsoft. I have been working for a bank and it uses this tool for storing a large database of customers, accounts etc. In my organization, SQL Server is used in the back end. This means all the work related to storing the date (e.g. using tables), retrieving the data and manipulating the data are all tasks performed by SQL Server and some helpful programming language. Review collected by and hosted on G2.com.

The only thing I don't like about SQL server is that it is complex to create EER(Enhanced ER diagrams). Review collected by and hosted on G2.com.

The best features of SQL Server is the amount of flexibility one can implement. With such high flexibility, once can assure business that SQL Databases will "Always" remain available without any/very minimal downtime. With the implementation of Always On High Availability groups, log shipping and replication, one can rest assured that data loss will be very minimal even in case of heavy disasters. Being a Microsoft Development House, SQL Server also suits our needs very well providing easy and maintainable data management. Review collected by and hosted on G2.com.

Administering SQL Server can be quite difficult at first, especially If you would like to build a top notch platform and not just deploy a single server. Fortunately, there is a lot of documentation available on the web for guidance and advise. Review collected by and hosted on G2.com.

Surely the strong point of SQL Server is its ease of installation and its very user-friendly IDE. For this reason, it is quite simple to start working in SQL Server without having advanced knowledge, just by following guides and tutorials available online. Review collected by and hosted on G2.com.

Compared to other relational databases, it requires a lot of machine resources to function smoothly. This is a problem especially for those who do not have a dedicated server and use their computer to install the instances and the SQLServer engine. Review collected by and hosted on G2.com.

The system is reliable and offers easy to use interface. It can be used to with several interfaces that makes it easy store data. Databases can be easily backed up and restored. Review collected by and hosted on G2.com.

Some commands that are offered in other database products are not listed in this. Some standard scripts built into the product would be nice. Review collected by and hosted on G2.com.

Ease of use and familiarity on a well-known interface that all our users are familiar with and manage well. Ability to obtain a powerful view of the engine and characteristics at a glance easily on the console Review collected by and hosted on G2.com.

Still has multiple steps to complete tasks, and certain activities have not been improved from earlier versions of SQL (e.g. 2008) Review collected by and hosted on G2.com.

server management studio, project management, query handler, DB schema comparison and optimization Review collected by and hosted on G2.com.

Professional license doesn't work as on-prem enterprise licence, product support could be improved Review collected by and hosted on G2.com.

I have been using SQL Server with Microsoft Azure. I like how deploying SQL Databases on Azure can easily help me retrieve my database on SQL Server. Review collected by and hosted on G2.com.

It has a typical syntax. Sometimes, even the correct column name does not run the query. The setup in Azure can be sometimes complex. Review collected by and hosted on G2.com.

To grow ground-breaking web applications in .net is unmistakably outstanding amongst other alternatives. The speed of association and the power and flexibility of the put away techniques make it simple to deal with it. Its very easy to start using it. It incorporates the Microsoft Sql Server Management Studio which is the instrument with which to interface both the neighborhood server or remote and with which to work outwardly on the database. It likewise joins many produced reports, reports to see the status of databases and make auspicious move. Review collected by and hosted on G2.com.

The most noticeably awful thing is the establishment, it is extremely lumbering and convoluted on the off chance that you don't know how to do it or in the event that you don't have a guide, it is anything but difficult to design some angle seriously and have issues later on. Review collected by and hosted on G2.com.

One of the best tool developed in the IT industry to store, extract, and retreive data from the server Review collected by and hosted on G2.com.

It is not open-source so, it is very expensive. It is not affordable for small companies. Review collected by and hosted on G2.com.

The fluidity of the software. It is very easy to use Review collected by and hosted on G2.com.

The complexity in navigating to certain functionalities Review collected by and hosted on G2.com.