Making the World Better

Steve reminds us about being charitable if we are fortunate enough to do so.

A Real-world Implementation of Database DevOps: People, Processes, Tools

This series of articles describes a path you can take to transforming an existing, manual and error-prone database development and release process into an automated and reliable Database DevOps 'pipeline', starting here with an overview of what we set out to achieve, and the people, processes and tools involved.

SQL RAISERROR to Better Handle Errors

Learn how and why to use RAISERROR in your SQL Server code to be able to better handle errors that may occur during code execution.

An Amazing Summit

Steve looks back at the recent PASS Summit.

Assigning a Server Role

Oracle optimizer Or Expansion Transformations

The previous installment of this series examined aggregate subquery removal and subquery coalescing, describing the latter as similar in some ways to an inverse for “Or Expansion” and “Join Factorization”. In this instalment, it’s time to take a closer look at Or Expansion and we’ll move on to Join Factorization in the next instalment.

DML Trigger Limits

Being Agile - A Success Story

Learn how one company adopted, adapted, and learned from the Agile methodology.

SQL Server at Scale - Using an Archive Table - Part 2

In my previous tip, I explained how we are inclined to use archive tables and how they become increasingly problematic over time. This tip will focus on ways to mitigate the issues.

Is Azure SQL Database a Good Choice for your Database Applications?

In this article, we cover things you should know about Azure SQL Database and why this may be a good choice for your database applications.