Administrator's Guide to SQL Server 2005 (Microsoft Windows Server)

Administrator's Guide to SQL Server 2005 (Microsoft Windows Server), 9780321397973 (0321397975), Addison Wesley, 2006

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.

Comments

Amazing Books

Practical Algorithms for Programmers

Addison Wesley, 1995

The purpose of this book is to provide a practical compendium of algorithms for use in applications. Unlike most works on algorithms, this book is not a textbook: you will not find implementation details left as an exercise for the reader, nor will you find highly theoretical discussions of algorithms with small snippets of code...

Designing Distributed Learning Environments with Intelligent Software Agents

Information Science Publishing, 2005

This book benefits the AI (artificial intelligence) and educational communities in their research and development, offering new and interesting research issues surrounding the development of distributed learning environments in the Semantic Web age.

With the rapid development of computer network and information technologies, especially...

Building a HIPAA-Compliant Cybersecurity Program: Using NIST 800-30 and CSF to Secure Protected Health Information

Apress, 2017

Use this book to learn how to conduct a timely and thorough Risk Analysis and Assessment documenting all risks to the confidentiality, integrity, and availability of electronic Protected Health Information (ePHI), which is a key component of the HIPAA Security Rule. The requirement is a focus area for the Department of Health and Human...

Adobe Business Catalyst: Design full-featured websites without the hassles of development

Adobe Press, 2011

The Internet has completely transformed the way products are marketed and sold. Technology is evolving very quickly and businesses are constantly reinventing themselves. Customers want more for their money. They have learned to shop around to find the best value. They compare reviews to purchase the highest-rated items. As the...

C# Complete

Sybex, 2003

C# Complete is a one-of-a-kind book--valuable both for its broad content and its low price. Whether you're brand-new to C# programming, are migrating from Visual Basic or Visual C++ to C#, or have already developed some expertise in C#, you'll get the skills you need to become proficient with Microsoft's powerful new language...

Database Systems: Design, Implementation and Management, Sixth Edition

Course Technology PTR, 2004

This Sixth Edition takes you clearly and effectively through the entire process of database development and implementation. This market leading text includes new Visio and UML tutorials, as well as a new chapter on Advanced SQL. All appendices are housed on a CD that accompany every copy of the text.

Takes students step by step through...