JR's Blog | April 2012

Have you taken a look at SSIS 2012.

by Jean-Rene Roy 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.

Tags:

.NET | SQL | SSIS | SSRS

Microsoft did a Case Study on a job I did for Canada Post and Innovapost

by Jean-Rene Roy 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.

Tags:

.NET | SQL | SSIS | SSRS

Jean-Rene Roy Bio

Jean-René Roy; architecting IT solution for large and small enterprises since 1987. In 1991 he founded the consulting firm Technologies SoftDesign Inc.

He has worked on projects for the Canada Council of the Arts, Treasury Board of Canada, Canadian Nuclear Safety Commission, House of Commons, Innovapost, Bell Canada, CGI and many other corporations assuming the responsibility of IT Manager, Technical Advisor, System Analyst, Business Analyst, Senior Software Architect, Senior Software Developers, Team leader, Project management and mentor. He is still very active in the developers’ community by acting as a user group leader for more than ten years with the Montreal .NET community and the Ottawa .NET community.

He is also the co-founder of an international developer’s conference www.DevTeach.com which is now directed by a member of his team. Jean-René Roy is a SQL Server Microsoft MVP.

 

 

Month List

Page List