SQL Server Reviews

We are a software development company. Most of our developers use SQL Server. We plan to continue using this solution in the future.

We use SQL Server for relational database management.

We have a variety of customers who use it in the government sector and in the tourism sector.

The time series database could be improved. There needs to be more storage space for large documents.

The user interface and the reporting could also be improved. It's not bad, but it could be improved upon.

I have been using this solution for 20 years.

SQL Server is both scalable and stable.

The technical support is good.

Installation was very easy. We had it installed within one hour.

One of our team members deployed it.

I would definitely recommend this solution to others.

On a scale from one to ten, I would give SQL Server a rating of eight.

• Effectiveness in a production environment
• New features test

Besides that, SQL Server has become very expensive like Oracle. Its stability delivers performance and usability.

• SSMS
• SSIS
• Reporting services
• FCI clustering
• AlwaysOn
• Basic availability groups.

I would like a mature real-monitoring built in into SSMS, even a trace file analyzer.

The database engine within SQL Server 2014 is one of the most valuable components of the platform to me.

The engine provides a solid and efficient database backend for any relational database requirement, performance is strong and there are options such as table, index partitioning and columnstore indexes that enhance the scalability of the platform.

In addition to the database engine, I would also highlight the built-in integration services platform (SSIS) for ETL purposes as well as the Reporting and Analysis Services functionality (SSRS and SSAS respectively).

One of the key features that I would use regularly to support the delivery of a Data Warehouse solution would be the Master Data Services (MDS). This is an extendable Master Data Management platform that works very well out-of-the- box.

As an IT Services organization, our companies have used this product in dozens of customer deliveries for solutions such as ERP applications, Data and Analytics solutions, and more. We also use the product internally as the backend for some of our most important operational systems.

The user interface to the web frontend of MDS could be more intuitive and the Analysis Services platform has not evolved much in recent times, these are the two things that come to mind.

This specific version (2014), I have used for approximately three years. However, I use other versions of the software on a regular basis, such as 2012 and 2016.

There were no issues with stability.

There were no issues with scalability.

Microsoft has a solid support structure for the SQL Server platform and I’ve always been provided with a good service.

We used a combination of RDBMS platforms and we still do in addition to this solution.

The installation and configuration was very straightforward. The full setup typically takes less than one day.

The Enterprise license includes features that enrich the product experience as well as performance and scalability options. Choose this over the standard license where possible.

We reviewed many RDBMS platforms for suitability depending on the requirements of the customers. We would also use the likes of Oracle 12c and Amazon RDS.

Install a trial version as soon as you can and give it a try.

It's a database that we use for our commercial applications, and our ERP sits on it.

SQL Server is definitely easy to use, and with the volume that we have, it's also stable.  Maintenance is much easier compared to other products. I may not be comfortable with Oracle because I don't have much experience with it. But in this case, SQL Server is much better for me. 

Performance could be better. But I don't know if it's a problem with my application or with my database. Maybe it can have the capability, but I may not be using it to the extent that it could be used, or the configuration is not as per the standard.

I've been using SQL Server for over ten years.

SQL Server is a stable solution.

The initial setup is very easy.

I implemented this solution by myself.

I would recommend this solution to potential users. If they have their own in-house team, they can manage it very easily. Microsoft is always easy to manage. It's a product where no expert is required for its maintenance.

On a scale from one to ten, I would give SQL Server a seven.

It's a solution that's always on.

It has High Availability, therefore provides failover if a node becomes unavailable.

• Few in SSIS
• Realtime data refresh in SSRS
• More datasources in Power BI

All our main DBs run on SQL.

Ability to convert to bigger DBs. It makes it easier to move or upgrade between branches.

From a DB administrator perspective, I would like to see more space requirements and space capacity history, so that we are able to see which DBs are growing, and by how much per day or week.

No issues with stability.

No issues with scalability.

Have not used tech support.

Straightforward.

Plan ahead, and make sure do not pay for something you are not going to fully use.

Naming conventions are very very important. Make sure that your principle and mirror servers have the same disk space from the outset.

The way the product shows the execution plan and the facility to the developer and tests the SQL code.

The product is used in the core systems. It has been used since the beginning.

Better execution plans and better debugging.

Improved dependency of use of temporary tables to reach good performance in complex SQL.

I've used this solution for six years.

Sometimes the cross-database performance isn't the best.

No.

An eight out of 10.

I have used Oracle and I also use IBM DB2. All of them have pros and cons.

No.

Great product. Like any software, a good and prepared staff is the key to success.