Database

A Guide to Stack Overflow’s Path to the Cloud

12/22/22 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 more …

The Power of Harnessing DevOps for the Database

11/08/22 Why do some organizations excel in streamlining their database operations and applications development while others find it immensely challenging? Why can some database te…

Containers vs. Virtual Machines: Rivals or Friends?

11/01/22 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 c…

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

10/26/22 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 w…

Comprehensive Guide on Partitioning and Sharding in Azure Database for PostgreSQL

10/07/22 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 ma…

What is a Data Warehouse? Benefits and Tips

09/07/22 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 …

Comparing PostgreSQL and MySQL Databases: Differences Explained

09/05/22 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, …

How DBAs are Using SolarWinds DPM and Marginalia to reduce MTTR

09/02/22 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 poo…

What is a Data Warehouse? Benefits and Tips

09/01/22 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 …

Pros and Cons of Horizontal vs. Vertical Scaling

08/17/22 Have you ever dealt with an application workload suddenly increasing and the demand on SQL Server begins to increase exponentially as a result? Maybe you’ve never had one …

Getting Started With Azure Database for PostgreSQL

08/15/22 Open-source software (OSS) relational database management systems (RDBMSes) are becoming incredibly popular in the cloud computing world. In this article, I’ll discuss one…

Importance of Data Warehouse Automation

08/09/22 The enterprise data warehouse (EDW) provides access to business data stored in a denormalized structure called a star schema, which makes it easy to analyze, visualize, an…