SQL Server Pros and Cons

SQL Server Pros

HarkamalSingh
User at a manufacturing company with 10,001+ employees
It is a pretty good solution. The on-premise version 2019 has many features, and they had introduced a really good and stable environment in version 2019. It has very good integration with big data clusters and other things. It covers pretty much everything that you can do with a SQL server. You can use any language to connect to it, which is not there in other solutions. They have also introduced Python, and it also has ArcScale. PaaS is a modern, scalable database. You can use Power Automate and a lot of features in this. It is very easy, and you don't have to worry about versions and upgrades. Microsoft keeps on adding new features to this solution. Microsoft is improving its connectivity on an ongoing basis. It connects well with Office 365. If you see something not working, in a couple of weeks, it is going to work because there is a team working on it. You can vote for the things that are missing, and Microsoft can work on them depending on the product that they're launching.
View full review »
reviewer1460082
Information Technology Software Developer at a financial services firm with 501-1,000 employees
It's a good learning environment, it's easy enough to learn and understand. Anybody that picks up the language early on will be able to develop in it.
View full review »
reviewer1389651
Certified Adjunct Faculty, School of Engineering and Computing at a university with 1,001-5,000 employees
It helps with moving the design of the database into reality.
View full review »
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: February 2021.
466,017 professionals have used our research since 2012.
reviewer1309482
Business Analytics Manager at a transportation company with 201-500 employees
The pricing of the solution is okay. It's less expensive than Oracle, for example.
View full review »
Lional Angelo
Manager Digital Technologies at a real estate/law firm with 51-200 employees
The solution has the capability to scale.
View full review »
Shanti Sahu
Cloud Data Architect (Data service Team) at NTT Data India Enterprise Application Services Pri
The feature that I have found most valuable is that it is easy to code.
View full review »
reviewer1484775
Senior Programmer at a tech services company with 51-200 employees
The product has very good online documentation that can be used for troubleshooting.
View full review »
JohannesJoubert
Business Solutions Architect at a real estate/law firm with 501-1,000 employees
The security and vulnerability management are well-managed through the vendor.
View full review »
reviewer1473555
Sr Tech Business Analyst, Group Data Projects & Ventures at a financial services firm with 10,001+ employees
The solution seems to be pretty flexible.
View full review »
Aju Mathai
Database Architect at Huron Consulting
It is one of the most stable relational databases out there.
View full review »

SQL Server Cons

HarkamalSingh
User at a manufacturing company with 10,001+ employees
There are a lot of improvements in the cloud space about which we open a case with Microsoft every now and then. These improvements are not in terms of features or functionality. They are more related to their own compatibility or connectivity on which they keep on working to improve the product.
View full review »
reviewer1460082
Information Technology Software Developer at a financial services firm with 501-1,000 employees
From a development perspective, the solution needs to be a lot easier to understand or it needs to be easier to implement API packages for connection pooling so we don't have connection interruptions when, let's say, a hundred people simultaneously access the network on a given system, utilizing a specific or single database.
View full review »
reviewer1389651
Certified Adjunct Faculty, School of Engineering and Computing at a university with 1,001-5,000 employees
The product overall would benefit from the addition of better tutorials to help master the skills necessary to actually build a project database. Right now, what is available isn't sufficient.
View full review »
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: February 2021.
466,017 professionals have used our research since 2012.
reviewer1309482
Business Analytics Manager at a transportation company with 201-500 employees
Their datatypes need improvement.
View full review »
Lional Angelo
Manager Digital Technologies at a real estate/law firm with 51-200 employees
Microsoft doesn't have active-active load balancing scenarios. It's always a failover cluster.
View full review »
Shanti Sahu
Cloud Data Architect (Data service Team) at NTT Data India Enterprise Application Services Pri
In terms of what could be improved, everything on-premise is now moving to the cloud. Obviously SQL Server has also moved, because Microsoft Excel has its own cloud called Azure Finance. Every solution comes with its own advantages and disadvantages.
View full review »
reviewer1484775
Senior Programmer at a tech services company with 51-200 employees
The licensing costs are very high.
View full review »
JohannesJoubert
Business Solutions Architect at a real estate/law firm with 501-1,000 employees
Linux-based editions are not yet proven to be on par with Windows deployments.
View full review »
reviewer1473555
Sr Tech Business Analyst, Group Data Projects & Ventures at a financial services firm with 10,001+ employees
Due to the fact that I'm dealing with the product more as a data analyst, the SQL Server management studio is really relatively primitive compared to other more advanced tools.
View full review »
Aju Mathai
Database Architect at Huron Consulting
I would like to see native plugins built for other platforms versus having to buy third-party plugins to tap into S3 buckets and AWS Cloud. Right now, it does not have those built-in plugins.
View full review »
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: February 2021.
466,017 professionals have used our research since 2012.