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)

2006-05-31

19,539 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

Daily Coping 19 May 2022

By

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

Running dynamic SQL in a different database

By

This is one of those things that on hindsight was a stupid problem, but...

VMware & SQL Server 823-824 alerts

By

We’ve been tracking a weird state with SQL Server virtual machines on VMware and...

Read the latest Blogs

Forums

Failed to build the OLAP cubes

By ramana3327

Hi, We installed default standalone SSAS in tabulator mode (SQL 2017 license). When they...

Exporting the Database Encryption Key

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Exporting the Database Encryption Key

SQL Duplicate remove Query

By rocky_498

Hi Guys, I want to remove duplicates from the table. The duplicate is a...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers