Imagine this. You are part of a team of experts and you have to  selecting 84 sessions for a conference. You received 72 proposals for a total of 350 sessions to select from.  That was not a simple task. But after some difficult choices you manage to pull off a very good show. Check you the new sessions for DevTeach Vancouver 2012. If you are in to web development, this is your conference. But what! You have to see the Pre-Conference and Post-Conference.  It’s really a very good conference. Trust me I know what I am talking about.  

Did you know, DevTeach is looking for speaker for their event of Vancouver (May 28^th to June 1^st). Check out the Tech Chair Team.  I will be the Tech Chair for three tracks, SQL BI, SQL DBA and SQL Dev. If you are interested, you have up to Dec. 20^th to submit your sessions.  To submit your sessions proposal you need to use DevTeach Excel template because this excel file will be used by a SSIS package that will load the data.  This event will have many flavors. It will cover many different technologies like .NET, Ruby, iOS, Android, PHP and more.  Get all the detail at this link.

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

You like to go the DevTeach but your boss do not agree you? That ok, in collaboration with the local community, DevTeach is presenting 4 bonus sessions. On November 2^nd, you can attend for free the Ottawa IT Community Speaker Idol. Come and see a friendly contest where local speakers have to do a 10 minutes presentation; the audiences will choose the winners.  On November 3^rd, we’re having three user groups presentations at the same time. The OttawaSQL will be presenting a sessions by Paul Nielson, The ODNC user group will present an Agile Scrum and Kanban presentation by David Starr and the OWSUG is having a IT Camp. All bonus sessions are free for everyone. Get all the details at this link.

This fall, TechDays Canada will be in 3 cities (Vancouver, Toronto and Montreal). If you think there are no TechDays in Ottawa this year, well you are wrong because TechDays Canada is the Platinum sponsor of DevTeach Ottawa. Most of the TeachDays content will be presented at DevTeach Ottawa, including new sessions on Windows 8 directly from the Build Windows Conference.  

That content mix with the special content of DevTeach promises to be a very good conference. Plus TechDays is a 2 days conference DevTeach Ottawa is 2 Days conference and one day of Pre-Conference. Unlike TechDays, DevTeach is limited to 300 attendees so register early.

I am getting ready for two presentations I will be doing in Toronto this Saturday. Amount the very good line-up of speakers, there is 2 speakers that are my favorite. Christian Coté and Edwin Sarmiento. Too bad I am presenting at the same time. I will miss very good sessions.   Take a look at the fantastic schedule for this event. It will be a fun time to be with the experts.

 ·         The event web site link.

 ·         The schedule link.

BTW, This is links to my presentations:

 ·         What is MS Sync. Framework

 ·         XML in SQL Server.  Why bother?

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.

Tonight I will be presenting at my UG www.OttawaSQL.Net on SSRS R2. Now SQL Server Report Services has been out for a long time but R2 is the version that got me exited.  Yes having a report server in your enterprise is a big advantages but if it difficult to maintain, that not fun. What about the ping pong game that going one between the client (Report User) and the DBA (Report Designer). Is that a pain or what?  Well viva SSRS R2 because it’s bring big benefits to all the areas.  Come and see what I have to say!

Please register here if you are coming. 

DBA’s are normally reluctant to accept XML in their database and developers are not aware of all the possibilities in XML in SQL Server. For this reason I design a session call XML in SQL Server! Why bother? I present this session with the point of view of the DBA, Developers and the software architect. It’s fun because someone asks a question, I answer three ways.  It will be presented in Vancouver March 2^nd. This is a most see.   You can download the code with this link.

It’s networking time! Because that what this trip is all about. My first stop is Vancouver on Saturday February 26 for the first SQL Saturday #65.  I am very impress by the lineup of sessions at this event. I am looking forward to see some of the sessions.  On Sunday I will take the train with many MVP’s heading to Seattle or more precisely Bellevue, WA. That night we have a Canadian MVP Dinner and that I am looking forward to.   On Monday, Tuesday and Wednesday I will try to learn as much as possible on Microsoft Campus in Redmond. Wednesday Morning I will take the bus back to Vancouver and at 5pm I will present my cool session “XML in SQL Server! Why bother?” at the Vancouver PASS chapter.   

Has you can see this will be networking trip but what I am most exciting is my diner with my cousins Greg and Sylvain.  We will meet on Saturday night. So you can see what the excitement is all about for me. Can’t way!