Nick Duckstein


Enforcing Referential integrity in Microsoft SQL Server 2000

Referential Ingegrity is a critical part of any well designed RDBMS application, not just a part of Oracle, DB2, or some other platform. SQL Server has tools to make it easy, but a developer has to take the time to ensure that it is setup correctly, and ignorance is no excuse. New author Nick Duckstein brings us a look at basic RI and how you can set this up in your database.

5 (2)

2005-01-17

13,760 reads

Blogs

Daily Coping 17 Sep 2021

By

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

Ethics in Modern Data at Music City Tech 2021

By

  On Sept 16, Christine and I presented our joint presentation on Ethics in Modern Data at...

Slides and Video from Building a Regret-free Foundation for your Data Factory Now Available

By

Last week, Kerry and I delivered a webinar with tips on how to set...

Read the latest Blogs

Forums

SQL 2016 SP3 CHECKDB WITH EXTENDED_LOGICAL_CHECKS problem.

By Ken McKelvey

This seems to be the same problem which occurred with SQL2017 CU21 and is...

Find all SPs, FNs, and VWs where particular string occurs

By Vladimir Isaev

I have this task to find all SPs, FNs, and VWs where particular string...

Excel privary levels

By V

There are three Excel privacy levels: Private, Organizational, Public. When Excel's privacy level is...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers