Tag Archives: testing

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

Detecting Issues

Posted on March 1, 2017 by

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 ,

Writing the Correct Query is Important

Posted on January 16, 2017 by

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

Where’s the Unit Testing?

Posted on July 25, 2016 by

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

Quick Tests for a Function

Posted on June 2, 2016 by

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

What’s Your Test Plan?

Posted on May 20, 2016 by

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

Testing T-SQL Made Easy

Posted on May 12, 2016 by

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

Quick Tests–Function Returns

Posted on February 15, 2016 by

I ran across a neat piece of code recently from Gail Shaw. She answered a question on returning the base path from a path in a string. Meaning if I had this string: c:\Users\Sjones\Documents\text.txt I’d want to return this: c:\Users\Sjones\Documents … Continue reading →

Posted in Blog | Tagged , , ,

Do You Have Scary Code?

Posted on November 10, 2015 by

I once worked in a company that had a VB6 application (this was a long time ago), which had been mainly written by three developers working at the company. Two of them left, but we still have one of the … Continue reading →

Posted in Editorial | Tagged ,

Using Automated Tests to Raise Code Quality

Posted on November 2, 2015 by

Abstract Agile development practices can speed the development of applications and increase the rate at which you can deploy features for your customers. But unless you include a high level of test coverage in your code, these practices can also … Continue reading →

Posted in Blog, Presentations | Tagged , , , ,