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.


3,334 reads


RMOUG Training Days in Denver


Next week I’m heading to the Lowry Conference Center in Denver for the RMOUG...

Daily Coping 7 Feb 2023


Today’s coping tip is to go to bed in good time and allow yourself...

Tales From The Field Weekly Wrap Up for the Week of 01-31-2023


 Hello Dear Reader!  After a weekend with a lot of activities, it was a...

Read the latest Blogs


What are the alternatives of S3 Object Lambda?

By kwalampur

Hi all! AWS has a good example of how to manipulate the requested objects...

SQL Script plug-in

By dmarino324

Is the SQL Script plug-in listed here no longer available? SQL Scripts in SSMS...

Modify RDS page missing the Storage Autoscaling option

By jecobdruv

Hi folks, I have a single Postgres instance on RDS that in the past...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers