July 28th, 2011 
Thank you for all of you that came out to my presentation at the Atlanta Microsoft BI user group, last Monday. We had a pretty good turn out, 40+. The slide deck can be found on the user group web site. http://atlantabi.sqlpass.org/Resources.aspx Here are the links to the other posts that I referred to during [...]
Archive for July, 2011
Posted in 
An alternate, perhaps better view of the SQL Saturday #89′s AWESOME schedule!!!…
I’ve seen on Twitter and heard over the grapevine that the SQL Saturday website can be managed a lot better. Now while that is true, for an extension of PASS, it’s a common look and feel web tool for user groups to host a SQL Saturday event in their backyard. But here we are now [...]
Table Auditing with XML
When working with meta data tables it can be very useful to track when people make changes to the data. How do you track any change against any number of columns for any table? I have implemented a fairly simple solution that uses triggers and stores all changes as XML into one change log table. [...]
Tags: Presenting @ Atlanta Microsoft BI user group
I will be presenting at the next Atlanta Microsoft BI user group. Monday, July 25th, 2011. http://atlantabi.sqlpass.org/ Topic: SSIS Logging and Auditing Framework Level: Beginer / Intermediate Meeting Place Matrix Resources 115 Perimeter Center Place Suite 250 (South Terraces Building) Atlanta, GA 30346 Overview: Proper logging in your SSIS packages can help save hours in [...]
T-SQL Tuesday #20 – T-SQL Best Practices – Formatting versus “The process worked and that’s what matters most, right?”
It’s that time of the month again for TSQL2sday, this time around, hosted by Amit Banerjee (Blog|Twitter). The topic for the twentieth edition: T-SQL Tuesday #20 – T-SQL Best Practices. Follow the link to see all of the other contributions made by the wonderful Online SQL Server Community, here is my humble contribution. And many [...]
I want you to attend John Welch’s Atlanta SQL Saturday #89 PreCon!!!
I want you to attend John Welch’s (Blog | Twitter) PreCon “Data Warehousing with SSIS DEEP DIVE” for SQL Saturday #89 Atlanta. Yes, that’s what I want. It’s to be held on Friday, September 16, and the details of which are below and can also be found here at the SQL Saturday #89 site. Now [...]
Atlanta SQL Saturday #89 – The Blitz Is On!!!…
The blitz is on!!! Well, technically, there’s no official NFL Football yet for the fall, but if you’re in tuned in the online SQL Server Community, you may have noticed a fair number of us are filling the social network media with new about this September’s Atlanta SQL Saturday #89. Details on SQL Saturday in [...]
