JR's Blog | August 2011

Save Big before September 1st!

by Jean-Rene Roy 31. August 2011 10:42

Guy’s,

DevTeach Ottawa (Nov. 2-4) is in our town this year and if you register early you can save big $$$.

Check the list of speakers and sessions already posted. Better yet, more sessions will be posted from TechDays Canada after the Microsoft Build conference.

 

Early registration (2 Days)

Cost CAN

Before August 1st, 2011

349.00$

Between August 1st and 30th, 2011

449.00$

Between September 1st and 31st, 2011

549.00$

Between October 1st and November 4th, 2011

649.00$

Tags:

A clash with the Open Source Wolds….

by Jean-Rene Roy 28. August 2011 01:09

Today I am spending time at the Ottawa Open Source Conference (http://www.fosslc.org/drupal/). It’s not my first time in an Open Source Conference but up to 3 weeks ago, I did not know we had one in Ottawa.  This is a very good event and I will be coming back next year.

This non-profit organisation is recording all sessions with software created here in Ottawa by (FOSSLC) which use a device made by (Epiphan VGA2USB), a company located in Kanata. I am very impress by this solution for recording conference and I seriously considering it for recording some of the DevTeach Ottawa sessions.  

Tags:

Do you what to go to Developer’s Haven for free!

by Jean-Rene Roy 20. August 2011 03:22

Yes that right. Developers' Haven for free! SC2010 Software Developers' Haven is a Ottawa event held at the University of Ottawa on August 27th. The cost of the event is $119 but DevTeach is giving free pass to the event. See DevTeach FaceBook page for Details.

 

Tags:

The unknown secret of Inserted row set of SQL Server

by Jean-Rene Roy 5. August 2011 00:42

Has a consultant I come and go in different enterprise and I meet Software Developers and DBAs.  In SQL Server, there is many aspects that are useless for DBA and very useful to the developers. But most developers I meet want to stay away from T-SQL. Almost like, if you do T-SQL you are a DBA and we know how Developers love DBA’s J.  

 Many developers ask me these questions.

·         How to update automatically a field during a T-SQL update statement?

·         How can I update the current row from a trigger in T-SQL?

This is how:

 

-- =============================================

-- Author:        Jean-Rene Roy

-- Create date: August 4th, 2011

-- Description:   Will update field ModDateTime for all updates

-- =============================================

CREATE TRIGGER [dbo].[MyTable_ModDateTime]

   ON  [dbo].[MyTable]

   AFTER UPDATE

AS

BEGIN

      -- SET NOCOUNT ON added to prevent extra result sets from

    SET NOCOUNT ON;

    Update MyTable

            set ModDateTime = GetDate()

            from inserted

            Where MyTable.id = inserted.ID

    SET NOCOUNT OFF;

END

SQL Server will populate the Row Set call inserted during the UPDATE or INSERT statement. You can access this row with the ‘’From inserted’’ clause.  In the case of a Delete statement you can access the deleted row with the ‘’From deleted’’ clause.   If your table has a identity field and you need to access it you can use the  @@IDENTITY system function to read it from a trigger.

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