Database

As I navigate further into my career, I’m finding the scope of my role has shifted over the years. I thought I’d take some time to help relay the differences…

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, and forecast essential business…

In the era of technology defined by cloud computing, features evolve at the blinding speed of continuous deployment. When large software development organizations like Microsoft deliver semi-annual releases of products,…

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 company, from year to year, and…

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…

Historically, there was a clear delineation between what system administrators (SysAdmins) do and what application developers are responsible for in IT organizations. In recent years—especially in organizations focused on software…

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 frustration. Two of an organization’s most…

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 by…

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…

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 SQL Virtual Machines. In this article, I’ll explain some…