As a follow-up to my former post “ Why you shouldn't´trust the friendship of NULL and the (NOT) IN predicate ” I asked Paul Randal during our SQL Server Master training about the possible internal reason that the results can vary if you have NULL...

(Update: Due to security reasons the functionality retrieving data from SSIS packages has been deprecated and is no longer available in SQL Server 2008 R2) (Sample project attached to the blog entry !) Having stated the need for getting data from...

Ever wanted to get feedback and interim results like a progress from a stored procedure ? Well, not that easy as the results such as PRINT information is send after the batch has been completed. If you want to get information back from your batches you...