It might seems early to you, but its now 2007 in Sydney Australia. Happy New Year. Its been one huge year and I hope this new one is even better!
You are browsing archives for
Month: December 2006
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 […]
The Five Easy Steps of Unit Testing for Database Professionals
Now that Microsoft have released Visual Studio Team Suite for Database Professionals (aka [story:datadude]) its time for SQL Server developers and dbas to learn more about Unit Testing. There is many different methods to test a database within the framework set by Visual Studio. So how do you know which way is best? Well one […]
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 […]
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 […]
I hope not every day is going to be like this…
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.
Unsigned Integer Datatype in SQL Server 2005
There’s been some interesting questions by users on the SQL Server Engine Tips blog. While almost all of them seem to be off topic, there are some interesting ideas. One of the fun ones was from Dave asking “Can we have some unsigned int data types?”. As a basic background for those of us who […]
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 […]