Tag Archives: testing

tSQLt tests for Day 5 Advent of Code 2017

Posted on January 24, 2018 by

This is day 5 of the Advent of Code 2017. If you want to read about the puzzles, start with Day 1. As I worked through the puzzles, I decided that I should be testing using their test sets and … Continue reading →

Posted in Blog | Tagged , , ,

tSQLt Tests for Advent of Code 2017 Day 4

Posted on January 19, 2018 by

This is day 4 of the Advent of Code 2017. If you want to read about the puzzles, start with Day 1. As I worked through the puzzles, I decided that I should be testing using their test sets and … Continue reading →

Posted in Blog | Tagged , , ,

tsqlt Tests for Advent of Code 2017 Day 2

Posted on January 13, 2018 by

This is day 2 of the Advent of Code 2017. If you want to read about the puzzles, start with Day 1. As I worked through the puzzles, I decided that I should be testing using their test sets and … Continue reading →

Posted in Blog | Tagged , , ,

My Second Pester Test

Posted on December 7, 2017 by

I should write about my first one, but I just copied Rob’s test, so that’s not so exciting. Instead, I decided to take his advice and write some code, then decide how I test it. This isn’t really TDD, but … Continue reading →

Posted in Blog | Tagged , , , | 1 Comment

Testing a Birthday Month Query

Posted on December 4, 2017 by

I ran across a post from a tester, wondering  how to write a query for birthday months. This makes sense, as I’m sure some businesses want to notify or track customers that have birthdays this month and give them something. … Continue reading →

Posted in Blog | Tagged , ,

A Christmas Bug

Posted on December 4, 2017 by

It’s not really a big deal for me, despite the fact that I travel to Europe in a few days for two weeks. At least, I’m fairly confident this won’t be an issue for me. A few of my fellow #sqlfamily might … Continue reading →

Posted in Editorial | Tagged ,

Installing Pester

Posted on November 27, 2017 by

One of the things that I believe strongly in is that we need better testing of software. Actually, what we really need is better habits and understanding of how to test our software. I don’t think we need to test … Continue reading →

Posted in Blog | Tagged , , | 2 Comments

Unit Testing T-SQL Code

Posted on October 18, 2017 by

Abstract Unit testing has become an integrated, expected part of most software development teams. Many database developers have yet to implement unit testing as a regular habit. This session will look at two-unit testing frameworks and show how to implement … Continue reading →

Posted in Presentations | Tagged ,

SQL Grouping on Sums (with testing)

Posted on September 25, 2017 by

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 , , ,

Using tSQLt to Find Min/Max Times

Posted on March 13, 2017 by

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 , ,