Portable DBA: SQL Server

Your On-the-Job Quick ReferenceCarry essential SQL Server administration information and troubleshooting techniques along with you so you can handle a wide variety of tasks on the spot. This handy resource offers fast access to administrative commands, syntax diagrams, error resolutions, best practices, and more. With coverage of the most commonly used SQL Server versions, this convenient reference gives you quick solutions in an easy-to-find format. Don't leave your desk without it! Get details on: Installation, configuration, and upgrades Security--authentication, Kerberos, logins, roles, permissions Creating and managing databases and database objects Backups, restoration, and recovery Loading and extracting data Automating SQL Server administration Monitoring, performance tuning, and replication Managing distributed databases Clustering and log shipping About The Authors: Damir Bersinic, MCSE, MCDBA, MCT, is a consultant and trainer who has been working with SQL Server since version 1.11a. He is the co-author of "MCSA Windows Server 2003 All-in-One Exam Guide" from McGraw-Hill/Osborne, and several other books. He is also a regular contributor to "MCP Magazine." Stephen Giles, MCSE, MCDBA, MCT, is a consultant, author, and partner at AllianzWeb, an IT consulting company based in Toronto, Canada. He is co-author of "MCSA Windows Server 2003 All-in-One Exam Guide" from McGraw-Hill/Osborne, and several other books.

Damir Bersinic (Mississauga, Ontario, Canada) is an Oracle Certified DBA and an independent consultant and trainer. He has been working with SQL Server since version 1.11a and holds several Microsoft certifications including MCSE, MCDBA, and MCT. Damir has authored a number of titles on SQL Server, Oracle, Windows 2000 and Active Directory. He is also a database columnist for certcities.com, and a regular contributor to MCP Magazine.

1: SQL Server Overview 2: Installing, Configuring, and Upgrading SQL Server 3: SQL Server Security 4: Creating and Managing Databases 5: Creating and Managing Database Objects 6: Database Backups 7: Restoring and Recovering Databases 8: Loading and Extracting Data 9: Automating SQL Server Administration 10: Performance Tuning Part 1: Monitoring SQL Server Performance 11: Performance Tuning Part 2: Tuning SQL Server 12: SQL Server Replication 13: Managing Distributed Databases 14: Clustering and Log Shipping