How To: Use the Same Data Flow Column Twice As a Parameter in SSIS

Every once in a while, you'll have a slightly more complex UPDATE statement in an OLE DB Command or Destination.  You'll use an UPDATE statement or a destination table that needsto use...

New Microsoft BI Labs site

Interesting new BI site from Microsoft called “BI Labs“.  This site says: “BI Labs is a collection of experimental business...

PASS Summit Session Votes

I blogged a week ago about the sessions that I submitted for the PASS Summit this year. At the point...

Summit Preference Voting

This year the PASS organization is asking us to vote on the PASS Summit 2011 sessions, not as a means...

The Recursive CTE

(Yet another boring org chart example – except this one has multiple roots)
One of my apps has a hierarchial org chart...

Where to put the logic? SQL? Code?

A discussion of where logic should go and why SQL might be the best place.
SQL is a powerful language and...

Checking Permissions

Someone posted this query recently:
select a.*,name, b.*
from sys.database_principals a, sys.database_permissions b

where permission_name = 'INSERT'
and
b.grantee_principal_id = a.principal_idThat’s a little ugly, so let’s fix...

DBA Brush-Up

I have a session I like to give called “Forgotton T-SQL”, or sometimes “T-SQL Brush-Up”.  The idea is that there’s...

NJ SQL UG Event: SQL Server 2008 Database mirroring - MAK

May 17th NJSQL UG Meeting - SQL Server 2008 Database mirroring with MAK
Date: Tuesday, May 17th

Topic: SQL Server 2008...

Not. Quite. There. This Time I Failed the Lab

Since I’ve been blogging about my progress through the SQL Server MCM certification, it makes sense to follow-up with my...