AUSSUG Upcoming Sessions
In case you aren’t in the Australian SQL Server User Group, AUSSUG, there are a few upcoming sessions in Sydney which will be pretty useful – check out the official site to register. Sessions are free and always useful.
Lunchtime Wed 3rd March, 2010 – Ensuring Optimal Performance in SQL Server 2008 Based Applications with Viktor Isakov
Evening * Thu * 4th Mar 2010 – What’s new in Reporting Services 2008 R2 and PerformancePoint Services 2010 with Peter Myers, presenting what’s new in the upcoming release of Reporting Services 2008 R2 and PerformancePoint Services 2010
And TBA date in April 2010 – Knights of the SSIS Round Table – Kevin Wong, Glyn Llewelyn and myself will be presenting a series of mini demos followed by Q&A, so a chance to pick some expert brains
Hope to catch you at one of the sessions!
AUSSUG: Integration Services 2008 new features – Tues 10 Nov 2009
One for those Sydney resident BI Monkeys – Kasim Wirama, SQL MVP is presenting to the Sydney Chapter of the Australian SQL Server User Group on new features in SSIS for SQL 2008.
Please register at the AUSSUG website if you plan to attend – sessions are free. I expect to be there, finally able to attend for the first time in months, having missed some very interesting sounding sessions. The presentations are always useful and a great chance to meet with some of the SQL Server Gurus in Sydney.
Full details below:
Venue: Mechanics’ School of Arts, Level 1, 280 Pitt St, Sydney
Duration
5:30PM Networking (Pizza & Drinks provided)
6:00PM – 8:00PM SessionOn: Tuesday, 10 November 2009
Session Details
====================SQL Server Integration Services (SSIS) is prime ETL engine of SQL Server 2005/2008.
At this session, I would like to show new feature and improvement in SSIS 2008 and
presents practical SSIS solutions, i.e.:* Referenced resultset
* Branching in control flow and data flow
* Centralized SSIS package configuration and logging
* Multi column output with Oledbcommand component
* Streaming (high performance) sequence number
* Dynamic source file connection with much less code than former DTS does
* Lookup improvement in SSIS 2008
The ABC of ETL with SSIS followup
I have now uploaded all the files used in the presentation as promised – see the blog post dated for yesterday. Everyone provided very positive feedback and it appears that there was something useful for all attendees. It was quite daunting presenting to 50+ people so i’m glad the audience was friendly!
The ABC of ETL with SSIS resources
Click here for the powerpoint presentation as given (in Powerpoint 2007 format)
Click here for the databases, packages and config files (in SQL 2008 format, so please note these cannot be opened or used by SQL2005)
SSIS Presentation: “The ABC of ETL with SSIS”
I’ll be presenting on the subject of the basics of Data Warehousing to the SQL Server User Group in Sydney on the 10th february – details at http://www.sqlserver.org.au/Events/ViewEvent.aspx?EventId=368.
This will be an entry level presentation, but will include a few tips & tricks for more experienced developers too, plus it’s always a good opportunity to meet fellow MS BI peeps!