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...
Author: Bradley Schacht
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
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...
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...
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...
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...
Check Mount Points and Disk Free Space with PowerShell
Those who know me will know that this post is a little out of the ordinary… I am posting about PowerShell. I have done one previously about Backing up and restoring site collection in SharePoint, so believe me I will...
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...
Excel Services in SharePoint 2010 Webinar Recording Is Up
First of all if you came out to my webinar this morning let me say a huge thank you! I really appreciate everyone taking time out of their busy days to listen to me ramble on for about an hour...
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...
