XML Programming in SQL Server 2005

With the RTM of SQL Server 2005, excitement is understandably running very high in the SQL Server developer community.  If you haven’t had a chance to get your hands on this release, I urge you to do so as soon as you can.  It absolutely rocks.  MSDN subscribers can download it here (and will also like this…


Database Design: Do Not Fear NULLs

Last week, I found myself simultaneously confounded and fascinated by a conversation on the internal Microsoft SQL Server discussion list.  If you know me at all, you know that I had to toss in my two cents, but I’m getting ahead of myself.   The thread started with a question from an application development consultant…


Two Programming Tricks: Counting Characters In A String and RETURN CASE

A couple of tricks here, from some recent work: a user-defined function to count the number of characters in a string, and a new (for me) syntax discovery: RETURN CASE. Here’s what I came up with for the user-defined function: CREATE FUNCTION dbo.fnCountCharactersInString(    @StringToTest nvarchar(max),    @CharactersToCount nvarchar(max))RETURNS intASBEGIN    DECLARE @EditableCharacterCount int,            @Looper int    SELECT @EditableCharacterCount =…


The Gig Was..

.. a blast.  Over $100 was raised, which the company will match, and as far as I know a good time was had by all. If you’d like to support Cocoon House, please let me know.