JR's Blog | November 2010

Why SSIS configuration is Rocket science?

by Jean-Rene Roy 17. November 2010 09:20

When I stated to use SQL Server Integration Services (SSIS) I thought it was easy until I had to setup a test, prod and a Dev environment.  The configuration in SSIS is all over the place and even if you are an expert, you still look many places to find what you what to configure.   

This is why I design this session call: Why SSIS configuration is Rocket science?

Learning SQL Server Integration Service (SSIS) is not that difficult but the deployment in production is. Why? Because SSIS package Configurations is Rocket Science. This session will present many examples of SSIS configuration and show you the pit fall, tips and tricks and best practices for SSIS. This session is not just for the DBA but also for the developers. Attending this session can save you many frustrations. You need to see it.

Come and see me at the OttawaSQL.Net meeting.

Date: Nov. 18th (Thursday night)

Location: 100 Queen 5th floor

Arrival: 5:45pm



.NET | Event | SQL

Ottawa Speakers Idol! It was a big Sucess...

by Jean-Rene Roy 16. November 2010 08:40

The Ottawa IT Community is organizing a contest where you can win a MSDN Ultimate subscription (value of $15,499). On November 9th, on the venue for TechDays Ottawa, you will be invited to present your tip, trick or a feature for 10 minutes. After all presentations have completed, the attendees will vote for the winners. Prizes will be distributed to the best presenters. Bellow, you can find the list of prizes, along with all the contest rules.

It was a Big success!


·         Jean Sigouin with Take advantage of T-SQL “Common Table Expressions”

·         Sylvain Boucher with XNA Basics

·          Charles Wiebe with Help! – I just need to a little push to get started with Web Parts

 Thank you to all participants.




Welcome to BlogEngine.NET 2.0

by Administrator 13. November 2010 12:00

If you see this post it means that BlogEngine.NET 2.0 is running and the hard part of creating your own blog is done. There is only a few things left to do.

Write Permissions

To be able to log in to the blog and writing posts, you need to enable write permissions on the App_Data folder. If you’re blog is hosted at a hosting provider, you can either log into your account’s admin page or call the support. You need write permissions on the App_Data folder because all posts, comments, and blog attachments are saved as XML files and placed in the App_Data folder. 

If you wish to use a database to to store your blog data, we still encourage you to enable this write access for an images you may wish to store for your blog posts.  If you are interested in using Microsoft SQL Server, MySQL, SQL CE, or other databases, please see the BlogEngine wiki to get started.


When you've got write permissions to the App_Data folder, you need to change the username and password. Find the sign-in link located either at the bottom or top of the page depending on your current theme and click it. Now enter "admin" in both the username and password fields and click the button. You will now see an admin menu appear. It has a link to the "Users" admin page. From there you can change the username and password.  Passwords are hashed by default so if you lose your password, please see the BlogEngine wiki for information on recovery.

Configuration and Profile

Now that you have your blog secured, take a look through the settings and give your new blog a title.  BlogEngine.NET 1.4 is set up to take full advantage of of many semantic formats and technologies such as FOAF, SIOC and APML. It means that the content stored in your BlogEngine.NET installation will be fully portable and auto-discoverable.  Be sure to fill in your author profile to take better advantage of this.

Themes and Widgets

One last thing to consider is customizing the look of your blog.  We have a few themes available right out of the box including two fully setup to use our new widget framework.  The widget framework allows drop and drag placement on your side bar as well as editing and configuration right in the widget while you are logged in.  Be sure to check out our home page for more theme choices and downloadable widgets to add to your blog.

Try Out New Features

BlogEngine now supports code syntax highlighting and HTML5 video out of the box. To add a video, click the "Insert video" button just above the post editor. Once your video is uploaded, use the following syntax to show it: [­video src="be-sample.mp4"]. Make sure to add "video/mp4" as a MIME type to your IIS.

You can add formatted code by pressing the "Insert Code" button on the post editor toolbar. Here is a small sample:

// Hello1.cs
public class Hello1
   public static void Main()
      System.Console.WriteLine("Hello, World!");


