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
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