Phil Factor reviews the various types of database test that need to run during development work, what sort of test data they require, and the challenges with managing this data, and in keeping the test cell stocked with the correct database, and data, in a way that allows rapid cycles of database testing.
2019-07-18
Phil Factor reviews the various types of database test that need to run during development work, what sort of test data they require, and the challenges with managing this data, and in keeping the test cell stocked with the correct database, and data, in a way that allows rapid cycles of database testing.
2019-05-20
Phil Factor reviews the various types of database test that need to run during development work, what sort of test data they require, and the challenges with managing this data, and in keeping the test cell stocked with the correct database, and data, in a way that allows rapid cycles of database testing.
2019-05-14
Slow, unreliable tests prevent teams doing great work, and make continuous delivery impossible. So what can you do to improve your automated tests?
2017-07-17
3,128 reads
There aren't many frameworks for writing acceptance tests for databases, including SQL Server. FitNesse is an obvious choice since it is designed with a Wiki-style interface that, once it is configured and set up correctly, makes it very easy for a non-specialist to set up individual tests.
2014-11-10
5,527 reads
Releasing a product without testing it is generally accepted as an unforgivable sin in the software development world. And frankly, there really isn’t an excuse not to test when we have whole suites of testing tools available to us
2014-09-03
8,387 reads
Matthew Flatt was trying to measure the performance of a tool interacting with Microsoft Azure, and had trouble getting a consistent test. His solution? Run the tests on VMs in Azure, housed in the same data center as the blob storage.
2014-06-18
2,717 reads
When one considers the amount of time and effort that Unit Testing consumes for the Database Developer, is surprising how few good SQL Server Test frameworks are around. tSQLt , which is open source and free to use, is one of the frameworks that provide a simple way to populate a table with test data as part of the unit test, and check the results with what should be expected. Sebastian Meine and Dennis Lloyd, who created tSQLt, explain
2011-01-19
3,084 reads
In this article sponsored by Red Gate, read about a beta tester's experience with new versions of SQL tools.
2009-07-16
1,595 reads
Andy Leonard continues on with his series on TDD. This time he performs some refactoring on his solution.
2010-11-12 (first published: 2009-07-13)
10,545 reads
Query tuning is not easy. In fact, for a lot of people, you shouldn’t...
This year I’ve been nominated again for the Author of the Year award at...
I know, I know, I’m on #teamexevents so I think that Extended Events can...
I tried many different ways and built a function to basically go character by...
I dont use share point regularly so this could be easy but struggling to...
My report is based on a stored procedure and the columns are outputted to...
Ask SSC