Database

Latest Posts in Database

A Guide to Stack Overflow’s Path to the Cloud

Like many companies, Stack Overflow is trying to get out of the business of running our architecture in our own data centers; instead, we want to offload some of the…

The Power of Harnessing DevOps for the Database

Why do some organizations excel in streamlining their database operations and applications development while others find it immensely challenging? Why can some database teams embrace agility while others take months…

Containers vs. Virtual Machines: Rivals or Friends?

Containers have been the buzz among developers in recent years with the adoption of cloud-native orchestration tools like Kubernetes and DevOps workflows centered around containers. At the same time, virtual…

Is Kubernetes Still the Best Container Orchestration Tool?

Over the last few years, containers have been one of the hottest topics when it comes to radically changing the way we develop, operate, and maintain our applications. And it’s…

How Do MySQL Indexes Work? An In-Depth Tutorial on Creating Clustered and Secondary Indexes and The Effect on Database Performance

MySQL is the most used database in the world. And as it continues to grow in popularity as an open-source database system for developers, understanding how these indexes work is…

Comprehensive Guide on Partitioning and Sharding in Azure Database for PostgreSQL

One of the biggest mistakes I’ve had to repeatedly help companies fix has been poor partitioning design. I’ve seen many database architectures designed in an attempt to make queries faster.…

Why You Need to Automate DevOps

When I began my career in IT more than two decades ago, most organizations had multiple silos of application development teams. Each team would be responsible for a single application…

What is a Data Warehouse? Benefits and Tips

A data warehouse (DW) is a centralized repository of data integrated from multiple systems.. This data is often cleansed and standardized before being loaded. Designed to support analytical workloads, a…

Comparing PostgreSQL and MySQL Databases: Differences Explained

Over the past two to three years, I’ve seen customers make a move towards both MySQL and PostgreSQL. There is no software licensing with either of these database systems, which…

How DBAs are Using SolarWinds DPM and Marginalia to reduce MTTR

Database performance is critical to business revenue. Slow and non-responsive databases can result in hundreds of thousands or millions of dollars in lost revenue from poor customer experience and downtime.…