David Sumlin

David Sumlin has run his own contracting business for the last 6 years and has been involved in SQL development for the last 8 years. He and his team of skilled developers have tried to stay up to date with Microsoft development technologies when it comes to SQL and .net. For the last few years, HeadWorks Inc. has been focused on data warehouses and marts and the reporting applications that interact with them for large financial institutions. When David isn't coding, he's out looking for birdies!

A Lookup Strategy Defined

by David Sumlin

SQLServerCentral.com

Basics

Most databases designs nowadays seem to have at least a few if not many lookup or reference tables. This article helps you define a strategy in how to design, approve, and deploy them.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

Log in or register to rate

You rated this post out of 5. Change rating

2003-02-20

13,239 reads

Discuss

Blogs

Using CAT for Testing of Data Agents

By Joyful-Craftsmen

In last months one of the scenarios where you can use AI has been...

Are you getting value from your reporting?

By ChrisJenkins

Do you spend so long manipulating your data into something vaguely useful that you...

The Book of Redgate: SQL Server Central

It was neat to stumble on this in the book, a piece by me,...

Read the latest Blogs

Forums

Foreach Loop still executes after process and delete all the folders

I have two challenges XML source control not displaying the XML file parent node...

Which 'Where' statement conditional upon a variable

Thanks in advance for any clues on this. I am trying to write a...

Backup to Immutable Storage

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Backup to Immutable Storage

Visit the forum

Question of the Day

Backup to Immutable Storage

In SQL Server 2025, a backup can be made on Azure Immutable Storage. What changes in how the backup is created?

See possible answers