MSDN Blogs

Posts

| |

|

Developer hearted / Relational minded

Consuming SSIS package data in Reporting Services (and using Web Services in addition) Part 2

Posted over 4 years ago

by Jens K. Suessmeyer -
- 3 Comments
(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...
Developer hearted / Relational minded

Getting feedback / progress from batches and stored procedures

Posted over 4 years ago

by Jens K. Suessmeyer -
- 5 Comments
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...
Developer hearted / Relational minded

The “magic” about trustable relationships with NULL and NOT IN

Posted over 4 years ago

by Jens K. Suessmeyer -
- 1 Comments
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...