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 » unit testing   (RSS)
Showing page 1 of 2 (12 total posts)
  • Database unit testing is now available for SSDT

    Good news was announced yesterday for those that are using SSDT and want to write unit tests, unit testing functionality is now available. The announcement was made on the SSDT team blog in post Available Today: SSDT—December 2012. Here are a few thoughts about this news. Firstly, there seems to be a general impression that database unit testing ...
    Posted to Jamie Thomson (Weblog) by jamiet on December 14, 2012
  • Thoughts on Test Driven Database Development

    Test-Driven Development (TDD) is a software development practise that has been around for a few years. Wikipedia describes it as: Test-driven development (TDD) is a software development process that relies on the repetition of a very short development cycle: first the developer writes a failing automated test case that defines a desired ...
    Posted to Jamie Thomson (Weblog) by jamiet on January 26, 2012
  • 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
  • Setting up database unit testing as part of a Continuous Integration build process [VS2010 DB Tools - Datadude]

    [This blog post assumes a familiarity with the terms Continuous Integration (CI), MSBuild & MSTest. If you don’t have a good appreciation of those terms then this blog post probably isn’t for you anyway so don’t worry about it!] Over the past few days I have been working to get database unit tests executing as part of our Continuous ...
    Posted to Jamie Thomson (Weblog) by jamiet on August 20, 2010
  • QueryUnit – Trust No One

    Yesterday I’ve release an updated version of QueryUnit, the version QueryUnit now supports AreNotEqual, Greater, and Less assertions and is more capable of managing strings results. I must say that I cannot live anymore without a proper Unit Testing of a BI solution. Just yesterday happened that one of the unit tests at a customer site ...
    Posted to Davide Mauri (Weblog) by manowar on April 13, 2010
  • The importance of Unit Testing in BI

    One of the main steps in the process we internally use to develop a BI solution is the implementation of Unit Test of you BI Data. As you may already know, I’ve create a simple (for now) tool that leverages NUnit to allow us to quickly create Unit Testing without having to resort to use Visual Studio Database ...
    Posted to Davide Mauri (Weblog) by manowar on April 1, 2010
  • QueryUnit POC v.

    Yesterday I released a new version of QueryUnit, a tool I've created to easily perform unit testing on SQL Server and Analysis Services databases. The main feature of this new version is the ability to automatically launch the NUnit GUI so that it’s even simpler to do unit testing. You can download it ...
    Posted to Davide Mauri (Weblog) by manowar on October 11, 2009
  • QueryUnit Binaries Released

    Due to several requests I’ve also released the binaries of QueryUnit: Enjoy!
    Posted to Davide Mauri (Weblog) by manowar on July 31, 2009
1 2 Next >
Privacy Statement