Tag Archives: tsqlt

Testing

It seems that software always contains bugs. No matter how much time and effort is spent building an application, there will be issues. Sometimes this is because of a lack of testing, and sometimes this is because of poor testing, … Continue reading

Posted in Editorial | Tagged , , | Comments Off on Testing

Expected Variables–T-SQL Testing

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

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

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