Joe Celko


Stairway to Database Design

Stairway to Database Design Level 1: Data Elements

Before you start to think about your database schema or tables, you need to consider your data: the type of data it is, the scale you use for values. It needs to be unique, precise and unambiguous. Then you need to name it in such a way that it can be generally understood. Joe Celko explains...

2019-03-26 (first published: )

38,082 reads

Stairway to Database Design

Stairway to Database Design Level 2: Domains, Constraints and Defaults

A clear understanding of SQL Data Types and domains is a fundamental requirement for the Database Developer, but it is not elementary. If you select the most appropriate data type, it can sidestep a variety of errors. Furthermore, if you then define the data domains as exactly as possible via constraints, you can catch a variety of those problems that would otherwise bedevil the work of the application programmer.

2019-03-26 (first published: )

27,420 reads

Blogs

Daily Coping 1 Dec 2022

By

Today’s coping tip is to discover your artistic side. Design a friendly greeting card....

New Database Job – The 6 Month Plan

By

So, we made it through our first 90 days, things start getting tougher now...

SQL Homework – December 2022 – What’s new in SQL Server?

By

SQL Server 2022 has been released! Long live SQL Server! No really, I’ve still...

Read the latest Blogs

Forums

Knowledgeable Information of Microsoft SQL server

By dorthakhan

Microsoft SQL Server is a relational database management system developed by Microsoft. As a...

Buy Best Reflective Writing Help By Top Experts

By carenawang

Are you searching for Reflective Writing Help? Get best Reflective Writing Help with top experts. The...

Replication Statistics

By coolchaitu

In Transactional Replication, create index and Alter index commands do not get replicated to...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers