Over the last week I have done several sessions either for the Pragmatic Works Free Training online or at SQL Saturday. It has been a lot of fun, so thank you to everyone who has come out and hopefully learned something from one of the sessions I have done. So, I mentioned a couple things I was going to do, one of which is post a quick recap and sample package from the Expressions and Variables session. So here that is. The other will come next week when I post some same situations and data sets...
Read More
Thank you to everyone who attended my free webinar hosted by Pragmatic Works yesterday (September 20, 2011) on SSIS Variables and Expressions. The webinar was recorded, so if you want to reference it again or if you were unable to attend and wanted to see it you can view the recording from this link here the clicking view on the right side on the Pragmatic Works website (Here is the direct link to the view button). I will be answering questions today if I was unable to get to your question in th...
Looks like it is that time again... for me to present a FREE webinar for good ol' Pragmatic Works today at 11AM eastern standard time. The topic today will be SSIS variables and expressions. I previously did a webinar on a similar topic that also included configurations. If you were in that webinar then you are well aware that we really only got to go into detail on configurations and not the other two topics. So today is completely dedicated to variables and expressions. Feel free to bring your...
What is the difference between COUNT(*), COUNT(1) and COUNT( ColumnName )? A mystery that will never be known… ok that was a lie, but the rest of this blog is not a lie, just to be clear. :) COUNT(*) – Number of records in the table regardless of NULL values and duplicates COUNT(1) – Number of records in the table regardless of NULL values and duplicates ** IMPORTANT NOTE: The 1 does NOT refer to an ordinal location of a column. This will not count the records in the first col...