Best For

Any company of all sizes, looking for database management software

Product Details

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.

Contact Details

Microsoft

http://www.microsoft.com

Founded in 1975

Located in United States

Starting Price

  • $931.00/one-time/user

Platform

  • Installed - Mac
  • Cloud, SaaS, Web
  • Installed - Windows
  • Mobile - iOS Native
  • Mobile - Android Native

Training

  • In Person
  • Live Online
  • Webinars
  • Documentation

Support

  • 24/7 (Live Rep)
  • Online

SQL Server Features

Access Controls/Permissions
Backup and Recovery
Data Migration
Data Replication
Database Conversion
Mobile Access
Multiple Programming Languages Supported
NOSQL
Performance Analysis
Relational
Virtualization
Backup
Data Migration
Database Conversion
Monitoring
OLAP
Performance Analysis
Queries
Storage Optimization

SQL Server Reviews

Overall
4.5/5
Ease of Use
4.5/5
Customer Service
4.5/5

Showing Most Helpful

Showing 50 of 1177 reviews

Showing Most Helpful

Showing 50 of 1177 reviews

Sort by:

Filter By:

Rating
Company Size
Reviewer's Role
Length of Use
Frequency of Use
Surender B.
Technical Lead
Information Technology and Services, 11-50 employees
Used the software for: 2+ years
Overall Rating
5/5
Ease of Use
5/5
Customer Service
3/5
Features
5/5
Value for Money
5/5
Likelihood to Recommend
10/10
Reviewer Source 
Source: Capterra
May 16, 2019

“Best DBMS tool for scalable enterprises”

OverallMy overall experience is 100% satisfactory because of its robust feature. I recommend this to all either its a large or small scale compan y because SQL server can handle large quantities of data and process it smoothly. Just loving it.
ProsMicrosoft SQL server is one of the best database management system that provide top rated performance optimisation with SQL queries, below is the list of top highlights: 1. Richness of user interface that provides ease of use with cool features like dock able windows. 2. Intelligence window is prominent feature that saves a lot of development time up to large extent. 3. Code debugging and performance tuning with query flow maps is the best features that assures about code optimisation. 4. Microsoft SQL Server Agent is provided with this software and that runs the automatic jobs in very secure way and later we can track the statements executed. 5. We can filter out the records in SQL Server Agent interface based on our interest. 6. Code snippet manager makes it easy to write high standard code that is perfact for code convention. 7. Most prominent feature is that it can handle large quantities of data, runs automatic jobs with concurrent transactions. 8. At last it's a Microsoft product that provides a belief to users.
ConsI have been using SQL server from version 2012 to 2014 and never troubled with SQL server's performance in any way. However I feel that error details must long descriptive when statement have some syntax error. Sometime its pathetic when we wants to know the exact error line but is hints the whole block of code instead of exact line number. Otherwise Its a great product and happy with it.
Reviewer Source 
Source: Capterra
May 16, 2019
Verified Reviewer
Information Technology and Services, 51-200 employees
Used the software for: 2+ years
Overall Rating
5/5
Ease of Use
5/5
Features
5/5
Likelihood to Recommend
10/10
Reviewer Source 
Source: Capterra
April 3, 2019

“Perfect for all types of workloads! ”

OverallHave used SQL Server as a a Relational Database (RDBMS) for the past 15 years, primarily to support SAP based enterprise workloads. Microsoft's development of SQL Server has been fuelled by its largest customer - SAP, in order to provide better functionality to rival its competition (Oracle, DB2, Informix (who remembers this one?). I started with MSSQL 2000 and boy has it come a long way. MSSQL versions are denoted via the year and is still a practice till today, similar to how Microsoft denotes its Windows versions. To date, the latest version of MSSQL 2017 is also supported on SAP, and I am sure once MSSQL 2019 is released later this year it would also be certified by SAP.
ProsThe review is based on my experience of using SQL Server as a database with SAP. What I like about MSSQL : - ACID compliant like any enterprise based RDBMS (Oracle, IBM DB2, SAP HANA) - Runs well and scales well with commodity x86 hardware - Various editions to suit customer needs and requirements. For example Express Edition for small workloads and is free, or all the way to Enterprise Edition for state-of-the-art functionality (High-Availability, Disaster Recovery etc. to prevent Single-Points-of-Failure). Its current functionality definitely rivals the existing enterprise RDBMS's - Straightforward learning curve as it is Windows based. Unlike other RDBMS's (e.g. Oracle or DB2), administering a MSSQL DB is very easy GUI (SQL Server Management Studio) is very easy to use especially if coming from Oracle/DB2, or if you're learning from scratch - Supports Linux (finally!) - MSSQL is no longer limited to the Windows platform, and Microsoft has released version on Linux to compete with the likes of Oracle, DB2, etc.
ConsOver my years of using MSSQL have encountered numerous bugs (performance issues, corrupted data, etc.) but these are normal with other RDBMS's (Oracle, DB2, SAP HANA, etc.) given the enterprise nature of the workloads. Can't really think of any other disadvantages.
Reviewer Source 
Source: Capterra
April 3, 2019
Griffin B.
Senior Strategic Planning Analyst
Hospitality, 1001-5000 employees
Used the software for: 2+ years
Overall Rating
5/5
Ease of Use
3/5
Features
5/5
Value for Money
5/5
Likelihood to Recommend
10/10
Reviewer Source 
Source: Capterra
February 3, 2019

“SQL Server is the backbone of my life!”

OverallOverall, my experience with SQL Server is amazing! I am able to store all of our Las Vegas luxury casino data (gaming, hotel, food & beverage, entertainment, etc.) and query that for information that we then turn into automated or ad-hoc reports. These then go to the operators of the business as well as the executives who analyze the reports and make better decisions daily, weekly, and monthly. The goal is simple: just become better over time...better than you were last year, last month, last week. And SQL Server is the vehicle to empower your organization to find those valuable insights hiding in plain sight to do just that!
ProsI absolutely LOVE SQL Server. It is my favorite software to use because the possibilities for query-writing are endless. I would say this is the most reliable and flexible of all the database software I have ever used. SQL Server allows you to write in T-SQL (T = transact, SQL = structured query language), which means that you can create variables, use temp tables, and write code in a procedural format that runs akin to a module in other programming languages. We use SQL Server 2008 at work, though I am really loving the new features in the latest version (as of today) SQL Server 2016. Overall, SQL Server is a platform for creating table schema, storing information, and then writing scripts (queries) to manipulate that data--to find insights that are useful to making better business decisions. The interface is easy to understand, the error-checking is strong (and actually tells you what is wrong). It doesn't hold your hand like other simplified coding languages, but it becomes very reliable and easy to use once you obtain a solid foundation in relational database theory and SQL language.
ConsHmm...if I had to speak ill of SQL Server...I would probably say that it is a bit tricky to get up to speed quickly with. There's a lot to it, so to speak, so it's taken me the better part of five years working in the data analytics industry to finally say that I feel I am completely proficient in utilizing the software to its full potential. Topics such as query optimization remain my areas of biggest weakness. I can write a query to pull any kind of desired information; however, the art lies in being able to pull it quickly and with reasonable efficiency. If your query takes more than 15 minutes (or even hours!) to run, it's probably not written correctly and likely poses a major threat to the server you are connecting to (and tying up!) in the process. I would like more information in the software (GUIs, warnings, etc.) regarding poorly-written queries from an execution standpoint.
Reviewer Source 
Source: Capterra
February 3, 2019
Verified Reviewer
Hospital & Health Care, 10,001+ employees
Used the software for: 2+ years
Overall Rating
4/5
Ease of Use
5/5
Customer Service
4/5
Features
5/5
Value for Money
3/5
Likelihood to Recommend
8/10
Reviewer Source 
Source: Capterra
December 19, 2018

