Beginning SQL Server 2005 Reporting Services Part 3: The Chart Control

Beginning SQL Server 2005 Reporting Services Part 3: The Chart Control

SQL Server 2005 SSIS: Tuning the Dataflow Task

SQL Server 2005 SSIS: Tuning the Dataflow Task

logins and passwords between instances of SQL Server

How to transfer logins and passwords between instances of SQL Server

How to resolve permission issues when you move a database between servers that are running SQL Server

"Troubleshooting Orphaned Users" topic in Books Online is incomplete

How to move databases between computers that are running SQL Server

SQL Server 2000 - Log Shipping

- By the way, you can move the logins using this method:
HOW TO: Transfer Logins and Passwords Between Instances of SQL Server
http://www.support.microsoft.com/?id=246133

-To monitor the process you could use the jobs that perform the log
backups and restores. Have them email you if there is a failure. This is a
great way to email from SQL Server: XPSMTP --
http://sqldev.net/xp/xpsmtp.htm

You may find these KB articles helpful:

314515 INF: Frequently Asked Questions - SQL Server 2000 - Log Shipping
http://support.microsoft.com/?id=314515

323135 INF: Microsoft SQL Server 2000 - How to Set Up Log Shipping (White
Paper)
http://support.microsoft.com/?id=323135

325220 Support WebCast: Microsoft SQL Server 2000 Log Shipping
http://support.microsoft.com/?id=325220

821786 Support WebCast: Microsoft SQL Server 2000: Using Log Shipping
http://support.microsoft.com/?id=821786

321247 HOW TO: Configure Security for Log Shipping
http://support.microsoft.com/?id=321247

329133 INF: Troubleshooting SQL Server 2000 Log Shipping "Out of Sync"
Errors
http://support.microsoft.com/?id=329133

SQL Server 2005 Features Comparison

The basics of asynchronous processing

http://www.simple-talk.com/dotnet/windows-forms/asynchronous-processing-in-.net-part-1-fundamentals/

Designing and building a robust data access layer

http://www.simple-talk.com/dotnet/.net-framework/.net-application-architecture-the-data-access-layer/

http://www.sql-server-performance.com/

Forrester Research: Technology research and advice.