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 […]
Author: Jen McCown
New Videos: .NET Objects in PowerShell, Interviews, and Being out of Work
I’d like to hold a little virtual celebration here, as we’ve just crossed over the threshold: we have more than 24 hours of training online! That means, if you were so inclined, you could sit down and listen to us talk about SQL, PowerShell, .NET, HTML, interviewing, Windows, and more for a full day and night…and that’s […]
Grouping – Level Zero
“Level Zero” doesn’t mean anything, it’s another Kung Fu Panda reference. “Iiiiii’m not an expert, let’s just start with zero…level zero.” Note: This article is the companion to the video Grouping Basics: Level Zero. You use a SELECT statement to get rows of data from the database. select ID, gameTime, thingEaten, thingTypeEaten, pointsGained from pacman […]