Adaptive Joins and Join Hints

At a recent all-day seminar on query performance tuning I was asked a question that I didn’t know the answer...

CCI – Data Loading considerations with Partitioned Tables and CCI

Introduction
In this blog post, I would like to describe two case scenarios of bulk loading data, using SSIS, into a...

Changes to the SQL Server servicing model (Cumulative Updates)

On Monday of this week, Microsoft announced changes to the servicing model for SQL Server, starting with SQL Server 2017....

Checking Trace Flags with dbachecks, online docs and PSPowerHour

It’s been a few weeks since i have blogged as I have been busy with a lot of other things....

Inspector V1.2 now available

It has been long overdue but finally V1.2 is now available on GitHub.
V1.2 brings a lot of changes, We put...

Inspector V1.2 revised installation guide

Pre-requisites:
SQL 2012 or higher

SQL Server Agent

A database to store the the data collected by the agent jobs (this can be...

T-SQL Tuesday #107 - Death March

This month’s T-SQL Tuesday is hosted by Jeff Mlakar and he asks us to write about a project that went horribly wrong. My story isn’t really worthy of the...

Veterans At PASS Summit ’18

Hello all!
This year at PASS Summit, I will be distributing the below ribbons once again to ANY and ALL Service...

Letting the business bully you: T-SQL Tuesday #107

Before I start anything I want go give a disclaimer. I absolutely believe that the business should be involved in...

minikibe on windows, getting stuck on networking issues like cant connect messages?

Reading Time 1 Minute
I have been getting kubernetes setup on my laptop via minikube and I followed all the examples to the T, especially the part about creating a...