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."The ability to store data in memory is a standout feature, enhanced by robust failover mechanisms."
"The product can automatically reinstall and reconfigure in case of a shutdown."
"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 paramount advantage is the exceptional speed."
"MemSQL supports the MySQL protocol, and many functions are similar, so the learning curve is very short."
"The product's initial setup phase was pretty straightforward, with no complex processes."
"The most valuable feature is the ability to create pipelines, streamline and extract data from the pipelines."
"The backup features are the most valuable."
"The stability is good and the performance is fantastic. Even when we try to do an inquiry into issues we can do it easily."
"It's the type of product that doesn't need much technical support assistance as it works seamlessly."
"The data availability and speed are impressive, especially compared to legacy systems. The loading speeds are much faster on Azure SQL."
"Its easy usage is the most valuable."
"What is really helpful about the Azure SQL is that when we have a problem with our sound queries, we can trade information about what indexes we should create on tables. It's really helpful for me and also for developers."
"Its technical support team is good."
"The initial setup is straightforward."
"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."
"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."
"Having the ability to migrate servers using a single command would be extremely beneficial."
"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 can be developed further to provide more appropriate output to users as it is one of the areas where there are shortcomings."
"I'm not really a SQL DBA, so I can't go into the depths of the areas that need to be improved. They can maybe make it a bit easier to educate people on how to develop SQL Server in Azure. They can provide some free seminars and webinars and more training in general for easier migration. I know there is some stuff on Microsoft learning, but it would be helpful and useful to have more up-to-date content."
"There is probably more functionality in our on-prem SQL Server than SQL Azure."
"They should include more accessible functions for image tooling."
"The way it has been designed, in the on-premises deployments, the underlying Windows OS is highly scalable but has a very large resource requirement. A lot of power-related and memory-related things are there, which I have not seen in the RHEL and Oracle. I have not tried SQL on RHEL EXEC. On Windows, infrastructure-wise, a very large workload is running on the SQL. This issue is related to Windows, not SQL."
"Integration needs to be improved for this solution."
"It's not a feature, but the solution only offers a certain amount of memory and that's limiting. The scalability should be extended to more than two terabytes."
"The solution could improve by allowing the export of the data more seamlessly. It is difficult to copy and back up data."
"The product could be more competitive in terms of features, security, and scalability."
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.