Articles
Snippets
Documents
Useful Sites
SQL Server Articles
These articles have been written as a guide for database developers and administrators that are starting out with SQL Server. The articles are intended to serve as a quick reference and starting point but are not necessarily comprehensive. The articles are written for SQL Server 2000, 2005 and 2008 with any version differences indicated in the body of the article.
Management Trees:
A simplified example of the creation of a management tree using CTEs for SQL 2005 or SQL 2008.
Naming Conventions:
Naming conventions for use in your SQL Server environment.
SQL Server Snippets
These code snippets and samples are written for SQL Server 2000, 2005 and 2008 with any version differences indicated in the body of the code.
Date and Time:
A few snippets for converting date and time data.
Professional Development Documents
These documents are provided as a courtesy for Information Technology professionals. Please feel free to use, edit or re-circulate as desired.
The documents themselves are based upon the "Employee Phone Book", a system being used by a fictional company for the purposes of illustrating the concepts required.
Design Specification:
A sample design specification document containing all the important data points. This document is in PowerPoint 2007 format.
Release to Production:
A sample document for tracking the Release to Production process. This document is in PowerPoint 2007 format.