This is a comprehensive overview of SQL Server architecture, up to and including Microsoft SQL Server 6.5. This guide covers all the basics of SQL Server system administration, showing how to implement distributed databases and enhance security. The text is designed to help database developers and administrators become quickly acquainted with Microsoft SQL Server 6.5. It shows how to create a well-designed Microsoft SQL Server database, improve database access via both direct SQL or stored procedures, and tune the database engine. It includes many specific techniques for optimizing applications, improving organizational productivity, eliminating unnecessary complexity and reducing hardware costs. Each important concept is illustrated with concise examples.
