November 2010

Unit Testing with Visual Studio DB Pro Part 2

21 November 2010

In Part 1, I talked about some of the challenges associated with writing effective database unit tests and in Part 2, we will work through setting up a new database test project in Visual Studio 2008 then writing and passing our first unit test. If you’re reading this I will assume you know about some of […]

Read the full article →

Storing Single Key/Value Settings

16 November 2010

I read an interesting post today by Arnie Rowland about a simple but clever way to ensure only one row in a table used for application settings or config items. I have found that tables like this can, if allowed to go unchecked, proliferate through a database which can cause minor, niggling maintenance issues and […]

Read the full article →

Unit Testing Databases with Visual Studio Part 1

14 November 2010

I’m a big fan of the benefits of test-driven development (TDD) and similar methods. Having a suite of unit tests that can be easily or automatically re-run gives me greater confidence in the quality of the software I produce and means that I spend less time debugging both during initial development and during any subsequent […]

Read the full article →

Configuration system failed to initialize

13 November 2010

I recently needed to change the root namespaces on a solution, I know this something that I should have perhaps thought out in more detail before getting so far in to the project but that’s not the point of this post. I stand to be corrected, but there doesn’t seem to be a way of […]

Read the full article →

Finding Dependencies in SQL Server

9 November 2010

I think that anyone who has used the system stored procedure sp_depends to find dependencies in SQL Server will have discovered  that the results cannot always be relied upon.  Most notably, this can occur when modules (procedures, views etc) have been created out of dependency order.  It seems that SQL Server only populates sys.depends values […]

Read the full article →

Why am I here?

3 November 2010

I suppose it’s traditional to start a new blog off with a “why am I here/what is this blog about” type post, so here goes… fast access cash I have worked in IT for almost eleven years, and have focussed on databases and SQL Server for ten of those. Like most seasoned professionals, I have […]

Read the full article →