Upgrading to 2005 (Microsoft) http://msdn2.microsoft.com/en-us/library/ms144245.aspx
Upgrading to 2005 (Informit) http://www.informit.com/articles/article.asp?p=421049&seqNum=4
SQL 2005 vs. Oracle 10g http://www.wisdomforce.com/dweb/resources/docs/MSSQL2005_ORACLE10g_compare.pdf
Revised Books Online for 2005: http://www.microsoft.com/downloads/details.aspx?FamilyId=BE6A2C5D-00DF-4220-B133-29C1E0B6585F&displaylang=en
SQL 2005 Database Mirroring: http://msdn2.microsoft.com/en-us/library/ms189852.aspx
SQL 2005 Encryption: http://www.sqlservercentral.com/articles/SQL+Server+2005+-+Security/sql2005symmetricencryption/2291/
SQL 2005 Encryption Heirarchy Diagram: http://www.sqlservercentral.com/columnists/mcoles/SQL2K5Enc.png
SQL 2005 Encryption Keys Example T-SQL code: /Documents/SQLEncryptionKeysExample.txt
Encrypting Data with SQL 2005: http://www.informit.com/guides/content.aspx?g=sqlserver&seqNum=245&rl=1
The COST of Encyrption: http://www.codeproject.com/KB/database/EncryptColsSQLServerPerf.aspx
Using SSL for SQL: http://www.informit.com/guides/content.aspx?g=sqlserver&seqNum=244
SSIS Tutorials @ Databasejournal.com: http://www.google.com/search?hl=en&q=sql+2005+server+integration+services+Part+site%3Adatabasejournal.com
Rebuilding the SQL Database & Registry: http://msdn.microsoft.com/en-us/library/ms144259.aspx
General SQL Info
The A.C.I.D. rule for transactions: http://msdn2.microsoft.com/en-us/library/ms190612.aspx
How does a transaction log work? http://msdn2.microsoft.com/en-us/library/ms186259.aspx
Understanding transaction logs: http://msdn2.microsoft.com/en-us/library/ms345583.aspx
Understanding the Bulk-logged Recovery Model: http://msdn.microsoft.com/en-us/library/ms190692.aspx
Supporting SQL on a SAN: http://blogs.msdn.com/sqlcat/archive/2005/10/11/479887.aspx
Supporting SQL on a SAN(2): http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1213487,00.html
SCRIPTS! - SQL Server Central http://www.sqlservercentral.com/
SQL Backups in a Nutshell http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx
SQL Server PERFORMANCE http://www.sql-server-performance.com/
SQL Server SECURITY - There is no patch for stupidity http://www.sqlsecurity.com
10 Steps to Help Secure SQL Server 2000 http://www.microsoft.com/sql/prodinfo/previousversions/securingsqlserver.mspx
About MSSQLCity.Com http://www.mssqlcity.com/AboutUs.htm
Database Journal http://www.databasejournal.com
SQL Server Magazine http://www.windowsitpro.com/SQLServer/
SQL Server Reference Guide http://www.informit.com/guides/content.asp?g=sqlserver&seqNum=24
SQL Server User Group: PASS http://www.sqlpass.org
Dandy Weyn - MCT SQL site http://www.dandyman.net/sql
Tibor Karaszi - MCT SQL site http://www.karaszi.com/SQLServer/default.asp
MSSQL Newsgroups http://www.microsoft.com/technet/community/newsgroups/server/sql.mspx
SQL Utilties
Microsoft SQL 2000 Home http://www.microsoft.com/technet/prodtechnol/sql/2000/default.mspx
Download SQL Server 2000 Security Tools http://www.microsoft.com/downloads/details.aspx?FamilyID=9552d43b-04eb-4af9-9e24-6cde4d933600&DisplayLang=en
SQL Server Most Popular SQL 2000 Server Downloads http://www.microsoft.com/technet/prodtechnol/sql/2000/downloads/default.mspx
SQL Web Data Administrator http://www.microsoft.com/downloads/details.aspx?FamilyID=c039a798-c57a-419e-acbc-2a332cb7f959&displaylang=en
Red-Gate software for SQL http://www.red-gate.com/
MSDE - Free SQL Server http://www.microsoft.com/sql/msde/default.asp
Free Trial Edition of SQL Server http://www.microsoft.com/sql/downloads/2000/default.mspx
Microsoft Baseline Security Analyzer (MBSA) http://www.microsoft.com/technet/security/tools/mbsahome.mspx
Revised Books On Line for SQL 2000 (Not in Service Packs!) http://www.microsoft.com/sql/downloads/2000/default.mspx
Microsoft Help and History Tool (SQLH2) http://www.microsoft.com/downloads/details.aspx?FamilyID=64983af0-7902-427e-9b41-7c2e8fdcc140&DisplayLang=en
Windows IT Pro Article on SQLH2 http://www.windowsitpro.com/Article/ArticleID/44838/44838.html
SQL Stress Testers http://support.microsoft.com/?kbid=887057
SQL Notification Services http://www.microsoft.com/sql/NS/default.asp
Lumigent Log Explorer http://www.lumigent.com/products/le_sql.html
DBMaint SMTP Alerts http://www.karaszi.com/SQLServer/util_smtp_alerter.asp
SQLDev.net SMTP sqlmail http://sqldev.net/xp/xpsmtp.htm
DIMAC - the makers of JMAIL (email without the client!) http://www.dimac.net
DesktopStandard.com- Automated Profiles without Outlook http://www.desktopstandard.com/OutlookProfileMaker.aspx
SQL Server 2000 System Tables Map http://www.microsoft.com/sql/techinfo/productdoc/2000/systables.asp
sqldiag.exe reference http://msdn.microsoft.com/library/default.asp?url=/library/en-us/coprompt/cp_sqldiag_96k9.asp
Sample Database Relational Models http://www.databaseanswers.com/data_models/index.htm
SQL REPORTING SERVICES:
Microsoft's SSRS 2005 Home Page: http://www.microsoft.com/Sqlserver/2005/en/us/reporting-services.aspx
SSRS Blog - lots of great tips: http://blogs.msdn.com/bobmeyers/
Great SSRS Demos: (Building Basic Reports)DNR TV: Reporting Services Part A
Great SSRS Demos: (Making Reports slick, Parameters)DNR TV: Reporting Services Part B
Great SSRS Demos: (Charting): DNR TV: Reporting Services Part C
Excellent suggestions for making good reports: SSW: Rules to Better SQL Reporting Services 2005
Reporting Expression Examples: http://msdn.microsoft.com/en-us/library/ms157328.aspx
What's new in SQL Reporting Services 2008? http://msdn.microsoft.com/en-us/library/ms170438.aspx