SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Database Design Rss

   Items 1 to 20 of 331    Older >>
 

How Perfect Should Our Software Be?

Steve talks about the level of engineering effort we need in software development.  Read more...
By Steve Jones 2019/02/19 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 46 reads

Stairway to Data, Level 1: The Basics

A great deal of the confusion that occurs when a database application is developed comes from a poor understanding of the basics of data. Here, Joe Celko gives a broad coverage of the difficulties you're likely to meet when handling data in databases  Read more...
By Joe Celko 2019/02/06 (first published: 2011/05/12) | Source: SQLServerCentral.com | Category: database design
Rating: |  Discuss |   Briefcase | 18,595 reads

Date Dimension Script

T-SQL script that creates Date_Dim & populates it for any date-range.  Read more...
By Dave Bunch 2018/12/27 | Source: SQLServerCentral.com | Category: data warehousing
Rating: |  Discuss |   Briefcase | 1,124 reads

Primary keys for an OLTP database

OLTP database performance with different clustered indexes.  Read more...
By Evgeny Garaev 2018/12/27 | Source: SQLServerCentral.com | Category: database design
Rating: |  Discuss |   Briefcase | 851 reads

Check your default constraints

Default constraints can lead to assumptions about the values in a column. Combine a check constraint to avoid slip ups.  Read more...
By Andy Robertson 2018/09/17 | Source: SQLServerCentral.com | Category: default constraint
Rating: |  Discuss |   Briefcase | 701 reads

Index on a computed column

By Evgeny Garaev 2018/09/06 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 865 reads

The Master of the Schema

Go database first, not code first.  Read more...
By Steve Jones 2018/08/14 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 70 reads

Who Likes NULL?

The use of NULL values in a database can be controversial. Today Steve talks about his views on this concept.  Read more...
By Steve Jones 2018/07/06 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 121 reads

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,420 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,733 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,771 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,439 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,308 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,710 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,650 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,671 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 | 129 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 | 184 reads

Date Dimension Script

T-SQL script that creates Date_Dim & populates it for any date-range.  Read more...
By Dave Bunch 2018/12/27 | Source: SQLServerCentral.com | Category: data warehousing
Rating: |  Discuss |   Briefcase | 1,124 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 | 79 reads
   Items 1 to 20 of 331    Older >>
 
Tags
advanced (53)    
miscellaneous (47)    
basics (29)    
t-sql (21)    
strategies (19)    
administration (18)    
sql server 7 (18)    
programming (16)    
naming standards (13)    
stairway series (13)    
datatypes (12)    
editorial (11)    
performance tuning (11)    
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 constraint (1)    
check constraints (1)    
continuin (1)    
customer service (1)    
database development (1)    
database performance (1)    
data-modeling (1)    
default constraint (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 (extract transform and load) (1)    
foreign keys (1)    
getdate (1)    
getutcdate (1)    
guid (1)    
guids (1)    
humor (1)    
identity (1)    
installation (1)    
joe celko (1)    
logging (1)    
modeling (1)    
name value pair (1)    
names (1)    
naming (1)    
natural key (1)    
newid() (1)    
newsequentialid() (1)    
nhibernate (1)    
not null (1)    
orm (1)    
partition (1)    
performance (1)    
primary key (1)    
product reviews (1)    
queues (1)    
rants (1)    
referential integrity (1)    
relational (1)    
resilience (1)    
row compression (1)    
scalability (1)    
schemas (1)    
software development (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)