Microsoft SQL Server

Microsoft SQL Server

Customer Verified
Top Rated
About TrustRadius Scoring
Score 8.9 out of 100
Top Rated
Microsoft SQL Server

Overview

Recent Reviews

SQL Server Review

8 out of 10
June 19, 2021
We use MS SQL Server as our main database to store customer data. We have a monolith web application that is using a single MS SQL Server …
Continue reading

MS SQL Server

8 out of 10
May 25, 2021
For the uninitiated it is first important to point out that many programs use a Database at the back-end and the end-user will be totally …
Continue reading

Reviewer Sentiment

N/A
Positive ()
N/A
Negative ()
Learn how we calculate reviewer sentiment

Awards

TrustRadius Award Top Rated 2022
TrustRadius Award Top Rated 2021
TrustRadius Best of Award, Best Of Customer Support 2021
TrustRadius Best of Award, Best Of Feature Set 2021

Reviewer Pros & Cons

View all pros & cons

Video Reviews

Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of Microsoft SQL Server, and make your voice heard!

Pricing

View all pricing

Subscription

$1,418.00

Cloud
Per License

Enterprise

$13,748.00

Cloud
Per License

Entry-level set up fee?

  • No setup fee

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting / Integration Services

Features Scorecard

No scorecards have been submitted for this product yet..

Product Details

What is Microsoft SQL Server?

Microsoft SQL Server is a relational database.

Microsoft SQL Server Video

Microsoft SQL Server Integrations

Microsoft SQL Server Technical Details

Deployment TypesSaaS
Operating SystemsUnspecified
Mobile ApplicationNo

Comparisons

View all alternatives

Frequently Asked Questions

What is Microsoft SQL Server?

Microsoft SQL Server is a relational database.

What is Microsoft SQL Server's best feature?

Reviewers rate Usability highest, with a score of 9.8.

Who uses Microsoft SQL Server?

The most common users of Microsoft SQL Server are from Enterprises (1,001+ employees) and the Information Technology & Services industry.

Reviews

(1-25 of 94)
Companies can't remove reviews or game the system. Here's why
Score 8 out of 10
Vetted Review
Verified User
Review Source
In our organization, Microsoft SQL Server is being used as a relational database engine to store and manage data for multiple applications of CRM, ERP, and Automation. It is widely used by a large number of teams across different project functions which require a database management solution.
  • Easy to configure and use with Visual Studio and Dot Net
  • Easy integration with MSBI to perform data analysis
  • Data Security
  • Easy to understand and use
  • Very easy to export database and tables in the form of SQL query or a script
  • Database backup and recovery functionality need improvement. Sometimes I have observed that when you try to restore a backup to a previous date/state, it does not work as expected, and restore fails.
  • Cost gets higher on integrating with Azure SQL
It is well suited for large-scale projects. It definitely requires a learning curve for the developers to work on. A plethora of support and self-help documents/articles are available on the internet to get familiar with the micro functionalities.
Gordon Lo | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
We use SQL server as a back-end for the vast majority of our software applications. This includes backends for web apps, data staging and SSIS/SSRS. As far as DB's go, SQL server is our first choice because it integrates easily with our Microsoft .net and .net core applications. Our SQL DB's are used across the entire organization.
  • high volume transactions
  • data staging and bulk data loads
  • integration to active directory
  • ease of setup
  • it's still a memory hog, but that's gotten better since 2016
  • it can be expensive to license
If your organization builds a lot of Microsoft based applications using .net or .net core, then the use of SQL is a no-brainer. The integration with .net is second to none as a backend for web apps and APIs.

In general, SQL performs well for a multitude of tasks beyond web app backends. We use SQL for high volume transactions for our core ESB which has very high data volume and data churn.
Pritesh Patel | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
We currently use Microsoft SQL Server as our database application for our applications. We are using the Microsoft SQL Server jobs, Analysis services, cubes, and many other features to help provide front end data solutions to our customers. Our instance of Microsoft SQL Server also allows for multi-database implementation with full backup capabilities. We also pair with the latest management studio to get the best UI experience.
  • Easy to use with Visual Studio and ASP projects
  • Multiple options for Data Security
  • Industry standard and easy to use
  • Easy to install and configure
  • Licensing can get complicated
  • Very very expensive
  • combability issues and dependencies with servers etc
  • Microsoft support....you know
