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

Blogs

Adding a Check Constraint to a Table–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Azure SQL Database Elasticity – Presentation Notes

By

This blog covers the content and points to the code used to create the...

How To: Create Schema Only Database Copies

By

Have you ever been asked to make a schema only copy of a database?...

Read the latest Blogs

Forums

Slicing a String in Python

By BTylerWhite

Comments posted to this topic are about the item Slicing a String in Python

SSRS 2016 giving 500 error

By PJ_SQL

Hello! I am getting this intermittent issue when browsing the report, this error goes...

Alwayson Availbility group extended to Azure?..

By alexsunny123

Hello, Can databases on-Premise  Alwayson Availability group of SQL server 2017 failover to Microsoft Azure...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers