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

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

Ghosts in your Database

Yes Virginia, there are ghosts in your database.  More specifically, there are ghosts in your SQL Server database.  They are...

How To Restore Database in SQL Server 2014 From .bak - Step By Step

Due to threats of data loss, human errors, scam attempts, hardware damage, or natural disasters, it is imperative for IT...

How To Restore Database in SQL Server 2014 From .bak - Step By Step

Due to threats of data loss, human errors, scam attempts, hardware damage, or natural disasters, it is imperative for IT administrators to ensure the security of data. In order...

Moving SSISDB is not as easy as it sounds

We’ve been doing a lot of upgrading recently and at one point had to move an instance from one 2016...

My backup script (where, how, how big, etc.)

A while back I wrote about how to find where your backups are. And I’ve also written about I use...

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

Setup Ola Hallengren SQL server Maintenance script

Ola Hallengren Maintenance Plan Deployment Many...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

SQL Server Adventures In Reducing IO

In the interests of curiosity I’m going to take a query that runs a relatively simple aggregation over a large...