Advanced

SQLServerCentral Article

Foreign Keys

  • Article

Foreign keys are an important part of a relational database. New author Ravi Lobo takes a look at foreign keys from the perspective of a new DBA with some scripts to help you ensure your database is setup correctly.

4.6 (5)

You rated this post out of 5. Change rating

2006-05-31

19,688 reads

Technical Article

Healthcare Data Models Matter

  • Article

Healthcare applications come and go, but data live on forever. We’ve seen that since the beginning of the computer industry; when we move from legacy systems into more “modern” architectures, we often leave behind applications, but we almost always take along the data into the future. Even though data are so important, we in health-IT don’t seem to spend the quality time necessary to structure our schemas and databases in such a way as to make it easier to maintain in the future. We often don’t design our data models solidly, and we don’t test them well by putting them through simulations or design them for multiple versions.

2006-03-27

2,502 reads

Blogs

SQL Prompt Quick Access to Helper Code

By

We’ve been doing some events as part of the Redgate Roadshow, and at one...

Eleven chapters of my data architecture book are available

By

As I have mentioned in prior blog posts, I have been writing a data...

Speaking at SQL Saturday Boston 2023

By

I’m happy to announce that I will be speaking at SQL Saturday Boston on...

Read the latest Blogs

Forums

Works on all other sql2022 servers but not on production. - must be dropped

By krypto69

HI We have a small utility that is giving us a "#table is missing...

Convert common Separated number to # table

By ralahari

@reportParameter 1008,1009,1011,1014 values need to insert to #Table Note: @reportParameter is not returning values...

Things to be considered before implementing database auditing

By vsamantha35

Hi All, As part of security compliance, we are told to audit DML &...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers