Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Authors
About us
Contact us
Newsletters
Write for us
Daily SQL Articles by email:
Sign up
Content with tag
Database Design
Items 1 to 20 of 323
Older >>
Degree of Duplication
Technology is constantly moving forward, but it is also helpful to understand how we arrived where we are today. Joe Celko reminisces about the history of database design and how it relates to the concept of ‘Degree of Duplication’ in this article.
Read more...
By
Additional Articles
2018/02/22
|
Source:
SimpleTalk
|
Category:
database design
Rating:
(not yet rated)
Rate this
|
Briefcase
|
3,134 reads
Stairway to Database Design Level 9: Normalization
In the final step of Database Design, Joe Celko gives a simple but effective explanation of the normalization process and why it is important.
Read more...
By
Joe Celko
2018/02/21 (first published: 2011/11/11)
|
Source:
SQLServerCentral.com
|
Category:
stairway series
Rating:
|
Discuss
|
Briefcase
|
12,497 reads
Stairway to Database Design Level 7: Triggers
In levels one to four, we built the tables, base and virtual, of a schema. Levels five and six dealt with stored procedures. This level deals with a feature you need to avoid as much as possible; this is article is on Triggers.
Read more...
By
Joe Celko
2018/01/24 (first published: 2011/09/30)
|
Category:
stairway series
Rating:
|
Discuss
|
Briefcase
|
10,658 reads
Validation, Verification, and Modification
A proper database design is very important, and changes to fix problems after the fact are expensive. In this article, Joe Celko discusses three aspects of database design that are often overlooked: validation, verification, and modification.
Read more...
By
2018/01/23
|
Source:
SimpleTalk
|
Category:
database design
Rating:
(not yet rated)
Rate this
|
Briefcase
|
3,164 reads
Stairway to Database Design Level 5: Procedures
Joe Celko tackles the subject of the Stored Procedure and its place in database design. What he writes is food for thought, even for experienced database developers.
Read more...
By
Joe Celko
2017/10/25 (first published: 2010/08/25)
|
Source:
SQLServerCentral.com
|
Category:
stairway series
Rating:
|
Discuss
|
Briefcase
|
14,213 reads
The ABCs of Database Creation
Creating SQL Server databases is easier than the internet may lead us to believe.
Read more...
By
Brandie Tarvin
2017/08/11 (first published: 2015/10/29)
|
Source:
SQLServerCentral.com
|
Category:
database design
Rating:
|
Discuss
|
Briefcase
|
7,695 reads
Using Super Keys to Enforce Database Constraints
Example of Using Super Keys to Enforce Database Constraints, instead of procedural code
Read more...
By
Dejan Mladenovic
2017/08/07
|
Source:
SQLServerCentral.com
|
Category:
database design
Rating:
|
Discuss
|
Briefcase
|
1,642 reads
Stairway to T-SQL DML Level 3: Implementing a Relational Model in SQL Server
This level of the stairway details the creation of a relational database, as well as filling in some of the history of the relational database model.
Read more...
By
Gregory Larsen
2017/08/02 (first published: 2011/11/09)
|
Source:
SQLServerCentral.com
|
Category:
stairway series
Rating:
|
Discuss
|
Briefcase
|
13,497 reads
Learning Data Modeling
Today Steve Jones is looking for database design resources.
Read more...
By
Steve Jones
2017/07/07
|
Source:
SQLServerCentral.com
|
Category:
editorial
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
124 reads
A Database Design Test
Steve Jones saw a database design test for developers, but he's never been given one.
Read more...
By
Steve Jones
2017/06/30
|
Source:
SQLServerCentral.com
|
Category:
editorial
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
183 reads
Date Dimension Script
T-SQL script that creates Date_Dim & populates it for any date-range.
Read more...
By
Dave Bunch
2017/05/08
|
Source:
SQLServerCentral.com
|
Category:
data warehousing
Rating:
|
Discuss
|
Briefcase
|
653 reads
Does Log Data Belong in a Table or a File?
Today we have a guest editorial that asks how one might want to manage all those logging metrics produced by applications.
Read more...
By
Andy Warren
2016/09/06
|
Source:
SQLServerCentral.com
|
Category:
editorial
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
78 reads
Proper Storage and Handling of Personal Names
As database developers, we may need to rethink the way we store and handle personal names
Read more...
By
Tung
2016/08/04
|
Source:
SQLServerCentral.com
|
Category:
database design
Rating:
|
Discuss
|
Briefcase
|
1,985 reads
Have You Designed a Database from Scratch?
An interesting question from Steve Jones today, asking what is your experience with designing databases.
Read more...
By
Steve Jones
2016/06/24
|
Source:
SQLServerCentral.com
|
Category:
editorial
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
171 reads
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.
Read more...
By
Joe Celko
2016/06/01 (first published: 2010/05/04)
|
Source:
SQLServerCentral.com
|
Category:
database design
Rating:
|
Discuss
|
Briefcase
|
26,003 reads
Adding PK Exceptions to SQLCop Tests
In this piece, Steve Jones shows how you can enforce a requirement of a Primary Key (PK) with a unit test, but also allow exceptions where needed.
Read more...
By
Steve Jones
2016/05/12
|
Source:
SQLServerCentral.com
|
Category:
tsqlt
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
964 reads
Database Design Follies: NULL vs. NOT NULL
It sounds simple enough. Either your column will always have a value or it may not. Yet somehow such a seemingly simple decision can become a never-ending debate where database schema begins to resemble superstition and designing effective tables seems more contentious than you expected it to be.
Read more...
By
Edward Pollack
2016/02/26 (first published: 2014/10/30)
|
Source:
SQLServerCentral.com
|
Category:
null
Rating:
|
Discuss
|
Briefcase
|
17,466 reads
Design Errors : PK's with multiple columns on table with identity
Find Tables with identity, which should have PK with 1 column but have a PK which is clustered but has multiple columns.
Read more...
By
Doran Mackay
2015/11/24
|
Source:
SQLServerCentral.com
|
Category:
database design
Rating:
|
Discuss
|
Briefcase
|
916 reads
Design Errors : PK's with multiple columns on table with identity
Find Tables with identity, which should have PK with 1 column but have a PK with multiple columns or where the unique identity is contained in other indexes.
Read more...
By
Doran Mackay
2015/11/24
|
Source:
SQLServerCentral.com
|
Category:
database design
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
118 reads
The ABCs of Database Creation
Creating SQL Server databases is easier than the internet may lead us to believe.
Read more...
By
Brandie Tarvin
2017/08/11 (first published: 2015/10/29)
|
Source:
SQLServerCentral.com
|
Category:
database design
Rating:
|
Discuss
|
Briefcase
|
7,695 reads
Items 1 to 20 of 323
Older >>
Tags
advanced
(53)
miscellaneous
(47)
basics
(29)
strategies
(19)
t-sql
(19)
administration
(18)
sql server 7
(18)
programming
(16)
naming standards
(13)
stairway series
(13)
datatypes
(12)
performance tuning
(11)
editorial
(8)
indexing
(8)
normalization
(8)
security
(8)
configuring
(6)
data modeling
(6)
foreign keys (fk)
(6)
blogs
(4)
data warehousing
(4)
denormalization
(4)
best and worst practices
(3)
best practices
(3)
constraints
(3)
reviews
(3)
system development life cycle
(3)
visual basic 6
(3)
xml
(3)
ado
(2)
book reviews
(2)
career
(2)
certifications
(2)
development
(2)
friday poll
(2)
identity property
(2)
monitoring
(2)
multi-tenant
(2)
null
(2)
other
(2)
primary key (pk)
(2)
sql server 2005
(2)
stored procedures
(2)
surrogate keys
(2)
.net
(1)
advanced querying
(1)
auditing
(1)
check constraints
(1)
continuin
(1)
customer service
(1)
database development
(1)
database performance
(1)
data-modeling
(1)
dependencies
(1)
design and theory
(1)
dri
(1)
dynamic sql
(1)
editorial - ipod
(1)
editorial - mp3
(1)
editorial - wmv
(1)
effective dating
(1)
encryption
(1)
etl
(1)
foreign keys
(1)
guid
(1)
guids
(1)
humor
(1)
installation
(1)
joe celko
(1)
modeling
(1)
name value pair
(1)
names
(1)
naming
(1)
natural key
(1)
nhibernate
(1)
not null
(1)
orm
(1)
partition
(1)
performance
(1)
product reviews
(1)
queues
(1)
rants
(1)
referential integrity
(1)
relational
(1)
resilience
(1)
row compression
(1)
scalability
(1)
schemas
(1)
sql server
(1)
sql server 2012
(1)
sql server 2016
(1)
sql server 6.5
(1)
sql server data services
(1)
sql-dmo
(1)
ssds
(1)
storage
(1)
superkeys
(1)
testing
(1)
tips
(1)
tsqlt
(1)
udm
(1)
uniqueidentifier
(1)
use of constraints
(1)
views
(1)
webinar
(1)
worst practices
(1)
Copyright © 2002-2018 Redgate. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.