“SQL Server 2016 - Features Review”

OverallOverall experience with SQL server 2016 is very nice and excited in my perceptions due to Better support for memory optimzed tables, Built in JSON support, Stretch DB concepts, Query Store and dynamic temp db according to size and presence of CPU in the databases.
ProsIn our project we have been migrated from Microsoft SQL Server 2008 to SQL server 2016 directly for all our databases & SSIS packages. There are many features that was available to use for the projects and some of those are: 1. Data was always encrypted, so less vulnerable to SQL injections and useful to take a backup when database is in motion. Prior version (Before SQL server 2016) support only when databases is in Rest. 2. Data/Software Migration is very useful from prior version without any issues or taking any time. It took only set of testing activities and 2 hours of trun around time to get it upgraded. 3. Very simillar like XML TSQL clause created in SQL 2005, in SQL 2016 JSON clause T-SQL has been created for JSON output from querying database objects. 4. In prior versions we have to wait for long running query to capture, however in SQL server 2016 ability to view the execution plan as the query is active on the system. 5. Strecth Database is a new concept that has been created and stored in Azure. However in the background it is shown as single databases for user views.
ConsOnly I know very least number of disadvantages this MS SQL server 2016 is having: 1. Enterprise pricing may be costly as some of the organisation cant afford for the count of data they are having. 2 With the performance tuning, Microsoft SQL Server will be having some gobble resources.
Reviewer Source 
Source: Capterra
December 19, 2018
Verified Reviewer
Information Technology and Services, 10,001+ employees
Used the software for: 2+ years
Overall Rating
5/5
Ease of Use
3/5
Customer Service
5/5
Features
4/5
Value for Money
4/5
Likelihood to Recommend
9/10
Reviewer Source 
Source: Capterra
October 17, 2018

“Easy to configure, difficult to master”

OverallEasily the most intuitive RDBMS software out of the box.
ProsThe most noteworthy features of Microsoft SQL Server are the many tools and wizards that allow even novice users to get started by creating tables and views without extensive knowledge of relational databases. The query wizard can even assist with creating queries with its intuitive IDE. These features lower the intimidating barrier to entry that accompanies other relational database software such as Oracle or MySQL. There is even a free version call Express that allows anyone to dabble in the software before committing to the product. Aside from the user assisted features, the other appealing aspect of SQL Server is the integration with other Microsoft products that are probably already running in an organization. SQL Server interfaces with Active Directory allowing for easy user management so appropriate levels of database access can be allotted via group membership. This is useful because even something simple like user access management in another RDBMS may present a learning curve for anyone that is not a DBA. With SQL Server a general IT resource could manage user access with an existing knowledge of Active Directory providing more time to focus on core database design.
ConsSQL Server carries a high cost subscription based licensing cost. The user assistance features provide a great introduction to relational databases, but there is still a significant and continuous learning curve. Databases continue to evolve with industry need. Anyone that interacts significantly with SQL Server during day to day database or application design may need to consider yearly training to keep up with all the changes.
Reviewer Source 
Source: Capterra
October 17, 2018
Avatar Image
Aníbal M.
Programador
Unspecified
Used the software for: 2+ years
Overall Rating
4/5
Ease of Use
3/5
Customer Service
5/5
Features
5/5
Value for Money
3/5
Likelihood to Recommend
7/10
Reviewer Source 
Source: Capterra
July 7, 2018

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

OverallI 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.
ProsThis 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.
ConsThe 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.
Reviewer Source 
Source: Capterra
July 7, 2018
Jerry A.
System Administrator
Unspecified
Used the software for: 2+ years
Overall Rating
4/5
Ease of Use
2/5
Customer Service
5/5
Features
5/5
Value for Money
5/5
Likelihood to Recommend
10/10
Reviewer Source 
Source: Capterra
July 2, 2018

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

OverallThis 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.
ProsSQL 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.
ConsYou 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.
Reviewer Source 
Source: Capterra
July 2, 2018
Avatar Image
alfredo r.
ventas
51-200 employees
Used the software for: Unspecified
Overall Rating
5/5
Ease of Use
4/5
Customer Service
4/5
Features
4/5
Value for Money
3/5
Likelihood to Recommend
10/10
Reviewer Source 
Source: Capterra
March 13, 2018

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

ProsIf 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
ConsSometimes, 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
Reviewer Source 
Source: Capterra
March 13, 2018
Verified Reviewer
Computer Software, 51-200 employees
Used the software for: 2+ years
Overall Rating
5/5
Ease of Use
4/5
Features
5/5
Value for Money
4/5
Likelihood to Recommend
9/10
Reviewer Source 
Source: Capterra
October 5, 2017

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

OverallOur entire product line (IIS-based web applications) relies on SQL Server. Without it, our business wouldn't function at all.
ProsAs 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.
ConsLike 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.
Reviewer Source 
Source: Capterra
October 5, 2017
Avatar Image
carlos m.
Human Resources Generalist
Consumer Electronics, 5001-10,000 employees
Used the software for: 6-12 months
Overall Rating
4/5
Ease of Use
4/5
Customer Service
4/5
Features
4/5
Value for Money
3/5
Likelihood to Recommend
9/10
Reviewer Source 
Source: Capterra
June 30, 2019

“Microsoft SQL Server, Database Management in a single interface.”

