Tag Archives: testing

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

tSQLt – SQLCop – Checking Naming Conventions

Posted on February 12, 2015 by way0utwest

I’ve been using tSQLt a bit to do some testing and one of the things I’ve tested is standards for code. I’ve been using a framework on top of tSQLt called SQLCop. These are a series of tests written to … Continue reading →

Posted in Blog | Tagged , , , , | Comments Off on tSQLt – SQLCop – Checking Naming Conventions

Debugging SQL Server

Posted on January 16, 2015 by way0utwest

One of the tools that I found useful early in my development career was the debugger. Being able to track the values of variables, check the call stack, and pause execution of programs was handy. Early in my career, the … Continue reading →

Posted in Editorial | Tagged , , , | Comments Off on Debugging SQL Server

Testing

Posted on January 8, 2015 by way0utwest

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