JR's Blog | SSRS

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

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

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.

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

Tags:

.NET | Event | SQL | SSRS

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

SSIS Presentation for Treasury Board of Canada Secretariat

by Jean-Rene Roy 26. October 2012 21:33

Tuesday October 30th I will be doing a Lunch and Learn for TBS in Ottawa. This presentation will show the new version of SQL Server 2012 Integration Services (SSIS). In SQL Server 2012, one of the biggest enhancements is the new server deployment model for SSIS package.  There is also many new things that I call users enhancement but the biggest thing are how Developer’s and DBA will be working together with this new version of SSIS. This presentation is exclusively for employees of TBS. This presentation will also be presented at SQLTeach Montreal on December 11th has a session of the Main Conference.

Tags:

SQL | SSIS | SSRS

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  

Tags:

SQL | SSIS | SSRS

Free SQL Server 2012 event in Ottawa June 22nd

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

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

Tags:

SQL | SSIS | SSRS

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.

Tags:

.NET | SQL | SSIS | SSRS

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.

Tags:

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