Skip to main content

Seeking Help: Sachin Rekhi’s Database Unit Testing Whitepaper Draft

Sachin has just published a draft whitepaper on database unit testing using Team Edition for Database Professionals. The whitepaper includes details steps on creating your first unit test; automatic test generation; the standard test conditions available; and even delves briefly into the C#/VB.Net code used by the testing framework. I highly recommend users of Database […]

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) […]

“Team Suite” Required to Install Database Professionals Trial

There has been a lot of discussion in the forums about which track of Visual Studio is required for the new Database Professionals (Data Dude) Trial to install. Database Professionals TRIAL requires Visual Studio 2005 Team Suite to be installed. A Visual Studio Team Edition for Database Professionals will be available as a standalone product […]