Since April 1^st 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 12^th OttawaSQL

·         April 14^th  Ottawa Code Camp

·         April 28^th 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.

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.

Last weekend was SQL Saturday 114 Vancouver.  SQLTeach was a sponsor and we draw a winner to SQLTeach Main Conference.  The winner was Sam DeMooy.  SQL Saturday 114 was a big success with an attendance of over 200 attendees.  Congratulation Sam.

You are all invited to join us on March 7 for the SQL Server 2012 Virtual Launch Event. This is a good opportunity for you to see what new in SQL Server 2012. You will have access to over 30+ sessions to learn about the new capabilities of SQL Server 2012 at your own pace, on your own schedule. This event brings together a who’s who of industry experts and executives to tell the SQL Server 2012 story in this unique online launch event. You will also be able to “meet” with other experts, customers and partners in a virtual “Expo Hall” to discuss SQL Server 2012 one-on-one.

To see the full agenda and to register go to http://www.sqlserverlaunch.com/ww/Home .

I am doing a session on SSIS 2012 in Vancouver this week. My good friend Richard Baumet is the UG Leader and he has been the UG leader for the past 4 years. Richard, has the main DBA for RBC, is very knowledgeable. He will be speaking at DevTeach Vancouver next May.  This is the sessions Richard will present at DevTeach Vancouver.

Building a database for Analytics and Reporting
Richard Baumet - SQL288
Dimensional Modeling - Building a database for Analytics and Reporting  

Data grows constantly and history becomes harder to maintain. Wether you’re a Developer, DBA, or a BI techie, we eventually come to a realization that the environment can get too large and too complex. This session shows one popular approach to database design to allow for efficent storage and ease of querying for the business.  

SQL Server 2012 - Upgrading to AlwaysOn
Richard Baumet - SQL345
This session will explore the brave new era in HA\DR with SQL Server AlwaysOn focusing on the upgrading of existing architecture and managing the mulitple replicas in your environment.

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.