Who Uses This Software?

Any company of all sizes, looking for database management software


Average Ratings

361 Reviews
  • 4.5 / 5
    Overall
  • 4 / 5
    Ease of Use
  • 4 / 5
    Customer Service

Product Details

  • Starting Price
    $931.00/one-time/user
  • Free Version
    Yes
  • Deployment
    Installed - Windows
  • Training
    Documentation
    Webinars
    In Person
  • Support
    Online
    24/7 (Live Rep)

Vendor Details

  • Microsoft
  • www.microsoft.com
  • Founded 1975
  • United States

About SQL Server

A relational database management system developed by Microsoft as a database server, designed to store and retrieve different requests. Choose your preferred language and platform and build modern applications creatively. Take advantage of breakthrough performance and availability while turning raw data into meaningful reports that can be delivered to any device or platform.


SQL Server Features

  • Backup and Recovery
  • Data Migration
  • Data Replication
  • Data Security
  • Database Conversion
  • Mobile Access
  • NOSQL
  • Performance Analysis
  • Queries
  • Relational
  • Virtualization
  • Backup
  • Data Migration
  • Database Conversion
  • Monitoring
  • OLAP
  • Performance Analysis
  • Queries
  • Storage Optimization

SQL Server Reviews Recently Reviewed!


Capterra-loader

I am using SQL server from three years as I am a software developer.

Jul 10, 2018
5/5
Overall
3 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: 1. The capability of extraction and manipulation of data. Using sql server you can fetch or gather data from different file system like excel file csv file etc and then manipulate them according to your need like sort them with name, make the first later of name in capital etc. And then you can print the manipulated data as well.
2. It provides backup for all your stored data into it, by this there is no worry of loosing your data.
3. After making backup obviously they provide the facility to restore those backups.
4. As I mentioned in first point report generation is also its one of the powerful feature.
5. It serves as back end for many programming language. When someone is maintaining his site.
6. Support of different tools like SQL profiler these tools will work as magic when you will be performing complex task.
7. Another tool is tuning adviser that can suggest you different ideas with which you can optimize your sql queries.
8.Gives you ability to run different instance of sql server in one system by this i mean one can have SQL server 2012 and then after that you can also have SQL server 2014 and 2016 parallaly.
9. Debugging tools like debugger.

Cons: There are very few things left about it as it has released its different versions.
1. It is paid
2. It is heavy sometimes it stucks.
3. Takes lot of resources like memory and space.

Overall: I am able to store thousands of users information in a arranged way.
I am able to analyse the data from different sources.
I am able to print report such as pdf file.
I am able to get backup of my data.
I can show the records in any form using SQL queries.
I can fetch details of any number of customer in just a second without going through the bunch.
I can update the data about my customer.
I can delete any unnecessary data.
I can send automatic mails using the sql job.
I can make my data easily accessible by using different index provided by SQL.
I can sort the data in ascending, descending or in alphabetical order.
So bottom line is I am making money by investing some money into SQL server.

Capterra-loader

My experience with sql Server has been satisfactory, I have done punctual work.

Jul 07, 2018
4/5
Overall
3 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
3 / 5
Value for Money
Likelihood to Recommend: 7.0/10 Not
Likely
Extremely
Likely

Pros: This software has as its first advantage that it is a Microsoft product and has the full support of the company and the stability of a well-tested product. At the basic level, I find it very efficient, the sql responses are fast and there are almost no service interruptions, which is a point in its favor when I use it, I find the Transact-SQL language that is used very powerful, I was able to assign commercial processes of the application in the database that allows multiple applications to use them and it is not necessary to program these functions in each application, the SQL server administration tools are very well thought to be all in a Microsoft environment, the integration is perfect, they are very intuitive to find new functions, they do not require prior knowledge, what is important to train new staff, another thing that I like about this software is the scalability that can start with a small database and grow, in A past project had transactional tables that inserted millions of records daily. I like security, it is possible to assign specific permissions to different users who perform different activities within the same database, this makes me trust the product.

Cons: The least I like is undoubtedly the cost SQL-Server does not have a good cost-benefit ratio, other brands offer better benefits in this regard, another point is the high consumption of RAM, it is necessary to allocate a large amount of resources for this And to guarantee the quality of the service, until now I have not found a hosting provider that offers me a PHP server with Sql-server. This stopped once a new development for a client was disappointing to me. It is difficult to learn in a particular way, the free versions of this software are very limited and the certifications are expensive, which reduces the interest when it is investigated.

Overall: I have worked several times with this software for different reasons I have been able to simplify developments thanks to the Transact-SQL so it has saved me programming time, the services that I have under my responsibility at work are stable, this gives confidence and tranquility for me and for my bosses, I made restorations in record time.

Ridiculously powerful and full of features we do not make use of. We love it, and cannot do without.

Jul 02, 2018
4/5
Overall
2 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: SQL Server is just so incredibly powerful, most users probably do not know how much it can do, or how much it can handle. In our type of organization, we deal with people and animals. We rely on donors and members for funding, we track everything about our animals from health issues, to medications, to physical exercise. Every one of our systems relies on, as the backbone, SQL Server. This software is powerful, versatile, and reliable. With pretty much every department of ours needing some type of database, standardizing to SQL Server was just the best move. It can handle it all. It can track it all. And it can report on it all for us. To date, we use it for: our Accounting software, our donor tracking, our membership tracking, our animal tracking (includes tracking from what zoo or aquarium animals came, their medical history, their exercise history, their diet, their location in our facility, their trainers, their behavioral issues/environmental factors), our vet's digital imaging systems, our guest services scheduling, our security systems (surveillance, door locks), our water quality and hvac sysytems logging and controls, our point of sale system (for admissions and food court and ecommerce), and our facility management software (maintenance and IT requests). This system does indeed handle everything we need it to.