Overallt is a business tool that allows the handling of huge amounts of data, it is used in local small and large transnational companies that connect and collect data in different parts of the world. I can add that once you get used to it to the SQL server user interface, the management and programming of it is quite comfortable and practical, but if necessary a fairly high knowledge of programming and data management, otherwise the clutter in the database would be almost impossible to fix.
ProsMicrosoft SQL server is a very administrative database management system known that SQL uses as programming language, additionally we can add command lines from other programming languages such as C # or java, to add functionality to your database, extremely easy to connect with other applications from which we can obtain the data we want, this manager does not facilitates maintenance where we can create and edit relational data, is capable of adapt to any operating system such as Windows, Linux and servers, in addition allows interconnection with an infinity of database managers such as MySQL, ORACLE and POSTGRE.
ConsMicrosoft SQL server is a very complete program but at the same time it is very complex to use, you need a prior or advanced knowledge about programming, especially in SQL, adding that the installation is quite tedious and long On the other hand SQL Server is not the only program that needs to be installed, for To be able to get the most out of the tool, the entire family of SQL server that includes tools for server interconnection, programming servers and other databases, despite having the ability to implement other programming languages, it is necessary to install third-party plug-ins. Is not a easy to use program for a single user, tends to be used in large companies, additionally it is a paid program if you require the assistance of Microsoft for the problem solving.
Reviewer Source 
Source: Capterra
June 30, 2019
Gonzalo P.
Technician
Industrial Automation, 11-50 employees
Used the software for: 2+ years
Overall Rating
5/5
Ease of Use
5/5
Customer Service
3/5
Features
4/5
Value for Money
3/5
Likelihood to Recommend
8/10
Reviewer Source 
Source: Capterra
August 21, 2019

“Good for medium and big companies ”

OverallI am using SQL Server for 4 years in a Low, Medium and Big environment, but in low environment i have a bad experience using SQL SERVER, Mysql is better in a small busines for cost, and simplicity, but in Big environment SQL SERVER can compete with ORACLE DB.
ProsIs powerfull Easy Complete Customer Support Features interoperatibity
ConsHave some errors You need to reset de SQL 1 time at week Consumes a lot of ram it needs a Windows Server
Reviewer Source 
Source: Capterra
August 21, 2019
Avatar Image
Anuj S.
Business Intelligence Analyst
Internet, 10,001+ employees
Used the software for: 2+ years
Overall Rating
5/5
Ease of Use
5/5
Features
5/5
Value for Money
5/5
Likelihood to Recommend
10/10
Reviewer Source 
Source: Capterra
September 5, 2018

“Two words - "Best RDBMS"!”

OverallHighly recommended - The Best RDBMS Package I have worked so far. Best IDE - let the wizard do basic things with you few clicks so you can focus on actual DB tasks and writing query. Developers in your team are going to love this Database!
Pros Microsoft SQL Server is the best RDBMS package I have ever worked on! (Other DBs I have used are - Oracle, Teradata, MySQL, and Redshift) Just like other Microsoft products; SQL Server is by far the most User-friendly Database Server - best IDE Lots of wizard features from import, export, backup, query builder etc that anyone can easily learn and do just with few clicks! Intellisense (like visual studio) to complete code while typing and showing common mistakes before you even execute Built-in execution plan viewer which is nice enough to start with. Free Plugins and third-party tools available to make your life even easier like: Poorman SQL Formatter, SentryOne Plan Explorer etc Integrates very well with other MS products. Full MS BI stack includes SSIS ETL, SSRS BI Tool, SSAS etc.
Cons No considerable cons. Maybe Microsoft should consider offering built-in features/tools for which developers use third-party tools and plugins. Like builtin execution plan viewer is not as great as SentryOne Plan Explorer. With so many built-in features one little must have to include is One click code indentation. Until Microsoft can add this feature, we can live with Poorman SQL formatter.
Reviewer Source 
Source: Capterra
September 5, 2018
Avatar Image
Scott S. M.
Sr. Data Analyst
Education Management, 501-1000 employees
Used the software for: 2+ years
Overall Rating
5/5
Ease of Use
4/5
Customer Service
4/5
Features
5/5
Value for Money
4/5
Likelihood to Recommend
10/10
Reviewer Source 
Source: Capterra
August 1, 2018

“Solid relational database ecosystem with useful accessories”

OverallThe ability to solve data problems and syndicate actionable information to the right audiences in a timely manner.
ProsI have been using Microsoft SQL Server for about 20 years and have watched the product evolve into a very mature and vibrant offering. SQL Server gives me the flexibility and performance needed for many different relational database solutions ranging from application OLTP databases to enterprise level business intelligence implementations. With my main focus being business intelligence, I have been very impressed with the SQL Server 2016 releases and improvements. It seems the Microsoft is very dedicated to this BI ecosystem and they seem committed to continuity in the products. Some of my favorite things to note are the new SSRS portal interface in 2016, the ColumnStore indexing in Enterprise versions, SSAS tabular models, and the ease of use with Power BI. Overall, I feel extremely confident in this product in terms of its use to solve almost any problem related to data. I find most things very easy to use and due to the wide use of this product, figuring out the more complex issues is not difficult thanks to Google.
ConsI sometimes don't appreciate the complexities related to transnational logging and the time it takes to roll back large transactions. Purely a performance and optimization issue, but the ambiguities in terms of when a task like this will complete can be frustrating.
Reviewer Source 
Source: Capterra
August 1, 2018
Umar W.
Software Engineer(Software Engineer)
Computer Software, 11-50 employees
Used the software for: 2+ years
Overall Rating
5/5
Ease of Use
5/5
Customer Service
5/5
Features
5/5
Value for Money
5/5
Likelihood to Recommend
10/10
Reviewer Source 
Source: Capterra
June 18, 2019

“My Database Engine”

OverallIt has been awsome as i am now a good Database developer because of this awsome tool.
ProsI am not DBA but i am using it from more than 3 years from university days and still using SQL in my professional life. I like everything about from query writing, to testing using SQL profiler. Most about it is that you can do most thing by using queries and GUI as well. Its easy to connect and configure with any kind of application with single line of code. Most thing about it is its prediction while typing and highlighting errors with underline squiggly.
ConsAs a developer i cant find anything that i dont like in it. Its always more than my expectations.
Reviewer Source 
Source: Capterra
June 18, 2019
Robert D.
Owner
Information Technology and Services, Self-employed
Used the software for: 1-2 years
Overall Rating
4/5
Ease of Use
3/5
Features
5/5
Value for Money
5/5
Likelihood to Recommend
8/10
Reviewer Source 
Source: Capterra
August 19, 2019

“SQL Server Great for SQL Database Creation”

