Paladin Consultants, LLC

"Good Information is just good business"

JA slide show
Home Resources Links And Tools
Print E-mail

Articles on Database Design


Two articles on database design Database Design and Technical Complexities of Database Design

There is some useful information at StoredProcedure.com with links and articles on client server technology and access to information.

A guide and tutorial on the Rules of Data Modelling and Normalization

Dr. E.F. Codd's 12 Rules for defining a fully relational database.

 

Articles and Links on SQL Language and SQL Server


Article on User-Defined Functions.

Article and code on creating and maintaining User-Defined Functions.

Article and code on the Rozenshtein Method for making crosstabs in T-SQL.

Article and code on using Case expressions for making crosstabs in T-SQL.

Article and code on using dynamic crosstabs for making crosstabs in T-SQL.

Article and code on an improved dynamic crosstabs for making crosstabs in T-SQL.

Article and code on passing lists of parameters into stored procedures in T-SQL.

Article and code on obtaining parameters of stored procedures in T-SQL.

 

A Collection of our own acticles specifically on SQL Server:


SQL Server Programming Environment
SQL Server Indexes
SQL Server Index Optimization
SQL Server Index Performance
SQL Server Security
SQL Server Profiler
SQL Server Stored Procedures
SQL Server Stored Procedures Interface
SQL Server System Stored Procedures
SQL Server Triggers
SQL Server Transact SQL Tools
SQL Server 2000 Data Types
SQL Server Managing Data
SQL Server Data Transformation Services (DTS)
SQL Server Bulk Copy Program (BCP)
SQL Server Replication

Links


Here is the Career Networking database program we wrote for some associates who were laid off during the 2000-2001 downturn.
The file likes to be located in 'c:\jobsearch\' folder because of the many possible variations in the configuration of service packs on the user's computer.
It requires Microsoft Access 2000, or later to operate. It will automate the process of writing and keeping track of letters to prospective employers, as well as email. And it will help keep track of people you might meet during your job search. Download Here (ZIP FILE NOT LINKED YET)

 

 
Copyright © 2001 by Paladin Consultants,Inc.
Chatham, NJ
All Rights Reserved
This page revised   March 6, 2007
 
Bookmark and Share