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)