Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Miscellaneous, Database Design Rss

   Items 1 to 20 of 53    Older >>
 

Worst Practices - Not Using Primary Keys and Clustered Indexes

Two weeks ago Andy started his wildly successful series on Worst Practices. This week he continues that series discussing why failing to use primary keys and clustered indexes are worst practices. Agree or disagree, read the article and join the discussion. One thing you'll have to admit, reading an article by Andy is a lot more interesting than reading Books Online!   Read more...
By Andy Warren 2008/05/09 (first published: 2003/11/10) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 65,871 reads

Is XML the Answer?

New Author! Don Peterson writes his first article for us and explores why he considers XML to be...bad! There are some interesting points made here and if you've haven't thought about what XML means to you as a DBA, it's a subject worth spending some time on.   Read more...
By Don Peterson 2008/05/02 (first published: 2003/10/07) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 64,213 reads

A Common Architecture for Loading Data

Importing data files is always a challenge for a DBA, especially when the files might vary in format. Having one codebase is important and new author Mark Balasundram brings us the template for a high performance application to do just that.   Read more...
By Mark Balasundram 2007/04/04 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 17,011 reads

Document Your Database

Computer professionals are constantly complaining about the documentation for the software they use. And are notorious for not documenting their own code very well. Longtime author Raj Vasant brings us a short article with some suggestions on how to go about documenting your databases.   Read more...
By Vasant Raj 2007/01/11 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 13,699 reads

The Socialization of Knowledge

This article is an excerpt from the forthcoming book, Business Metadata, to be published on or about September, 2007, co-authored by Bill Inmon, Bonnie O’Neil and Lowell Fryman, published by Morgan Kaufman.  Read more...
By Additional Articles 2007/09/25 | Source: TDAN | Category: miscellaneous
Rating: (not yet rated)  Rate this |   Briefcase | 1,674 reads

Enums in SQL Server

SQL Server MVP Simon Sabin brings us a very interesting article on a possibilltyfor using enumerated values instead of integer or other coded foreign keys. It is an interesting idea that could go a long way towards making code easier to read.   Read more...
By Simon Sabin 2007/08/28 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 8,682 reads

SqlCredit - Part 5: Adding Card, Vendor, and Purchase, Plus Much Refac

As I built out the last pieces of the original table set (Card, Vendor, and Purchase), I found a number of pieces that needed to be fixed in the design.   Read more...
By Additional Articles 2007/06/19 | Source: Database Journal | Category: miscellaneous
Rating:  Rate this |   Briefcase | 1,292 reads

SqlCredit - Part 4: Schema and Procedure Security

In this month’s installment, we will add security to the existing code and add new unit tests to prove that security.  Read more...
By Additional Articles 2007/06/15 | Source: Database Journal | Category: miscellaneous
Rating:  Rate this |   Briefcase | 2,210 reads

SqlCredit - Part 3: Schema/Proc Updates and Automated Unit Testing

In this month’s installment, we will discuss updates based on feedback from part 2 as well as introduce automated unit testing.  Read more...
By Additional Articles 2007/06/14 | Source: Database Journal | Category: miscellaneous
Rating:  Rate this |   Briefcase | 2,168 reads

SqlCredit - Part 2: Creating the Database, Tables, CRUD Procedures

Continuing with this series on building a database system  Read more...
By Additional Articles 2007/06/13 | Source: Database Journal | Category: miscellaneous
Rating:  Rate this |   Briefcase | 3,468 reads

Part 1: Introduction, Business Problem, and Initial Design

The purpose of the SqlCredit series is to demonstrate the database design and development portion of a development project. We will build a complete, functioning, tested credit card database to illustrate the complete software development lifecycle.  Read more...
By Additional Articles 2007/06/12 | Source: Database Journal | Category: miscellaneous
Rating:  Rate this |   Briefcase | 2,899 reads

Delivering on SQL Server

