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...

Infrastructure matters, even in the Cloud

I am still amused by terminology in the Information Technology field. Words like “Kubernetes,” “containers,” and the BASIC keywords PEEK...

MongoDB – Basic Commands

We discussed about MongoDb installation and startup. I highly recommend to go though the training session which will provide a detail...

SQL Server Availability Group FailoverDetection Utility PowerShell Function Improvements – Named Instances, Archiving Data, Speed

In my last post I wrote about a new function for gathering the data and running the FailoverDetection utility by...

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. In this post, I’ll show you how to set...

T-SQL Tuesday Participation Over the Years

I have personally participated in quite a large number of these TSQL Tuesday events - despite not being every single one. This is a roundup of my personal participation...

T-SQL Tuesday Participation Over the Years

Loads of TSQL Tuesdays

Years ago the TSQL Tuesday party was started by Adam Machanic (b|t). The premise of the monthly event...

Turbo Charged Staging\Caching Tables With In Memory OLTP

Since SQL 2012 some really awesome new technologies have been introduced into the engine that are massively underused. Everyone is...

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...

Clustered Column Store Load Pitfalls – Magic number 64 when using WHERE IN clause

The Problem
During our workload we have recognized a difference in performance for queries using IN clause. We are building query...