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,261 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

Azure Platform Series: How to setup Azure Cloud Shell

By

This blog post will be a series on the Azure Platform and some things...

Daily Coping 5 June 2020

By

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

Use Chocolatey to Install Multiple SQL Server 2019 Instances for Testing

By

I’m working on a project where it’s useful to automate environment setup and teardown...

Read the latest Blogs

Forums

How to generating Excel File with multi sheet by using SQL server 2012?

By ahmed_elbarbary.2010

I need to create stored procedure or query or any thing on SQL server...

performance tuning for a subquery

By rohitkocharda

Hey Guys I have a quick questions regarding a better way to write a...

Maximum number of users that can simultaneously log in SQL 2016

By SQL_Hunt

Hello, By default, SQL Server allows a maximum of 32767 concurrent connections which is...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers