Portable DBA : SQL server

your On-the-job Quick Reference carry 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. A must-have for anybody working 6.5, 7, and 2000 MSSQL. Very well scoped-out in its depth of coverage. Explains aspects of the RDBMS that will be required knowledge for any DBA coming from a non-MSSQL background. Covers differences from SQL 6.5 through SQL 2000. Sure, there is a lot that is not in here, but it is impressive how much is covered (from basics of physical design, to ACID transactions, to replication-related stored procedures). The smaller form factor makes it easy to carry around, which is an absolute bonus. The material in this book (and the "for Experienced DBAs" book in the Osborne series) must be distilled from a vast amount of real-world experience-- sadly, not out there yet for SQL 2005. This book is the ultimate field guide for every SQL Server DBAs laptop bag. Dont go onsite without it! Covers the most commonly used SQL Server database versions. Handy, easy-to-find information includes security, database creation and management, restoration and recovery, automating SQL Server administration, monitoring performance, tuning, and much more. This ultimate field guide offers fast access to administrative commands; syntax diagrams; error resolutions; best practices; security; database creation and management; monitoring performance; tuning; and much more. -- Edited summary from book The first step in administering SQL Server is knowing what it is and what it is supposed to do.