Cons: You need a lot of training to make the most of it. Or it could cost you a lot if you have to pay a developer to help you get the most out of your systems. Luckily a couple of us are really into databases, and we both have a lot of experience with SQL, we can do most things in-house. But still the amount of training we go through to keep current, or to keep learning is probably the biggest "problem" with this software. Most software packages, you can buy, setup, receive a few hours or a few days of training, and you'll be good to go. With SQL, if you intend to use it, to get the most of out it, you will need more extensive training, or to hire people to put in the work. It's not cheap. But it can help you accomplish so much if you put in the time.

Overall: This software practically runs our facility. Without it, we couldn't keep track of our animals or our people (staff, members, donors). To us, this software is well worth the costs involved.

Capterra-loader

If you are working from scratch,it is relatively easy to set up a new database server and connectivi

Mar 13, 2018
5/5
Overall
4 / 5
Ease of Use
4 / 5
Features & Functionality
4 / 5
Customer Support
3 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: If you are working from scratch, it is relatively easy to set up a new database server and connectivity between clients. Everything is quite simple, given that you have knowledge of the database. The DBMS allows you to easily create several things completely in design (tables, views, etc.), which is a great advantage when you do not know all the syntax.

The integration of other monitoring software such as fog light is very easy without the consumption of time. Great ability to handle all complex query requirements. Suite of advanced functions of sql. Provide all the excellent functionalities, such as Reporting Services, Integration Services, Job Scheduler, Resource Manager, Query Analyzer and Profiler, etc. Each of these modules is perfectly constructed and manages the tasks effectively. Configurable in each level. The user permission is on all objects and other higher levels. Changes can be made for specific privileges at the user level. Window service based on Control to the server to start and stop the service.
I think one of the best things about Microsoft SQL (currently using 2012) is the Developer Network and the useful resources that are available. Thanks to the network of developers, I have been able to learn much more about queries and create more useful and advanced queries over time. Things like Transact-SQL (T-SQL) are useful many times due to the large number of new queries that can be generated after learning T-SQL.Compatibility with most SQL Server administ

Cons: Sometimes, performance when executing some long queries is not what you would expect. Although the power of the CPU is important for this part, but in the company we have state-of-the-art servers in the NAP of the Americas, so it seems a software problem instead of a hardware problem.
Some of the configurations of previous versions (2008 - 2012) are quite clumsy and not very well done - I have had several instances of my corrupt installer and have to re-download. The administrator of the database, sometimes, takes time to load.
Scalability is excellent, but not the best, like other new databases in the market. The memory consumption of the CPU is always more than normal in the production specifically by the sql server. Scope of the improvement in the profile generator for the most used options.
Sometimes, if it is not handled properly with a predefined scheme, the relations and the maintenance of the data become a problem. This happens mainly only when it comes to new users or with people who do not work as part of a larger workforce that manages the system.
Certain add-ons also provide useful features, but if SQL added them, it would save users the problem of finding and installing them. The database is the target of many attacks from your SA account, this should be disabled by default and just after installation, about 30 seconds, the attacks begin, with many requests per second, need to improve the firewall to prevent these attacks, or place the SQL Server inside a VPN

Very reliable, relatively easy-to-use, and reasonably-priced compared to Oracle

Oct 05, 2017
5/5
Overall
4 / 5
Ease of Use
5 / 5
Features & Functionality
4 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: As a Systems Administrator, MS SQL Server is one of the easiest DBMS you can use from a management perspective. SQL Server Management Studio is a very robust client, and it allows you to configure everything from either the GUI or SQL scripts. No digging into config files, calling apps from command line, etc. User management in SQL server is easy and straight-forward while being EXTREMELY granular. Plus, it easily connects to Active Directory if you so desire.

The software is very reliable. MySQL can have issues during backups, but not SQL Server. Once you get it set up and configured properly (again, not hard to do), you can leave it running for months without encountering problems.

While SQL Server is by no means cheap, compared to the other enterprise-level DBMS like Oracle, it's quite reasonable. MySQL is free, but it's quite limited when you do a feature-by-feature comparison with SQL Server.

If you're on the fence, install an Express instance (up to 10GB databases with some limitations). You won't be disappointed.

Cons: Like a lot of other Microsoft software, the installer is pretty bloated with prerequisites, components, etc. But that's a fairly small nitpick.

I will also say that RAM management in SQL Server isn't perfect. SQL will, as long as it is regularly used, consume all of the RAM you have allocated it. By default, that setting is 2 petabytes of RAM, so it will slow your system to an absolute crawl, consuming everything it can to the detriment of the OS itself. This means you need to manually allocated a reasonable amount of RAM to SQL knowing full-well that it will likely consume this RAM at all times. That's fine for dedicated database servers, but it's not ideal for people running SQL on laptops.

Aside from that, I have very few complaints about SQL Server.

Overall: Our entire product line (IIS-based web applications) relies on SQL Server. Without it, our business wouldn't function at all.

I have been working with this software from last 8 years. I like this software and used its features

May 25, 2018
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money

Pros: This software offers a lot of features that are very handy to work with. And frankly it took very less time to understand this software and get used to it. I have used this software for creating stored procedures, functions, views, database schema.
Easy to connect with external database as well. I have heavily used the SQL profiler which again is a very useful feature. SQL profiler let you see the request that SQL receive from a source and it help you debug your code. Generating backup, restoring backup, importing and exporting data tiers all features are so easy to understand. Even I never googled to know how to do it, I just saw the option and start following the instructions and it's done. Its easy to use and all its features are very useful. Even when you didn't saved your file and accidentally your laptop got off,it help recover your files. Easy interface to create database tables even if you do not remember the script syntax.

Cons: There is nothing that I don't like kind of this with this useful software.
Its just if the edit rows option could have been made easy by auto showing the SQL pane to write query while editing the rows. I found it one step extra. It should be like when we select rows. Also running the query on edit rows if could be done via f5 only, then it would be easier for the user.

MS SQL Server Perfect Database Management Solution