Microsoft SQL Server is best for enterprise-level databases for data management. If you need to scale easily there are other options like Azure SQL, etc, but this also works best on bare metals servers. The licensing can get a bit complicated so it is not good for small companies/applications. I also don't think it is the best for mobile applications, etc.
Score 9 out of 10
Vetted Review
Verified User
Review Source
Microsoft SQL Server is being used by my whole organization by analysts and database administrators to maintain banking data including documents, statements, check images location pointers etc. It is able to store large banking information and can be managed easily at one place. Besides our client banks data, our company internal applications database is also stored and managed in it.
  • Data Storage and Manipulation
  • Highly Scalable
  • Easy Integration with a lot of framework including .NET
  • Lower prices
  • Better UI
  • Requires a lot of maintainence
  • No visualization of data
Well suited scenarios include:
1. Microsoft SQL Server is well suited when company needs to have high control over their data from creating, managing to maintaining.
2. Data needs to be highly structed and related to each other.
3. It can be integrated with a lot of frameworks.

Less appropriate scenarios include:
1. Pricing is very high and becomes difficult for smaller or mid-tier companies.
2. We are moving towards big data which is mostly unrelated and is very difficult for SQL to handle it.
Score 10 out of 10
Vetted Review
Verified User
Review Source
We have been using SQL Server through AWS RDS and it is our main tool in terms of data. All collected data from our system goes directly to the SQL Server before going to RedShift. So, we call it internally our live data and it contains everything in real-time.
  • It's the most used Database so it's mandatory to have knowledge for most of the roles today
  • You can find anything your need related to SQL Server on forums
  • Easy Implementation
  • I don't see too much to improve but maybe a more intuitive or graphical way to monitor the performance
It is very well suited if you need to store data in the relational model. It is a very powerful tool and can be used from small companies to huge companies. As it is the most used database in the market you can find all the necessary information and how to make it works in a better way.
Blake Baron | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
We use it as our central data warehouse across the entire organization for most of our data needs. We base our MicroStrategy Analytics software off of it, executive reporting off of it, and use it to house several years of transaction and inventory data. It serves as the central source of truth.
  • Is reasonably responsive even when thousands of queries are executing at the same time
  • Provides an end user experience that allows for intuitive use of structured query language coding
  • The database explorer is intuitive and easy to use for SQL neophytes
  • This is probably a sys admin setting, but it forces me to reset my password every month
  • I've heard the enterprise edition is quite costly
  • If we want to do anything substantial with it beyond simple storing and reporting, we often need to hire consultants
As long as my colleague that I'm recommending Microsoft SQL Server to has an unlimited budget, it's great. Truly best-in-class enterprise-wide data warehousing and reporting functionality; Microsoft SQL Server is the real deal for robust reporting. It's best suited for a Fortune 500 company that definitely has the budget for IT sophistication.
Score 10 out of 10
Vetted Review
Verified User
Review Source
Over in IT we use [Microsoft] SQL Server as our primary RDBMS across the entire department. We have a handful of legacy oracle databases which are yet to be retired and are planned to switch over to [Microsoft] SQL Server. [Microsoft] SQL Server is the database behind all of our software application systems essentially and is how we maintain and store all of our application data.
  • Extremely reliable
  • Great interface via SSMS
  • Fast operations
  • Atomicity
  • A better debugging experience
  • More built in support for logging
  • Better diagram generation
[Microsoft SQL Server is] very well suited for transactional systems, less suited for big data querying and analyzing.
Score 10 out of 10
Vetted Review
Verified User
Review Source
Microsoft SQL Server is used by our organization to store data for internal line of business and management systems. It meets these need well, is fairly easy to backup and manage.
  • Relational Database Server
  • Easy to stand up DB to support OEM Applications
  • Backend for Custom Written Application
  • COTS DB
  • Cost for Enterprise Edition
  • Heavy Mgmt Tools
Microsoft SQL Server is a great RDBMS and meets all of our requirements. If you need a stable DB platform to support your line of a business application you'll be well served. Licensing costs are far cheaper, more portable and a lot more user friendly than Oracle. Product support and security patches from Microsoft are strong.
June 19, 2021

