SQL Server I/O

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

To Influence or Be Influenced?

How have you impacted somebody in the community?
Well, have I come up with a doozy of a topic for this...

To Influence or Be Influenced?

Getting feedback from others is that little check that is needed to help progress and move in the right direction. When allowing time and opportunity for feedback from others,...

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

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

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 administrators to ensure the security of data. In order...