Jeff Reinhard


A Pattern for Email Address storage and retrieval

Email addresses are very prevalent in IT systems and often used as a natural primary key. The repetitive storage of email addresses in multiple tables is a bad design choice. Following is a design pattern to store email addresses in a single table and to retrieve them efficiently.

4.39 (33)

2017-09-15 (first published: )

7,791 reads

Blogs

Architect a disaster recovery for SQL Server on AWS: Part 1

By

  New blog post - Architect a disaster recovery for SQL Server on AWS: Part...

Seamlessly migrate large SQL databases using AWS Snowball and AWS DataSync.

By

New blog post - Seamlessly migrate large SQL databases using AWS Snowball and AWS...

Daily Coping 3 Aug 2021

By

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

Read the latest Blogs

Forums

FOR JSON command adding carriage return to output

By fxferguson

I'm pretty new a creating JSON output form SQL server. I'm having trouble with...

Create a delta from downloaded info

By Bruin

I'm looking for some suggestions on how to create a delta file that will...

Last Time Stored Procedure Ran ?

By homebrew01

Hi, I've found several examples using dm_exec_procedure_stats but the results are only useful  as...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers