Advanced

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)

2006-05-31

19,392 reads

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

Data Saturday #8–Southwest US

By

I am very excited to announce that I will be speaking for Data Saturday...

Data Weekender v3.1

By

I am super excited about this new version of Data Weekender, coming up on...

Thanks Kathi and Mala

By

I have to thank Kathi and Mala for putting on the WIT Mental Health...

Read the latest Blogs

Forums

Checking Up on Vendors

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Checking Up on Vendors, which...

Upgrade 2014 Web Edition to Standard

By @SQLNumpty

Hello. I'm working with a client who currently has a SQL 2014 Web Instance...

Package failing but the table is already there and the system says its missing!!

By hurricaneDBA

Dear Everyone Im using SSIS 2019 and VS 2019 The data scientist gave me...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers