Database

DataOps vs. DevOps – Similar or Completely Different?

01/05/23 Over the past several years, there has been a big focus on streamlining infrastructure operations. Many organizations have begun using DevOps principles in their software …

Can an Application Exist Today Without a Database?

12/22/22 As a data professional, I often think about all the things around me generating data and consider where this data is ultimately being used. Have you ever taken a minute to…

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 …