Apr 05, 2018
4/5
Overall
4 / 5
Ease of Use
5 / 5
Features & Functionality
4 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Comments: I would definitely recommend that you read the Windows administration book before you start exploring SQL server.

Pros: SQL server is a great database management product. This is a very fast and stable and at the same time cross-platform solution running on both Linux and Windows operating systems, the security of which is implemented at the highest level. It is also gratifying that SQL server works equally well on both physical and virtual servers, both on the ground and in the cloud. Since this product is produced by Microsoft, it integrates well with other products of this company, such as Power BI. This app can provide you with high availability and a wide selection of options available of your choice, though everything will depend on the edition. And most importantly, many features can be tested completely free using Developer Edition.

Cons: Although SQL server is easy to manage through the graphical user interface, but to understand how it works, to fix some problems you need to read a thick book, and even more than one and read ton of documentation. Does not have good monitoring tools out of the box. For some companies will not be a cheap solution.

A great database and a data management solution

Nov 21, 2016
4/5
Overall
4 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
3 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: You can do practically anything with this database because it, has complete solutions integrated into it like SSIS, SSRS, Monitoring, Task Schedule (SQL Agent), alerts, other database connectors, etc.
And currently Microsoft is working to finish his database 2016 version to running on Linux.

Cons: Perhaps the only (at the moment) problem, are the locks management in the database when the update/delete operations are very big. I miss the possibility to auto-partition (internal scripts) of these operations, managed by the database engine.

Overall: I have been working with MS SQL Server from the SQL 2000 version. Currently I work with SQL 2016 (and I am testing SQL 2016 in Linux). In all of these years, I have been using a different solution of the database (clustering, data mirroring, CDC, log shipping, AlwaysOn, etc..), always with a great satisfaction.
A great number of people think that MS SQL Server is a database for small data volumes but, these people are wrong. This database, can manage a big data volume and his management could be very easy if you follow the MS recommendations.
On the other hand, you have a great knowledge base in Microsoft and in a great number of tech portals and blogs. You can find in the Internet, (almost) any T-SQL code to implement with only search it.

Stable, high performance and extremely capable enterprise database software

Jan 28, 2018
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: Microsoft Ecosystem
SQL management studio
Query Analyser
DB Tuning / Optimization wizard
Estimated Query Results
Ease to integrate with any front end technology
High Performance
High Scalability
Scheduled jobs
Ease of Integration via Visual Studio

Cons: Enterprise License costs
Slight learning curve for advanced features like SSIS, data warehousing.
Performance Tuning of large database would take years of core specialized training and experience
No supporting software like RedGate to performance schema / data comparisons

Overall: This is a very vast and complex software and one has to spend years using this software to summarize its very many benefits.
Having worked in mostly Microsoft development shops for the past 14 years, I have used SQL server in almost every enterprise project that I have worked on.
Ease of use, simplicity to alter schemas, easy TSQL syntax, ability to easily create and manage indexes/stats, reporting services, ease of access control, security via encryption, performance tuning capabilities, always on features, backup and restore capabilities with advanced backup and restore options, cloud capabilities, ease of integration with various front end software are just some of the various benefits of this mammoth software.

It really is a complete DBMS, and easy to use, with very good support and documentation. I recommend

May 11, 2018
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money

Pros: That is a relational DBMS that allows programming in hybrid environments, either locally or in the Microsoft cloud. It allows you to transfer databases in a very simple and intuitive way between your local environment and the cloud. It is one of the most secure databases in the world, because it allows transparent data encryption, audits, extensible key management and encrypted backups to protect data in critical workloads, and its storage system allows a query performance much higher than usual. All the processes of analysis, consultation, cleaning, data formatting and access are carried out at a speed that surprises you. It allows to carry out backups and recoveries: they can be configured in advance, which makes their execution carried out in a simple way. It provides extreme compression of tables and indexes and High availability: the downtime caused by updates and revisions disappears or is minimized, in order to guarantee an almost permanent availability. These availability and maintenance status of the databases can be checked easily with a very visual panel. It provides a Task Scheduler which allows you to plan tasks in advance, and they will be executed automatically. It has good documentation. And management of data types and users, which strengthens

Cons: Really as such, there is something that I do not like, in which case what I like the least is the price

"Microsoft SQL server - WHY"

Oct 17, 2016
5/5
Overall
4 / 5
Ease of Use
4 / 5
Features & Functionality
4 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Pros: Data accessing via Excel or Access is very easy.
Reporting services are a really good example to present and analyze the data to management.
We do have an analytics team which does a lot of data modeling and also uses lots of integration services.

Cons: Definitely room for improvement in SQL server reporting services.
Missing the functionality to purge/archive/delete the reports from the server. We have to do it one at a time.

Overall: I prefer SQL Server for SharePoint applications. There are SSIS data sources, destinations that can be used to sync data between SharePoint lists and SQL Server tables. SQL Server is a good choice if you are looking for a solution with quicker time to market. It is simple to use and administer. However, I would prefer something else (like Oracle) for enterprise solutions.

Recommendations to other buyers: I think for any application it really works well. It has lots of features which could help with business requirements. It can easily import the data from different data sources and also can export the data in the required format. It is really good in OLTP transactions too. We will have to use it well to make it more efficient. For ex: if you don't have proper indexing, it might take time to retrieve the data you wanted or you might run into time out situations.

Great data base! Recommended for bussiness or personal use.

Jul 13, 2018
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: SQL Server is a data base that is increasing your functionality, features; has a great performance on Windows or Linux, is stable, secure. You can use it for big projects like SAP without any trouble. Highly recommended, you can do a test with the free version of SQL Developer - you will get all the features, but it is just for devoloping, not for production use. You can use the Express edition for free but with the limitation that the dabase file size is just of 10GB.

