Works at a manufacturing company with 10,001+ employees
Jan 23, 2021
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.
Features like autoscaling, business continuity, and security are beneficial. The tool's compatibility with almost all of the enterprise-class applications is also beneficial for users.
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.
Works at a manufacturing company with 10,001+ employees
Jan 23, 2021
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.
Information Technology Software Developer at a financial services firm with 501-1,000 employees
Dec 24, 2020
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.
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.
Certified Adjunct Faculty, School of Engineering and Computing at a university with 1,001-5,000 employees
Jul 26, 2020
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.
Sometimes, the tool doesn't support all the native features, and because of this, our company has to customize it to meet our requirements, which is a challenging process for our company's engineers.
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.
