Visualizing Nested Loops Joins And Understanding Their Implications

This post is the first in a series about physical join operators (be sure to check out part 2 - merge joins, and part 3 - hash match joins).

Watch...

Visualizing Nested Loops Joins And Understanding Their Implications

This post is the first in a series about physical join operators (be sure to check out part 2 - merge joins, and part 3 - hash match joins).

Watch...

How many Cores per Socket do I need?

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...

SQL Server I/O

Sometimes I like to see and know what SQL server is doing under certain operations and recently I wrote an...

Attaching databases via a dockerfile – UPDATE

This has been bugging me for a while but I just haven’t had a chance to get around to revisiting...

PayPal for Non Profits

Part of having 501c(3) status is figuring out where and how it might make a difference. Applying for non profit...

T-SQL Tuesday #109 – Mentors and Mentees

G’day again,
So, it’s time for T-SQL Tuesday again, the blog party 
started by Adam Machanic (
This time we're talking about people...

SQL Server Essentials for beginners

SQL is the essential part of SQL Administration and SQL Development. A quick overview of basics can take you a...

Data Warehousing Tip #1 – Store fact data at the leaf level

My first data warehousing tip is to store fact data at the leaf level. If you aggregate your fact data...

Privacy and Protection in the Age of the GDPR

We’re seeing more and more GDPR-style laws coming out from various governments. With the GDPR starting to do enforcement at...