For example in a company that I give IT services they had SQL Server 2005 with Windows Server 2003 r2 for many years, they moved to SQL Server Standard 2014 with Windows Server 2012 in 2016 because they need to apply an update over a software. So, it is very stable and secure. We didn't have any issue or problem during all the years (and still).

Cons: I don't have any negative comment about SQL Server, because from my point of view it is a very good and stable data base. May the only one could be the price.

Overall: Easy to use, secure, stable, good performance.

Capterra-loader

So far I enjoy using SQL Server to query databases that our customer have at my job

Apr 17, 2018
4/5
Overall
3 / 5
Ease of Use
4 / 5
Features & Functionality
4 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: 7.0/10 Not
Likely
Extremely
Likely

Pros: I like that you can upload a database, then immediately start querying the data or altering if needed. There is no waiting afterwards. Our customer at my job have databases that we don't really query on to reduce usage or traffic. So we make backups and upload on our person computers that way we can hit it hard and not have to worry about the customer seeing any issues or if we accidentally mess up, it doesn't shut them down instantly. Once you get used to using select statements, joins, and looking at store procedures, SQL is pretty easy to use.

Cons: My only con is that the learning curve is difficult but I understand why. It would be ridiculous to make it easy and then hackers all over would destroy data or steal it even more. The actual con I have is in the latest release of SQL Server. It is a bit glitchy when it comes to opening the application and waiting for it to fully load after signin. This could be the hardware I am using it on but at times it is the only thing running and still is slow.

Capterra-loader

SQL Server is a powerful, fast and feature-rich enterprise database platform

Jun 05, 2018
4/5
Overall
4 / 5
Ease of Use
4 / 5
Features & Functionality
4 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: SQL Server is constantly being improved for features, performance, reporting and stability. The SQL Server community is great and Microsoft do a good job at providing information, training and resources to support it. SQL Server is all the tools and features for modern software development against a database platform. The query tuning/profiling continues to improve, as does the database engine itself which allows software developers to gain valuable insight into how the engine works. SQL Server features and components all work together under one management solution which is great.

Cons: SQL Server dependencies can sometimes be painful to deploy and manage correctly. The installer continues to improve, but would be great to have more smarts in this part of the solution. Would be great if SSMS had better support for visualizing which database you're currently working on, when using in a multi-database environment.

Overall: SQL Server is the back-bone of all of our software development and reporting.

Enterprise-grade SQL that is polished and with high adoption for the Microsoft eco system

Feb 22, 2018
4/5
Overall
3 / 5
Ease of Use
4 / 5
Features & Functionality
4 / 5
Customer Support
3 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Pros: - Support: Well-documented, and is a cornerstone of Microsoft enterprise software, and is well-designed very robust.
- Integration: If you are standing up Microsoft applications that require MS SQL as it's back-end, the process is flexible regarding if you want the SQL server hosted on the same box or on a remote server for design and resilience. The process is generally very well documented and the requirements for the installation are highlighted and straightforward.
- Clustering: It can be complicated to initially setup, but it is worth it. Clustering your SQL servers reduced single points of failure, leveraged our hardware resources more efficiently while also making maintenance and patching more flexible.

Cons: - Pricing confusion for physical vs virtual licensing: Pricing is a moving target with Microsoft, so pay very close attention to your infrastructure, how you use SQL, and work with your reseller to determine the most cost-effective way to move forward.
-Split-permissions: Active Directory is the flagship of Microsoft enterprise software, and it grooms you to understand shared permissions that are integrated around Active Directory, and everything joined to it. MS SQL is not setup this way, they are split out, so to understand the permissions model of MS SQL, you have to invest in the MS SQL eco system.

Microsoft SQL Server - An industry standard database system for a variety of applications

Apr 10, 2018
5/5
Overall
3 / 5
Ease of Use
5 / 5
Features & Functionality
3 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: Microsoft's SQL Server database engine is a standard for SQL applications. Users can write their own apps around it, but it is often used to support other off the shelf software where a database is required. It is also the backbone of Microsoft's SharePoint and Reporting Services, yet is used by countless other apps such is its appeal. Queries against data can be made directly inside the database app itself, as well as with countless client apps including many free ones. Permissions access to objects can be local or from Active Directory. Development apps such as Microsoft's Visual Studio can work directly with to create rich database driven applications.

Cons: There can be quite a learning curve with SQL Server, but this is due to its sheer complexity and security. It is well worth it thouh once these obstacles are overcome.

Overall: It supports other apps such as Backup Exec, SharePoint, and our own in-house database driven CRM.

Capterra-loader

The giant of RDBMS.

Feb 02, 2018
5/5
Overall
4 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money

Pros: I am a DBA specialized in using the microsoft platform for several years, even having seen several DBs I can confirm that in this case Microsft has created a complete and really well done product. I believe it is absolutely one of the best RDBMS on the market, since the latest versions have also introduced in-memory technologies is truly a complete product. Obviously we are talking about a "business-enterprise" product, but if you want to play a little with express / developer versions you can also start with simpler and faster implementations.

Cons: The licensing costs are high especially if we are talking about Enterprise versions, it must be said that direct competitors have much higher prices and do not provide complete packages like that of Microsoft that includes everything in the license cost, including the complete package of tools suitable for BI (ETL, REPORTING, OLAP ...).

A popular BI platform that makes the implementation of integrated BI services easy.

Feb 06, 2018
4/5
Overall
4 / 5
Ease of Use
4 / 5
Features & Functionality
3 / 5
Customer Support
Likelihood to Recommend: 7.0/10 Not
Likely
Extremely
Likely

Comments: Overall Microsoft SQL Server BI would have a solution for most requirements of a typical BI solution. The look & feel, as well as how the tool interacts with its users can be improved.

Pros: Microsoft SQL Server BI offers a full set of tools and functionalities for different phases of a BI solution. Since it is a very popular and widely being used, there are a lot of resources available. Moreover, Microsoft provides tools and services that serves both the upper stream and lower stream of BI services, making the adoption of Microsoft SQL Server BI seamless on existing Microsoft infrastructures.

