Author: Bradley Schacht

0

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...

Posting This Week 0

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...

1

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...

Reset Identity Column in SQL 0

Reset Identity Column in SQL

I’ll be honest, I am partially writing this because I always forget how to reset the identity column on a table and I want to be able to just pull up my blog and look it up.  Yet again today...

2

Excel Services in SharePoint 2010 Webinar

Tomorrow I will be presenting a webinar at 11 AM eastern time for the Pragmatic Works Training on the T’s.  This month each of the authors of the SharePoint 2010 Business Intelligence 24-Hour Trainer available from Wrox are presenting a...

0

SQL Saturday #79 South Florida

SQL Saturday in South Florida is quickly approaching in just 2 short weeks.  As usual, if you are in the area please come out and support the wonderful people who are giving of their time to help out in the...