This seminar was co-led by world renowned author and public speaker on Windows networking and security, Rand Morimoto, along with Convergent Computing SQL expert and technical editor of the book "SQL 2005: Changing the Paradigm," Ross Mistry.

The following is an outline of the discussion topics:
Terminology commonly used in SQL Server such as database, transaction logs, and indexes

• Implementation strategies such as disk layout and database / transaction log placement

• Recommended backup and recovery strategies and how to restore SQL Server to the point of failure

• High availability alternatives and their applicability in various SQL recovery scenarios including SQL Server clustering, transaction log shipping, and replication

• Maintenance practices with SQL 2000 including maintenance plans, performing database integrity checks, and validating indexes on the server are up–to-date

• How to effectively monitor SQL Server to ensure operation efficiency

• What’s new in SQL 2005 and the right time to upgrade from SQL 2000 to SQL 2005

You should download and print the slide deck that will be used throughout this session

Video #1 (1-hour, 32-minutes): Covers SQL Capacity Planning and Backup Strategies

Video #2 (37-minutes): Covers Maintenance Practices, Monitoring SQL, and Migrating from SQL 2000 to SQL 2005

Convergent Computing is a technology consulting firm headquartered in the San Francisco Bay Area that helps organizations plan, implement, and support their server, network, and application environments. If your organization can use assistance understanding the best products, solutions, or technologies to meet your business needs, please contact our organization for assistance mailto:sales@cco.com