SQL Server SSIS Presentation

Val Matison will be presenting a session on documenting SQL Server Integration Services ETL packages at the next Toronto Code Camp, March 1, 2008.

Documenting ETL is awkward at best. SSIS supports some task level text elements but that’s the extent of it. How do non-SQL Users view ETL? What can be done within the packages to facilitate documenting the ETL process? This discussion will look at leveraging XML both in SSIS and SQL Server to create documentation that is stored in SQL Server and can be accessed via reporting services.

More information on the session is available here:

http://www.torontocodecamp.net/Sessions/tabid/55/CodecampId/1/SessionId/10/Default.aspx

SQL Server 2008 Presentation

I will be presenting a session on SQL Server 2008 at the Metro Toronto .Net Users Group on February 7, 2008. This session is an overview of SQL Server 2008 and some of the many enhancements to this already feature rich database engine.
More information is available here:

http://metrotorontoug.com/User+Group+Events/696.aspx

Please register so the event organizers know how many people to expect. Thanks!

SQL Server MVP 2008

Microsoft has been kind enough to name me as a Microsoft SQL Server MVP for 2008. It's an acknowledgement of my skills and the work that I do in the community to disseminate information about Microsoft SQL Server.

In my work I am most concerned about creating actionable information from existing applications and databases. SQL Server’s rich data engine, ETL toolset and Analysis Services provides a very strong foundation on which to build robust analytics applications. It’s a cost effective and feature rich tool.

I will be presenting at a number of locations in the next few months and will post notices here as to dates and times.