Views are used quite often within SQL Server for a number of reasons.  They can be used to restrict access to tables (restrict the columns viewable or the records returned) , combine multiple tables into a single 'virtual table', or apply specific sets of formulas(like avg cost or an item).… Read more

Conditional Split is a very powerful component, enabling you to send records in different directions or exclude them from the downstream altogether.  I use this component quite often in my SSIS packages.  In the industry I work in, publishing, there are many times we'll get a file in from…

Read more

Conditional Split is a very powerful component, enabling you to send records in different directions or exclude them from the downstream altogether.  I use this component quite often in my SSIS packages.  In the industry I work in, publishing, there are many times we'll get a file in from…

Read more

I just gave a virtual presentation, courtesy of Pass and the appdev group.  The recorded presentation is available here:

Recorded Presentation

A copy of the slide deck is available in the download section:

Index Statistics

  Read more

I have worked in many industries, but most of my time has been in the publishing industry.  For those not familiar with this industry it is rather interesting.  The main objective is to "sell" as many books as possible to as many retailers and distributors as possible.  I put sell… Read more