System specifics understanding SQL Server 7.0 architecture, requirements, and features such as SQL Server Manager, Enterprise Manager, and Microsoft Cluster Server Installation and setup tutorials and guides to local and remote installations and upgrades Maximizing everyday performance working with Transact-SQL, data retrieval, tables, indexes, views, and SQL Server Agent Optimizing server-side featuresrules, constraints, defaults, stored procedures, and replication Maintenance and troubleshooting—backup/recovery, user and security management, query optimization, and common performance issues Scalability using distributed transactions to deploy mission-critical processes with DTC (Distributed Transaction Coordinator) and MTS (Microsoft Transaction Server)