SQL Server Review

Score 8 out of 10
Vetted Review
Verified User
Review Source
We use MS SQL Server as our main database to store customer data. We have a monolith web application that is using a single MS SQL Server database. MS SQL is one of the best RDBMS in terms of speed and its really easy to use with a lot of pre-built functions that are really convenient for our application.
  • It has quite a lot of pre-built function that helps speed up development time.
  • One of the fastest SQL database engines.
  • Built for enterprise use with enterprise-level of support available.
  • It could be very expensive to utilize MS SQL server to its full potential due to the licensing tier limit.
  • It does not have a built-in JSON type column, unlike PostgreSQL, although it has built-in functions to help to work with JSON.
  • Require more space to install the database engine compared to other SQL databases.
If you need RDBMS for an enterprise that needs to be fast and reliable without looking at the pricing or if you or your company are willing to pay a premium price for the best quality, MS SQL Server is your best choice. However, if you are a small startup that doesn't have a lot of data and not so complex application to use the database, PostgreSQL or MySQL might be better for you.
While its really convenient to use for me as a web developer, its fairly expensive to use in a production environment. I need to explain or justify the choice of using MS SQL Server against its pricing tier which is pretty expensive. We need to think about how to keep the whole infrastructure cost reasonable while keeping MS SQL Server.
Score 10 out of 10
Vetted Review
Verified User
Review Source
It is used as a back-end database engine for front-end client databases. Client is installed on user computers and it connects to a Microsoft SQL Server server for data.
  • It supplies a quick and easy way to analyze raw data when troubleshooting.
  • It gives the ability to easily create non standard ad hoc reports for clients.
  • It provides a standard platform for trouble shooting when we need to bring in engineers with advanced skills to solve problems.
  • It provides great tools for testing and development off line.
  • Configuration of the environment to create compatibility and restrict resource uses.
  • Configuration of connections in configuration manager.
  • Connection of data to other Microsoft products like Excel.
My ability to support the recommendation with skills I have gained using Microsoft SQL Server. My ability to provide Microsoft SQL Server queries and stored procedures to others when supporting Microsoft SQL Server in an environment. Ease of moving data into Microsoft SQL Server. It does present problems when importing data from older versions or other sources and takes advanced skills in many cases. Installer is a bit baffling at times and you have to just know from experience what to check or uncheck in the process. Needs a better way to determine what version to use, where and with which licensing mode. Express version often fails for unexplained reasons even though the environment, data size, number of connections.... all are within spec.
May 25, 2021

MS SQL Server

Score 8 out of 10
Vetted Review
Verified User
Review Source
For the uninitiated it is first important to point out that many programs use a Database at the back-end and the end-user will be totally unaware of that fact. So Microsoft SQL Server is a Database software. You (or the program you use) can enter all the needed information and then retrieve it when needed.
  • Holds data tables
  • Filters information quickly
  • Integrates with many programs
  • Installation is pretty complicated
  • Needs professional maintenance
  • Costs a pretty penny
Some programs just require Microsoft SQL Server as the back-end Database, but if you have the choice I would go for one of the open-source free alternatives.
If you have a big base of Data, for instance, your customers' contact information, each customer's own detailed contract and layout, their tickets and service hours. You want to store them all in a organized manner and be able to retrieve any information quickly. That's when you use a Database of any kind and Microsoft SQL Server is one such Database programs which does a good job.
Score 9 out of 10
Vetted Review
Verified User
Review Source
We use Microsoft SQL Server to provide a platform for our field users to input data for multiple purposes. We store contract data, financial data, time entry data, customer survey data among other data. Microsoft SQL Server gives us a single source of truth for a lot of our reporting. This allows us to have confidence that we are recording and reporting out accurate data.
  • Integration. We use PowerBI and Crystal Reports for our reporting and it integrates seamlessly with either.
  • Ease of use. Easy to learn and use. (Not the language - but the application)
  • Protection. Easy maintenance and backup options.
  • Licensing. Can be sometimes confusing layers and expensive.
  • Efficiency. Can be memory intensive on larger tables.
  • Server maintenance can be intensive as well.
