Auto-Scaling Azure SQL DB

When I was presenting my Azure SQL Database session at DataRelay (used to be SQLRelay) I was asked (over coffee)...

Power BI Dashboards, Reports, and Datasets with the SQL Chefs

This week I had the opportunity to learn about dashboards, reports, and datasets in Power BI using the best kind...

The SQL Agents’ view of SQL Server

I recently came across a really odd issue with the SQL Agent, there were two agent jobs attached to one...

Which is faster? IN (list) or IN (SELECT FROM Temp)

If you’ve done much with IN (list) then you’ve realized that it basically translates out to
col=val1 OR col=val2 OR...

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