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

Meetup Pro for Non Profits

We use Meetup for SQLOrlando. We have enough members that we have to pay for the service and it works...

MongoDB – Docker Install

Docker and Container making my life great. these days I can explore every thing using this. I have installed MongoDB...

Oh Query, Query, Query

I thought I would post this a bit early so everyone can memorize the words before Hanukka starts next week.
I...

SSIS Catalog Execution Parameter Values

When doing any new development or major overhaul of existing SSIS architecture, I almost always recommend to clients that they...

SSIS Catalog Execution Parameter Values

When doing any new development or major overhaul of existing SSIS architecture, I almost always recommend to clients that they deploy those packages to the SSIS catalog. Using the...

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

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