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,539 reads
Developing a database can be an trying experience, and it's ways good to see how someone else builds a design. In this new article, MVP Andy Leonard shows us how to build a database using test-driven development for a weather database.
2010-10-29 (first published: 2009-04-30)
27,778 reads
By James-Serra
The Microsoft Power Platform consists of three products: Power BI, PowerApps, and Microsoft Flow....
It’s time for a little bit of change to occur. I am no longer...
Data professionals around the globe are frequently finding themselves occupied with figuring out why...
Hi, We have 3 people that answer the phones to help our customer with...
I appreciate it is a trifling question and yet. One of our sites organises...
Hi All, We have SQL Server instance running on a VM. Now we wanted...
Ask SSC