Database

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 …

Virtualized Databases: Friend or Foe to Federal IT Pros?

02/14/22 Federal IT pros have historically had limited time and resources; this makes it crucial to find the source of application slowdowns or outages as quickly as possible. Data…

Benefits of DevOps

01/19/22 The term DevOps has taken the IT world by storm. Though every business incorporates DevOps practices differently—and even defines the term differently—doing so can offer b…

What Is DataOps and How Does it Impact Data Management?

01/17/22 Government IT administrators manage several different types of operations. There’s DevOps, which led to the creation of DevSecOps. Now, data-driven agencies are being intr…

The Importance of Database Backups: A Guide to Costs, Benefits, and Risks

01/11/22 Data is the lifeblood of businesses, and protecting it is incredibly important. One of the ways DBAs help ensure the continuous availability of data is through database ba…