Cons: A lot of tools are not smart enough and requires intense manual work. For example, SSMS can't recognize and auto-pop newly-created tables/views without restarting; SSIS is not able to refresh the metadata on its own when there is underlying table changes; SSRS offers very limited format control for Excel/PDF export.

Run a true enterprise database management system reliably

Mar 19, 2018
5/5
Overall
4 / 5
Ease of Use
4 / 5
Features & Functionality
3 / 5
Customer Support
3 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Pros: We run about 20 SQL servers across the company reliably. We run various editions from Standard to Enterprise. The bulk of the servers host student information systems as well as point of sale systems. This means that data transactions are consistent throughout the day. We're also able to extract and mine data using SSMS for our data warehouse and ad hoc reporting needs. This has allowed our company to increase its business and are looking to expand in the very near future.

Overall: A solid database engine that will run without issues as long as you've got the hardware for it.
The product is great. However, the cost is substantial. The licensing is a bit of a mess depending on what edition you run and varies across yearly editions. One version might be licensed by server while others are licensed by core. We'd like to see all versions licensed in a more standard fashion.

Easy to use

Jul 26, 2017
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
4 / 5
Customer Support
4 / 5
Value for Money

Pros: Whether they advertise it a lot or not, Microsoft invests heavily in SQL Server¿s core database engine in every new version. Back in the old days, a nine-table join was a recipe for disaster; now it¿s no big deal. The same holds true for SQL Server 2012: You can expect better overall performance when compared side-by-side to older versions, and ¿better performance¿ is always a reason to consider an upgrade.

Cons: Newest versions of SQL Server brings some significant changes, and change isn¿t always best. For example, your IT team will have to re-think how they engineer database availability given the completely-changed high availability features in SQL Server. Most other administrative tasks will remain significantly unchanged, but if availability is an important concern for your organization, make sure you understand what you¿re getting into with this new version.

Capterra-loader

SQL Server as great Relation Database Management System

Feb 14, 2018
5/5
Overall
4 / 5
Ease of Use
4 / 5
Features & Functionality
5 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: Works on cloud and on-premises servers.
Deep integration with another Microsoft and not only products.
It is cross platform RDBMS can be run as on Windows and on Linux.
The database engine provides the ability to adjust and monitor performance levels that can reduce resource usage.
It is very fast and stable.
It got good security with data encryption and another options.
It provides multiple high availability solutions to choose from.
You can test many features of the product by using free developer version.

Cons: Not very easy to conduct performance tuning, need to use multiple tools, there is no any native good graphical tool from the box.
Not very easy and fast to perform migration from instance to instance.
Not cheap solution.

Overall: You can test many features of the product by using free developer version before pay it.

Intuitive tabular database tool that integrates across Microsoft¿s huge catelogue as well as countless other products

Nov 07, 2017
4/5
Overall
3 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Comments: Despite the above critique, the troubleshooting and development issues become less and less frequent and all of the positives mentioned above become more noticeable than any cons. Also, although the software can be pricey, it is unnecessary to have a large number of licenses for most businesses as long as a handful of professionals have the skills to role it out and manage it, you can get away with limiting the costs.

Pros: For the 90% of businesses that use Excel at the very least, SQL offers seemless integration for compliling, staging, and connecting multiple data sources in an easily accessible format with little or (in the case of dash boarding and automated refreshes) no training.

Cons: Building a database from scratch is tedious, and sql server is granular enough that minor mistakes can cause big problems and can be hard to fix once an instance has 100s of variables, multiple sources, or connections.

Capterra-loader

I used it for university projects

May 28, 2018
4/5
Overall
3 / 5
Ease of Use
4 / 5
Features & Functionality
3 / 5
Customer Support
1 / 5
Value for Money
Likelihood to Recommend: 6.0/10 Not
Likely
Extremely
Likely

Pros:
*It is a database management system.

*It is useful to manage and obtain data from the network of networks.

*It allows us to forget about the files that make up the database.

*If we work in a social network it allows us to add other SQL Server servers. For example, two people who work with SQL Server, one of them can connect to the server of their other partner and thus you can see the databases of the other partner with SQL Server.

*SQL allows you to manage permissions to everything. It also allows someone to connect your SQLO to ours but nevertheless we can tell you that you can not see this database but another yes.

Cons:
*It uses a lot of RAM memory for installations and software use.

* It can not be used as practices because many things are prohibited, it has restrictions in the particular.

* The relationship, quality and price is very low compared to oracle.

* It has many blockages at the page level, a fixed page size and too small, a terrible implementation of variable data types.

Overall:
Although I use it in university projects, it worked very well for the requirements I had

Good but nothing special

Mar 31, 2018
5/5
Overall
3 / 5
Ease of Use
3 / 5
Features & Functionality
3 / 5
Customer Support
3 / 5
Value for Money
Likelihood to Recommend: 7.0/10 Not
Likely
Extremely
Likely

Pros: SQL server has provided us a great security and integrity improvement over our previous software database. We were desperated with DBase constant corruptions. It's been 6 years since we adopted SQL server and never ever had an issue with data. Nothing.
Performance is amazing even with huge databases. It's worth the price.

Cons: Not easy to manage.
Not multiplatform. We bought SQL server because we were "forced" to work in Microsoft ecosystem, and that forced us to pay for Windows licenses, backup software, a more expensive server... We did not like that. We use other database systems like MySQL server or Maria DB with the same good results (and a little more freedom).

Overall: I had bad times with data integrity and corruptions using other database systems. Never had that issue since we started using SQL server.

Capterra-loader

excellent database manager with a large number of tools for the development of a project

