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,229 reads

Discuss

Blogs

Using Prompt AI for a Travel Data Analysis

I was looking back at my year and decided to see if SQL Prompt...

FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency

By Ige Adetokunbo Temitayo

In the era of cloud-native applications, Kubernetes has become the default standard platform for...

2025 Wrapped for Steve

I’ve often done some analysis of my year in different ways. Last year I...

Read the latest Blogs

Forums

reaching ftp thru winscp but erroring in ssis ftp task connection

Hi, below i show various results trying to reach our ftp site (a globalscape...

Finding Motivation

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Finding Motivation

The Last Binary Value of the Year

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Last Binary Value of...

Visit the forum

Question of the Day

The Last Binary Value of the Year

What does this code return?

SELECT cast(0x2025 AS NVARCHAR(20))

Image 1:

Image 2:

Image 3:

Image 4:

See possible answers