JR's Blog | Jean-René Roy Blog about the Basic things...

SQL Server 2012 Self Service BI workshop in Montreal on Dec. 12th, 2012.

by Jean-Rene Roy 27. September 2012 21:02

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.

Get more details on SQL Server 2012 Self Service at this link: http://www.microsoft.com/sqlserver/en/us/solutions-technologies/business-intelligence/office-based-tools.aspx  



The DevTeach Post-Conference on Windows Azure Dec. 12, 2012

by Jean-Rene Roy 3. September 2012 20:28

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.



.NET | Blog | Event | SQL | Windows 7

Did you konw:DevTeach Montreal Dec. 10-12, MobileTeach Dec. 12-15, 2012

by Jean-Rene Roy 27. July 2012 09:35

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…

Check the links:





What is the geeky thing to do in July for me?

by Jean-Rene Roy 2. July 2012 05:21

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.


Blog | Event

The annual Ottawa UG End of season Party

by Jean-Rene Roy 22. June 2012 05:31

Next week is the annual Ottawa IT Community social night. You are all invited. It’s free J

When and Where: Mon June 26th 2012 on Elgin Street

340 Elgin Street
Ottawa, Ontario

Register with this link:  http://oitcsocial2012.eventbrite.com/ 


Free SQL Server 2012 event in Ottawa June 22nd

by Jean-Rene Roy 25. May 2012 05:22

I am hosting a free event on SQL Server 2012 on June 22nd.  Come and join us.

Discover SQL Server 2012 first hand in Ottawa

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.



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.



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.



Sam DeMooy winner a free registration for SQLTeach

by Jean-Rene Roy 21. March 2012 10:47

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.


Event | SQL | SSIS | SSRS

March 7 is SQL Server 2012 Virtual Launch

by Jean-Rene Roy 2. March 2012 01:19

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.

To see the full agenda and to register go to http://www.sqlserverlaunch.com/ww/Home .



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