Tag Archives: testing

Writing the Correct Query is Important

Posted on January 16, 2017 by way0utwest

There’s a saying in the data world: garbage in, garbage out. We use that when we can’t get good information from our database because the data we’ve stored isn’t as useful as we would like. That’s a problem, and it’s … Continue reading →

Posted in Editorial | Tagged , , | Comments Off on Writing the Correct Query is Important

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?