.
Links:
Technet SQL Server 2005
Architecture and Design
SQL Server Best Practices
White Papers and MSDN Articles:
SQL Server 2005 Techical Articles
Working with TempDB
Physical Database Storage
SQL Server 2005 Upgrade Technical Reference Guide
SQL Server 2005 Upgrade Handbook
SQL Server 2005 Failover Clustering White Paper
Implementing Row- and Cell-Level Security in Classified Databases Using SQL Server 2005
Upgrading MSDE 2000 to SQL Server 2005 Express
Troubleshooting Performance Problems in SQL Server 2005
SQL Server 2005 Clustering
Knowledge Base Articles:
SQL Server 7.0, SQL Server 2000, and SQL Server 2005 logging and data storage algorithms extend data reliability
How to move SQL Server databases to a new location by using Detach and Attach functions in SQL Server
Blogs Articles References:
Page Checksum - Che cosa è il page checksum e come sostituisce il "torn page detection"
Under the covers: IAM chains in SQL Server 2000
Under the covers: IAM chains and allocation units in SQL Server 2005
Fragmentation part 1 - What are records?
Fragmentation part 2 - What are pages?
Fragmentation part 3 - What are extents?
Clustered Index Scans - Part I
Clustered Index Scans - Part II
Clustered Index Scans - Part III
Articles:
DateTime problems:
L'Articolo che spiega il perchè ed il percome del datetime
Trattare le Date con SQL Server
Gestire date ed orari con SQL Server 2000
SQL Server e il formato datetime ISO 8601
SQL Server Agent, Schedulazione e Job:
Con quale account vengono eseguiti gli step di un job di Sql Server 2000?
Full Text Search:
SQL Server Full Text Search Language Features
SQL Server Full Text Search Language Features, Part 2
Integration Services (SSIS)
Integration Services: Performance Tuning Techniques
Blogs:
Official Sql Server Development Team Blogs:
SQL Server Customer Advisory Team
SQL Server Data Engine + CLR Integration Team
SQL Server Express Team
SQL Server Database Engine - Tips Site
SQL Server ISV Team
SQL Server Communication Protocols
Relational Engine Management Team
Query Optimizer Team
SQL Server Protocols
"Unofficial" Sql Server Development Team Blogs:
Michiel Wories, PM on the Managability Team (SMO, sqlcmd, etc)
Mosha's Analysis Services Info
Kirk's Integration Services Info
Michael Rys on all things XML
John Gallardo, on XML in SQL Server 2005
XML insight from Shankar
Slava's excellent SQLOS info
Rushi's SSB and other interesting stuff site (Service Broker)
Remus's SSB Info (Service Broker)
Have Data Will Travel (Service Broker)
Data works, All things data access related
Ken Henderson's deeply sql-geeky blog
Cihangir Biyikoglu's info from ISV land
Ian's Query Plan guidance
TempDB and other cool info from Wei
Bruce Prang on the tools
Bob's cool Reporting Services info
Sleazy SSRS Hacks from Chris
Laurentiu Cristofor's blog (PKI)
Tony Rogerson's ramblings on SQL Server
Craig Freedman's WebLog (query processing, query execution, and query plans in SQL Server)