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

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.