SQL Server Reviews

- Ease of use of this product is much better than equivalent products - New AlwaysOn availability group enhancements bundles more DR and HA features in one easy to use interface - In-Memory OLTP, or project Hekaton, allows for utilizing memory to boost application performance with only minor application changes - Power, scalability, flexibility, and bundled tooling means it will meet all of your organizational DBMS needs for all size workloads - Support from MS and free knowledge and support from the MS community is terrific - Virtualization friendly! - Core features of the product include many features that require additional licenses with other platforms - SImple to setup and keep running

- Ease of installation means that anyone can install it, but many do not perform the steps required to properly maintain the data - The increasing cost of the platform is slowing adoption by the SMB space

I am so fond of this product that I have dedicated this portion of my career to focusing on mastering this platform as a consultant. I feel that this product is the best fit on the market for your database needs. The product is stellar, the amount of free knowledge on the Internet for this product is without parallel, and the community around SQL Server is so strong that I consider it a family.

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.

On-premises

It is used for many things. We primarily use it for our two-tier and three-tier applications.

It is stable, and it works okay.

It would be nice if they can reduce its price.

I have been using this solution for ten years.

It is stable.

I didn't use their technical support.

I have used Microsoft Access.

Its installation is straightforward. It took half an hour to one hour.

I can install it myself.

We did a one-time payment. Its price, in general, can be reduced.

I would recommend this solution to others. I would rate SQL Server an eight out of ten.

On-premises

Our server projects are mostly related to SQL Server, and we're using it. All our healthcare projects are using the SQL Server, and we're able to load millions of data without any issues.

It's more user-friendly than most databases. If we don't have to use the command mode, it's very easy.

The performance could be better. When we pump in millions of records, we start struggling, and that's why we want improvement in those areas.

I have been using SQL Server for more than ten years.

In the past, it wasn't stable compared to other products like Oracle Db2, but it has improved, and now it's stable. 

The installation is easy, and performance-wise it's okay now.

SQL Server installation is easy, and we did it by ourselves.

I would recommend this product to new users.

On a scale from one to ten, I would give Microsoft SQL Server an eight.

On-premises

We primarily use the solution as a database for business operations.

I personally work with Microsoft products and therefore I like the continuity it provides. I like sticking with the brand.

The solution is very stable.

The product has very good online documentation that can be used for troubleshooting.

The solution can scale as necessary.

We've found the setup to be quick and relatively easy.

The licensing costs are very high.

I would like the scaling process to be more transparent and obvious.

There's a lot of documentation on the web, and it is quite extensive, and yet it isn't very well organized which makes it hard to find items often.

I've been using the solution for a very long time. It's been around ten years or more. I'd say it's been at least a decade at this point.

The stability of the solution is quite good. We don't have issues with it. It doesn't crash or freeze. We don't experience bugs or glitches. It's reliable.

While I personally haven't gone beyond 50 or so users, it's my understanding that as long as you pay for the licensing, you can grow as much as you need to. There would be costs involved, however, the solution can scale if a company needs it to. 

I'd love to have Microsoft explain to me the scaling process so that I could better understand it. Right now, I'm in the dark.

In terms of technical support, I can say that sometimes I need them. However, it's very difficult to contact Microsoft support for anything. 

In general, they have none. I wouldn't know how to reach them directly for help if I needed it.

Right now they have good support for their Azure product, in the cloud. However, this is not the case for on-premise products. That means, as an on-premise user, I have a problem. That said, since their product is well-known, there's a lot of documents on the web. If I try to search online I will typically find the answers I need. 

The initial setup is not complex. It's pretty straightforward. It takes an hour or less to set everything up. Some people may need a few hours, however, for me, less than an hour was enough. That said, the Windows Server would also take an hour or two to set up as well.

The solution certainly comes at a cost, however, for me, it's an acceptable cost. I find it acceptable due to the fact that it would be free if I use MySQL on-premise, however, then it would be hard to hire people to maintain it. It's a give and take. That said, the license cost is very very high. I'm afraid if I use it on a larger scale it will cost a lot.

Currently, we're just Microsoft customers, although we would like to have a partnership with the company in the future.

I haven't done the HA for SQL server yet, therefore, I'm not sure how hard it is and how difficult it would be to implement, or how stable and how scalable it is.

There are two markets really. It's Microsoft and non-Microsoft. If anyone is familiar with Microsoft products, then they should go with this, however, they should bear in mind that it comes at a cost. The SQL cost is quite high if a company is using it at a large scale.

That said, if a company is looking at something small scale, there is a free edition. I use the standard edition, and it won't cost too much. 

In any case, for those that aren't tied to Microsoft options, there are a lot of products out there that might be suitable with very little overhead.

In general, I would rate the solution at an eight out of ten.

On-premises

SQL Server Migration Assistant for Access (AccessToSQL).

We migrated loads of access database into large scale SQL server.

Access validation rules and expressions need improvement while converting into SQL Server.

I've been using it for 10 years, and was using previously older versions and now I'm on the latest one.

We just needed to upgrade Windows.

It was average.

It was average.

I previously used Oracle 11G, I switched because of less hardware resources were needed to run heavy software.

It's straightforward to do providing you've read the manual.

We did it in-house.

It's beneficial in terms of what the business gains from it.

It's average to purchase.

We also looked at Oracle 11G.

First look into scalability issues before adopting the right product.

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

Customer Service:

N/A

Technical Support:

N/A

SQL Server has helped us make better decisions through the queries that we have built.

SQL Server's most valuable features are that it is a large number of community resources to help you out. that's one, and then it is quite powerful.

SQL Server backups could be better.

I have been using SQL Server for approximately three years.

SQL Server is a stable solution.

I have found SQL Server to be scalable.

The solution is suitable for all-sized businesses.

The technical support from SQL Server is quite good.

I was satisfied with the implementation of the solution.

The price of SQL Server is great. In my company, SQL Server is part of the Microsoft Suite, we don't have to pay for any additional license costs, it's quite cost-effective for us.

My advice to others is SQL Server is a good tool to work with and there are a lot of community resources available to help you out in case you are stuck anywhere.

I rate SQL Server a ten out of ten.

Private Cloud