SSIS Catalog Automatic Log Cleanup

Built into the SSIS catalog is a mechanism that can automatically purge log data after a set period of time....

Actual Emails: What is a "soft delete"?

What's a "soft delete", and why should DBAs be aware of such behavior in tables?
So, a DELETE statement is a “hard” delete. The data is gone.

However, it is a...

Top 50 PowerShell bloggers of 2018

My work is recognized and my blog is listed under Top 30 elite list. I am pleased, honored and humbled...

Azure at the Ranch

From our webinar today, I mentioned I had a dog named “Azure”. Here she is.

No, this isn’t an homage to...

Quickly Compare Data in Two Tables Using CHECKSUM and CHECKSUM_AGG

There are times when we need to compare two tables and figure out if the data matches. I often see...

T-SQL Tuesday 109: Influence Somebody Recap

Small tokens of gratitude and small actions help to build this wonderful SQL Community that gives and gives and gives. Humility leads us to seek out ways to give...

T-SQL Tuesday 109: Influence Somebody Recap

How have you impacted somebody in the community?
This month I am in charge of the topic for TSQLTuesday. The invite...

Seeing WriteLog wait type on your SQL Server?

One of the more common wait types for SQL Server is called WriteLog.  In its most basic form it is...

Visualizing Merge Join Internals And Understanding Their Implications

This post is part 2 in a series about physical join operators (be sure to check out part 1 – nested...

Visualizing Merge Join Internals And Understanding Their Implications

This post is part 2 in a series about physical join operators (be sure to check out part 1 - nested loops joins, and part 3 - hash match...