May 10, 2018
4/5
Overall
3 / 5
Ease of Use
5 / 5
Features & Functionality
4 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Pros: When developing a project where a large amount of information must be recorded, it is excellent to use a SQL relational database.
it allows us to store information in the best way so that the data is not cloned and does not find repetitions of these.
Microsoft SQL Server gives us a large number of commands and tools to develop, manipulate, retrieve, create and define data, and can be configured to use multiple instances.
includes a friendly graphical environment that allows the use of commands. it allows us to work in client-server mode and supports storage procedures and transactions.
can be used to develop complex projects that contain three or more layers without any problem

Cons: This software can consume many resources on computers, such as RAM. causing our equipment to freeze. in relation to quality and price, it has a lot of competition compared to other SQL relational database administrators

Capterra-loader

In the field of systems development, I have mostly used Microsoft SQL Server as database manager

Apr 29, 2018
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
4 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: Microsoft SQL Server is one of the most powerful database engines on the market, all the robust Microsoft tools such as Dynamics and Sharepoint use it as a database manager. Each version has greater capabilities and better sentences so that the code with which we manipulate the data is the most efficient possible. One of the most used tools to detect some type of problems regarding the queries that are being sent to the server is the SQL server profiler, when we have a query and we want to observe the efficiency of it we can use the tool in the query analyzer. of execution plan which gives us an overview of it and thus gives us a vision of how it would run and also detect problems that we can solve in the query. We can create a cluster of servers to have high availability of information, we can create jobs to execute sentences at certain times, among others

Cons: The free version of Microsoft SQL Server, called express, has very little size capacity for databases, currently 10 GB. Although this serves as input for people to know the tool, today this is very little if we wanted to build a small application that saves images in bit format, it would grow very quickly.

Overall: Most of the applications developed throughout my career use Microsoft SQL server as database manager, it is one of the most powerful engines in the market and its use is oriented to applications and services in high demand and that require bases of Robust data that allows to grow with time and make the data as manageable as possible.

SQL server is the most known Database Management Software, easy to use and intuitive.

May 20, 2018
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money

Pros: It's intuitive, easy to use and easy to learn. Most of the functionaities have an GUI for a fast and reliable experience. Later versions are fast on their tasks and manages data in a more efficient way. Column encryption, granular access to data and easy programmability makes this a good choice for Database Management. Another advantage is that actually it can be installed on Windows and Linux environments.

Cons: For small companies, price would be a big stopper. SQL server comes in a variety of versions, Enterprise edition costs thousands of dollars and small businesses could opt to choose a more "cheaper" Database Management Software. Also, it has a propietary language so if you are looking for a cheaper host to store your database would be complicated.

Easy to work with, interface like visual studio

Dec 11, 2017
5/5
Overall
4 / 5
Ease of Use
5 / 5
Features & Functionality
4 / 5
Customer Support
4 / 5
Value for Money

Pros: I really do enjoy working with the SQL Server client. Something about its familiarity like visual studio makes it pretty easy to use. It's definitely the nicer looking client out there for those user other database clients. The nice thing is that the client is rock solid and I've never had it crash on me. You have the ability to query multiple servers at a time, and the answer sets are preserved per query window - very useful. Its definitely more powerful than Access since it is a fully fledged database.

Cons: I find sometimes its hard to bring things into or out of the tool. Exporting data can be a pain sometimes, it would be nice as a Microsoft product to export to excel, and vice versa to be able to import with excel files too.

Build more Powerful models with SSAS in Visual Studio for improved performance. Better tools and easier (but not easy) for the novice.

Jun 14, 2018
3/5
Overall
2 / 5
Ease of Use
4 / 5
Features & Functionality
2 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Comments: Really improved integration with other tools, especially Excel and Power BI. Also, somewhat more intuitive than more limited SSAS instances.

Pros: This is extremely useful software for data analytics and reporting, and the new interface with Microsoft Excel Power Pivot makes it much easier for a novice to pick up some useful tools. It's an especially nice product to set up a live connection with KPIs to Power BI which does not allow users to create KPIs independently.

Cons: Unless your data model is based on an organization server, modeling in SSAS will not help with much more than consolidating multiple sources into a single connection...in which case you either need to maintain a live connection or load into memory. So either keep your system running 24/7 triple your RAM.

Capterra-loader

excellent

Jun 10, 2018
5/5
Overall
4 / 5
Ease of Use
5 / 5
Features & Functionality
4 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: We don't havemuch choice in the matter with this one; several of our LOB software titles require MSSQL server, so we deployed it. That said, it's a very reliable and robust solution, especially in the later versions we're testing. The redundancy/failover clustering we're testing is AMAZING and results in smooth failovers in the event of a server issue. SSMS is easy to use and MSSQL syntax is logical.

Cons: SSRS leaves a bit to be desired, though. It's been neglected for years it seems and that really shows in the UI and functioanlity of it compared to other reporting solutions. They're making improvements to it in 2016 so I'm interested to see how our data analysts feel about it as time goes on.

SQL database queries aren't intuitive, but they are a powerful way to understand your data

May 17, 2018
5/5
Overall
3 / 5
Ease of Use
5 / 5
Features & Functionality
3 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Pros: With Microsoft SQL, you can run a query for any situation that your data may illustrate. For example, in a healthcare setting, you can run a query on a population of a very specific set of patients and correlate additional datapoints. It's very powerful, and I haven't seen a database program that could quickly run these types of reports.

Cons: The GUI/Management Console isn't intuitive at all. It's basically learning a programming language to get at the reports that you need. It would be nice if it had its own interface, but many times applications are developed with SQL and will have their own GUI to work with their database. If you're working directly in SQL, you'll have to learn its language.

Capterra-loader

Friendly application that allows you to program forms and reports in oracle, and access information

Jun 29, 2018
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support

Pros: Its structured way to develop applications to be used in companies that want to control and manage their processes.
It has standards that allow it to be easy to use and you can consult online, through the internet, any doubts you may have about the syntax to apply for the development of programs or reports.

Cons: It is required to have knowledge of the key fields of the tables in order to obtain the desired results or to control.

