JR's Blog | SQL

What is a Modern DBA, Tips and Tricks for Dev.

by Jean-Rene Roy 8. February 2016 19:51

When you work the same job for over 10 years, it easy to stop learning new tricks because what you do and know works in your environment. But when you constantly change environment you need to learn new tricks and tips to get the job done.  Has a software Architect and Senior DBA I am in this position of teaching tricks and tips when I get to do consulting in different enterprises. This is why I created the session ‘’The Modern DBA’’.  I am presenting a Dev version of this session at the Ottawa IT Community tomorrow.  Aldo I am giving it a Dev Spin any DBA will feel at home in this session.  I hope to see you tomorrow. 



.NET | Event | SQL | SSIS | SSRS

Check out DevTeach Montreal 2016 sessions line up

by Jean-Rene Roy 26. January 2016 09:30

#DevTeach just posted the sessions line up for their event in Montreal. Over 48 speakers presenting in 5 track. I will be presenting my Modern DBA sessions in the All About Data Track. This event is presented during the Jazz Fest in Montreal (July 4-8) and you can also attend a Pre-Con on SQL Server Query design workshop and 2 Post-Con on Angular 2 and Dynamic CRM. With the early bird right now, you can attend for only $200 per day. You do not what to miss this event.  Check it out:



.NET | Event | SQL

DevTeach Call for speakers is on!

by Jean-Rene Roy 19. November 2015 07:38

is back in Montreal on July 5-7 2016. Submit your sessions by Dec 24th.


.NET | Event | SQL | SSIS

DevTeach , SQLTeach and SQLSaturday366 Ottawa Pre-Con announcement

by Jean-Rene Roy 24. February 2015 01:08

Edwin Sarmiento will present a two days’ workshop on SQL Server HA /DR.  Is workshop is also a Pre-Con to SQLSaturday # 388 in Ottawa.  The Main conference will be held in the Microsoft Office on Saturday April 25th. Edwin Pre-Con will be presented on Thursday April 23th and Friday April 24th. Been a good friend of Edwin, I can tell you that, in regard of disaster recovery he is one of the best on this planet. We, SQL Server MVP, look up to Edwin for is expertise.  I will be attending this Pre-Con and I hope to see you there.




Event | SQL | SSIS | SSRS

Case Management is more and more popular in Government

by Jean-Rene Roy 3. October 2014 10:14

In Ottawa, the federal government is standardizing on Dynamic CRM platform for case management application. These time of application manage Case File like ticket at help desk, Sale lead or files that take many actions to be close.

For the Government of Canada, this application will manage things like, committee booking for house of common, Grant management for Canada Council of Art, Nuclear manipulation for CNSC or transport incidents for transport Canada.

Coradix created a new user group call Case4Gov.ca. This new group, also on meetup, is will help developer know more about this platform. I was invited to present my presentation “How to integrate legacy application with Dynamics CRM 2013” on September 25th.  I did this presentation many times and I will post a video recording this presentation on DevTeach Video Hub soon.  Hope to see you at this new user group.




Event | SQL | SSIS

Presenting Dynamics CRM 2013 at TBS Innovation Center

by Jean-Rene Roy 4. June 2014 22:20

TBS is recommending Dynamics CRM 2013 has the development platform for Federal Government agencies. I did a presentation at the TBS Lunch and Learn in May. That presentation was well received and TBS Innovation center invited me to present it again on June 11th but this time it will be recorded and broadcasted live via WEBX (TBS internal network) to all TBS employees.  This is the same presentation I did for Ottawa IT Community and you can find the slide at this link: http://www.meetup.com/ottawaitcommunity/events/152062432/


.NET | Event | SQL | SSIS

Presenting at a House of Commons Private DevTeach May 20th

by Jean-Rene Roy 20. May 2014 21:51

DevTeach is organizing private conference for clients. The next event will be done for House of Common and I will be presenting on May 20th my presentation on Data Migration and Integration with SSIS and Dynamics CRM 2013. I done this presentation at the User Group Ottawa IT Community on April 24th and you can read the comments or download the slides at this link:  http://www.meetup.com/ottawaitcommunity/events/152062432/




.NET | Event | SQL | SSIS | SSRS

Presentation of Dynamics CRM 2013 at TBS Lunch and Learn

by Jean-Rene Roy 11. May 2014 09:49

I have been invited to present my sessions Data migration and Integration with Dynamics CRM 2013 at TBS Lunch and Learn.  This presentation is normally done in 2 hours and 30 min.  So I will have to present it 2 parts.  The Part 1 will be presented on  May 8th . This presentation have been done at the Ottawa IT Community and slides can found at this link: http://www.meetup.com/ottawaitcommunity/events/152062432/


Blog | Event | SQL | SSIS

Data Migration and Integration with SSIS and Dynamics CRM 2013

by Jean-Rene Roy 8. April 2014 09:34

I have been working on contract at Canada Council of Art where I had to design an ETL for Data Migration and a sync strategy for CCA stakeholder.  This work inspires me to present a session about Data Migration and Integration with Dynamics CRM 2013. I did this presentation with Salim Adamon (CRM MVP) and we are presenting it at Ottawa IT Community on April 24th .  Hope to see you there.



Blog | Event | SQL | SSIS

Do not miss DevTeach Vancouver event (Dec. 2-4)

by Jean-Rene Roy 2. November 2013 11:01

Although Vancouver has a large IT industry, it doesn’t get many web developers conferences.  DevTeach has been doing events in Vancouver every 18 to 24 months since 2007.  Our next conference will be from Dec 2nd   to the 4th at the Sheraton Wall Center; exactly where it all started 6 years ago.  Don’t miss this opportunity otherwise you may have to wait a few years to get that level of training.  The best speakers will be there to share their expertise. Google the DevTeach Rebate code or use the Group price to get the best training for less than $333 per day.



.NET | Event | SQL | 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