SQL Server 2012 is the version that introduces many good tools for the power user. This is all part of the Self Service BI initiative.SQL Server 2008R2 introduce a version of Report Services (SSRS) that allows DBA to setup a Sandbox were users can create reports with Report Builder with no restrictions. SQL Server 2012 pushes the envelope event more by providing business analyses with real good cleansing tools which include the Business Analyses in the ETL process. Now Office 2010 introduce PowerPivot which allows you to consume data form any source. Office 2013 will provide event more tools for the self-service BI. The best way to know about these new initiatives from Microsoft is to go to Rushabh Mehta Post-Conference at DevTeach Montreal on December 12th and get the details there.

On December 12th you can attend one of the post-conferences at DevTeach. If you are into Web Development, you need to start at looking at Windows Azure for your backend web service and frond end. Guy Barrette Workshop will show all the advantage of doing this with the Azure platform. The potential economies for a commercial web site are big. Click on this link to know more about this the Azure workshop.

Wow! This conference is really for everyone. It covers from SQL Server to all aspect of .Net and Windows 8 and Windows Phone 8. The event is help from Dec. 10th to Dec 12th, 2012. But that not all. You have also a MobileTeach on Dec. 12,13 on iOS and Android on Dec. 14,15.That 6 days of training…

Sandrine and Gabriel call me “Le Roy des Geeks” because for the past 6 years I have been awarded the title of Microsoft MVP.There are call me like that because of the trophy MS is sending me.So the geeky thing to do for me in July is showing off my Trophies in my display caseJ.

Microsoft in collaboration with SQLTeach is having a full day of workshop and presentation on SQL Server 2012. The day will start with presentation on some of the new feature then after lunch we will have hand on with virtual lab. This is the perfect opportunity to experience firsthand the new SQL Server 2012. Come and discover the new features in SQL Server 2012.

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.

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.

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.

Last weekend was SQL Saturday 114 Vancouver.SQLTeach was a sponsor and we draw a winner to SQLTeach Main Conference.The winner was Sam DeMooy.SQL Saturday 114 was a big success with an attendance of over 200 attendees. Congratulation Sam.

You are all invited to join us on March 7 for the SQL Server 2012 Virtual Launch Event. This is a good opportunity for you to see what new in SQL Server 2012. You will have access to over 30+ sessions to learn about the new capabilities of SQL Server 2012 at your own pace, on your own schedule. This event brings together a who’s who of industry experts and executives to tell the SQL Server 2012 story in this unique online launch event. You will also be able to “meet” with other experts, customers and partners in a virtual “Expo Hall” to discuss SQL Server 2012 one-on-one.

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.