SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Bradley Schacht

Bradley Schacht is a Data Platform Solution Architect on the state and local government team with Microsoft based in Jacksonville, FL. He has co-authored 3 SQL Server books including "SQL Server 2014 Professional Admin". As a former consultant and trainer, he uses his experience on many parts of the Microsoft BI and data platform to help customers deliver the best possible solutions. Bradley frequently presents at community events around the country. He is a contributor to sites such as SQLServerCentral.com and an active member of the Jacksonville SQL Server User Group (JSSUG).

Archives: September 2011

SSIS Variable and Expressions Followup

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,… Read more

2 comments, 3,878 reads

Posted in Bradley Schacht on 30 September 2011

Posting This Week

I just wanted to do a quick post to let everyone know that I am in fact going to be posting the follow up content that I promised in my webinar and at SQL Saturday.  It has been a busy busy week and I just haven’t had the time to… Read more

0 comments, 468 reads

Posted in Bradley Schacht on 28 September 2011

SSIS Variables and Expressions Webinar Recording

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… Read more

0 comments, 848 reads

Posted in Bradley Schacht on 21 September 2011

SSIS Variables and Expressions Webinar

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… Read more

0 comments, 643 reads

Posted in Bradley Schacht on 20 September 2011

SELECT COUNT(*) vs COUNT(1) vs COUNT(ColumnName)

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… Read more

0 comments, 12,559 reads

Posted in Bradley Schacht on 15 September 2011