Microsoft SQL Server Reviews & Product Details

The management of data and information is vital in today's world. Companies and businesses handle costs and product information through various software programs. The most important aspect of a good system is its database, and Microsoft has a manager up to the task, which is SQL Server. It is a magnificent manager where we can administer our data securely and quickly. It is possible to set up table configurations by placing key fields to relate them to other information tables. SQL has a query section where, through instructions, we can extract the information required, whether by clients or company personnel. Review collected by and hosted on G2.com.

At the query level, it is not as user-friendly as handling information using MySQL. It is a bit more complex to perform extensive queries; it is not possible to take aliases to sum them up, and it is necessary to place the complete query on the field. Similarly, with the ordering of information, a lot of data manipulation is required to achieve the final goal. Review collected by and hosted on G2.com.

Microsoft SQL is easy to learn, well documented, and well supported. It works well and can be integrated with other commonly used programs like MS Excel. Review collected by and hosted on G2.com.

The error messages from some of the common types of errors are difficult to understand what is wrong. Sometime a simple error like the wrong operator or a missing parenthesis can cause an error that appears to be a more widesweeping error. It would be useful to have a suggestion saying 'check your parentheses' for things like this Review collected by and hosted on G2.com.

The use of natural language is my favorite part of using ms sql.

> A wealth of helpful input available on the net.

> Easily integrated into other tools and products whether it's for further processing or reporting.

> I love the support of multiple data input and output data formats

> The easy with which one can use queries to transform data using logic Review collected by and hosted on G2.com.

For the purpose that I use Ms SQL for, it hasn't disappointed me much.

For one, the creation of special functions such as for de-duplicating large strings using fuzzy logic is very difficult. I would recommend the creation of templates to assist with the configuration or creation of such functions.

Review collected by and hosted on G2.com.

Microsoft SQL is very robust but easy to install and maintain. The available tools such as SQL Server Management Studio really simplify the maintenance process and also allows developers to easily access their databases with powerful and speedy queries. The ability to schedule jobs, setup custom alerts based on message contents, easily setup security access, connect to remote or local databases and just the overall simplicity in managing all of your critical databases and also backup databases on a schedule with little disruption really all contributes to a very powerful solution for most applications that require a database. Review collected by and hosted on G2.com.

We find that there are issues when you run SQL on VMs and when you takee a VM snapshot it can mess with your incremental backups which is kind of a huge problem if you are not aware of it. A company definitely needs to have a regular testing plan for data backups as there are some finicky things about SQL that if you do not have a strong DBA or at least a good understanding of SQL, you can easily get into trouble.

Also, I am not happy about the pricing for SQL as it is very confusing and when they start talking about per core pricing, it is like being punished because you happened to purchase yourself a decent server. Review collected by and hosted on G2.com.

We can easily store data of large project and easily retrieve form data base very fast which make our project faster. We can also use store procedure for retrieve data from data base this very fast process for call large data in list. we can also take backup of design and data very easily bye creating script. we can also use script for create , delete or truncate table. Review collected by and hosted on G2.com.

it is not easy for install it and use it. after installing we need some expert person for help to setup all setting of Microsoft SQL. we also get problem in connecting with server or with local server. Review collected by and hosted on G2.com.

MSSQL is a decent DBMS alternative that will suit many of your needs. It comes with a lot of built-in functionality that eases writing complex scrips as I don’t have to reinvent the wheel. It’s also very stable and I’ve never had a problem with it. It’s easy to install and set up. Review collected by and hosted on G2.com.

MSSQL takes up a lot of space and resources on a computer and it isn’t very scalable because of it. Community isn’t as big as with other database systems. Review collected by and hosted on G2.com.

MSSQL is a very flexible and robust piece of software. Now that you can run it on Linux or even on Mac, I've started using it everywhere. It offers amazing stability and functionality. I love the user management features in which you can assign roles to each and every user. It's also very secure. You can encrypt entire tables. Schema system is helpful as well and helps you organize your databases better. It's easy to set up and start working on. Review collected by and hosted on G2.com.

Performance can be a bit slow sometimes. You can't use it with low RAM as it will often hang up. It's also expensive, so it might deter smaller enterprises. Review collected by and hosted on G2.com.

SQL server is a robust DB application. User interface is pretty much intuitive and databases connectivity is pretty seamless. It's an efficient solution to manage the different size (large or small scale) databases. Sql query editor's intellisense feature is helpful during code writing. We are easily able to create new database, table, stored procedure, function etc. For table schema it supports number of data types. Provides optimum secure access as user can perform action according to their privileges (Read/Write/Execute) etc. Data encryption/decryption process is pretty much easy to perform. We can create the database master key to manage the advanced level security. Database transition, archive, backup etc. features are easy to perform and automate.

Inbuilt SQL profiler is very useful to debug the executions as well as with the help of its trace tool we can trace the client server requests and processing time. This also provides SSRS and SSIS features.

Data integrity is very high as this works on ACID model.

Database optimization process is simple - it's database engine tuning advisor provides enough details about necessary improvements. SQL server's estimated and actual execution plan generates query cost details so with the help of these statistics we are easily able to review and analyse the performance of sp, sql statements etc. Review collected by and hosted on G2.com.

Application license fees is bit high but as compare to its feature and functionalities this is still worth of use. Review collected by and hosted on G2.com.

The most impressed me in MSSQL was its security and stability. We have customers located on places with frequently energy failures, and of all database that we try use, the MSSQL was the one that no crashed.

This is very important when you choice a database solution to this situations of instability.

The tools available is very usefull too, like query analiser, task scheduler and replication tool, create a great package to DBA´s. Review collected by and hosted on G2.com.

Basicly nothing disliked me on MSSQL. May be a some improves in query editor, like an assitent to query builder or to create store procedures, but nothing relevant. Review collected by and hosted on G2.com.

I work in a software company that uses Microsoft SQL for the majority of the back end of the software. We have recently starting transitioning from .Net applications programmed with C# to a React Web page front end with a .Net core and Microsoft SQL has been the best solution for both. Review collected by and hosted on G2.com.

Microsoft SQL does have a high cost of licensing the software, but even though the cost is high, it is worth it. Review collected by and hosted on G2.com.