IT Central Station is now PeerSpot: Here's why

SQL Server Pros

PJ
Professional Services Manager at Business Intelligence DA
The technical support that Microsoft provides is great.
View full review »
RN
President at a consultancy with 1-10 employees
One of the things I most like about SQL Server is the log shipping piece. This is a great feature.
View full review »
HarkamalSingh - PeerSpot reviewer
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 »
Buyer's Guide
SQL Server
June 2022
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: June 2022.
610,518 professionals have used our research since 2012.
Meindert Van Der Galiën - PeerSpot reviewer
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 »
Satyam Saxena - PeerSpot reviewer
Senior Software Developer at a manufacturing company with 5,001-10,000 employees
SQL Server is quite user-friendly. I have experience with Oracle and PostgreSQL, so out of three, I like SQL Server a lot.
View full review »
BL
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 »
Shivanshu Srivastav - PeerSpot reviewer
IT Manager : HOD at Condot Systems
The replication feature, user interface, reporting services, and notification services are really good. They are providing SQL profiler and SQLCMD as their integrated software, so we don't find it difficult to integrate any of our third-party applications with MS SQL because all of them support MS SQL very clearly.
View full review »
RS
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 »
AL
Senior Service Architect at a tech services company with 501-1,000 employees
The solution is stable.
View full review »
ThembaNhlapo - PeerSpot reviewer
System engineer at a financial services firm with 51-200 employees
The most valuable feature would most likely be querying. We query a lot, we use a lot of stored procedures. As for other features, such as replication and all other more fancy features we don't use them the most. I do not know, but perhaps the DBAs would be the best people who know of the features that they use, but as far as how I use it, it's just for querying and running stored procedures. We use the bare minimum features.
View full review »

SQL Server Cons

PJ
Professional Services Manager at Business Intelligence DA
SQL Server doesn't have proper bitmap indexing, proper columnar databases, or proper implementation of materialized views.
View full review »
RN
President at a consultancy with 1-10 employees
In the next releases, I would only like more enhanced backups and more restore points.
View full review »
HarkamalSingh - PeerSpot reviewer
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 »
Buyer's Guide
SQL Server
June 2022
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: June 2022.
610,518 professionals have used our research since 2012.
Meindert Van Der Galiën - PeerSpot reviewer
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 »
Satyam Saxena - PeerSpot reviewer
Senior Software Developer at a manufacturing company with 5,001-10,000 employees
It may be a licensing issue, but sometimes its operating speed becomes slow if we have multiple users. It's lacking some performance, but it's acceptable because we have a heavy load.
View full review »
BL
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 »
Shivanshu Srivastav - PeerSpot reviewer
IT Manager : HOD at Condot Systems
Performance could be improved. There could be more support to PHP-based websites and to providing direct plugins for connections, and the related services or application services could be improved.
View full review »
RS
Business Analytics Manager at a transportation company with 201-500 employees
Their datatypes need improvement.
View full review »
AL
Senior Service Architect at a tech services company with 501-1,000 employees
The performance is not always the best.
View full review »
ThembaNhlapo - PeerSpot reviewer
System engineer at a financial services firm with 51-200 employees
If SQL Server could perhaps run on Linux, that would be good. Most of us prefer Linux and I've used a lot of Linux. I understand that SQL Server is quite powerful, but I'm not sure if the functionality is there, but if it could be used in an open-source type of environment, it would be very good.
View full review »
Buyer's Guide
SQL Server
June 2022
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: June 2022.
610,518 professionals have used our research since 2012.