9. April 2012 02:22
Since April 1st you can get SQL Server 2012. Amount many new features you will find a new version of SQL Server Integration Services (SSIS). This new version is full of new features including a new server deployment model for SSIS. You can see what new in SSIS by coming to one of the presentations I will be giving in the next 3 weeks.
· April 12th OttawaSQL
· April 14th Ottawa Code Camp
· April 28th Vancouver Tech Fest
This is the sessions I will be presenting:
SSIS Configurations in SQL Server 2012
Before SQL Server 2012, SSIS configuration was a Rocket science. Since then Microsoft has been working nonstop to get this aspect of SSIS more simple. A large amount of enhances in SQL Server 2012 have been done to SSIS and if you know how difficult it was to configure SSIS packages in SQL Server 2008, you need to see this session. If you are new to SSIS you also need to see all enhances to SSIS and see how simple it is to use it.
4. April 2012 10:05
Back in 2009 and 2010 I did a job for Canada Post and Innovapost. At that time Canada Post was changing all is plant sorting equipment for new machine. I was asked to produce an ETL application that can process and aggregate 4 million mail piece events every 10 minutes. It was a very nice challenge and I manage to process it in 9.3 minutes. In the design of this application I also build a frame work that mange batch execution. It was also design to manage parallel execution for ETL Process. Since then Innovapost optimized the application. You can read about this case study at this link.