Tag Archives: testing

Expected Variables–T-SQL Testing

Posted on November 10, 2014 by way0utwest

After I wrote about creating tables that contain the results I expected, I wondered if I could do the same thing with variables. I was thinking that I’d like to better self-document my tests, and I’d like to be able … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Expected Variables–T-SQL Testing

Setting Expectations–T-SQL Testing

Posted on November 3, 2014 by way0utwest

I don’t know who started this pattern, as I’ve seen it in a few places. It could have been Sebastian Meine or Dennis Lloyd. Maybe it was Dave Green, who did the Pluralsight course on tSQLt. Not sure, but I … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Setting Expectations–T-SQL Testing

Anatomy of a tSQLt test

Posted on October 20, 2014 by way0utwest

I’ve been doing some work on testing database code, and working with the tSQLt framework. I really like the framework more and more, and want to continue to use it. The whole idea of testing is a bit immature in … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Anatomy of a tSQLt test

A T-SQL Code Testing Guide

Posted on October 7, 2014 by way0utwest

Do we need a guide for code like this one? The piece linked is from a programmer at Google who gives some code review items that should be tested for. I’m wondering we we might want to have something similar for T-SQL … Continue reading →

Posted in Editorial | Tagged , | Comments Off on A T-SQL Code Testing Guide