OverallOverall, my experience with SQL Server has been pleasant. If I had employees, I would strongly recommend them to use is as their main source to create SQL databases. It makes sense to use a platform that is specialized and can be a one stop shop. That is what SQL Server is.
ProsI love the ability to create SQL databases separate from Visual Studio. Although you can create databases in VS, I like how SQL Server Management Studio is designed specifically for database creation. Plus, it has advanced features for database admins which Visual Studio does not. After creating a database, the admin can migrate the SQL Server database in Visual Studio.
ConsIt is difficult to learn if someone at a beginning level is using it. They will need to utilize the many tutorials provided within EDX.org, youtube or Udemy (to name a few) to learn it. It makes sense if you know how to create SQL databases and the SQL language prior to using it. If not, I suggest to learn SQL first prior to jumping into SQL Server to do database management.
Reviewer Source 
Source: Capterra
August 19, 2019
Avatar Image
Giorgi K.
Junior Commercial Analyst
Banking, 5001-10,000 employees
Used the software for: 1-2 years
Overall Rating
4/5
Ease of Use
4/5
Customer Service
4/5
Features
4/5
Value for Money
5/5
Likelihood to Recommend
8/10
Reviewer Source 
Source: Capterra
July 25, 2019

“A great database system for any purpose”

OverallWe use SQL Server for a data warehouse project in a large bank. It stores thousands of tables and terabytes of data, so it's mandatory for DBMS to run smoothly. SQL server does its job extremely well.
ProsSQL server is packed with features. It was a very fun job to implement it and using it is even better. Runs well, built-in tools are useful and plenty.
ConsIt takes up quite a bit of resources. Sometimes, tech support isn't very helpful. Otherwise, it's good.
Reviewer Source 
Source: Capterra
July 25, 2019
Anjali G.
Senior software developer
Unspecified
Used the software for: 2+ years
Overall Rating
5/5
Ease of Use
5/5
Customer Service
5/5
Features
5/5
Value for Money
5/5
Reviewer Source 
Source: Capterra
May 25, 2018

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

ProsThis 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.
ConsThere 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.
Reviewer Source 
Source: Capterra
May 25, 2018
Verified Reviewer
Computer Software, 1-10 employees
Used the software for: 2+ years
Overall Rating
5/5
Ease of Use
5/5
Customer Service
5/5
Features
5/5
Value for Money
3/5
Likelihood to Recommend
10/10
Reviewer Source 
Source: Capterra
September 9, 2019

“Very complete Database manager”

ProsEven when some people argue that is not the most fastest database for me is the most useful and with more tools than most, almost all databases has store procedure, functions, etc. but one thing that SQL Server has that most don't is the ability to create your own type of data, I mostly prefer to use Table type so I can insert a lot data in one single transition without using a loop condition to validate The source manager allos to see the type the query and from what machine is been executed
Consyou need to use the installer every time you need to create a new instance, if the server is down and you restar the services, you need to open the sql magnament to restart the jobs as well
Reviewer Source 
Source: Capterra
September 9, 2019
Jamie A.
IT Support Technician
Furniture, 51-200 employees
Used the software for: 2+ years
Overall Rating
5/5
Ease of Use
3/5
Customer Service
5/5
Features
5/5
Value for Money
5/5
Likelihood to Recommend
10/10
Reviewer Source 
Source: Capterra
September 5, 2019

“The absolute core of our business”

OverallOur overall experience with SQL Server has been formidable. This is the reason that it has been at the center of our business since we outgrew an Access central database over 20 years ago.
ProsInstallation and upgrading of the software is excellent. The additions of Query Store and other Analytics have drastically changed our ability to monitor the performance of all metrics of our Databases.
ConsTurn around time from issuing the Purchase Order until the license is released into our Microsoft account was rather slow, when we needed the software, we had to find an alternative solution until our license was released to us.
Reviewer Source 
Source: Capterra
September 5, 2019
Jordan S.
CTO/Co-Founder
Information Technology and Services, 1-10 employees
Used the software for: 2+ years
Overall Rating
4/5
Ease of Use
3/5
Customer Service
4/5
Features
4/5
Value for Money
4/5
Likelihood to Recommend
7/10
Reviewer Source 
Source: Capterra
August 22, 2019

“SQL Server: Beasty”

OverallI have had a pleasant experience working with SQL Server and have architected multiple relational database schemas with it. I think given it's native functionality inside of Windows environments and ease-of-use make it a nice Windows powered database tool.
ProsI love the ability to create native Windows powered web applications with Microsoft SQL Server databases at the heart of them all. Simple and easy to use SSMS (Sql server management studio) means you can administer and work on SQL Server databases in a snap. Also there are some very handy functions built in that allow easy duplication and movement of data between SQL server environments that I use quite a bit.
ConsThe learning curve can be steep and certain inherent complex bits of working with databases are not made any easier with SQL Server. One other thing I dislike about SQL server is more in the SQL Server management studio as they have yet to update that application with compatibility with QHD displays (at least as far as I know)
Reviewer Source 
Source: Capterra
August 22, 2019
Juan Carlos G.
IA Developer
Telecommunications, 11-50 employees
Used the software for: 2+ years
Overall Rating
4/5
Ease of Use
4/5
Customer Service
2/5
Features
4/5
Value for Money
2/5
Likelihood to Recommend
9/10
Reviewer Source 
Source: Capterra
July 18, 2019

“A nice Relation DB”

OverallI used to be working with freeand unexpensibe software like postgreSQl and mysql , moving to paid bar allowme to programm all my task on jobs or triggers making everything more easy and leaving me with more time to develop. Also my team controll allow me to check whats going on an d how did every move.
ProsEasy to use , many tools to help you with , most of our partnets use it. Lots of information on internet. Frequenly updated and patched up for microsoft. Help you with data analysis works on windows and ISS
ConsHeavy size . Most of the features are not used for new users. Costly yearly billing.
Reviewer Source 
Source: Capterra
July 18, 2019
Verified Reviewer
Health, Wellness and Fitness, 10,001+ employees
Used the software for: 2+ years
Overall Rating
4/5
Ease of Use
4/5
Features
4/5
Likelihood to Recommend
7/10
Reviewer Source 
Source: Capterra
July 11, 2019

“Easy to use. Lots of possibilities”

OverallWe use this for reporting and keeping a health of the business
ProsIt is easy to use. it uses standard structure T SQl language. Reporting options are not limited at all. It is very good and quick with queries. With 2017 there is a lot of changes and improvements on the fly queries as well as self monitoring of Data sources and server health. It works well with all microsoft products and easily can send things to SSIS or Microsoft office excel automatically.
ConsIt is hard to use with products not owned by microsoft. It is not easy to pull data directly from oracle. There are a lot of known driver issues that are being worked on. In the cloud as it is now it runs a little slower.
Reviewer Source 
Source: Capterra
July 11, 2019
Avatar Image
Vijai T.
CV /AV Architect
Automotive, 5001-10,000 employees
Used the software for: 2+ years
Overall Rating
5/5
Ease of Use
5/5
Customer Service
4/5
Features
5/5
Value for Money
5/5
Likelihood to Recommend
10/10
Reviewer Source 
Source: Capterra
September 29, 2018

