This week in honor of Valentine’s Day and TSQL Tuesday, Relationships Edition, we’re talking relationships. First off, let’s start with comic from The Oatmeal, “The Three Phases of Owning a Computer“. The three phases are: The Honeymoon, The comfortable phase, and Behold, the dinosaur. I love this comic because it’s a beautiful illustration that relationships […]
Category: SSC
Perfmon, .blg, .csv, and my love for the internetz
I'm so in love with the Internetz, I think I'll marry it. I just semi-borked a load test I was supposed to be tracing…perfmon wouldn't start at the last minute, and in the scramble to get it going, I not only forgot to start my SQL trace, I also left the perfmon output file in […]
SSIS: Deploy Packages, Part 1
This is the companion text to the video SSIS: Deploy Packages. This will be a two- or three-part series, I think. There are two ways to deploy SIS packages, and the difference becomes important when you have a lot of packages. The first way is just to individually deploy a package directly to SQL (or […]