94 Reviews and Ratings
1608 Reviews and Ratings
Apache Cassandra is a NoSQL database and well suited where you need highly available, linearly scalable, tunable consistency and high performance across varying workloads. It has worked well for our use cases, and I shared my experiences to use it effectively at the last Cassandra summit! http://bit.ly/1Ok56TK It is a NoSQL database, finally you can tune it to be strongly consistent and successfully use it as such. However those are not usual patterns, as you negotiate on latency. It works well if you require that. If your use case needs strongly consistent environments with semantics of a relational database or if the use case needs a data warehouse, or if you need NoSQL with ACID transactions, Apache Cassandra may not be the optimum choice. Incentivized
Microsoft SQL Server is a great RDBMS and meets all of our requirements. If you need a stable DB platform to support your line of a business application you'll be well served. Licensing costs are far cheaper, more portable and a lot more user friendly than Oracle. Product support and security patches from Microsoft are strong.Incentivized
Continuous availability: as a fully distributed database (no master nodes), we can update nodes with rolling restarts and accommodate minor outages without impacting our customer services.Linear scalability: for every unit of compute that you add, you get an equivalent unit of capacity. The same application can scale from a single developer's laptop to a web-scale service with billions of rows in a table.Amazing performance: if you design your data model correctly, bearing in mind the queries you need to answer, you can get answers in milliseconds.Time-series data: Cassandra excels at recording, processing, and retrieving time-series data. It's a simple matter to version everything and simply record what happens, rather than going back and editing things. Then, you can compute things from the recorded history.Incentivized
Easy to configure and use with Visual Studio and Dot NetEasy integration with MSBI to perform data analysisData SecurityEasy to understand and useVery easy to export database and tables in the form of SQL query or a scriptIncentivized
Cassandra runs on the JVM and therefor may require a lot of GC tuning for read/write intensive applications.Requires manual periodic maintenance - for example it is recommended to run a cleanup on a regular basis.There are a lot of knobs and buttons to configure the system. For many cases the default configuration will be sufficient, but if its not - you will need significant ramp up on the inner workings of Cassandra in order to effectively tune it.Incentivized
The import/export process can be tricky to follow with lots of steps and could be better for importing flat filesObtaining help from Microsoft is cumbersome and often other internet sources are better and quickerThe documentation is not great and again it's generally better to obtain help elsewhere if neededIncentivized
I would recommend Cassandra DB to those who know their use case very well, as well as know how they are going to store and retrieve data. If you need a guarantee in data storage and retrieval, and a DB that can be linearly grown by adding nodes across availability zones and regions, then this is the database you should choose.Incentivized
We understand that the Microsoft SQL Server will continue to advance, offering the same robust and reliable platform while adding new features that enable us, as a software center, to create a superior product. That provides excellent performance while reducing the hardware requirements and the total cost of ownership of our solution.Incentivized
It’s great tool but it can be complicated when it comes administration and maintenance.Incentivized
SQL Server mostly 'just works' or generates error messages to help you sort out the trouble. You can usually count on the product to get the job done and keep an eye on your potential mistakes. Interaction with other Microsoft products makes operating as a Windows user pretty straight forward. Digging through the multitude of dialogs and wizards can be a pain, but the answer is usually there somewhere.Incentivized
Its does not have outages.Incentivized
SSAS data cubes may some time slow down your Excel reports.Incentivized
Sometimes instead giving straight answer, we ‘re getting transfered to talk professional service.Incentivized
We managed to handle most of our problems by looking into Microsoft's official documentation that has everything explained and almost every function has an example that illustrates in detail how a particular functionality works. Just like PowerShell has the ability to show you an example of how some cmdlet works, that is the case also here, and in my opinion, it is a very good practice and I like it.Incentivized
It was goodIncentivized
very hands on and detailed trainingIncentivized
Other than SQL taking quite a bit of time to actually install there are no problems with installation. Even on hardware that has good performance SQL can still take close to an hour to install a typical server with management and reporting services.Incentivized
We evaluated MongoDB also, but don't like the single point failure possibility. The HBase coupled us too tightly to the Hadoop world while we prefer more technical flexibility. Also HBase is designed for "cold"/old historical data lake use cases and is not typically used for web and mobile applications due to its performance concern. Cassandra, by contrast, offers the availability and performance necessary for developing highly available applications. Furthermore, the Hadoop technology stack is typically deployed in a single location, while in the big international enterprise context, we demand the feasibility for deployment across countries and continents, hence finally we are favor of Cassandra Incentivized
[Microsoft] SQL Server has a much better community and professional support and is overall just a more reliable system with Microsoft behind it. I've used MySQL in the past and SQL Server has just become more comfortable for me and is my go to RDBMS.Incentivized
SQL server does handle growing demands of a mid sized company.Incentivized
I have no experience with this but from the blogs and news what I believe is that in businesses where there is high demand for scalability, Cassandra is a good choice to go for.Since it works on CQL, it is quite familiar with SQL in understanding therefore it does not prevent a new employee to start in learning and having the Cassandra experience at an industrial level.Incentivized
Increased accuracy - We went from multiple users having different versions of an Excel spreadsheet to a single source of truth for our reporting.Increased Efficiency - We can now generate reports at any time from a single source rather than multiple users spending their time collating data and generating reports.Improved Security - Enterprise level security on a dedicated server rather than financial files on multiple laptop hard drives.Incentivized