We performed a comparison between SingleStore and SQL Azure based on real PeerSpot user reviews.
Find out in this report how the two Database as a Service solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."It's a distributed relational database, so it does not have a single server, it has multiple servers. Its architecture itself is fast because it has multiple nodes to distribute the workload and process large amounts of data."
"The most valuable feature is the ability to create pipelines, streamline and extract data from the pipelines."
"The product can automatically reinstall and reconfigure in case of a shutdown."
"The paramount advantage is the exceptional speed."
"The product's initial setup phase was pretty straightforward, with no complex processes."
"MemSQL supports the MySQL protocol, and many functions are similar, so the learning curve is very short."
"The ability to store data in memory is a standout feature, enhanced by robust failover mechanisms."
"We have multiple applications running for our customers that we can integrate into Azure SQL."
"SQL is a simpler database. We use it more than other databases."
"The solution effectively handles storing and maintaining information in databases."
"The product's initial setup phase is very easy."
"SQL Azure is good with transactional systems."
"We primarily and generally use it only for DB purposes. When it comes to the Azure part, we can easily provision, scale up, and scale down the generator machine. This kind of flexibility is the USP of SQL Azure. Its interface and ease of use are also valuable. It is very easy to use and integrate with multiple databases. If I need to pull in or import some data from my on-premises database, the ease with which you can connect and pull the data, not only from SQL Server but also from other flavors of MySQL or even Oracle, is very good."
"Customers can benefit from a lot of cost savings if they go for Azure."
"Their technical support is the most valuable."
"There should be more pipelines available because I think that if MemSQL can connect to other services, that would be great."
"It is not the optimal choice for direct data collection through queries, and it's more suited for aggregation tasks."
"Having the ability to migrate servers using a single command would be extremely beneficial."
"The product can be developed further to provide more appropriate output to users as it is one of the areas where there are shortcomings."
"For new customers, it's very tough to start. Their documentation isn't organized, and there's no online training available. SingleStore is working on it, but that's a major drawback."
"We don't get good discounts in Pakistan."
"Poor key distribution can significantly impact performance, requiring a backward approach in design rather than adding tables incrementally."
"The product's pricing needs improvement."
"One of the nice features in Microsoft SQL Server is the SQL Server CLR, which we sometimes need to use to protect our procedures using C# or CLR. This is not available in the SQL Azure database."
"The solution lacks feedback tools."
"The solution could improve by supporting more operating systems."
"Lacking in technical documentation."
"Its automation can be improved. SQL Server Agent was a very big part of the on-prem tools. While moving from on-prem to the cloud, redoing some of such tools was very cumbersome in Azure. There was a whole new set of technologies and methodologies. It should have easier automation-type features to be able to implement such tools. It should have almost a SQL agent type of substance built into that."
"The default 1433 port for communication should be customizable because most hacks or attacks are attempted when creating any application or database on the default port."
"It would help if the solution was more secure."
SingleStore is ranked 6th in Database as a Service with 7 reviews while SQL Azure is ranked 2nd in Database as a Service with 90 reviews. SingleStore is rated 8.8, while SQL Azure is rated 8.6. The top reviewer of SingleStore writes "A reasonably priced product that offers good speed and seamless support". On the other hand, the top reviewer of SQL Azure writes "The SQL connector effectively syncs data to databases". SingleStore is most compared with SQL Server, MySQL, Teradata, Oracle Database and CockroachDB, whereas SQL Azure is most compared with Amazon RDS, Google Cloud SQL, MongoDB Atlas, Oracle Database as a Service and Google Cloud Spanner. See our SQL Azure vs. SingleStore report.
See our list of best Database as a Service vendors.
We monitor all Database as a Service reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.