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 2 of 3 (23 total posts)
  • How to Benefit from Unit Testing T-SQL: choosing what to test.

    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 ...
    Posted to Alexander Kuznetsov (Weblog) by Alexander Kuznetsov on September 28, 2010
  • How to Benefit from Unit Testing T-SQL. Part One.

    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 ...
    Posted to Alexander Kuznetsov (Weblog) by Alexander Kuznetsov on September 27, 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
  • How I lay out my T-SQL source code

    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 ...
    Posted to Alexander Kuznetsov (Weblog) by Alexander Kuznetsov on June 24, 2010
  • Survey: how do you unit test your T-SQL?

    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?
    Posted to Alexander Kuznetsov (Weblog) by Alexander Kuznetsov on May 3, 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
Privacy Statement