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.

MobileTeach is presented with the best expert in the industry.  Markus Egger, Colin Melia and Tim Huckaby are expert in the Windows Phone and Windows 8 plateform, Ben Sheiman, Kevin McNeish and John  Waters master the iOS. Wei-Meng Lee, Jessica Ker and Martin Legris know all the secrete of Android and Bryan Costanich is a master in cross platform Mono and MonoTouch from Xamarin.  This is an impressive lineup of speakers. http://www.devteach.com/Mobileteach/

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 having a boxing week! That right, if you register this week, for the Vancouver event, you can use this rebate code (DEVTBOXINGDAY) good for $200 off on the early bird prices.  That really a good deal because the early bird price is $799. That price minus $200 you can get 3 days of training for $599! That only $199 per day for this high profile event.  This offer end Saturday.

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