JR's Blog | SSIS

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. 

http://www.meetup.com/ottawaitcommunity/events/228292431/


Tags:

.NET | Event | SQL | SSIS | SSRS

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.

Tags:

.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.

http://www.devteach.com/specialeventsql.aspx  

https://www.sqlsaturday.com/366/eventhome.aspx

Tags:

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.

http://www.meetup.com/SCMS_COP/events/206818132/

 

Tags:

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/

Tags:

.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/

 

 

Tags:

.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/

Tags:

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.

http://www.meetup.com/ottawaitcommunity/events/152062432/

Tags:

Blog | Event | SQL | SSIS

The Ottawa IT community Call for speakers is Open.

by Jean-Rene Roy 9. August 2013 10:15

The Ottawa IT Community is now open to suggestions for the season 2013-2014. We are looking for speakers for the Dev and DBA.  We like you to submit to Joel Hebert and Jean-Rene Roy the sessions you like to present with one  or two of the dates below.  Your proposal session(s) can be about Web Development, Cloud, Software Architecture, Agile methodologies, Database administration, Development, BI or any subject related to IT.  Please submit your proposal before September 15th.

Proposed Date 

Time of Day

Group

  

 

Labour Day

Thursday, September 12, 2013

Evening

ODNC

Thursday, September 19, 2013

Evening

OttawaSQL.net

Thursday, September 26, 2013

Lunch

ODNC

Thursday, October 17, 2013

Evening

OttawaSQL.net

Thursday, October 24, 2013

Evening

ODNC

Thursday, October 31, 2013

Lunch

ODNC

Thursday, November 07, 2013

Evening

ODNC

Thursday, November 14, 2013

Evening

OttawaSQL.net

Thursday, November 28, 2013

Lunch

ODNC

Thursday, December 05, 2013

Evening

ODNC

Thursday, December 12, 2013

Evening

OttawaSQL.net

Wednesday, January 16, 2013

Evening

ODNC

Thursday, January 23, 2014

Evening

OttawaSQL.net

Thursday, February 06, 2014

Evening

ODNC

Thursday, February 13, 2014

Lunch

OttawaSQL.net

Thursday, February 13, 2014

Evening

OttawaSQL.net

Thursday, March 06, 2014

Evening

ODNC

Thursday, March 20, 2014

Evening

OttawaSQL.net

Thursday, March 27, 2014

Lunch

ODNC

Thursday, April 03, 2014

Evening

ODNC

Thursday, April 10, 2014

Evening

OttawaSQL.net

Thursday, April 24, 2014

Lunch

ODNC

Thursday, April 24, 2014

Evening

OWSUG

Thursday, May 01, 2014

Evening

ODNC

Thursday, May 08, 2014

Evening

OttawaSQL.net

Thursday, May 22, 2014

Evening

OWSUG

Thursday, June 05, 2014

Evening

ODNC

Thursday, June 19, 2014

Evening

OWSUG

 

Send your proposal to:

Joel Hebert : joel.hebert(At)opulentasp.com

Jean-Rene Roy: jrroy(At)DevTeach.com

Tags:

.NET | Blog | Event | SQL | SSIS | SSRS

SQLSaturday #198 Vancouver is next weekend

by Jean-Rene Roy 13. February 2013 06:35

Can you believe it! It the event 198 of SQL Saturday! Richard Baumet and is friends are organizing a very good one day conference.  For this event your will find 8 rooms presenting SQL Stuff at the same time. This very big! I will be presenting at 4:20pm in room 1850. You can get the full schedule at this link: http://www.sqlsaturday.com/198/schedule.aspx Hope to see you there.

Tags:

Blog | Event | SQL | SSIS

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