External Article

State Transition Constraints

  • Article

Data Validation in a database is a lot more complex than seeing if a string parameter really is an integer. A commercial world is full of complex rules for sequences of procedures, of fixed or variable lifespans, Warranties, commercial offers and bids. All this requires considerable subtlety to prevent bad data getting in, and if it does, locating and fixing the problem. Joe Celko shows how useful a State transition graph can be, and how essential it can become with the time aspect added.


1,942 reads


A Live Conference Experience at Data Minds Connect 2021


Last week I was privileged to attend a live conference in Belgium. dataMinds Connect...

Daily Coping 25 Oct 2021


I started to add a daily coping tip to the SQLServerCentral newsletter and to...

A New Form of Address: Mx


When I was presenting at the dataMinds Connect conference, I called on someone in...

Read the latest Blogs


cannot generate SSPI context

By premkuttan

We have one user who face this issue while connecting to SQL server ''Cannot...

Database Corruption - LOB

By database diva

Hello, I have recently inherited a SQL 2012 database (no backups available), running in...

Cannot connect to Existing Replica

By Arsh

Dear Friends, I setup a test run case on 2-Node AlwaysON , on developer...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

A Simple Error

See possible answers