Ownership chaining or how to extend permissions without giving away the server
The nightly process in our production system collects data from our real time systems (JD Edwards) and then processes that data.  Many of these process manipulate the data and supply a modified data set for use by the dozens of client processes and applications.  All of the client applications have their own databases (tables, views, procedures, etc), but due to the nature of the 'raw' data we collect (we have over 350 million rows of historical and current data) sometimes the client apps need to directly access this.  It would be too costly to replicate this data for each individual application that would need it as well as maintaining dozens of copies would be impossible

Head on over to SQL University
Jorge Segarra has put together a wonderful collection of sql articles known as 'SQL University'.  I this is a place that all levels of sql practitioners should bookmark and go to.  I am happy and honored to announce that I have been selected as one of the faculty members.  Head on over and take a gander, you won't be disappointed.  The link to SQL University.

Index Primer - Just what statistics are kept?
Here is a link to my article on sqlservercentral.  Thank you Jorge Segarra for the guidance and opportunity. Index Primer

Linked to the Microsoft SSIS Documentation Portal
I am thrilled to announce that my blog has been linked to the Microsoft SSIS portal page.  This information was sent to me late September and I was unable to blog at that time.  Special thanks to  Douglas Laudenschlager of the Microsoft SSIS documentation team.  Here is the link: portal

Where I've been..
This isn't a technical post, yet I believe the community deserves an answer as to where I've been for the last 75 days.  I am home now and getting back into the swing of things.  I originally went into the hospital for a severe back spasm, which turned out to be caused by a cancer known as Multiple Myeloma.  The MM, presented in my spine, causing weakness in certain vertebrae.  The muscle spams were caused by lytic lesions, which are basically small fractures, which impinged on a few nerves and hence the spams.  With good doctors, shear force of will, a loving family, caring friends, a supportive community (a special thanks to Wibke Weilacher and the Exceptional