SQL Server 2005 Service Pack 2

Just in case this slipped by [:)]   Check http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/servicepacks/sp2.mspx for all the details and the downloads.   Enjoy!     Maurice de Beijer www.TheProblemSolver.nl wiki.WindowsWorkflowFoundation.eu/  

Cool tool: Lutz Roeder’s Reflector

Reflector by Lutz Roeder is probably the tool I use most often when developing .NET code, well just after Visual Studio 2005 anyway. And now there is a new version, 5, out. Still free, still excellent. Highly recommended.   Download from http://www.aisto.com/roeder/dotnet To check for new features: http://www.aisto.com/roeder/paper/reflector5.ppt Enjoy!     Maurice de Beijer www.TheProblemSolver.nl wiki.WindowsWorkflowFoundation.eu/  

Determining the table updated inside of a SqlTrigger

SQL CLR is pretty cool and lets you quickly do lots of things that are hard, if not impossible, to code in TSQL. But if you want to create generic code you sometimes need to know the context that the code is running under. The problem I had was creating a generic table update trigger and knowing the table that was updated.   During the execution of an update trigger you can get your hands on the new data using the Inserted temporary table so the data is there but there is no way of knowing the original table name, … Continue reading Determining the table updated inside of a SqlTrigger

Enabling CLR Integration in SQL Server 2005

SQL Server CLR integration is pretty cool [:)] allowing me to write .NET code and have it execute in SQL Server, for example as a stored procedure. Not that I would want to write every stored procedure using .NET code but for some of them it sure is a lot easier.   To enable it you need to reconfigure SQL Server a bit though. You need to enable CLR integration using the sp_configure sproc. Just don’t forget to execute a Reconfigure when done.   Just use: sp_configure ‘clr enabled’, 1goreconfigurego And you are ready to go [:)]  Enjoy!     Maurice de … Continue reading Enabling CLR Integration in SQL Server 2005

VSTO Excel solutions and disappearing Action Panes

If you are using Actions Panes in a VSTO Excel add-in you might have seen the following behavior. You create an new ActionPane, derived from UserControl, and add it to the Workbook ActionsPane.Controls collection. It shows up nicely so you think you are done.   Now the user creates a new Spreadsheet using File/New. Note that the ActionsPane disappears and remains hidden until the user reactivates it using View/Task Pane or Ctrl+F1.   So how do you automatically display the TaskPane when the user switched back to the original document? You need to add the following code to the ThisWorkbook … Continue reading VSTO Excel solutions and disappearing Action Panes

Cool attribute Diagnostics.Conditional

Something I often see in code is that parts of it are contained in the following construct:#If DEBUG Then   ‘ Some code#End If   Nothing wrong with that but often the code is the complete function body leaving an empty function in release mode. Now the JIT optimizer will make short work of it so there isn’t a big performance penalty but why make it go through these steps in the first place.   Another way way of doing so is using the Diagnostics.Conditional attribute. This can be applied to some function and removes all calls to it, so much … Continue reading Cool attribute Diagnostics.Conditional

Relaxed delegates in Visual Basic 8

In C# they have a thing called relaxed delegates that allow you to create an event handler with all parameter types as object and still be able to bind them to an event. Nice [:)]   In VB we don’t have the same thing, the parameters must match exactly. So the following piece of code doesn’t work [:(]   Imports System.Reflection Imports System.Windows.Forms   Module Module1       Sub Main()         Dim demo AsNew EventDemo         demo.HookEvent()         demo.FireEvent()     EndSub EndModule     PublicClass EventDemo     Private _textBox AsNew TextBox       PublicSub HookEvent()         … Continue reading Relaxed delegates in Visual Basic 8

Software Developer Conference 2007 – Call For Speakers

  The Software Developer Network (SDN) has begun planning for its 16th annual Software Developer Conference (SDC) to be held in The Netherlands on September 17 and 18, 2007. We hereby invite you to submit proposals to be considered for participation as a speaker on this upcoming event.   Software Developer Conference In May 2006, Software Developer Network held its 15th SDC in a row, again presenting the attendees with the latest techniques available. SDC 2006 was attended by over 400 professional software developers. 38 domestic and international speakers presented over 100 sessions on various topics.   Request for Speakers … Continue reading Software Developer Conference 2007 – Call For Speakers