On the web

You can find BlogEngine.NET on the official website. Here you'll find tutorials, documentation, tips and tricks and much more. The ongoing development of BlogEngine.NET can be followed at CodePlex where the daily builds will be published for anyone to download.

Good luck and happy writing.

The BlogEngine.NET team

Tags: ,


DevTeach and SQLTeach Call for speakers...

by Jean-Rene Roy 11. November 2010 23:37


Yes SQLTeach is back. Last year we did a limited event call DevTeach. Very little SQL was presented. This year SQLTeach is back with 3 SQL tracks presented in 3 days.  Get all the details at this link: http://www.devteach.com/TechChair.aspx


We would be honored to receive a proposal from you for our SQLTeach Montreal (May 30th  to June 3rd , 2011) events. If you are interested, send your session’s abstracts to our Tech Chair members. Please include ‘’DevTeach-SQLTeach-Montreal-2011-Sessions" in the subject of your email and user our template. Speakers must submit their session’s abstracts December 20th ,2010.


You can meet the Tech Chair Team at this link: http://www.devteach.com/TechChair.aspx

More Details:

All sessions demonstrating Visual Studio and/or SQL Server must be presented using Visual Studio 2010 and/or SQL Server 2008.  The only exception is for demonstration of beta where future versions are allowed. Try to include .NET 4.0 or SQL Server 2008 R2 stuff in your sessions.

What DevTeach/SQLTeach covers for speakers?

For selected non-local speakers , DevTeach will cover up to 4 nights at the hotel of the conference and all travel expenses. All speakers will get a Polo shirt, a complementary pass to the main event that includes 3 breakfasts and 3 lunches. They will also be invited to the speaker’s dinner.


  • 5 SQL Server DBA/Admin. Track Chair Jean-Rene Roy
  • 6 SQL Server Development. Track Chair Jean-Rene Roy
  • 5 SQL Server BI. Track Chair Christian Coté
  • 6 Windows Azure Development. Track Chair Guy Barrette
  • 6 .NET Agile. Track Chair James Kovacs
  • 11 Silverlight and WP7. Track Chair Colin Melia
  • 6 SharePoint sessions. Track Chair Rob Windsor
  • 11 Software Architecture. Track Chair Mario Cardinal
  • 11 Web Development sessions. Track Chair Guy Barrette

Total sessions: 68

Use our template to submit

We are compiling your submission with a SSIS package. You must submit your sessions with our Excel template.

Download our DevTeach Montreal 2011 Session Abstracts Template

Click here to send your session abstracts!


.NET | Event | SQL

Speaking on SSIS next week at Ottawa TechDays

by Jean-Rene Roy 5. November 2010 09:13

Next week (Nov. 9th at 10:00am) I will be speaking at TechDays Ottawa in the Local Flavours track.  I originally name the session. “Why SSIS configuration is rocket sciences” but for TechDays we change the title to:

SQL Server Integration Services Tips and Tricks

Learning SQL Server Integration Services (SSIS) is not that difficult but deployment of packages can be challenging. This session will present many examples of SSIS configuration and show you tips & tricks as well as best practices for SSIS. This session is not just for the DBA but also for the developers. Attending this session can save you many frustrations. You need to see it.

Anyway, I prepared 10 demos to get my Point(s) about SSIS configuration and if you work with SSIS, this session is not to be missed.



A full day of TFS training for $5? Unreal!

by Jean-Rene Roy 2. November 2010 09:05

The Montreal .Net Community is doing a full day of training on TFS 2010. The cost! Only $5! That that not all. You also get a chance to win $15499 of software. That right! The group will draw a MSDN subscription Ultimate for the participant. There is only one catch to this. You need to be a member of the group. That is not a very big problem because you can become member by simply pay $25 and you will be member for a full year.  This is a very good thing.  Many subject will presented Saturday. We will see Migration of SourceSafe (Which MS end the support in March 2011) to TFS. Manuel testing, Production bug tracking and automating testing.  This will be a very cool Saturday that I will not miss. Ho! There is one more catch to this.  The all day will be resented in French.



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