Tag Archives: testing

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

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