Having been at the sharp end of many successful SQL Server solutions, I believe there are some fundamental principles that all successful SQL Server installations have in common. Whilst the challenges in delivering an enterprise-scale database-intensive application can be wide and varied, there are a few basic practises that will give you the best possible chance of success.  Read more...
By Additional Articles 2007/04/05 | Source: Other | Category: miscellaneous
Rating:  Rate this |   Briefcase | 2,229 reads

A Common Architecture for Loading Data

Importing data files is always a challenge for a DBA, especially when the files might vary in format. Having one codebase is important and new author Mark Balasundram brings us the template for a high performance application to do just that.   Read more...
By Mark Balasundram 2007/04/04 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 17,011 reads

Document Your Database

Computer professionals are constantly complaining about the documentation for the software they use. And are notorious for not documenting their own code very well. Longtime author Raj Vasant brings us a short article with some suggestions on how to go about documenting your databases.   Read more...
By Vasant Raj 2007/01/11 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 13,699 reads

Physical Database Storage

This article provides a guide for physical storage design and gives recommendations and trade-offs for physical hardware design and file architecture.  Read more...
By Additional Articles 2006/06/29 | Source: MSDN Communities | Category: miscellaneous
Rating:  Rate this |   Briefcase | 3,541 reads

Dual Processor vs Dual Core

Will multiple processors or a dual core processor be beneficial to you, and what are the differences between them? These are the questions this article will attempt to lay to rest.  Read more...
By Additional Articles 2006/04/04 | Source: Other | Category: miscellaneous
Rating:  Rate this |   Briefcase | 5,605 reads

A Call to Arms

Long anticipated, the arrival of radically restructured database architectures is now finally at hand.   Read more...
By Additional Articles 2005/09/26 | Source: Other | Category: miscellaneous
Rating:  Rate this |   Briefcase | 3,821 reads

SOA, Multi-Tier Architectures and Logic in the Database

Programmers, webmasters, Web services developers and database administrators (DBAs) are not strangers to the "Can we have it tomorrow?" request. That's why software and web developers have embraced a continuous stream of silver bullet technologies that promised to accelerate development. The developer community has experienced "web time", object-oriented programming (OOP), rapid application development (RAD), "extreme programming" and "agile development". Accelerated development schedules put a premium on understanding architecture and knowing how to match the tools to the job. That means understanding today's model of applications as services and what role a database can play. If you understand SQL technology, for example, you can adapt databases to application and service requirements by embedding logic in a database.   Read more...
By Additional Articles 2005/07/27 | Source: Other | Category: miscellaneous
Rating:  Rate this |   Briefcase | 2,486 reads

Just SQL Part I

How many of you have asked yourself what SQL is all about anyway? Join me as I begin a venture down the road of understanding SQL and how to take advantage of this language.  Read more...
By Additional Articles 2005/07/22 | Source: Database Journal | Category: miscellaneous
Rating:  Rate this |   Briefcase | 3,215 reads

Worst Practices - Not Using Primary Keys and Clustered Indexes

Two weeks ago Andy started his wildly successful series on Worst Practices. This week he continues that series discussing why failing to use primary keys and clustered indexes are worst practices. Agree or disagree, read the article and join the discussion. One thing you'll have to admit, reading an article by Andy is a lot more interesting than reading Books Online!   Read more...
By Andy Warren 2008/05/09 (first published: 2003/11/10) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 65,871 reads
   Items 1 to 20 of 53    Older >>
 
Tags
programming (14)    
strategies (9)    
sql server 7 (8)    
t-sql (7)    
administration (6)    
basics (4)    
configuring (4)    
visual basic 6 (3)    
advanced (2)    
best and worst practices (2)    
book reviews (2)    
career (2)    
certifications (2)    
data warehousing (2)    
monitoring (2)    
naming standards (2)    
reviews (2)    
stored procedures (2)    
ado (1)    
best practices (1)    
data types (1)    
indexing (1)    
installation (1)    
performance tuning (1)    
sql-dmo (1)    
worst practices (1)    
xml (1)