Skip to main content

Hey Geeklog! Where did my [ story: ] go?

After receiving so much comment/trackback spam recently, I decided to make some changes to my site. Asides from the unrelated and often very undesirable content of the spam, textual urls were being turned into hyperlinks by Geeklog. I’d already removed the tag from the list of permitted html (configurable through $_CONF[‘user_html’]). So I headed off […]

Cannot BACKUP or RESTORE a database snapshot

I’ve been beta testing SQL Backup 5 and came across an old problem. If you iterate through all the databases on a server and issue a BACKUP DATABASE for Database Snapshot you will receive an error message similar to: Msg 3002, Level 16, State 1, Line 1 Cannot BACKUP or RESTORE a database snapshot. Msg […]

Data Dude

Data Dude The simplest way to say “Visual Studio 2005 Team Suite Edition for Database Professionals”. A suite of tools built by Microsoft for designing, deploying and testing SQL Server databases within the Visual Studio IDE. Visit the Visual Studio 2005 Team Edition for Database Professionals A.K.A. DataDude website.

LEN(NULL) != 0

Its pretty often that I run across SQL code that supposed to handle empty or null varchar values. But a lot of the time it doesn’t. And usually its because a developer has made the false assumption that null has a length of 0. It doesn’t. LEN(NULL) IS NULL. LEN(NULL) does not = anything. LEN(NULL) […]