Tag Archives: testing

Where’s the Unit Testing?

Posted on July 25, 2016 by way0utwest

I’ve been a proponent of Unit Testing, especially for databases. I’ve given presentations on the topic and advocate the use of techniques to verify your code works, especially over time when the complexity grows, new developers change code, and potentially … Continue reading →

Posted in Editorial | Tagged , , | Comments Off on Where’s the Unit Testing?

Quick Tests for a Function

Posted on June 2, 2016 by way0utwest

I was writing a poorly performing UDF the other day and then wanted to replace it with a better performing one. However, I wanted to be sure that the function was the acting the same externally. In other words, does … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Quick Tests for a Function

What’s Your Test Plan?

Posted on May 20, 2016 by way0utwest

I ran across a post on upgrading a SQL Server instance, where the original poster (OP) was asking about a document to upgrade from SQL Server 2008 to 2014. That’s a big ask, especially as not many documents tend to … Continue reading →

Posted in Editorial | Tagged , , | Comments Off on What’s Your Test Plan?

Testing T-SQL Made Easy

Posted on May 12, 2016 by way0utwest

Abstract: Everyone tests that code, but most people run a query, execute a procedure and run another query. This ad hoc, non-repeatable testing isn’t reliable, and encourages regression bugs. In this session you will learn how to begin introducing testing … Continue reading →

Posted in Presentations | Tagged , , | Comments Off on Testing T-SQL Made Easy