Tag Archives: tsqlt

Testing T-SQL Made Easy

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

Quick Tests–Function Returns

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 , , , | Comments Off on Quick Tests–Function Returns

Webinar: Unit Testing with SQL Server and tSQLt

I ran into Sebastian Meine at the PASS Summit a few weeks ago and we were talking testing. Sebastian is the founder and developer of tSQLt, which I really like using. We’ve done some teaching together and I’ve delivered a … Continue reading

Posted in Blog | Tagged , , , | 3 Comments

Using Automated Tests to Raise Code Quality

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 , , , , | Comments Off on Using Automated Tests to Raise Code Quality