“Efficient & Affordable RDBMS Product”

OverallGreat experience using this product back from SQL 2000 days to SQL Server 2017. Have used for both small size applications to big data projects that has data over 100 gb. Partitioning, Indexing, Sprocs, Views are used and taken advantage off. Automatic plan correction, Adaptive Query Processing are improvements in 2017 need to take advantage off. My vote is for this product
ProsNice GUI & Easy to configure using wizards. Scalable product from midsize to complex solutions. Has come a long way from where it was started back from late 90's to till date. On par with other RDBMS products like Oracle in the market. Microsoft has built nice cluster support especially for redundancy and high availability.. New features such as Dynamic resource allocation, Graphical Query Analyzer, OLAP services are huge win. Additional products to support warehousing & Reporting, Transformation services, Analytics is a huge plus. Lot of performance improvement with 2017 version.Bang for the buck.
ConsStill there's a concern from consumers perspective that SQL Server is for mid-complex systems. For ERP based systems, IoT use cases users go for No SQL products. Another challenge is for global distributed database solutions there's challenge especially Mirroring of data, synchronization, concurrency it's a huge challenge.
Reviewer Source 
Source: Capterra
September 29, 2018
Vish P.
Technology Lead
Computer Software, 10,001+ employees
Used the software for: 2+ years
Overall Rating
4/5
Ease of Use
5/5
Customer Service
4/5
Features
5/5
Value for Money
4/5
Likelihood to Recommend
10/10
Reviewer Source 
Source: Capterra
August 21, 2019

“Good option for RDBMS”

OverallIt is a good product as long as you are not looking at it for backups or you are not moving data between multiple environments, since copying around 1.5 -2 TB of data will take upwards of 24 hours.
ProsEase of accessing data and the speed with which you can read million of records User and Access Management is simple and not at all complicated Creating a new table, stored procedures, etc. is standard and can be done without issues.
ConsDatabase backup, restore, and migration take a ton of time. they are super slow, and totally make it a bad choice for a archival type of database or secondary backup system.
Reviewer Source 
Source: Capterra
August 21, 2019
Avatar Image
Sudharshan S.
Software Engineer
Computer Software, 1001-5000 employees
Used the software for: 2+ years
Overall Rating
5/5
Ease of Use
4/5
Customer Service
5/5
Features
3/5
Value for Money
4/5
Likelihood to Recommend
8/10
Reviewer Source 
Source: Capterra
August 6, 2019

“The best is yet to come.”

Overallgreat and fulfilling. the Future is definitely bright.
ProsSQL Server in traditional sense always belonged to a group of mid range companies. Hosting terrabytes of data was never a part of its ideals. But the recent upgrades for its availability on the cloud makes one wonder where it is headed. I think the future for SQL Server is good.
ConsNO SQL functionality does not exist. Although columnar, flat file data sources can exist, the SSAS functionality needs to include a database conversion to a NO SQL database view. This greatly enhances the visibility of a transactional database.
Reviewer Source 
Source: Capterra
August 6, 2019
Sourav K.
Software Engineer
Information Services, 5001-10,000 employees
Used the software for: 1-2 years
Overall Rating
4/5
Ease of Use
4/5
Customer Service
4/5
Features
4/5
Value for Money
4/5
Likelihood to Recommend
7/10
Reviewer Source 
Source: Capterra
April 14, 2019

“MS SQL -- Database Engine”

OverallWe are using it as a main backend Database engine and it is doing well
Prosit is a great RDMS engine that has a great User friendly interface .We can easily manage the database with the help of interface that provides a lot number of options and thus makes job of DBA more effective and Reliable .we can easily restore the database and operates Database functions like update , delete , insert etc and if needed we can also trace the query that is running at a time with the help of inbuilt tool called profiler. Remote access of the Database engine is very easy to configure , we just need to put the Database engine name , user name and password and we are connected and perform operations. To automate certain query , another built in tool called Job agent can be used by which we can create the job in which we just need to put the SQL query and its timing means when will it be executed .We can also integrate permission in the SQL as per the Organization and thus making it more secure .Database backup , schema extraction of the objects , most heavy query , most occupied table can be done with very ease.
ConsWebAgent takes a lot of CPU utilization and thus making System slow Large queries having millions of lines of code is not handled properly Does not automate shrink table size when data is deleted from the table ,need to done manually
Reviewer Source 
Source: Capterra
April 14, 2019
Charan G.
Senior Software Engineer
Information Technology and Services, 10,001+ employees
Used the software for: 2+ years
Overall Rating
5/5
Ease of Use
5/5
Customer Service
5/5
Features
5/5
Value for Money
5/5
Likelihood to Recommend
10/10
Reviewer Source 
Source: Capterra
February 22, 2019

“MS SQL Server is the best tool for DBMS - All in one”

OverallI am using the MS SQL server since 2011 which is almost 9 years and I never faced any challenges in database management. I would say it is a great application, easy to learn, use and play with it. Also, Microsoft is having great support for this application in terms of documentation, trouble shooting and live support. Whenever I faced any challenges in terms of server connectivity, database connection, authentication I always get a solution from Microsoft forums to resolve this issue. Simply I am a happy user and I would recomend MS SQL to others as well.
ProsThe MS SQL Server helps our organization to create/organize/maintain customers data. For most of the Web applications, we are using the MS SQL server for database management. It is not only helping to manage customer database, but it also helps in generating SRS reports for our valuable client. It gives ability to create tables, stored procedure, functions, triggers, backup and restore the data. It is having job scheduling capability as well. It is having the ability to create indexes on database tables which allows us to retrieve the database in a faster manner.
ConsI don't have anything to mention here. I find everything is good in this software. Using the MS SQL Management Studio you can use this software for your database management.
Reviewer Source 
Source: Capterra
February 22, 2019
Avatar Image
Ebrahim F.
Software Developer
Computer Software, 11-50 employees
Used the software for: 2+ years
Overall Rating
5/5
Ease of Use
5/5
Features
5/5
Likelihood to Recommend
10/10
Reviewer Source 
Source: Capterra
January 9, 2019

“Stable, fast and reliable”

