THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SQL Server » unit testing   (RSS)
  • Enforcing naming conventions using database unit testing

    My naming convention obsession Anyone that has ever worked with me will tell you that I am a stickler for naming conventions. I have a somewhat obsessive reputation for it; I can’t help it – I seem to have a deep seated uncontrollable desire to ensure that every object in my database(s) is/are named consistently (is there anyone else out there ...
    Posted to Jamie Thomson (Weblog) by jamiet on October 5, 2010
  • Experiences from writing sp_CascadingDataViewer – DB unit testing and code distribution

    Its now been a month since I introduced sp_CascadingDataViewer and I wanted to take the opportunity to talk about a couple of my experiences while writing it.   SQL Server needs packages Version 1 of sp_CascadingDataViewer is an 899 line stored procedure (view the code at changeset 58999), that’s a lot of code and much of it is repeated. I ...
    Posted to Jamie Thomson (Weblog) by jamiet on September 18, 2010
  • Microsoft publish Visual Studio 2010 Database Project Guidance

    Three days ago I wrote a blog post entitled Setting up database unit testing as part of a Continuous Integration build process [VS2010 DB Tools - Datadude] which goes through some of the intracasies of using Visual Studio 2010 Database projects (aka datadude projects) and database unit testing as part of a continuous integration build. ...
    Posted to Jamie Thomson (Weblog) by jamiet on August 23, 2010
Privacy Statement