There's a new presentation on IT’s Showtime! in it the SQL 2005 architecture is discussed in detail and compared to the SQL 2000 architecture. The topics covered include client APIs, wire protocols, storage engine, memory management, job coordinator, transactions, query execution engine, relational database interface and security.