Testing

External Article

SQL Server Unit Testing with tSQLt

  • Article

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

SQLServerCentral Article

An Example of Test-Driven Development

  • Article

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.

3.66 (80)

You rated this post out of 5. Change rating

2010-10-29 (first published: )

28,202 reads

External Article

Close these Loopholes - Reproduce Database Errors

  • Article

This is the final part of Alex's ground-breaking series on unit-testing Transact-SQL code. Here, he shows how you can test the way that your application handles database-related errors such as constraint-violations or deadlocks. With a properly-constructed test-harness you can ensure that the end-user need never see the apparent gobbledegook of database system error messages, and that they are properly and robustly handled by the application.

2008-06-12

3,334 reads

Blogs

Creating an Empty Repo in GitHub–#SQLNewBlogger

By

I saw someone struggling with getting started with a Visual Studio project and Azure...

Product Review: DataVeil

By

If you’re looking at data masking tools, I recently was able to review the...

The Last Price Bump for the Data Community Summit

By

This week the cost of the PASS Data Community Summit jumps up to full...

Read the latest Blogs

Forums

Calender Error in SSRS with SSAS Tabular Source

By RADISSOUFAN

I have a report which get a Date Parameter.. I don't want to display...

Calender Error in SSRS with SSAS Tabular Source

By RADISSOUFAN

I have a report which get a Date Parameter.. I don't want to display...

Best CI/CD or release process

By sqlenthu 89358

Hello my SQL friends, I want to know about few of the best approaches/methodologies/applications...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers