SAP SQL Anywhere vs Microsoft SQL Server

• The ability to host network database services and the ability to manage them.

Read full review

• Stored procedures, efficient and so much easier to update business logic when under pressure!
• High availability always on groups (since 2012), is pretty easy to set up and just works - has been an absolute savior on 2 server failures.
• Fairly straightforward to administer out the box as it were (but this can be enhanced see below).
• So widely used that someone somewhere has probably faced the same challenges that you have so [to] find a guide, solution, suggested path is relatively easy (not strictly a SQL server thing but makes a massive difference knowing that you have access to huge resource with a well supported well adopted piece of software).
• Very well supported in terms of third party software to enhance administration (backups, performance, etc.).

Read full review

• I think it should be more user friendly for non-technical users.
• More functional functionalities should be added to the object explore when working with a table to transform data/manipulate data.

Read full review

• Partitioning does not provide as many options as Oracle (like Foreign Key partitioning, list partitions, hash partitioning and sub partitions)
• The default READ COMMITED isolation level block readers, so it is important to use the READ_COMMITTED_SNAPSHOT option, that should be default right now...

Read full review

• Skilled/experienced resources are less prominent than Microsoft SQL Server or even Oracle, or MySQL, so finding solutions and assistance, if needed, takes more time than it would with other platforms
• You will need to find a good SQL query tool by yourself because the Sybase Central / Interactive SQL utilities are lacking in many basic features, and just generally have a bad user interface

Read full review

• Since SQL Server 2014 Developer Edition, Microsoft has been offering these tools free of charge. The ROI is mainly focused around training investment. We do the training in-house, so the ROI is around one year.
• The cost-benefit ratio offered by Microsoft's data warehouse solutions is, by a long shot, much more convenient for our customers, small and medium-sized companies, than solutions from other vendors.
• Every system upgraded will benefit; from the improvements in Clustered ColumnStore, to increased throughput in Always On Availability Groups, to the enhancements of In Memory OLTP, not to mention the new security features.
• We implemented with an in-house team only, with proper, prior training that was also done in-house.

Read full review