Tag Archives: testing

tSQLt in Azure SQL Database

I was excited to hear about the v12 Azure databases supporting CLR assemblies. Mainly because I’ve been doing testing work with tSQLt and wanted to run tests in an Azure database. I upgraded a SQL Azure database to v12 and … Continue reading

Posted in Blog | Tagged , , , | 2 Comments

Unit Testing in Philadelphia

I’m helping teach a pre-conference session on Friday, June 5, 2015 at the Microsoft office in Philadelphia. This is an all day, paid for event, that looks at how you can use a framework to write unit tests for your … Continue reading

Posted in Blog | Tagged , , , , | Comments Off on Unit Testing in Philadelphia

Refactoring Mistakes Are Why We Write Tests

I wrote a short piece the other day trying to show how one can use tSQLt to test code. It’s a simple test built against a user defined function. It works well and when the test is run, it passes. … Continue reading

Posted in Blog | Tagged , , , | Comments Off on Refactoring Mistakes Are Why We Write Tests

Why Test Table MetaData Tests with tSQLt

I wrote at SQLServerCentral about using tSQLt to check table metadata. In essence we are testing the API of our table. However, since the table could change, and may need to, what’s the value of having a test fail if … Continue reading

Posted in Blog | Tagged , , , | Comments Off on Why Test Table MetaData Tests with tSQLt