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

Deadlocks in a SQL Server Database

Deadlocks in SQL Server happen when 2 (maybe more) processes are fighting over a resource in the database and are...