Tag Archives: testing

SQL Grouping on Sums (with testing)

Posted on September 25, 2017 by way0utwest

I ran across a post recently that I thought was an interesting T-SQL problem. The user wanted to group values into a running total, but the groups would reset based on a sum. In this case, the user had this … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on SQL Grouping on Sums (with testing)

Getting the tSQLt Run Adapter working in Visual Studio 2017

Posted on March 13, 2017 by way0utwest

Last year I heard about the tSQLt test Adapter for Visual Studio from Ed Elliot. I’ve been wanting to try it, but various items got in the way. Finally I had the chance to play and it worked well in … Continue reading →

Posted in Uncategorized | Tagged , | 2 Comments

Using tSQLt to Find Min/Max Times

Posted on March 13, 2017 by way0utwest

I love tSQLt. It’s a good way to write tests that can determine if your code is actually working. Since I’m a fan of unit testing, I think using tests to verify your logic is great. What’s excellent with tSQLt … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Using tSQLt to Find Min/Max Times

Detecting Issues

Posted on March 1, 2017 by way0utwest

Here’s a simple question: how are more of your application issues detected, by people or systems? I bet most of you initially think of your monitoring systems and the automated messages or pages that are sent out regularly as detecting most, … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Detecting Issues