OverallOverall, my experience with SQL Server has been awesome
ProsAs a lot of my development work depends on SQL Server, it is something that I use almost every day. It is extremely stable and reliable and certainly the only database platform that I will ever consider working with. There is still so much I have yet to learn about SQL and so much to explore, but for my current skills and work requirements, it is excellent and always works well. From simple queries to complicated procedures, I always find it a pleasure to work with. I have worked with other database architectures before, but found that SQL is much quicker, as well as easier to work with.
ConsMy problem is with SQL Management tools and some of their limitations, but not SQL Server itself. One such example would be backing up and restoring of large databases (40GB upwards). While backups are mostly a breeze, restoring becomes extremely challenging and time-consuming as the database grows beyond the 40GB mark. I am not sure if this is because of the limitations on the available management tools, or if it is an actual problem with SQL server, as the large databases I have worked with had no issues with CRUD operations or backups.
Reviewer Source 
Source: Capterra
January 9, 2019
Michael H.
Systems Engineer
Financial Services, 51-200 employees
Used the software for: 2+ years
Overall Rating
4/5
Ease of Use
4/5
Customer Service
3/5
Features
5/5
Value for Money
4/5
Likelihood to Recommend
9/10
Reviewer Source 
Source: Capterra
November 15, 2018

“SQL Server - Keeps Getting Better”

OverallI have spent more than a decade working with SQL Server and various technologies from a Sys-Admin/Sys-Analyst role in modern day IT organizations. I've had the opportunities to install, maintain, worked on and within, and develop throughout several versions of SQL Server. I've worked in SaaS and Web App for providers that combined have covered the entire Fortune 50 and more than half of the Fortune 500. I've worked in JavaScript prior to and throughout it's massive growth creating projects in NodeJS using mssql and node-mssql to transform SQL data into useful JSON object sets on the fly since before SQL could even output JSON. I've authored several helpful tools over the years combining SQL Server with bleeding edge platforms to provide tools to previous organizations that were better at the time than even some leading tools performing those functionalities today.
ProsSQL Server is an industry standard software. It is highly configurable, capable of multiple setups, and deeply ingrained with the Microsoft Windows platform. Administration is quick, effective, and easier than ever.
ConsSQL Server 2017 has a weak implementation of Graph databases which will be a much more prevalent database type once big data and IoT really kicks in. In my opinion, Microsoft should be forcing the graph database capabilities forward and trying to match products like NEO4j in performance.
Reviewer Source 
Source: Capterra
November 15, 2018
Pam K.
Sr. Sysadmin
Aviation & Aerospace, 201-500 employees
Used the software for: 2+ years
Overall Rating
4/5
Ease of Use
5/5
Customer Service
2/5
Features
5/5
Value for Money
2/5
Likelihood to Recommend
7/10
Reviewer Source 
Source: Capterra
August 14, 2019

“SQL Server - Costly but Worth It for Business”

OverallOur in-house ERP system was built originally on Access. We moved over to SQL Sever and gained many business rich features that help empower us to meet our customer requirements.
ProsSet up and deployment is simple compared to some of the 'free' and 'open source' software packages available.
ConsCostly. Very, very costly. The price keeps increasing for on premise versions of SQL Server.
Reviewer Source 
Source: Capterra
August 14, 2019
Verified Reviewer
Information Technology and Services, 1001-5000 employees
Used the software for: 2+ years
Overall Rating
4/5
Ease of Use
5/5
Customer Service
5/5
Features
4/5
Value for Money
5/5
Likelihood to Recommend
9/10
Reviewer Source 
Source: Capterra
August 7, 2018

“SQL Server in my daily life”

Overall70% of my daily office work is depend upon this product. Whenever i need to debug the issue, find the query, procedure executed behind the display then i have to execute on Sql Server. I use to select the data, update, alter , change in any column as per requested by customer. I always check my CPU, Execution time, reads and writes to improve the performance of my product display.
ProsThis is one of the product which I use in my daily life. 1. With this , I check all the data in the tables which show in the front end (display). 2. I use one of the feature i.e. Sql Profiler to get the query, procedure, tables etc which executing while load the display. 3. Get the execution time , CPU time , Reads, Wrtites, etc of the query from profiler with this product. 4. We can make shortcut keys of the query which you use the most like select query, show the columns of particular columns etc.
ConsSometimes, I faced the issue while using the WINDOW+R shortcut which toggles the result set. Many times it stucks and then I toggle the result set by dragging it. For installing it , need compatible software, window version. It took more time to set up . If one of the requirements is not fulfilled then you have to make it compatible and try again the process.
Reviewer Source 
Source: Capterra
August 7, 2018
Denis V.
MS SQL DBA
Computer Software, 201-500 employees
Used the software for: 2+ years
Overall Rating
4/5
Ease of Use
4/5
Customer Service
4/5
Features
5/5
Value for Money
4/5
Likelihood to Recommend
8/10
Reviewer Source 
Source: SoftwareAdvice
April 5, 2018

“MS SQL Server Perfect Database Management Solution”

OverallI would definitely recommend that you read the Windows administration book before you start exploring SQL server.
ProsSQL 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.
ConsAlthough 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.
Reviewer Source 
Source: SoftwareAdvice
April 5, 2018
Avatar Image
Umut K.
Software Developer
Information Technology and Services, 51-200 employees
Used the software for: 2+ years
Overall Rating
5/5
Ease of Use
5/5
Customer Service
5/5
Features
5/5
Value for Money
4/5
Likelihood to Recommend
9/10
Reviewer Source 
Source: Capterra
August 10, 2019

“Powerfull Database”

ProsEnterprise level database Fast There is a free(express) version for small application Go to database for Microsoft ecosystem
ConsSlow installer Eats all of your server's memory
Reviewer Source 
Source: Capterra
August 10, 2019
Avatar Image
Nirmesh K.
Team Lead Manager
Computer Software, 10,001+ employees
Used the software for: 2+ years
Overall Rating
4/5
Ease of Use
5/5
Customer Service
4/5
Features
5/5
Value for Money
4/5
Likelihood to Recommend
9/10
Reviewer Source 
Source: Capterra
December 9, 2018

“SQL Server - Robust application for database storage, analysis and reporting”

OverallWe are using Sql server in our organisation to create new databases and maintaining the existing one. Data access is so simple and secure. If there is any sensitive data then we use to encrypt the table columns data. Overall its a great application.
ProsSql server is a powerfull data storage tool and widely used in our organisation. Its enrich with numerous inbuilt features. In sql server backup and restoration task is much easy. Its preety much secure and reliable tool. In sql server there are several security roles to authorize the user, so we use to supply the privilege according to need. Its reporting services are greatly helpfull for us to analyse the data. I can easily monitor the performance / health of the database. Dtabase tuning advisor extremely good in case of performance improvement task as this reveals proper detail of missing items like Index, primary key, stats etc. Easy to review the execution plan of a stored procedure. Data movement from one server to another server is much easy. I can trace the sql statements nicely with the use of trace component.
ConsMicrosoft Sql server setup takes a bit more time but once done then all good.
Reviewer Source 
Source: Capterra
December 9, 2018
Avatar Image
Abhinav K.
Sr Software Integrator
Computer Software, 501-1000 employees
Used the software for: 2+ years
Overall Rating
4/5
Ease of Use
4/5
Customer Service
4/5
Features
4/5
Value for Money
4/5
Likelihood to Recommend
8/10
Reviewer Source 
Source: Capterra
November 17, 2018

