Microsoft SQL Server Reviews & Product Details

The Express version is flexible enought to attend a number of small companies, and can be use as BI tool storage for this companies also. The easy way to connect the database to another tool, like Excel, PowerBI or any kind of BI tool like Qlik View, Tableau etc. The version of Microsoft SQL Express is very complete and attend many sizes of business. Review collected by and hosted on G2.com.

The database is target of many attacks from it's SA account, this must came disabled by default and just after the instalation, some of 30 seconds, the attacks starts, with many requests per second, need to improve the firewall to prevent these attacks, or put the SQL Server inside of a VPN and local network to avoid these attacks. Review collected by and hosted on G2.com.

Ease of integration with Microsoft power automate flows. I have created views and have run the scripts on data too. Review collected by and hosted on G2.com.

The design part of the view sometimes return errors while the query works successfully. Review collected by and hosted on G2.com.

The best thing about Microsost SQL Server is that it is user friendly. It is easy to integrate other tools like PowerBI, Excel with it which indeeds helps in streamlining workflows with ease.It provides advanced security feature which includes encryption and authetication making it a reliable tool. Microsoft offer many support channel. it includes 24/7 assistance and a diverse knowledge base. It is also useful for daily usage whether it's querying data from a database or generating reports. The installation and setup process of SQL server is straighforward. Review collected by and hosted on G2.com.

Although SQL Server is user-friendly, yet some features of it might seem challenging to beginners. For larger systems,setting up SQL server could take up ample amount of time which is a downside. Customer support is good but sometimes the response time could be high for things which has higher urgency. Review collected by and hosted on G2.com.

Microsoft SQL Server is a database management system. It is widely used in many companies. It is very stable and can handle large volumes of data at a time. It is secure enough and roles can be assigned to users for access to the database. You can also use the SQL Server Reporting Services for analysing data. It is easy to get help from the Microsoft support team for any issues. Replication of a database is easy to do. Review collected by and hosted on G2.com.

It utilizes a lot of resources on the system that it is installed on. This can slow down the system thus making it difficult to use. Regular maintenance and monitoring is required. Review collected by and hosted on G2.com.

Easy to learn syntax and well documented learning material. it also follow the statandard SQL syntax. Review collected by and hosted on G2.com.

Lack of protection against deleting the entire table since it does not make provision of where clause mandatory.

When you have sub-query on your query it allows the use of main query fields in the sub-query without explicitly referencing the main query table name or aliase, if this was done in error it will not raise any syntax error, it will just use the field of the main query if it's not found in the sub-query resulting with unexpected (and often unnoticed) results. Review collected by and hosted on G2.com.

Best place where your Data is securely stored, query and analyse easily with query language.

Outstanding Relational Database management application for big data.

Easily store data in relational form and query that with query language.

High speed processing with ACID properties.

Data transfer is also easy with Structured query language.

Sql helps you to interact with database with 100% uptime.

Using it as a developer from last 4+ years.

Worked with so many banking client and other domain also , they all used the SqL server because of the high performance.

Backups is also very helpful. Review collected by and hosted on G2.com.

Found difficulty while integrated with non Microsoft tool. Review collected by and hosted on G2.com.

ADVANCED FUNCTIONALITY WITH LESS COMPLEXITY Review collected by and hosted on G2.com.

SOME TIMES THERE IS A MEMORY BASED ERROR Review collected by and hosted on G2.com.

Microsoft SQL Server has robust Database Management System which supports and stored operational data Review collected by and hosted on G2.com.

None, it has a rich UI and very simple navigations Review collected by and hosted on G2.com.

Everything about SQL is great. How whole database can be created, modification and updation all at once platform. Complex logic can be written in a very effective and easy to understand by third party. Learning Sintax is comfortable and simple. Review collected by and hosted on G2.com.

Nothing as such. We have all the documentation and customer support bif we have any doubt. Review collected by and hosted on G2.com.

QUERY PERFORMANCE ,ALWAYS ON, IT IS GOOD SOFTWARE FOR MEDIUM SIZE INDUSTRIES Review collected by and hosted on G2.com.

CURRENTLY ALWAYS ON REQUIRE DOMAIN CONTROLLER , REQUIRE NEW WAYS WITHOUT DOMAIN CONTROLLER Review collected by and hosted on G2.com.