Andy Leonard

The Regina Technology Community welcomes Andy Leonard!

Topics: Database Design and Incremental Loads using SQL Server

Part I - Database Design for Developers
This interactive session is for software developers tasked with database development. Attend and learn about patterns and anti-patterns of database development, one method for building re-executable Transact-SQL deployment scripts, a method for using SqlCmd to deploy re-executable Transact-SQL deployment scripts, and fodder for a lively discussion about NULLs. Bring your database deployment practices and be prepared to participate!

Part II - Introduction to Incremental Loads
This session is for SQL Server Integration Services (SSIS) developers and DBAs. Attend and learn more about Transact-SQL and SSIS design patterns for loading data incrementally. The session includes two demos: Incremental Loads in Transact-SQL; and Incremental Loads in SSIS.

Speaker: Andy Leonard
Andy Leonard is an SSIS Trainer and Consultant, SQL Server database and Integration Services developer, SQL Server data warehouse developer, community mentor, SQLBlog.com blogger, and engineer. He is a co-author of Professional SQL Server 2005 Integration Services and SQL Server MVP Deep Dives. His background includes web application architecture and development, VB, and ASP; SQL Server Integration Services (SSIS); data warehouse development using SQL Server 2000, 2005 and 2008. Check out his blog at sqlblog.com/blogs/andy_leonard.

Location:
Royal Saskatchewan Museum
2445 Albert Street, Regina
Map

Date: Tuesday Evening, April 26th, 2011

Cost: Free

Schedule:
5:30 pm Food and social - please register if you are joining us for dinner
6:00 pm Welcome
6:05 pm Part I - Database Design for Developers
7:05 pm Break
7:20 pm Part II - Introduction to Incremental Loads
8:20 pm Closing

Registration:
We need to know how much food to order! :)

If you're joining us for dinner, please register through the Regina Technology Community website.

If you've registered and are unable to attend, please let us know.

We order food at 12:00 pm on Tuesday, April 26th, so please register before then!

Sponsors:
A big thank you to our sponsors!!

Gold Sponsors
Prairie Developer Conference
Solvera Solutions
Greystone Managed Investments
SaskTel
Telerik
Conexus
MicroAge
ISM Canada
TMC Technology Management Corporation
Adxstudio
Paradigm Consulting Group
DevTeach

Silver Sponsor
Sutherland Consulting Inc.
JCC Computer Sales and Services
Metaplexity Associates LLC

Want to invest in your community? Check out our sponsorship page.