I came across a really interesting audit trigger for SQL Server 2005 a little while back, and thought it was worth re-posting it here.The trigger basically logs changes for only columns that are affected into a generic audit table. It's got some fancy bit manipulation coding (that I still don't fully understand) and uses dynamic SQL, but hey, since I normally stay away from triggers anyway, I can accept a little dynamic SQL :-)The alternative is to have an audit table that closely resembles my real table and log changes to that. And then run queries to find what was...

I've been holding off upgrading my Subversion repository and tools, until last week or so when the "perfect storm" of source control arrived: VisualSVN Server with Subversion 1.5, TortoiseSVN 1.5, and the last piece of the puzzle, AnkhSVN 2.0. If, like me, you've been waiting for the right time to upgrade your Subversion source control to the newly-released 1.5, then the free VisualSVN Server is one official (and dead-simple) way to do this as CodeBetter's James Kovacs recently noted. My older 1.3 repository was upgraded painlessly using VisualSVN Server, although I could have also called svnadmin upgrade from a command line...

SQL Bits is having a logo competition, and I entered the following:My goal was to feature the familiar (often yellow) database cylinder, with simple text. I don't expect to win, but given the prize (an XBox 360) I thought it would be worth a try :-)Links: http://www.sqlbits.com/LogoCompetition.aspxTags: sql bits, logo, contestBlogged with the Flock Browser

My mother-in-law Marijke gave me a special surprise the other day: a hand-me-down copy of the 1984 tome "Choosing and Using Your Home Computer: An Introductory Course". Marijke had bought it some time ago to learn about computers. The book is a classic, from the time when PC's were called "microcomputers". It covers the latest hardware available at the time, the BASIC language, accessories like printers, plotters and the new-fangled "mouse", sprite graphics, games and the business case for computers. What makes this book more poignant is that I was into computers in 1984. I had a Commodore 64, and one of...