SQL Server Reviews
- Highest Rating
- Lowest Rating
- Review Length
Showingreviews based on the current filters.
Jul 27 2020
What is most valuable?The most valuable aspect of the solution is that the metadata is just generalized. Metadata is the way that data is described both for technical aspects of building a database and for the user… more »
What needs improvement?The server itself doesn't need much improvement. The product overall would benefit from the addition of better tutorials to help master the skills necessary to actually build a project database. Right… more »
What's my experience with pricing, setup cost, and licensing?I, unfortunately, do not handle licensing, so I don't know what the costs are for the product.
Which solution did I use previously and why did I switch?Previous to my position at the university, I worked both as an employee and a consultant and was very much involved with Oracle as a database for years, going back to 1997 and until about 2010.
What other advice do I have?In August of last summer, we updated to the latest version of the solution. At least, at that time, it was the latest version. What the school does in its academics is make a minimum training… more »
Which other solutions did I evaluate?MySQL as a database is sufficient for the scale of the projects that I've been talking about for ht purposes we have currently. PostgreSQL, which I do not personally know very well, is something else… more »
Jul 29 2020
What is most valuable?The feature that I have found most valuable is that it is easy to code. You can very easily get a resource to work on that. For example, if we have a big project it's hard to get a good resource in the IT industry. However, since SQL Server… more »
How has it helped my organization?SQL Server is cost effective in multiple ways - both the cost of software and the cost of the resource. Meaning, how many resources do we have and what is their expertise level? How easily can they use the SQL Servers or can I use any of… more »
What needs improvement?In terms of what could be improved, everything on-premises is now moving to the cloud. Obviously SQL Server has also moved because Microsoft has its own cloud called Azure SQL and azure synapse. Every solution comes with its own advantages… more »
Which solution did I use previously and why did I switch?It's hard to tell the exact reason of switching. As I told earlier, Choosing DB cannot be measured only on the performance of the Database. Multiple points need to be considered.
What other advice do I have?My advice is that this is the time to completely move to the cloud. If you have a golden or platinum partnership with Microsoft or you have good Microsoft resources then best is to move azure clouds. Azure DB services have been improved a… more »
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: August 2020.
438,246 professionals have used our research since 2012.
Apr 04 2019
What is most valuable?* Performance-wise, it is an excellent tool. * It is a Microsoft product, so there's a lot of support. * It's not a new tool; it has been around for a while. * It is one… more »
How has it helped my organization?I am in the process of creating a data strategy to consolidate multiple siloed data centers. Once my plan is finalized and approved, then we are going to execute it on the… more »
What needs improvement?I would like to see native plugins built for other platforms versus having to buy third-party plugins to tap into S3 buckets and AWS Cloud. Right now, it does not have… more »
What's my experience with pricing, setup cost, and licensing?It is expensive, but you get what you pay for. Since we are a cloud-based company, there is AWS pricing on top of the SQL Server pricing. The Enterprise Edition can… more »
Which solution did I use previously and why did I switch?Our company has probably been using this solution since it was released.
What other advice do I have?I would definitely recommend SQL Server. It's not cheaper any more, like it used to be, but if you can afford it, then it's the best. When I select a vendor, from a tool… more »
Which other solutions did I evaluate?From my perspective, the two vendors for this are Microsoft and Amazon (AWS). They are working on making it better with every release, compared to Oracle Db2 and IBM.
Jul 29 2020
What is most valuable?Security is obviously the most valuable feature because I can provide certain logins for a particular level of security and I can provide specific permissions for certain logins. That's a very good feature. I like the user interface as well, it's easy to use. The SSMS Management Studio, which we use to do some work in database file query is a recent feature from 2018 and the SSMS is quite good. It… more »
What needs improvement?I'd like to see a simplification of the query optimizer and feel that SQL needs to look into the internal processing of the query because the query optimizer sometimes uses a different query plan, which we don't expect. It is similar to the triggers they have which are used after execution and not before. For example, if I'm running a query, my trigger will be run after the query has executed… more »
What other advice do I have?I would recommend this solution, particularly for OLTP purposes, the transactional data purpose rather than for warehousing. For data warehousing I think there are better solutions but for the transaction data, for application purposes, SQL Server great. I would rate this solution a nine out of 10.
Jun 18 2020
What is most valuable?The performance is a very valuable aspect of the solution. SQL is very easy to manage.
How has it helped my organization?The solution has provided our clients with some valuable data feeds.
What needs improvement?Occasionally the performance, as good as it is, is a bit off. We sometimes experience memory spiking. If they could maybe fix that aspect of the solution, that would be… more »
What's my experience with pricing, setup cost, and licensing?I'm not the person that deals with billing and payments, so I don't know what the cost of the solution is, or if it is monthly or yearly billing.
Which solution did I use previously and why did I switch?It's been about ten years since we started using SQL, which is quite a long time. I don't recall if we used a different solution before that or not. If we did, I don't… more »
What other advice do I have?We are using the 2008 and 2017 versions. I'd like others to know that SQL is easy to use and easy to manage. It also offers pretty good performance, in my opinion. I'd… more »
Which other solutions did I evaluate?I'm not sure if we would have looked at something else or what it might have been. If there was research and a comparison was done, that would have been a decade ago. It's… more »
Sep 05 2020
Easy to use and integrates well with other Microsoft products, but the performance needs improvement, and there are many hidden costs at the enterprise level
What is most valuable?The most valuable features are ease of use and the integration with Single Sign On (SSO), as well as with other Microsoft products.
How has it helped my organization?We are familiar with Microsoft products and bringing another Microsoft product was a very easy transition.
What needs improvement?The performance needs some improvement and it needs more features integrated into it. Technical support could be better. Scalability could be less costly. One of the conflicts with Microsoft is if you… more »
What's my experience with pricing, setup cost, and licensing?Pricing is reasonable for small organizations, but the scaling increases the price. For larger organizations that would be using enterprise solutions, it contains some hidden costs.
Which solution did I use previously and why did I switch?Previously, we had not used any other solutions. We have been a Microsoft shop from the beginning.
What other advice do I have?It's suited for small organizations, but if someone from a larger organization is looking for this, they might have some problems implementing enterprise-wide solutions. This is because of the… more »
Aug 09 2020
What is most valuable?The latest version supports for big data analytics. SQL Server's vector processing-based batch execution mode is now available to the entire execution of R or Python code. Since much of the work that tends to be done in R and Python… more »
How has it helped my organization?Microsoft database is very user friendly. This new version of SQL Server continues to meet these twin demands. It adds new features from the worlds of data science and NoSQL. It offers cross-platform capabilities and Docker container… more »
What needs improvement?CAL licenses should cost less. Microsoft usually prices high for client access licenses. Server plus user client access license (CAL) licensing requires a separate Server license for each server on which the software is installed, plus a… more »
Which solution did I use previously and why did I switch?SQL standard 2008.
What other advice do I have?It is an overall very good product.
Aug 23 2020
What is most valuable?The most valuable feature is the system architecture.
What needs improvement?The number of concurrent users is too limited and other databases are better than SQL in this regard. There are limitations with load balancing. We would like to see support for in-memory processing.
Which solution did I use previously and why did I switch?I have also worked with SAP HANA.
What other advice do I have?My advice for anybody who is considering SQL Server is that it works well for small applications. However, large business applications that use a content delivery network or geographical location, it is not suitable for. I would rate this… more »
Which other solutions did I evaluate?We are currently searching for other products to replace this one with.
See 8 More SQL Server Reviews
Read Archived Reviews
What is SQL Server?
SQL Server is the Microsoft-driven relational database management system. This system is used to store data as well as retrieve it when necessary; these functions can be supported by individual users or by multiple users within a larger network. The Microsoft SQL Server has warehousing options, quality and integration services, management tools that are simple to implement, as well as robust tools for development.
Looking at the more technical end of things, Microsoft SQL Server uses query languages such as T-SQL and ANSI SQL. Disaster recovery is one of the product's most prominent features, in addition to in-memory performance, scalability, and corporate business intelligence capabilities.
Also known asMicrosoft SQL Server, MSSQL, MS SQL
SQL Server customers
Microsoft SQL Server is used by businesses in every industry, including Great Western Bank, Aviva, the Volvo Car Corporation, BMW, Samsung, Principality Building Society, Wellmark Blue Cross and Blue Shield, and the Catholic District School Board of Eastern Ontario.