“SQL Server - A RDBMS by Microsoft”

OverallMicrosoft SQL Server is helping use to find the best programming capacity to match up with the secure and best performance. User interface is also user friendly as it does not need any basic training to under the infrastructure.
ProsSQL Server is the one of the best database management software I have ever worked on. Relational database management system based on relational model. Performance of the SQL Server is also high. It is easy to setup and GUI also provide the user friendly interface to work on it. Integration on SQL Server with non relational data source is also improved compare to the SQL Server 2015. The Best feature in it advance analytics which help you to keep the track of the development. Support and integrity also improve in the SQL Server 2017 with cross-platform as it can now work with Linux as well as Docker container.
ConsSQL Server is having the large community so the vulnerability and fixing are coming very frequent. Real time intelligence sometime not work as expecting. The SQL profiler should come with more default option and Microsoft should provide the interface where we can develop and design the profiler template.
Reviewer Source 
Source: Capterra
November 17, 2018
Avatar Image
David M.
Senior Developr 2
Computer Software, 1001-5000 employees
Used the software for: 2+ years
Overall Rating
5/5
Ease of Use
5/5
Customer Service
5/5
Features
5/5
Value for Money
5/5
Likelihood to Recommend
10/10
Reviewer Source 
Source: Capterra
October 23, 2018

“SQL over the time”

OverallI have used SQL Server as the weapon of choice for business development and despite some minor product bugs over time, always has been a highly manageable and capable especially for long-standing data, very friendly even with developers who are not familiar with Microsoft technologies
ProsFor long time has been the working horse for database oriented applications and corporate data on Microsoft side. Is a highly robust database engine and supports a lot of punishment on production enviroments. Also provides a long standing continuity for older database repositories over from previous versions of the product. The management tools in their several incarnations provided almost all the needed capabilities for developers and database administrators. Also the cross data capabilities and the support for OLAP has been among the stronger points, currently enhanced capabilities for memory oriented data, cloud computing and the newest support for Linux enhance the experience
ConsI found that a major drawback i found over the time is than usually SQL Server releases are a little behind their competitors in terms of state of the art capabilities and features.
Reviewer Source 
Source: Capterra
October 23, 2018
Daniel T.
Architect IT
Information Technology and Services, Self-employed
Used the software for: 2+ years
Overall Rating
4/5
Ease of Use
4/5
Customer Service
5/5
Features
5/5
Value for Money
3/5
Likelihood to Recommend
9/10
Source: Capterra
November 21, 2016

“A great database and a data management solution”

OverallI 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.
ProsYou 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.
ConsPerhaps 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.
Source: Capterra
November 21, 2016
Verified Reviewer
Food Production, 51-200 employees
Used the software for: 2+ years
Overall Rating
5/5
Ease of Use
4/5
Customer Service
4/5
Features
5/5
Value for Money
5/5
Likelihood to Recommend
9/10
Reviewer Source 
Source: Capterra
August 12, 2019

“SQL Server database administrator”

OverallI am developer of sql server which makes me easy is SDLC and SSRS reporting . Which is very fast and efficient.
Pros1. Fast searching and supporting large sized data. 2. SQL indexing is making it very fast. 3. support all framework. 4. Integration and support for most of dotnet based software and erp solution. 5. highlt secured and very precise reciovery option.
ConsNot at all only it should be free to use for small shops.
Reviewer Source 
Source: Capterra
August 12, 2019
Kelsey M.
Senior Software Developer
Health, Wellness and Fitness, 10,001+ employees
Used the software for: 2+ years
Overall Rating
5/5
Ease of Use
5/5
Customer Service
5/5
Features
5/5
Value for Money
4/5
Likelihood to Recommend
10/10
Reviewer Source 
Source: Capterra
June 5, 2019

“The premier database engine”

OverallI have been using SQL Server for over 20 years as a full stack developer. I have used other DB engines as well but nothing has come close in feature set and ease of use. Microsoft support, when needed, has been exceptional as well.
ProsSQL Server's features, interface, and vast amount of documentation make it an amazing choice for a database engine. Management Studio makes dealing with day to day database needs simple and intuitive.
ConsThe cost. SQL server for large systems can be expensive. With that expense you do get the piece of mind of having Microsoft support behind it's product which when needed has been top notch.
Reviewer Source 
Source: Capterra
June 5, 2019
Avatar Image
Gurleen K.
Software Engineer
Information Technology and Services, 10,001+ employees
Used the software for: 2+ years
Overall Rating
5/5
Ease of Use
5/5
Customer Service
5/5
Features
4/5
Value for Money
5/5
Likelihood to Recommend
9/10
Reviewer Source 
Source: Capterra
April 24, 2019

“RDBMS by Microsoft”

OverallMicrosoft SQL Server is a great software to manage your relational database. Data Maintenance plan can be configured easily to setup the different kind of backup like differential backup,transaction log backup, tail-log backup. Microsoft is working on simplifying the management part with high availability of server using features like fail-over and load balancing.
ProsSQL Server is a relational database developed by Microsoft. SQL Server manages the data warehousing and manage the workload efficiently. The real time analytics help in improving the store-procedure performance. Clustering help to distribute the workload in the peak hours. Mirroring database helps in redundancy and can be recovered in case of database corrupt .Dynamic data masking and data encryption help to secure the data. Fail-over is easy to configure in SQL Server 2019 edition.
ConsMS SQL Server backup encryption is one of the best feature Microsoft added in it but it needs some more options like recover key options. Microsoft SQL Server Developer edition should also support the hybrid cloud environment so DBA's can also implement the 2 Tier architecture.
Reviewer Source 
Source: Capterra
April 24, 2019
Avatar Image
Sanchita A.
Software Engineer
Telecommunications, 10,001+ employees
Used the software for: 2+ years
Overall Rating
5/5
Ease of Use
5/5
Customer Service
4/5
Features
4/5
Value for Money
4/5
Likelihood to Recommend
9/10
Reviewer Source 
Source: Capterra
March 22, 2019

“SQL Server - RBMS by Microsoft.”

OverallWe are working with this technology from past seven years. The buffer pool extension and encryption for database backup make its production ready RBMS. The high featured management tool for SQL Server help in administration and make it user friendly. The SQL express edition is also good as it comes with all basic feature to host the RBMS.
ProsMicrosoft SQL Server is a structured query language based relational database. SQL server is easy to implement as administrator makes it simple. The high performance sql engine help in data compression and can be scaled upto petabyte of data with maintaining the enterprise grade. MS SQL improves the security with its each patch and make it least vulnerable. High availability and feature like load balancing make it user's first choice to implement it as its production friendly where A high end server is needed. The backup can be scheduled under maintenance plan.
ConsMicrosoft SQL server price for enterprise edition cost thousands of dollars. Depending on the requirements it also needs high end and dedicated server which indirectly increase the cost with the platform licensing cost.
Reviewer Source 
Source: Capterra
March 22, 2019
Eyamir U.
Profesora
Unspecified
Used the software for: 2+ years
Overall Rating
5/5
Ease of Use
5/5
Customer Service
5/5
Features
5/5
Value for Money
5/5
Reviewer Source 
Source: Capterra
May 11, 2018

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

