Database

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…

Importance of Data Warehouse Automation

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…

New Features and Enhancements in SQL Server 2022

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…

Six Tips To Become a More Productive DBA or DBRE

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…

Importance of Data Stewards for Master Data Management: The Power of a Single Version of the Truth

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…

What Is DevOps?

03/21/22 This post was updated on June 19, 2024 If you look back to the state of technology only a few decades ago, you’ll stumble upon a technological world full of silos and frus…

A Conversation With Aaron Bertrand

03/09/22 Back in the early days of Microsoft SQL Server, database administrators had few resources to draw upon and learn from. In the ’90s, we had SQL Server Professional, edited …

Understanding the Role of a Data Steward

02/23/22 Many years ago, in my earliest IT jobs in Omaha, Nebraska, I realized the field of data was going to continue to evolve and, as such, there would always be a need for peop…

What to Know About Azure SQL Database Serverless Compute Tier

02/15/22 Over the past several years, I’ve helped numerous customers migrate SQL Server workloads to Azure SQL, including Azure SQL Database, Azure SQL Managed Instance, and Azure …