Tag Archives: testing

Unit Testing in Philadelphia

Posted on May 22, 2015 by way0utwest

I’m helping teach a pre-conference session on Friday, June 5, 2015 at the Microsoft office in Philadelphia. This is an all day, paid for event, that looks at how you can use a framework to write unit tests for your … Continue reading →

Posted in Blog | Tagged , , , , | Comments Off on Unit Testing in Philadelphia

Refactoring Mistakes Are Why We Write Tests

Posted on May 20, 2015 by way0utwest

I wrote a short piece the other day trying to show how one can use tSQLt to test code. It’s a simple test built against a user defined function. It works well and when the test is run, it passes. … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Refactoring Mistakes Are Why We Write Tests

Why Test Table MetaData Tests with tSQLt

Posted on May 18, 2015 by way0utwest

I wrote at SQLServerCentral about using tSQLt to check table metadata. In essence we are testing the API of our table. However, since the table could change, and may need to, what’s the value of having a test fail if … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Why Test Table MetaData Tests with tSQLt

tSQLt with TRY..CATCH

Posted on March 25, 2015 by way0utwest

Someone asked me the question recently about how tSQLt works with TRY..CATCH blocks and the exceptions that we might test for. It works fine, just as it would with other code, but you need to understand that a CATCH still … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on tSQLt with TRY..CATCH