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

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.