Opulent ASP is pleased to pervey that Joël Hébert was named the SQL Developer Stream Director for the Ottawa SQL.NET chapter or PASS. Being a Microsoft MVP for ASP.Net and a long standing member of the Ottawa .Net communities steering Mr. Hebert believes he can bring experience and dedication to this role.

Yesterday I had the pleasure to present at the Ottawa Code Camp.I showcased something quite interesting and got alot of feedback on it.



In Entity Framework you can stronly type your linq to sql includes by adding Extension Methods. I found just methods as I was perusing the net one day.

Extension Method

Later on I discovered that the possiblitily to daisy chaine these strongly typed incudes could be done by daisy chaining lambda expressions. .This can be acheived with this Extension Method from the same author.

Extension Method for multiple includes

The lesson to retain is that the compilation is going to catch the erroneous fields if they are altered or missing , and not the user at run-time.

Here is the semantical variance:

NORTHWNDEntities ctx = new NORTHWNDEntities();

var Category_Products_EagerLoad = ctx.Categories.Include("Products");

//VS

var test = ctx.Categories.Include(c => c.Products);

Tomorrow J-R and Myself are going on a road trip to do a dual presentation in Québec city.

PART 1: C’est quoi SQL Service Broker? PART2: The pragmatics of Effective Web Farm Session State Management in ASP.NET

I am excited not only for the chance to enjoy a great poutine but to present in french for the first time.

I made some changes to my presentation as of late since I discovered many new things about Azure - Microsoft's Cloud Computing Platform. What I discovered is that the same things that plague Asp.Net and its Web Farms is present in Azure but there is already a provider to resolve the situation. I was very pleased to see this and have discused this at an event we had where I expose products during a Product Discovery Showcase.

Here are a few links for Azure (this is my blurb abotu Azure in the .net invite for the Ottawa .Net Community):

I was discussing with Peter Ritchie (C# MVP) about how excited I was for DevTeach and we both did conclude that if you dont go to DevTeach you are falling behind.

Then I go on the DevTeach site and see this!!!! 2 crazy deals

Get VS 2008 Pro, ExpressionTM Web 2 and Tech-Ed DVD set when you register
We believe that all developers need the right tool to be productive. This is what we will give you, free software, when you register to DevTeach or SQLTeach. Yes that right! We’re pleased to announce that we’re giving over a 1000$ of software when you register to DevTeach. You will find in your conference bag a version of Visual Studio 2008 Professional, ExpressionTM Web 2 and the Tech-Ed Conference DVD Set. Is this a good deal or what? DevTeach and SQLTeach are really the training you can’t get any other way.

DevTeach and SQLTeach are announcing a rebate for 350$ with your TechDay coupon…
What? A rebate of 350$, how is that possible! Well if you still have your TechDay/DevTeach rebate coupon you can use it for the December Montreal event and you will get a 350$ rebate. Originally the coupon was good for 100$ rebate but we like Microsoft so much that DevTeach changed its database and the coupon you have in your hand is worth 350$! This rebate will be effective until December 2nd. So hurry, don’t miss the opportunity to attend a conference with renowned speakers coming from all over the world.

http://www.devteach.com/

For those of you whom are attending DevTeach it will be fun to have a few chats and to greet each other once again. I wanted to let you guys know I will be attending this pre-conference session. I chose this topic due to two reasons. I have seen Adam Machanic speak in Ottawa and it was very well done. The eloquence and simplycity was bar none.

For a reference do peruse here:

Designing Highly Concurrent SQL Server Database Applications

Here is a little more about the session I am attending.

SQLCLR from Beginner to Expert By Adam Machanic 

The integration of the Common Language Runtime into SQL Server 2008 provides SQL Server developers and DBA with a vast new toolset for solving complex business and technical problems. This full day post-con event is designed for SQL Server DBA and developers who know some .NET or .NET developers with a strong interest in databases, and is designed to take the attendee from SQLCLR beginner to expert. You will learn all of the ins and outs of working with SQLCLR routines, including best practices for leveraging them in real-world scenarios.

By Adam Machanic Pre-requirements: 300-level; assumes at least one year of basic SQL Server and .NET (C# preferred) experience

Here is a little more about Adam:

Adam Machanic is a Boston-based independent database consultant, writer, and speaker. He has been involved in dozens of SQL Server implementations for both high-availability OLTP and large-scale data warehouse applications, and has optimized data access layer performance for several data-intensive applications. Adam has written for numerous web sites and magazines, including SQLblog, Simple Talk, Search SQL Server, SQL Server Professional, CoDe, and VSJ. He has also contributed to several books on SQL Server, including "Expert SQL Server 2005 Development" (Apress, 2007) and "Inside SQL Server 2005: Query Tuning and Optimization" (Microsoft Press, 2007). Adam regularly speaks at user groups, community events, and conferences on a variety of SQL Server and .NET-related topics. He is a Microsoft Most Valuable Professional (MVP) for SQL Server and a Microsoft Certified IT Professional (MCITP).