After upgrading DasBlog to the latest release and setting up FeedBurner I felt that I needed to do something to improve my posting experience.  Since inception I've been using the built-in rich text web form in DasBlog.  However good it may be it still lacks in a few areas:

1. No real-time spell checking.  Since FireFox 2.0 came out this hasn't been an issue since it includes a very nice spell checker.
2. Code formatting.  For the life of me, I cannot get code formatting to respect my tab spacing.  It parses the code just fine, but after it gets inserted into the post text area all the tabbing is gone.  This last point has really frustrated me and kept me from posting code as often.
3. No offline mode.  Yeah I know, that's a bit much to ask of a web product, although Google seems to have found away around this with their Google Gears, which allows me to use the Google Reader in offline mode.

All of these issues have led down the path to Windows Live Writer, which is what I'm using right now to write this post.  The thing that amazed me about both DasBlog and Windows Live Writer, is that installing and configuring Windows Live Writer just worked.  There was no oeed to read any instruction manual or otherwise research how to set this up.  It just worked.

The other thing that impressed me was that it has a web preview mode which allows me to actually see this post as would appear on my blog - and I mean exactly as it would appear on my blog.  It basically has a complete cache of my blog home page, even when disconnected from the inter-web, which is really nice and unexpected.  In Google terms, that feature "delighted" me.

As for code, lets see if I can cut and paste from Visual Studio...

/// <summary>
/// Converts a local DateTime instance to the MiniTix date time format.
/// </summary>
/// <remarks>
/// ISO 8601 date format in Zulu time.
/// </remarks>
/// <param name="date">The date.</param>
/// <returns></returns>
public static string ToMiniTixDateTimeFormat(DateTime date)
{
    return date.ToUniversalTime().ToString("u");
}

Darn, that didn't quite work did it?  Fortunately I noticed Windows Live Writer has a plugin feature.  Google search...  Found a code formatter plugin right away on CodePlex!  Lets see how the new plugin works.  Exception, Directory not found!  OK that didn't work, although Live Writer did find and load the plugin automatically while it was running (I unzipped the plugin to the plugins folder while Live Writer was still running), lets try restarting Live Writer and try again - Insert clipboard as code:

        /// <summary>
        /// Converts a local DateTime instance to the MiniTix date time format.
        /// </summary>
        /// <remarks>
        /// ISO 8601 date format in Zulu time.
        /// </remarks>
        /// <param name="date">The date.</param>
        /// <returns></returns>
        public static string ToMiniTixDateTimeFormat(DateTime date)
        {
            return date.ToUniversalTime().ToString("u");
        }

 Much better!  Even the XML comments got picked up.  Finally, lets see if I can post!

1. Feed speed optimization, my blog server isn't the hottest thing around - by a long shot.  In fact its on my todo list to find a new hoster.
2. Exposure, hopefully I can draw in more readers.
3. Feed analytics.  Right now I have really no idea if anyone ever reads this blog, or how often.
   
4. Everyone's doing it.
   

Well, I fixed our CC.NET build that builds one of our C++ projects.  The MSBuild script was taking longer than the timeout specified in CC.NET (which was set to 5 minutes), so CC.NET was killing the build before it finished without reporting as to why the build was failing.

USE MASTER
GO

-- If the database already exists, drop it
IF EXISTS(SELECT * FROM sysdatabases WHERE name='Northwind')
ALTER DATABASE Northwind SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO

IF EXISTS(SELECT * FROM sysdatabases WHERE name='Northwind')
    DROP DATABASE Northwind
GO

int theRef = 42;
int theOut = 0;
Expect.Call(obj.MyMethod(ref theRef, 0, out theOut)).Return(True).OutRef(13, 666)

using System;
using System.IO;
using log4net;

namespace ConsoleApplication1
{
    class Program
    {
        private static readonly ILog Logger = LogManager.GetLogger(typeof(Program));

        static void Main(string[] args)
        {
            string input;
            do
            {
                input = Console.ReadLine();

                if (input != null)
                    DeleteDir(input);

            } while (input != null);
        }

        private static void DeleteDir(string input)
        {
            if (Directory.Exists(input))
            {
                Logger.InfoFormat("Deleting directory {0}", input);
                Directory.Delete(input, true);
            }
            else
                Logger.WarnFormat("Directory {0} does not exist", input);
        }
    }
}

    USE ASPState
GO

ALTER PROCEDURE dbo.TempGetAppID
    @appName tAppName,
    @appId int OUTPUT
AS

    -- start change

    -- Use the application name specified in the connection for the appname if specified
    -- This allows us to share session between sites just by making sure they have the
    -- the same application name in the connection string.
    DECLARE @connStrAppName nvarchar(50)
    SET @connStrAppName = APP_NAME()

    -- .NET SQLClient Data Provider is the default application name for .NET apps
    IF (@connStrAppName <> '.NET SQLClient Data Provider')
        SET @appName = @connStrAppName

    -- end change

SET @appName = LOWER(@appName)
SET @appId = NULL

SELECT @appId = AppId
FROM [ASPState].dbo.ASPStateTempApplications
WHERE AppName = @appName

IF @appId IS NULL BEGIN
BEGIN TRAN

SELECT @appId = AppId
FROM [ASPState].dbo.ASPStateTempApplications WITH (TABLOCKX)
WHERE AppName = @appName

IF @appId IS NULL
BEGIN
EXEC GetHashCode @appName, @appId OUTPUT

INSERT [ASPState].dbo.ASPStateTempApplications
VALUES
(@appId, @appName)

IF @@ERROR = 2627
BEGIN
DECLARE @dupApp tAppName

SELECT @dupApp = RTRIM(AppName)
FROM [ASPState].dbo.ASPStateTempApplications
WHERE AppId = @appId

RAISERROR('SQL session state fatal error: hash-code collision between applications ''%s'' and ''%s''. Please rename the 1st application to resolve the problem.',
18, 1, @appName, @dupApp)
END
END

COMMIT
END

RETURN 0
GO