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

Blogs

Data Masker Reads Column Classificiations

By

One of the newer features in Data Masker for SQL Server is the ability...

Upgrading SQL Server 2017 Containers to 2019 non-root Containers with Data Volumes – Another Method

By

Yesterday in this post I described a method to correct permissions when upgrading a...

Power Platform Quick Tips – Episode 02: Dynamic Power Apps Form Headers

By

Welcome back to my Power Platform Quick Tips series! In this second episode we...

Read the latest Blogs

Forums

Numeric and Decimal

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Numeric and Decimal, which is...

Verify your SQL Server database backups

By Steve Rezhener

Comments posted to this topic are about the item Verify your SQL Server database...

error trying to create another log file

By Snargables

For some reason I'm unable to create another log file. Ideas? ALTER DATABASE [DBNAME]...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

The CTE Insert

See possible answers