Professional SQL Server 2005 Administration

Professional SQL Server 2005 Administration
ISBN-10
0470055200
ISBN-13
9780470055205
Category
Computers
Pages
768
Language
English
Published
2006-12-06
Publisher
Wrox
Authors
Brian Knight, Ketan Patel, Wayne Snyder

Description

SQL Server 2005 is the largest leap forward for SQL Server since its inception. With this update comes new features that will challenge even the most experienced SQL Server DBAs. Written by a team of some of the best SQL Server experts in the industry, this comprehensive tutorial shows you how to navigate the vastly changed landscape of the SQL Server administration. Drawing on their own first-hand experiences to offer you best practices, unique tips and tricks, and useful workarounds, the authors help you handle even the most difficult SQL Server 2005 administration issues, including blocking and locking. You'll learn how to fine-tune queries you've already written, automate redundant monitoring and maintenance tasks, and use hidden tools so that you can quickly get over the learning curve of how to configure and administer SQL Server 2005. What you will learn from this book How to use some of the more advanced concepts of installation Techniques for properly administering development features such as SQL CLR Ways to secure your SQL Server from common threats How to choose the right hardware configuration Best practices for backing up and recovering your database Step-by-step guidelines for clustering your SQL Server Who this book is for This book is for experienced developers and database administrators who plan to administer or are already administering an SQL Server 2005 system and its business intelligence features. Wrox Professional guides are planned and written by working technologists to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.

Get the book

Amazon.com
Amazon.com
Search the book
eBay.com
eBay.com
Search the book

Other editions

Similar books

  • Beginning SQL Server 2005 Administration
    Beginning SQL Server 2005 Administration
    By Paul Turley, Chris Leiter, Dan Wood

    SQL Server Integration Services (SSIS) is Microsoft's new enterprise class data Extract, Transform, and Load (ETL) tool. SSIS is a completely new product built from the ashes of SQL Server 2000's Data Transformation Services (DTS).

  • Beginning SQL Server 2008 Administration
    Beginning SQL Server 2008 Administration
    By Robert Walters, Grant Fritchey, Carmen Taglienti

    From college students, to experienced database administrators from other platforms, to those already familiar with SQL Server and wanting to fill in some gaps of knowledge, this book will bring all readers up to speed on the enterprise ...

  • Beginning Microsoft SQL Server 2008 Administration
    Beginning Microsoft SQL Server 2008 Administration
    By Chris Leiter, Dan Wood, Michael Cierkowski

    Cuddy ...

  • Expert SQL Server 2005 Integration Services
    Expert SQL Server 2005 Integration Services
    By Brian Knight, Erik Veerman

    As a practical guide for Integration Services ETL development, this book shows you ways to implement your ETL solution requirements from the data to the administration and everything in-between.

  • Pro SQL Server 2008 Replication
    Pro SQL Server 2008 Replication
    By Sujoy Paul

    This book will also cover advanced topics like replication with heterogeneous databases, backup and recovery of replicated databases, database mirroring with replication, log shipping with replication, troubleshooting, plus optimization and ...

  • Beginning T-SQL with Microsoft SQL Server 2005 and 2008
    Beginning T-SQL with Microsoft SQL Server 2005 and 2008
    By Paul Turley, Dan Wood

    ... varchar(25) NULL ,FirstName varchar(25) NULL ,Position varchar(25)NULL); INSERT SlateGravel VALUES ('Flintstone', ... is stored in a casesensitive collation searching for “flint%” will not return strings beginning with “Flint.

  • Pro SQL Server 2005 Integration Services
    Pro SQL Server 2005 Integration Services
    By Jim Wightman

    What you’ll learn Understand how to develop and deploy SSIS solutions that will perform in multibillion–item environments from an author who has been there and done it Build bespoke custom components tailored to your projects exact ...

  • Professional SQL Server 2005 Performance Tuning
    Professional SQL Server 2005 Performance Tuning
    By Steven Wort, Douglas Hinson, Haidong Ji

    ... Publisher Richard Swadley Vice President and Executive Publisher Joseph B. Wikert Project Coordinator, Cover Lynsey Osborn Proofreader Ian Golder Indexer Robert Swanson Acknowledgments We have to start by thanking our families.

  • Pro SQL Server 2005 High Availability
    Pro SQL Server 2005 High Availability
    By Allan Hirt

    This book comprehensively covers the technology, the people, the process, and the real-world best practices for planning, deploying, administering, and maintaining highly available SQL Server 2005 instances.

  • Pro SQL Server 2005
    Pro SQL Server 2005
    By Thomas Rizzo, Louis Davidson, Robert Walters

    * First book to provide comprehensive, deeply practical coverage on all major new SS2005 features. • Lead author (Tom Rizzo) is a key member of the SQL Server team at Microsoft and a respected author and blogger. • Gets the DBA and ...