Overall:
It allows me to work determining the problems of the incidents reported by users in an agile way because it observes or determines the details that could be the cause of the error presented or the reason for the incident.
Additionally, it allows to make the necessary modifications so that the application works correctly.

Comfortable and still kicking

Sep 02, 2016
5/5
Overall
5 / 5
Ease of Use
4.5 / 5
Features & Functionality
4 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Pros: Microsoft SQL Server has served me well, handling all kinds of tasks from Data warehousing, automated data pushes, reporting, notifications and ad-hoc analysis. Since we started using SQL Server several years ago, it has allowed us to better serve our customers with consistent data analysis and file pushes. There are also plenty of third party add ins which add immense value to the program.

Cons: This program has been around for a long time and most of the complaints I have ever had have been ironed out in recent versions. There is not much to dislike about the program. I will say that there are other vendors with better support than Microsoft but it is not lacking in any way, just not quite the personal touch you get from other vendors. Lastly, it would be nice if Microsoft would incorporate some of the extra features that third party vendors have created. They have slowly incorporated some of them in the past and I am sure it will continue though.

Recommendations to other buyers: Just make sure you have the proper hardware for your instance and you are good to go. There is not a lot of complication surrounding this install and evaluation is a cinch.

Administration suite of SQL Server far outshines other platforms

May 22, 2018
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
4 / 5
Customer Support
3 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Pros: Administration of users and interfacing with existing services is hassle free. Can use set system accounts or my latest feature is using available SSO to connect to databases in which permission has been granted. Analysis services has been updated which gives more accurate insight on procedures causing delays and db locks.

Cons: Using SQL Server is easy as it conforms to ISO standards, only issue is upskilling new users . There are too many ways to achieve the best results which tends to lead people to stick to one option without research. However this is not a fault of SQL. I enjoy using. Justifying licensing year on year becomes a bit of a mission to explain to business

The best database system on the market - both on premises or in Azure

Sep 25, 2017
4/5
Overall
4 / 5
Ease of Use
5 / 5
Features & Functionality
4 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: Comprehensive functionality - you get database engine, analysis services, integration services and reporting services. All pieces play very nicely with one another. You can easily set up SQL server on premises or in Azure. Very large user community with tons of documentation, tutorials and walkthroughs.

Cons: Enterprise edition is very pricey. Anything that you choose to set up in Azure tends to be pricey as well. Overall decent value for the money as long as you stay away from the Azure world. Storage in Azure (even premium storage) is less powerful than even middle-of-the-road SANs.

Overall: One stop shop kind of a tool for all of our data management needs. Nice integration with Power BI for visualizations.

It is our main Database manager.

Mar 30, 2018
5/5
Overall
4 / 5
Ease of Use
5 / 5
Features & Functionality
4 / 5
Customer Support
3 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: I like how fast the manager is. Its installation is simple to perform. The options available within the menus are placed in a way that makes it easy to find what is needed. The backup and restore options of the BD are very easy to use. Its capacity of operation, depends on the hardware installed, that allows to grow easily.

Cons: I do not like that it only works on Windows Operating Systems. The process of configuring access ports can be confusing and is not easily accessible after installation. Access control is very rigid in its configuration, which means that its configuration requires greater knowledge.

Overall: We have centralized the data repositories of the different corporate applications.

Reliable database engine

May 04, 2018
5/5
Overall
4 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: Very reliable database engine.
Years of test cases, and documentation in regards to any use case.
Very robust and highly available
SQL management studio
Ease to setup
Sql Express free versions is very generous for not costing anything
Backups and restorations are straight forward

Cons: Versioning differences. Older versions do not play well with the newer versions of SQL.
SQL Management studio is rather difficult to find in newer versions and doesn't appear to be bundled in .
Can be a resource hog unless you specify specific memory and CPU amounts
Disabling some versions of TLS causes caveats with certain tasks when trying to connect to databases.

Best full stack data platform

Oct 18, 2017
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
3 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: You get everything with SQL Server. A fully functioning database, ETL tool, report server, and multidimensional analysis server. All included in one low price. Features are being added quite frequently, and the software assurance license makes sure you have the best features for the next couple years.

Cons: It can seem a bit fragmented at times. But that is only because there is so much available to you. The documentation out there does require someone with the base knowledge of SQL and programming in general. Biggest problem for me is the separation of PowerBI away from SSRS. That really should be included all together. It is a shame they separate it.

New versions have become very robust

Sep 15, 2017
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: Ease of use. This is a very robust database server and good for business. I have been using Sql Server for a very long period of time and with every new version there are many new features and ease of use. This product is good for personal, small size, mid size and large organizations. Also very easy to understand as there are many resources available online and so one can get help easily. There are many courses available and has a great job market. I would recommend companies to use this product and organize their data. It also has great BI and reporting which has now become a very important part for any organization.

Its Easy, Friendly and Familiar

Mar 21, 2018
4/5
Overall
4 / 5
Ease of Use
4 / 5
Features & Functionality
4 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Comments: My company is primarily a Microsoft shop, so why not MS BI. Our Govt. has an MOU with MS so we get all the tools and we are trained in most things MS so we are comfortable and satisfied with this product. Even our PeopleSoft solutions run on SQL Server.

Pros: 1. Easy to use even by non-technical users 2. If you know what you are doing you can extend functionality and flexibility for almost anything you want 3. The above leads me to my next pro : stable IDE and flexible integration with SSAS

Cons: 1. A common language to develop and make changes would be nice 2. Its expected that you are an excel expert - but then again who isn't 3. It uses a lot of hardware power - but we have the horses

A great SQL server solution with a great deal of features and support, but expensive

Apr 13, 2018
4/5
Overall
4 / 5
Ease of Use
4 / 5
Features & Functionality
4 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: A very stable environment with clustering, replication, and everything you would expect from an enterprise level product. Includes a huge number of tools for working with data including import, export, SSIS, SSMS, TSQL and more. You can build your own custom modules that will integrate directly into the server. Recent versions allow for installation on Linux. There are user groups.