Microsoft SQL Server has so many ways to integrate data from other platforms and sources, and available tools that it really is versatile enough to handle almost any need. There could be cheaper alternatives out there if you only have a minimal amount of data. At the same time, the cost can be high for smaller companies looking into big data capabilities.
Salvador Orochena | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
I currently provide consulting services to various clients. These clients use [Microsoft] SQL Server as the database for there financial system and CRM applications in addition to using for reporting and ETL processes.
  • ETL using SSIS to automate processes
  • Reporting Services to offer SSRS reports as a standard reporting interface
  • Data Analysis using stored procedure, views and transformations
  • Connectivity/Integration with other applications through ODBC, Linked Server, etc.
  • Simplify licensing
[Microsoft SQL Server is well suited] as a comprehensive solution as transactional database, data warehouse, analytics, reporting and ETL. Able to communicate with Azure database environment.

If you use other Microsoft applications, it integrates well such as Excel and Access.

If you have limited resources to support and maintain environment this may not be ideal compared to a managed service or SAAS solution such as Snowflake.
Score 10 out of 10
Vetted Review
Verified User
Review Source
Microsoft SQL Server is our organization's main Database Management System and is the primary back-end server for most of our critical business applications. It's a general requirement that any new application we implement has to operate on SQL Server, if it requires a database back-end. We have a great dependency upon SQL Server and it has not disappointed us.
  • Easy to use to set up databases
  • Reliable clustered instances
  • Maintenance plan wizards
  • Good UI with Management Studio
  • Good BI tools out of the box with SSIS, SSAS, and SSRS
  • It could use more/better templates in SQL Server Profiler
  • Lacks error avoidance tools when working in different environments (DEV/TEST/PROD). That is, preventing some code execution against PROD, for example.
I have used Microsoft SQL Server in one flavor or another for two decades. It has always been a reliable database management system for running anything from custom, in-house applications to business critical Enterprise Resource Planning systems. There is also a broad SQL Server ecosystem available on the internet, which is helpful for development tasks, training and troubleshooting.
Score 9 out of 10
Vetted Review
Verified User
Review Source
Microsoft SQL Server houses our databases for our CRM application. The CRM application is the core system that contains all of our company's information to function as a Distributor of safety products. The CRM application has many functions that would not perform properly without the use of the Microsoft SQL server.
  • Mircosoft SQL Server allows mutliple database to be set up for business purposes.
  • Microsoft SQL Server allows jobs to be scheduled after hours, when no one is in the office.
  • Microsoft SQL Server allows queries to be run to gather specific information needed.
  • Microsoft SQL Server allows security settings that will only allow specified users access. Easy disable employees no longer with the company.
  • Microsoft SQL Server has an activity monitor that will show any errors.
  • I have been using Microsoft SQL Server for 12 years and I have no complaints.
Microsoft SQL Server is great, as long as the user is familiar enough with it. There are always free classes online that will assist with gaining knowledge. In my past life, I was support for users. Currently, I am the user. Anytime, I need to understand something that I am not familiar with, I simply google it and someone out there has an answer. There is never an issue with having too much data as it does hold a lot.
John Ramírez | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
This is the database engine we use for our own systems and for our clients. So we use it internaly and externaly, to store all the information we need to have control of.
Also this is the source for different process and reports, outside the database sich as Power BI.
It helps a lot with the database storing, since it is very easy to use and manage.
  • Safe to store and query information
  • Query optimization
  • Scheduled jobs and tasks
  • Easy to code.
  • Maintenance procedures
  • External data sources
  • Support and chatting
Our companny is a Service Desk, and IT Support supplier. We have different needs regarding information, ticketing systems, clients systems and also our company internal information such as HR related.
We are capable to keep the information always available around the globe, also this is kept in a safe way.
We have our systems working on several countries, and the response time, is always excelent.
Lisandro Fernigrini | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
We use Microsoft SQL Server as the DB option for the commercial back-office modules of our MLFF (Multi-Lane - Free Flow) Tolling solution. All the commercial back-office (from Customer registration to involvement and payment handling) relies on Microsoft SQL Server databases. Other vital components of the entire solution, like Security and Vehicle Management, and the Reporting environment also utilize Microsoft SQL Server.
  • Microsoft SQL Server is simple to install and configure.
  • Many advanced options like Compression and Partitioning are available with no extra cost, thus reducing the overall TCO.
  • Partitioning does not provide as many options as Oracle (like Foreign Key partitioning, list partitions, hash partitioning and sub partitions)
  • The default READ COMMITED isolation level block readers, so it is important to use the READ_COMMITTED_SNAPSHOT option, that should be default right now...
