2261 & 2262 Supporting Windows XP

Useful links and articles for 2261 and 2262.

Windows XP Resource Kit

Useful knowledge base articles

Use Excel's Median function in Access

2072 - SQL Administration

Below are some useful links to supplement the course 2072 - SQL Server 2000 Administration:

SQL Server Administration Tips

SQL Server Performance

SQL Junkies

SQL Server Central

SQL Team

Migrating Access Databases to SQL Server

SQL Server Security

How to prevent the transaction log from growing unexpectedly

Track SQL Server file growth

SQL Server DTS

TSQL or GUI for SQL DBAs?

SQL Server Articles

General Microsoft SQL Server articles, tips and links:

Stored Procedure to find all instances of a field

What's best for DBA's? GUI or T-SQL commands?

Which tool should I use: Enterprise Manager or Query Analyzer?

What is XML?

How to configure Reporting Services log file reports

2073 Links

Below are some useful links to supplement the course 2073 - Programming a Microsoft SQL Server 2000 Database:

Naming Conventions

OLE DB versus ODBC data access methods

Transact SQL

T-SQL Scripts

Tracking File Growth

Cursor Performance

Query Execution Plan Analysis

SQL Server Parallel Execution Plans

10 Things You Shouldn't Do With SQL Server (Data Access Methods)

Temp tables discussed

2071 - TSQL

Below are some useful links to supplement the course 2071 - Querying SQL Server 2000 with Transact-SQL:

SQL Server Development Tips

Transact SQL

SQL Server Performance

Crystal Reports Articles

General Crystal Reports tips, tricks, and other articles

Field Clipping
Table join problems