When we write articles, blog posts, and books, our examples must be simple. On the other hand, when we write automated tests in real life, the most complex modules need automated tests much more than simple ones. Consider, for example, the following trivial stored procedure: CREATE PROCEDURE ...

Unit testing may be extremely useful if we do it right – if. On the other hand, if unit testing is being used inefficiently, it can be a huge waste of time and effort. When we were beginning to unit test our T-SQL more than three years ago, we wrote a series of articles describing how to do it with C# and NUnit. This approach worked out ...

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 ...

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. ...

[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 ...

I have a Visual Studio solution which mostly consists of unit and automated tests. All tests are developed in C#, using NUnit and our own library for database tests.All my T-SQL code is also included in the same VS solution. Because Windows search frequently fails to find files, I am using VS search, which always finds all the right files as long ...

How do you unit test your T-SQL? Which libraries/tools do you use? What percentage of your code is covered by unit tests and how do you measure it? Do you think the time and effort which you invested in your unit testing harness has paid off or not? If you do not use unit testing, can you explain why not?

Yesterday I’ve release an updated version of QueryUnit, the version 0.0.0.8. 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 ...

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 ...

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 ...