I've found Microsoft SQL Server a robust and affordable solution for most OLTP scenarios, starting with department solutions up to enterprise-level systems. There are many advanced features (like compression and partitioning) that correctly implemented provide huge benefits on performance, reducing hardware requirements and costs. The default locking mechanism can be a problem for systems with high concurrency if the READ_COMMITTED_SNAPSHOT option is not selected.
We have not used official support to solve any particular problem, we have used different community resources (like forums) to obtain additional information on specific issues or doubts that did not require escalation to Microsoft support.
Score 9 out of 10
Vetted Review
Verified User
Review Source
Our business's in house desktop and web applications run off a SQL Server database. We have used it (and abused it) for 12 or so years now. I don't personally have experience with other databases (a little MySQL) but so far I haven't come across a scenario where SQL Server has been lacking, and that is coming from someone who advocates putting the business logic in SP's (OK, let's not start down that path...).
  • Stored procedures, efficient and so much easier to update business logic when under pressure!
  • High availability always on groups (since 2012), is pretty easy to set up and just works - has been an absolute savior on 2 server failures.
  • Fairly straightforward to administer out the box as it were (but this can be enhanced see below).
  • So widely used that someone somewhere has probably faced the same challenges that you have so [to] find a guide, solution, suggested path is relatively easy (not strictly a SQL server thing but makes a massive difference knowing that you have access to huge resource with a well supported well adopted piece of software).
  • Very well supported in terms of third party software to enhance administration (backups, performance, etc.).
  • Enterprise is unbelievably expensive.
  • Not tolerant of bad practices and poor query writing, really shows up when you do it badly!
  • Deep insight into what is happening with query performance is not especially great (but as mentioned in the "Pros", software support from third parties does cover this).
I have grown very fond of SQL Server, as I say I don't have a lot of experience with other relational databases, but I haven't hit upon a limitation within our use cases. Its TSQL is a pretty easy (scripting) language to pick up, stored procedures are very powerful and offer efficiency and security, not to mention allowing for quick changes to logic can be a real time-saver.

I will say I have had limited joy with text search (full-text indexing) to achieve better text searching results, but that's probably done to me. It's the one area I have never really managed to find a great guide on though.
Akhilesh Arya | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
We are using Microsoft SQL Server Express edition for teaching RDBMS to the students its really a nice tool to use. In personal I have also used the developer edition for application development. The best part of this software is it is robust. You can use it for both [...] website application[s] or [...] web application development. This database tool support[s] Microsoft visual studio so if you are using that IDE for development this is one of the most compatible and reliable [databases] software. Very efficiently handle the CRUD operations.
  • Easy to use is of course the foremost reason [for] its extensive use in almost every industry
  • Less expensive than Oracle tools
  • Multiple user support in [a] single set up
  • Excellent user support and documentation
  • Visualization is not available for that you have to use [the] different tool this is one of the feature[s] I think they should include
  • In MS Access you can design the query but here you have to write it in SQL
  • Enterprises edition is really expensive
For almost all [development-related] jobs this is the [well-suited] database server. You should convert your excel sheets into the SQL database so that with the exponential growth of your data, [the] system will not go slow. The only thing you need to convert all your data into a systematic [database] is SQL expert who can right queries for your application.
Mike McFarland | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
SQL Server is our only database engine. We use it for every main application and therefore across the entire organization. It solves the business problem of getting the right data to the right users quickly and efficiently.
  • Reliable
  • Efficient
  • Fast
  • Ease of use
  • De-duplicate data
Where ever data is stored in large quantities and needs to be retrieved quickly by queries. Where data is small and easily manipulated by a spreadsheet, then SQL will be overly complicated as a solution.
Score 10 out of 10
Vetted Review
Verified User
Review Source
We have a few [Microsoft SQL Server's] in our environment and they are used for SharePoint, Dynamics CRM, and many other database requirements that we have. Everyone indirectly uses it as it houses all our data which is accessed by some application frontends that our users work with. Being a Microsoft product it is very easy to manage and administer with in our Active Directory environment.
  • A requirement for most MS based applications
  • Widely used in the industry, allowing to easily support it
  • Flexible in terms of configurations
  • Very expensive!
  • Scalable, but not with ease
  • Resource hog
[Microsoft SQL Server] is great for any Microsoft shop as it seamlessly integrates with most Windows based applications. It would not really make sense to run it outside of a Windows environment as there are better options for that. It is not the best database solution, but it has been around forever and is a very reputable brand with long history.
Score 9 out of 10
Vetted Review
Verified User
Review Source
We utilize Microsoft SQL Server as the database for our Epicor Prophet 21 ERP system. It is used by all of our users to process the products that we sell, the potential customers for our Sales staff, and our purchasing department to order from suppliers. We also utilize SQL Reporting to create custom SQL reports for Management and end users. Microsoft SQL Server helps address the ability for management to easily query and access necessary business metrics. Customized SQL Server views and stored procedures are used to automate management tracking and customer contact. Since SQL Server is a widely-used database, numerous third-party tools that we use, like Pipedrive and Google BigQuery, easily interface with our data.
  • Easy to create queries to return specific, filtered data
  • Interfaces with many third-party tools, like Pipedrive and Google BigQuery
  • Provides easy mechanisms to backup and restore data
  • SQL Reports are easily created and customized
  • Better exporting of SQL Reports to multiple formats
  • More Tool Tips for some of the less familiar options
  • More backwards compatibility for older software
Since [Microsoft] SQL Server is a widely-accepted and popular database format, it is well-suited for smaller and larger environments, thanks to the different SQL Server versions available. SQL Server installation and configuration is fairly straightforward, and can be installed on different hardware, depending on needs. It may be less appropriate where simple database usage is required.
John P. Maher | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
I have worked with Microsoft SQL Server on many projects. The most recent was as the backend of an ERP system. The nature of an ERP system involved the entire organization from the shop which would use it to get the BOM (Bill Of Material) to build the parts to QA to check the parts to Purchasing to buy the raw materials to Sales to sell the parts to Shipping to ship the parts and even HR.
  • When properly maintained results are returned quickly
  • Backups and restores can be done quickly for testing
  • Support for common data access methods makes coding less painful
  • SSMS (SQL Server Management Studio) really helps IT in database activities
  • Debugging stored procedures can be done better
  • SSMS could be integrated more efficiently
  • Tasks that require many steps could be either streamlined or at the very least remember the data entered for each step
Microsoft SQL Server is a good database and works well in all the situations in which I have used it. Although there are things that can be challenging or unintuitive but once they are learned you quickly forget how difficult or unclear they are. To be fair, other databases exhibit the same difficulties and overall, SQL Server provides great service in any situation where a multiuser environment is required.
Score 7 out of 10
Vetted Review
Verified User
Review Source
Microsoft SQL Server is used in our organization to store data, run analyses, and produce reports using data from our web-based application. It is mostly being used in the data analytics department and it allows the team to work on projects together and integrate with other software used in the organization.
  • UI is user-friendly, making integration easy for all members of the team.
  • It is easy to set up and teach to new members.
  • Good support with third-party software.
  • Cost can be expensive.
  • Some learning curves for users transitioning from other services.
If security and consistency is important then Microsoft SQL [Server] might be a great option as your DBMS.
Score 7 out of 10
Vetted Review
Verified User
Review Source
SQL Server is used company-wide: All of our business data is stored in SQL databases and all of our applications utilize SQL in some capacity.
  • Scales well
  • Widespread usage means resources are more readily available.
  • Reliable when configured and maintained properly.
  • *Very* complex
  • Performance can be poor when configuration isn't tweaked just right.
  • System resource intensive, and some resources are capped by licensing.
  • Upgrading to newer versions is difficult and time-consuming.
SQL Server is a good choice for situations where a more industry-standard database server is a better fit than an open-source option, or when products or development that is based on other Microsoft tech will be used.