SQL Server Reviews

The database is primarily used as back-end storage.

As an engineer working for multiple organisations, MS SQL has proven stability and operational power.

The additional tools, like SSIS and reporting services, make this solution useful.

Improvements to the indexing, columnstore indexing, and high availability groups are good improvements for future versions.

MS SQL is constantly improving their products. New options, such as managing with PowerShell, are good improvements.

The most valuable feature is the easy installation. The user just needs to know how to read.

The SQL Server is helping us with the most feared corporate problem: Excel spreadsheets. The individual user can perform an integration and share the same results with others without the necessity to "share" the file. This reduces the data traffic on my company network.

Table partition and memory management. The performance could be better.

I have used it for more than 10 years.

The SQL Server has a big issue when some systems use Java as a primary software interface. This database loses the ability to manage memory, consequently locking the processes and losing performance in the execution of some robust queries.

Unfortunately, this database doesn't have a good concept of partition table. If you need to create monthly (Jan. to Dec.) partitions in one table, this action creates 12 different files for the same table. In others databases, this process is more transparent and capable to create partitions inside the same database.

The technical support team for the SQL Server is very friendly, if we compare with others commercial database products. Not only with Microsoft, but this database has more technical information published on the internet, books, and self-taught users to help.

I am still using other commercial solutions, but the price of this database is much less expensive than others. It is about four times less expensive.

The initial setup is one of the good things about MS SQL. It is very easy to do and start the development that you need to use after the installation.

In my point of view, the MS SQL is the most inexpensive database commercial solution. If do you need to build a consistent ERP for example, with a medium to hard capability, and don't have much budget to spend it, this is your solution.

Of course, I evaluated other options! I never choose the first option and I always try to look around to find competitive vendor options. I already know and have expertise with IBM/DB2 and Oracle solutions. For this new architecture, MS SQL was the best option at the moment for being a pilot project.

I suggest that you are first familiar with the bundle functions and plan some of the functions before starting the project. Find more information about the routines and how easy or hard it might be to start the development when you are thinking about cascade and constraints.

It allows for performance tuning to maximize performance. With the enhancements to the tuning wizard indexes are added to the needs of the system structure and use. I find this helps prevent locking of the system.

It cuts down on the variable speed of queries, and individual queries can be tuned by optimizing the database server.

The speed is inconsistent.

N/A

N/A

N/A

N/A

N/A

We are using SQL Server for internal development projects.

SQL Server is easy to manage because all our DevOps team are familiar with it and simple to access because it is cloud-based.

The solution could improve by being more user-friendly.

I have been using SQL Server for approximately 10 years.

The solution is stable.

The solution is scalable, we have found it to be vertically scalable, but horizontal scaling, we have not used it for this purpose.

We are mostly using this solution for internal use, not for public services. We have approximately 10 developers using it.

My experience with technical support has been an average level of satisfaction.

The installation is easy.

We have one individual that is managing the solution at this time.

For our purpose, we are not required to have a license for what we are using it for.

I would recommend this solution to developers who are familiar with Microsoft's platform. However, for others who work with Linux-based solutions, I could recommend something else.

I rate SQL Server an eight out of ten.

We use the solution for managing our database functions.

The solution is easy to use.

The performance could improve.

I have been using the solution for approximately four years.

I have found SQL Server stable.

I have found it to be scalable.

The technical support is good from Microsoft. We have four people that do the maintenance of the solution.

The initial setup is straightforward, it took approximately one hour.

I did the implementation myself.

There is a license required for this solution.

I would recommend this solution to others.

I rate SQL Server an eight out of ten.

Right now, we are using DB2 and the SQL Server. It's really helpful for the replication of data. It's real-time and very easy to use.

The product is very stable. We find it to be reliable.

The scalability is okay. 

The installation is pretty straightforward.

For now, we've found the features to be sufficient. I cannot recall feeling anything is actually missing.

The pricing of the product could be better. They could make it more reasonable or more competitive.

Microsoft's technical support could be better.

We've been supporting these servers for a couple of years at this point. It's likely been about two or so years. We've worked with them for a while. 

The solution is very stable and reliable. There are no bugs or glitches. It doesn't crash or freeze. We're happy with it.

The scalability potential depends on the resources. If the resources are enough, we can scale it. For us, it's already enough. However, if a company plans to expand, it should be prepared for that beforehand. 

We have more than ten users on the solution currently.

Microsoft technical support could be improved upon. They aren't the best. They could always be better.

We also use IBM DB2. We support it for our customers.

We have found the solution to be straightforward. It's not overly difficult or complex. A company shouldn't have any issue with implementation.

The product implementation process depends on the needs of the client. For us, deployment was around 30 minutes to one hour. It's pretty quick.

The solution could be priced more competitively. We'd, of course, like it to be lower. Microsoft can sometimes be expensive.

Each customer needs their own license.

We use the solution both on the cloud and on-premises. 

I'd rate the solution at a nine out of ten. We've been pleased with its capabilities overall.

I would recommend the solution to other users and companies. They should know that it is very easy to use. 

We had two people that handled the initial setup - an engineer and a manager. It's pretty easy to handle if an engineer is doing the setup.

The solution is used for database management.

I have found that SQL Server works very well in the Microsoft Dynamics environment.

There is room for improvement in performance when managing a large quality of data and a high number of active users. 

I have been using this solution for approximately 17 years.

I have found the stability great.

The scalability is very good. We have five people in my organization using this solution in my organization.

I have used previously Oracle MySQL, IBM DB2, and SAP HANA. They are better suited for large-size data management.

We have approximately 15 people handling the deployment and maintenance of the solution.

The solution is on a pay-per-use pricing model.

I would strongly recommend this solution to others wanting to implement it in a Microsoft environment.

I rate SQL Server an eight out of ten.

We use the solution for managing database information from our clients and for testing database access.

I would like to see the integration with other platforms improved in the future.

I have been using the solution for four months.

The solution is stable.

I have found the solution to be scalable.

The installation is really easy.

I would recommend this solution to others and we are going to continue using it.

I rate SQL Server an eight out of ten.