Operations | Monitoring | ITSM | DevOps | Cloud

The latest News and Information on Databases and related technologies.

How to monitor Cassandra database clusters

Apache Cassandra is an open-source distributed NoSQL database management system that was released by Facebook almost 12 years ago. It’s designed to handle vast amounts of data, with high availability and no single point of failure. It is a wide-column store, meaning that it organizes related facts into columns. Columns are grouped into “column families.” The benefit is that you can manage data that just won’t fit on one computer.

How Converting to YAML Build Pipelines Can Help Engineering Teams Be More Efficient

Engineering teams can only be as efficient as the processes they employ during development. The need for increased efficiency is why software development has shifted from the “waterfall” approach to a more responsive, agile methodology. In an agile development environment, quality software can be delivered consistently to suit the ever-changing needs of stakeholders and end users.

Gaining a real competitive edge in managed services

These are interesting – and challenging – times to be a Managed Service Provider. When it first published its Managed Services Market Size Forecast, Mordor Intelligence valued the market at US$152 billion in 2020, and predicted it to reach US$274 billion by 2026, a compound annual growth rate of 11.2%. Over a year later, following a pandemic which has changed the way most of us work and which will probably see permanent changes going forward, Mordor is sticking by its prediction.

How to encourage DBAs to embrace DevOps, rather than fear change

How do we help Database Administrators (DBAs) embrace DevOps in a way that can be really productive and part of a rich DevOps team that delivers value to customers quickly and continuously? That’s an important question to ask right now because there’s a common view among DBAs that DevOps isn’t for them. They’re responsible for documentation and maintenance and deployments, they have internal customers, and they serve internal requests.

After analyzing 600,000 SQL queries, these are the top mistakes developers make - Oded Valin

Yalla! DevOps 2021 -- The first, in-person DevOps conference of the year! Driven by the DevOps community. All about the DevOps community. Users want to see their data fast, immediately, now. Whether you’re working with an ORM or writing native SQL, you probably had a “scratching-my-head-trying-to-figure-out-why-this-database-is-so-slow” moment. The team at EverSQL analyzed more than 600,000 SQL queries from thousands of different companies, to lay down the most common mistakes developers do when writing SQL queries. This talk focuses on writing SQL the right way, the fast way.

Cloud 66 Feature Highlight: Multi Database Support

Many applications use multiple types of datastores simultaneously - mixing SQL and NoSQL databases, for example. Or your application might need two separate clusters of the same database engine to handle an upgrade, or to support separate services. This is where Multi Database Support comes handy. What is Multi Database Support? Multi Database Support makes it possible to attach more than one database group to your application.

Why Would You Pay for Flyway?

Flyway is an open-source database deployment tool that also includes a paid tier called Teams. Since it’s open-source, you can just download Flyway and run it for free. You’ll get a robust DevOps tool to assist you in deploying your databases just like you deploy your code. It just works. So, why would you even bother to pay for Teams? Actually, there are a number of reasons why people pay for advanced tiers of open-source software in general.

Data cataloging: A giraffe's eye view

In the latest DBAle podcast episode our hosts, Chris and Chris, tackled what they really mean by cataloging a database and how taking a ‘giraffe’s eye view’ approach to compliance is not enough. That’s because the most common data concerns for managers and execs center around where your sensitive data is, the risk it poses and, if you’re migrating to the cloud, how much sensitive data is being stored on that database or that instance.

Overcoming SQL Server Blocking and Locking Challenges

One of the most common performance problems with SQL Server databases in production is the blocking of queries, which happens because database resources are locked. Understanding why locking happens is just half the battle. Being able to resolve locking, which will resolve blocking issues as well, is the second half.