Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
Administrator's Guide to SQL Server 2005 (Microsoft Windows Server)

The Complete, Practical, 100% Useful Guide for Every SQL Server 2005 DBA!


This book has one goal: to help database administrators and their managers run SQL Server 2005 with maximum efficiency, reliability, and performance. Renowned SQL Server expert Buck Woody covers every facet of database administration, from installation and configuration through maintaining enterprise-class business intelligence environments.


If you’re a new SQL Server administrator, Buck will help you master core tasks rapidly–and avoid costly mistakes that only show up when it’s too late. If you’re familiar with previous versions of SQL Server, he’ll get you up-to-speed fast on everything new that matters, from high availability improvements and Integration Services to the SQL Server Management Studio. Whatever your background, you’ll find best practices, real-world scenarios, and easy-to-use automation scripts–all grounded in Buck’s unsurpassed SQL Server knowledge.


     •  Timesaving tips, practical applications, and start-to-finish examples throughout

     •  Understand the key “decision points” at every stage of your SQL Server deployment

     •  Perform day-to-day maintenance more efficiently, from hotfixes to backup/recovery

     •  Automate maintenance tasks with the SQL Server Agent

     •  Establish and audit security on SQL Server 2005 and the underlying Windows Server platform

     •  Monitor and optimize SQL Server: baselining, profiling, index strategies, query refactoring, and more

     •  Maximize availability using replication, clustering, mirroring, and SQL Server’s new online indexing

     •  Leverage important new improvements in Integration Services and Reporting Services

     •  Use Analysis Services to support enterprise-class Business Intelligence deployments

     •  Even set up a simple configuration of SQL Server 2005 for free–legally!


About the Author

Buck Woody has been working with technology since he built his first computer (with 1 whole kilobyte of RAM) in 1980. He has worked every position from the help desk to software design, with stops along the way as an IT manager here and there. He has been a database administrator since 1995, when he managed an Oracle system on an HP 9000. Buck also served for five years as the president of the Tampa SQL Server User Group (TSUG). He is a Microsoft MVP (2006, SQL Server) and holds the MSCE and MCDBA certifications. He currently works at Jabil Circuit as a database architect and hosts a weekly “Guide” for SQL Server at InformIT.com.

(HTML tags aren't allowed.)

Adobe Photoshop Elements 5.0 A-Z: Tools and features illustrated ready reference
Adobe Photoshop Elements 5.0 A-Z: Tools and features illustrated ready reference
If you are a digital camera enthusiast jumping into enhancement and manipulation, and looking for quick answers, this easy-to use, ready reference is for you. Its like having the author Philip Andrews sitting next to you, with his no-nonsense style, giving you practical, hands-on tips for getting striking images using Elements 5.0.

Encyclopedia of Infectious Diseases: Modern Methodologies
Encyclopedia of Infectious Diseases: Modern Methodologies

New multidisciplinary approaches that are changing our understanding of infectious diseases

Discover how the application of novel multidisciplinary, integrative approaches and technologies are dramatically changing our understanding of the pathogenesis of infectious diseases and their treatments. Each article...

Simulating Ecol Evolution Systems C
Simulating Ecol Evolution Systems C
Computer simulations are a powerful tool for understanding ecological and evolutionary systems. Simulating Ecological and Evolutionary Systems in C models a diverse range of biological processes and systems, including competition, foraging, predation, mating systems, and life-history optimization, by simulating large collections of interacting...

The Digital SLR Guide: Beyond Point-and-Shoot Digital Photography
The Digital SLR Guide: Beyond Point-and-Shoot Digital Photography
Have you stepped up to a digital single-lens-reflex (dSLR) camera only to find the range of capabilities daunting? Combining features traditionally found on 35mm film cameras — precise shutter speed and exposure settings, interchangeable lenses and accessories, superior image quality — with the ease and storage capacity...
An Executive's Guide to Information Technology: Principles, Business Models, and Terminology
An Executive's Guide to Information Technology: Principles, Business Models, and Terminology
Assessing the most valuable technology for an organization is becoming a growing challenge for business professionals confronted with an expanding array of options. This book is an A-Z compendium of technological terms written for the non-technical executive, allowing quick identification of what the term is and why it is significant. This is more...
Drupal 7 Multi Sites Configuration
Drupal 7 Multi Sites Configuration

Drupal is a flexible Content Management System (CMS). One important feature that it provides is its ability to run multiple websites from one single installation of the Drupal software. This book is about that specific feature. From installation to configuration, then to maintenance and updating, this book focuses on the nuances of what is...

©2020 LearnIT (support@pdfchm.net) - Privacy Policy