There are several frameworks for assisting with the testing of SQL Server databases, but tSQLt is popular because it is written in TSQL and is simple for a database developer to set up and use. It doesn't get in the way. Rob Sheldon shows you how to get started.  Read more...

It is more and more essential for developers to work on development databases that have realistic data in both type and quantity, but without using real data. It isn't exactly easy, even with third-party tools to hand. Phil Factor shows how it can be done, taking the classic PUBS database and giving it a more realistic set of data.  Read more...

With database applications, the process of test and integration can be frustratingly slow because so much of it is based on manual processes. Everyone seems to agree that automation of the process provides the answer to accomodating shorter development cycles, but how, exactly? Dave Green describes a successful process that integrates third-party tools.  Read more...

Writing maintainable code is hard. It must be understandable, testable and readable. Any one of these can be tricky, and together they seem pretty daunting. Thankfully, Michael Williamson makes it look easy to become a code craftsman.  Read more...

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  Read more...

Andy Leonard continues on with his series on TDD. This time he performs some refactoring on his solution.  Read more...

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.  Read more...

It seems that many companies don't have the luxury of working with a variety of hardware configurations to test their architecture before deploying their applications. Some of the issues involve time and some involve tools. Steve Jones has an idea that could help with the latter today.  Read more...

It seems that many companies don't have the luxury of working with a variety of hardware configurations to test their architecture before deploying their applications. Some of the issues involve time and some involve tools. Steve Jones has an idea that could help with the latter today.  Read more...

It seems that many companies don't have the luxury of working with a variety of hardware configurations to test their architecture before deploying their applications. Some of the issues involve time and some involve tools. Steve Jones has an idea that could help with the latter today.  Read more...

It seems that many companies don't have the luxury of working with a variety of hardware configurations to test their architecture before deploying their applications. Some of the issues involve time and some involve tools. Steve Jones has an idea that could help with the latter today.  Read more...

Testing our applications is important, but at what level do we need to test? Steve Jones talks about unit testing today, and wonders if this is prevalent for SQL Server developers.  Read more...

In this article sponsored by Red Gate, read about a beta tester's experience with new versions of SQL tools.  Read more...

Andy Leonard continues on with his series on TDD. This time he performs some refactoring on his solution.  Read more...

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.  Read more...

This article talks about an easy way to add hundreds of unit tests in your solution using SQL Load Test from Codeplex.  Read more...

Testing software is important, and the use of state models can help. This week Steve Jones talks about a new book that exposes software testing at Microsoft.  Read more...

Testing software is important, and the use of state models can help. This week Steve Jones talks about a new book that exposes software testing at Microsoft.  Read more...

Testing software is important, and the use of state models can help. This week Steve Jones talks about a new book that exposes software testing at Microsoft.  Read more...

Testing software is important, and the use of state models can help. This week Steve Jones talks about a new book that exposes software testing at Microsoft.  Read more...