"MemSQL supports the MySQL protocol, and many functions are similar, so the learning curve is very short."
"The most valuable aspect of the solution is that it's integrated with the Visual Studio and also with Microsoft SQL Server Management Studio. It's a tool they have and it's quite easy to use and understand. It's the interface for programming for SQL Services."
"The solution can be used for a host of applications."
"I have found that SQL Server works very well in the Microsoft Dynamics environment."
"SQL Server is very good, it can be used as a transactional database and used to support the data warehouse. Additionally, the ANSI-compliant satisfies our database properties."
"Stability and usability, which is quite simple, are two of the solution's most valuable features."
"The most valuable features are ease of use and the integration with Single Sign On (SSO), as well as with other Microsoft products."
"We've found it to basically be pretty problem-free."
"I love SQL Server's Common Table Expression. In addition to that, I like its lead and lag functions. That helped us reduce a lot of code when comparing rows in SQL Server."
"There should be more pipelines available because I think that if MemSQL can connect to other services, that would be great."
"We experience latency at times when there is a lot of data being processed."
"I would like to have the option to use fewer processors for certain tasks, thus reducing the licensing fee."
"The Management Studio is a pretty heavy piece of software, and it's sometimes slow. I would recommend making an express version of the Management Studio, which is lighter and has fewer features but is a little faster."
"The user interface and the reporting could also be improved."
"The free version of SQL Server is time-limited before updating to the paid version."
"The solution needs to be more secure. It's lacking, compared to, for example, Oracle."
"The integration could be better. They are not open-source, so the integration with other platforms is not that easy."
"Performance could be better. But I don't know if it's a problem with my application or with my database."
Lenses is a simple and secure self service DataOps platform, to operate with confidence on Apache Kafka & Kubernetes.
SQL Server is the Microsoft-driven relational database management system. This system is used to store data as well as retrieve it when necessary; these functions can be supported by individual users or by multiple users within a larger network. The Microsoft SQL Server has warehousing options, quality and integration services, management tools that are simple to implement, as well as robust tools for development.
Looking at the more technical end of things, Microsoft SQL Server uses query languages such as T-SQL and ANSI SQL. Disaster recovery is one of the product's most prominent features, in addition to in-memory performance, scalability, and corporate business intelligence capabilities.
SingleStore is ranked 6th in Database as a Service with 1 review while SQL Server is ranked 1st in Relational Databases Tools with 167 reviews. SingleStore is rated 10.0, while SQL Server is rated 8.2. The top reviewer of SingleStore writes "MySQL Big Brother with built-in data pipeline, high concurrency, and blazing fast analytical queries". On the other hand, the top reviewer of SQL Server writes "Good performance, well-priced, trivial to set up, and helpful support". SingleStore is most compared with MySQL, CockroachDB, Cloudera Distribution for Hadoop, Oracle Database and Teradata, whereas SQL Server is most compared with SAP HANA, Oracle Database, LocalDB, MariaDB and IBM Db2 Database.
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.