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

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

Get Rid of those unused indexes!

Indexes in relational databases are very helpful and increase the speed to access data.  However maintaining indexes is just as...

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

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