Author: Bradley Schacht

Find Recently Run Queries 0

Find Recently Run Queries

If you have ever closed a query window by accident only to wish you could get back your work an instant later you may be in luck.  If you ran the query in question there is hope for you.  The...

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

2

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