ProsThat 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
ConsReally as such, there is something that I do not like, in which case what I like the least is the price
Reviewer Source 
Source: Capterra
May 11, 2018
Verified Reviewer
Unspecified
Used the software for: 2+ years
Overall Rating
5/5
Ease of Use
5/5
Customer Service
5/5
Features
5/5
Value for Money
5/5
Likelihood to Recommend
9/10
Reviewer Source 
Source: Capterra
January 28, 2018

“Stable, high performance and extremely capable enterprise database software”

OverallThis 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.
ProsMicrosoft 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
ConsEnterprise 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
Reviewer Source 
Source: Capterra
January 28, 2018
Verified Reviewer
Unspecified
Used the software for: 2+ years
Overall Rating
5/5
Ease of Use
5/5
Customer Service
5/5
Features
5/5
Value for Money
5/5
Likelihood to Recommend
10/10
Reviewer Source 
Source: Capterra
July 13, 2018

“Great data base! Recommended for bussiness or personal use.”

OverallEasy to use, secure, stable, good performance.
ProsSQL 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).
ConsI 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.
Reviewer Source 
Source: Capterra
July 13, 2018
Piyush J.
Student
Computer Software, 51-200 employees
Used the software for: 2+ years
Overall Rating
5/5
Ease of Use
4/5
Customer Service
4/5
Features
4/5
Value for Money
4/5
Likelihood to Recommend
8/10
Source: Capterra
October 17, 2016

“"Microsoft SQL server - WHY"”

OverallI 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.
ProsData 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.
ConsDefinitely 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.
Recommendations to other buyersI 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.
Source: Capterra
October 17, 2016
Pankaj R.
Pankaj Rayal
Computer Software, 10,001+ employees
Used the software for: 2+ years
Overall Rating
4/5
Ease of Use
5/5
Customer Service
5/5
Features
4/5
Value for Money
4/5
Likelihood to Recommend
9/10
Reviewer Source 
Source: Capterra
February 1, 2019

“Great for Enterprise application”

OverallI will rate it 9/10. Looking into features and ease to operate, performance etc. I have tried other DBs but personally like this one. SSDT is great component for Visual Studio and sometime you don't need to run SSMS (SQL Server Management Studio), as you get most of it on SSDT, but database engine must be running. I love it.
ProsEven for beginners it's easy to use. Great for creation, management and easy to learn. The query analyser is awesome. Inbuilt template for New Database, stored procedure, views, tables. Easy to generate script for table and it's data. Execution plan is really helpful when writing complex queries. Overall, I really like it. I have full version installed my machine and have disabled some services which I don't want like SQL Agent.
ConsThe heavy one. I know it has many in built features like sending emails directly from database and generate reports but still heavy. Sometime I couldn't restore the backup from older version and that is painful. The price is high, may be the reason they have done tremendious job since they release 2005 version.
Reviewer Source 
Source: Capterra
February 1, 2019
Verified Reviewer
Management Consulting, 1-10 employees
Used the software for: 2+ years
Overall Rating
5/5
Ease of Use
3/5
Customer Service
5/5
Features
4/5
Value for Money
5/5
Likelihood to Recommend
9/10
Reviewer Source 
Source: Capterra
September 10, 2018

“Solid Data Consolidation Platform”

OverallIf you are an IT resource, the experience is great.
ProsSQL Server continues to get better all the time. I use it for helping SMBs consolidate their data for BI/analytics for both on-premise and Azure. The product is solid and never have a problem (especially Azure). If you have used any of the previous versions. Due to its long history and wide use, resources are always available to support the product. The security continues to get better and integrates well into Power BI. Over the last couple of years, Microsoft has also added additional connector services which is great for many IT shops.
ConsIf Microsoft wants to stay relevant in the SMB world they need to make it more automated, intuitive and dummy proof for individuals in Marketing and other disciplines. The product requires some serious IT support which is not always available. I have never been happy with their Training and certification programs (basically they suck). Microsoft dictates how classes are to be run and lost connection with the evolving world.
Reviewer Source 
Source: Capterra
September 10, 2018
Avatar Image
Nicholas R.
Software Support Technician
Computer Software, 11-50 employees
Used the software for: 2+ years
Overall Rating
4/5
Ease of Use
3/5
Customer Service
4/5
Features
4/5
Value for Money
4/5
Likelihood to Recommend
7/10
Reviewer Source 
Source: Capterra
April 17, 2018

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

ProsI 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.
ConsMy 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.
Reviewer Source 
Source: Capterra
April 17, 2018
Edwin d.
SQL Server Engineer
Retail, 201-500 employees
Used the software for: 2+ years
Overall Rating
4/5
Ease of Use
3/5
Features
5/5
Value for Money
3/5
Likelihood to Recommend
8/10
Reviewer Source 
Source: Capterra
November 21, 2018

“DBA's review on SQL Server (v7/2000-2017)”

OverallKeeps getting better and better!
ProsSince the redesign of the database engine in 2005, each new version is enriched with more and more feaures and functionallity, also pushing down more and more Enterprise features to lower editions. Microsoft took another road a couple of years ago and are now fully embracing other platforms and eco-systems that makes the choice for SQL Server easier (or harder ... :-)). With R, Polybase, Linux and dockers, SQL Server is definitely on their way to the future.
ConsIt takes some time to figure out which licens model you have to choose. Even with the assisitence of third parties you hear different suggestions that makes it even harder. But with some effort and puzzling we were able to come up with a structure that is robust an least expensive, you should closely watch the type of VM's you put on the same host in a VM-cluster and think about the way you (over)provision that host. The massive amount of new features are hard to keep up with though ...
Reviewer Source 
Source: Capterra
November 21, 2018
Avatar Image
Rod W.
Owner
Unspecified
Used the software for: 2+ years
Overall Rating
4/5
Ease of Use
4/5
Customer Service
4/5
Features
4/5
Value for Money
4/5
Likelihood to Recommend
10/10
Reviewer Source 
Source: Capterra
June 5, 2018

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

OverallSQL Server is the back-bone of all of our software development and reporting.
ProsSQL 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.
ConsSQL 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.
Reviewer Source 
Source: Capterra
June 5, 2018