Pierre-Emmanuel Dautreppe

When you have some SQL deadlocks in your application, (typically you will receive message like this : Transaction (Process ID XX) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction), it can be very difficult to find.
Hopefully, you can use the "SQL Profiler" to detect the source of the deadlock, asking it to generate "Deadlock Graph".

In this post, I will give some an example of a simple SQL query that can generate such a deadlock and how to detect it using the "SQL Profiler" tool and thus how to correct it. [Plus]

Just back from the first day of the TechDays 2008 in Antwerpen, Belgium. Here are my notes about the sessions I have seen meaning :
- Opening Keynote (By Rafal Lukawiecki)
- Session 1 : WCF & WF - Integrating two key technologies of .NET 3.5 (By Ingo Rammer)
- Inspiration Session 1 : ASP.NET Futures (By Matt Gibbs)
- Session 2 : Building Applications with Silverlight 2.0 (By Nikhil Kothari)
- Session 3 : Advanced debugging using Visual Studio (By Ingo Rammer)
- Session 4 : Sql Server 2008 - What's new for Developpers (By Dandy Wein)
- Session 5 : Ajax Patterns (By Nikhil Kothari) [Plus]

Just back from the launch day of the TechDays 2008 in Antwerpen, Belgium. Here are my notes about the sessions I have seen meaning :
- Opening keynote (by Bill Hilf), presenting Windows Server 2008, Visual Studio 2008 and Sql Server 2008
- Session 1 : Visual Studio 2008 Overview (by Peter Himschoot)
- Session 2 : Next Generation Web Application with Visual Studio 2008 (by Gil Cleeren)
- Session 3 : Pervasive Business Intelligence with Sql Server 2008 (by Frederik Vandeputte) [Plus]

You may know one of the improvement of Sql Server 2005 was the tight integration with the .NET CLR, giving the ability of creating stored procedures in C#.
We have never used in production environment and it's time to exchange on this subject.
One of my colleague will give a training on this subject.

Check all details about this event ! [Plus]