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)