What’s new in PASS? Okay, that’s not truly what this is about. This is about what’s new in my little corner of PASS.
CBusPASS Meeting, June 11th
Last week the local PASS chapter met and Brent Ozar and I gave a recap of our Pain of the Week presentation – Developing Something for Nothing (SQL Server Express Edition and SQL Server Management Studio Express). The presentation went very well despite some bandwidth problems with LiveMeeting – audio glitches led to Brent sounding like a crazy evil robot a few times.
After the presentation, a number of local chapter members sat around and talked about what we have been working on and the things that we’d like to see presentations about in the future. It’s nice to take the time and connect with the local SQL community. I think, too often, we focus on getting a solid presenter and pulling everything off without a hitch rather than encouraging a sense of community. Last week’s meeting definitely had some hitches – pizza was late due to outside causes, there were Live Meeting audio issues due to bandwidth, we were in a different room due to scheduling conflicts. But, despite all of that (or because of it) we had a great meeting with a lot of interaction and community building. And, at the end of the day, isn’t that what having a user group is all about?
PASS Application Development Virtual Chapter
Yesterday, June 16th, the Application Development Virtual Chapter had its monthly meeting. Mladen Prajdic, author of the SSMS Tools Pack was kind enough to speak. The presentation was a huge success and we had 27 attendees tune in virtually for Mladen’s presentation: SQL Server 2008 for Developers. The presentation was recorded with LiveMeeting and will be available online for download in the next week.
Upcoming Presentations
CBusPASS
Next month, Andy Leonard will be presenting, via LiveMeeting, at CBusPASS. The topic of the presentation is Incremental Loads, Change Data Capture, and SSIS 2008 – Change Data Capture is a new SQL Server 2008 feature. One benefit of CDC is data filtering for Incremental ETL in SSIS: only touching rows that are new, updated, or have been deleted! In this presentation I walk through enabling Change Data Capture in SQL Server 2008, then present an overview of an SSIS package that utilizes Change Data Capture to perform Incremental ETL.
App Dev Virtual Chapter
Aaron Alton will be presenting for the Application Development Virtual Chapter about Simple Data Change Tracking in SQL Server – For many reasons, it is often advantageous to be able to track data modifications in SQL Server applications. Some businesses require change tracking for audit purposes, and application administrators often desire change tracking to maintain visibility into application interfaces.
In this presentation, Aaron Alton will look at the two most common methods of application data change tracking: DML triggers and SQL Server Change Tracking. Aaron will review the strengths and weaknesses of each method, and demonstrate the ease with which data changes can be recorded and retrieved.
Hope to see you all there!