Cons: Not the most expensive, but still expensive, especially with free alternatives. Some of the Microsoft nomenclature around TSQL can be annoying, such as square brackets. Some features seem unnecessary and ponderous, like XML.

Capterra-loader

Industry Standard for Databases

Nov 07, 2017
5/5
Overall
4 / 5
Ease of Use
4 / 5
Features & Functionality
4 / 5
Customer Support
3 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Pros: Industry standard, full featured SQL Database.
Reliable code completion in the SQL Server Manager.
Large Community online able to answer questions.
Ability to Pivot data on the fly.

Cons: Generally considered to be a little expensive.
Proprietary standard.
Open Source could provide alternative solution.

Overall: As an Analyst it was good to use an industry standard and reliable tool that was relatively easy to use. Code completion in the Server Management Studio works really well, unlike some of the tools for open source equivalent tools. Full functionality vs other DBs like MySQL, so I was able to complete complex tasks at the database rather than reporting layer which sped analysis time up considerably.

I love SQL Server

May 06, 2018
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: SQL server comes with lots of tools like a Profiler, Management Studio, BI tools and Database Tuning adviser which will save you a lot of time in development and debugging. SQL Server has been evolving and being optimized for years and it a pretty solid database engine overall. Lastly, due to its popularity and support in the community it is well documented and you can find answers to anything you need quickly.

Cons: The only con with choosing SQL Server is that licensing is very expensive because the costs is per processor. Plus it only really can run on Microsoft's OS.

Overall: Enterprise level database engine.

Now a good alternative to Oracle

Apr 27, 2018
4/5
Overall
5 / 5
Ease of Use
4 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money

Pros: Standard. Follow ANSI92 standard . Others DBMS have own standard.
Easy to Use: If you know PLSQL, You can learn TSQL easily and can develop procedure for any purpose
Free. Express Edition is still free and was the first DB with this feature
Integration. Best integration with all Microsoft develop tools and others database systems
Linux. Yes. Exists Linux version and I've tested on Ubuntu. Very Good :)

Cons: Size. For big size data better Oracle rather than MS SQL Server.
DataType: Non easy migrate to MS SQL Server: Have to be careful with datatype.
No others Cons, in my opinion.

Solid Enterprise Database and great for database work

Jul 20, 2017
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: Microsoft SQL is a standard for applying the Structured Query Language to tabular databases, which makes life much easier when your database is massive. You can select the data that you want using clear syntax, and from there work more quickly.

Cons: I dislike that Microsoft SQL isn't as as streamlined as you might expect. For example, it takes many more keystrokes and clicks to import a table than it should, and table entries that are too large may not display properly.

Overall: SQL helped with data replication across database with ease. Picking all of those out one by one would have take a long time, but SQL made this processes fast.

Capterra-loader

Sql server is a complete engine to persist your data

Mar 13, 2018
5/5
Overall
5 / 5
Ease of Use
4 / 5
Features & Functionality
4 / 5
Customer Support
3 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Pros: * it have a "sql express" edition that allows to use it free * (mem and cpu limits)
* it allows to have a backend data service to retrieve information as you need it
* It have Sql management studio that is a complete suite to make querys, stored procedures and create tables/stored procedures/views/etc

Cons: it is propietary, not like mysql or firebird that are open source,.
It cost money if like the enterprise version

Overall: sql server is a complete solution to store / persist data. It is complete and reliable and allows to focus on the application and not how the data have to be saved.

For handling large amounts of data, it is best. Allows the analysis of the same.

Aug 15, 2017
4/5
Overall
4 / 5
Ease of Use
5 / 5
Features & Functionality
4 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Pros: Is designed for the management of many information at the same time, its speed in processing.It can be used for the design of related databases, in small and large companies, making more efficient the management of the information, its traceability and its audit.

Cons: The administration of many commands. The system needs to handle a large amount of physical memory to be able to process the information, making the equipment where it resides, be a machine rubusta and updated.

Overall: Saving time and financial resources to the company, keeping information centralized in a powerful system.

Capterra-loader

I've been using MS SQL for the last 11 years and loved how it helped me get the best of RDBMS.

Apr 19, 2018
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: MS SQL is very reliable, efficient and secure. I've been using SQL Profiler for the last 8 years and it made my life easier when searching for specific logs or activities that have taken place on a specific time and date. MS SQL has high security level. With the right settings and configuration, anyone's database will be fully secured.

Cons: I have nothing negative to say about MS SQL. It is simply the best RDBMS I have ever worked on. MS SQL is awesome!

Overall: I have learned everything I know now on RDBMS from MS SQL. I will not trade MS SQL for anything less. It's the best!

Capterra-loader

It's a great RDBMS, easy to use!

Apr 30, 2018
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
4 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: MS SQL Server is very easy to use and secure. I've been using SQL Server during 10 years and it made my job easier when I do a report, I always made a SQL sentence te get a result. The performance is stable with short time to wait. SQL Server is fully secured.

Cons: I have nothing in cons to say about MS SQL Server. It's a great RDBMS.
Sometimes I had a few difficult to setup permissions and roles. In high sentences this uses a lot of RAM memory but not is a big deal.

Overall: How it integrates seamlessly with Windows Server products and makes configuration and updating so easy.

Perfect for managing large data sets

Jul 03, 2018
5/5
Overall
3 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: We use SQL server on a daily basis to review data loaded on our system. It is incredibly powerful when you know the basics about querying. SQL server helps us to manage backups of our data schedule backups effortlessly. Once you get used to the interface, it is very easy to create shortcuts and navigate.

Cons: This is pretty tough when you first get started. There are a huge amount of features that take a decent amount of time to get a hold of. There has not been any other issues that we can report.

Overall: manage large datasets, admin, backup scheduling, db setup