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…
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 …
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, …
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…
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 …
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 …
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…
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…
08/08/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…
07/19/22 In the era of technology defined by cloud computing, features evolve at the blinding speed of continuous deployment. When large software development organizations like Mic…
05/27/22 At this point in my career, I’ve realized the responsibilities of database administrators (DBAs) and database reliability engineers (DBREs) can differ from company to comp…
05/04/22 Not many years ago, the role of the data steward was the domain of the world’s largest organizations. When I was in college, the only person I heard of with this job title…