Star Wars Sale
 
 

Special Offers see all

Enter to WIN!

Weekly drawing for $100 credit. Subscribe to PowellsBooks.news for a chance to win.
Privacy Policy

More at Powell's


Recently Viewed clear list


The Powell's Playlist | June 18, 2014

Daniel H. Wilson: IMG The Powell’s Playlist: Daniel H. Wilson



Like many writers, I'm constantly haunting coffee shops with a laptop out and my headphones on. I listen to a lot of music while I write, and songs... Continue »
  1. $18.87 Sale Hardcover add to wish list

    Robogenesis

    Daniel H. Wilson 9780385537094

spacer

This item may be
out of stock.

Click on the button below to search for this title in other formats.


Check for Availability
Add to Wishlist

This title in other editions

Administrator's Guide to SQL Server 2005

by

Administrator's Guide to SQL Server 2005 Cover

 

Synopses & Reviews

Publisher Comments:

“Buck Woody’s new book will help new and experienced users alike in getting productive with SQL Server 2005 quickly. His special attention to security and performance make this an exceptional reference that is sure to remain relevant for some time.”

—Chip Andrews, CISSP, MCDBA, Director of Research and Development Special Ops Security, Inc.

 

“SQL 2005 is the most exciting upgrade to come out of Redmond in years; this book will help you get up and running quickly to take full advantage of it! If you are looking for a book about upgrading to SQL 2005, look no further, this one is all you need. It gives you all you need to take advantage of everything SQL 2005 has to offer, and that is a lot!”

—Doug Ellis, Area Technical Manager, Cognos

 

“Buck Woody provides insight into administering SQL Server 2005 that all developers and database administrators will find useful; the book assumes very little knowledge by providing ‘DBA 101’ sections which will not alienate the experienced reader while providing the necessary introduction to topics for those less experienced.”

—Doug Holland, Visual C# MVP, Precision Objects

 

“SQL Server 2005 is a landmark release and this title does an awesome job of hitting everything new in SQL 2005. It covers new and improved administration tools, and contains an overview of Notification Services, SQL Server Service Broker, Reporting Services, Integration Services, and Analysis Services. As a result, you’ll be able to work on your own SQL Server 2005 solutions quickly and painlessly. Ultimately, this book provides you with a starting point, a roadmap, and then the tools and knowledge to exploit this powerful new database server to its fullest power. So, start your computer and get ready to learn SQL Server 2005!”

—Alexzander N. Nepomnjashiy, SQL Server DBA, NeoSystems NorthWest

 

“A solid introduction to administering SQL 2005. The ‘DBA 101’ sections provide useful tips for the new DBA, good review for the experienced DBA, and the 101 label enables the seasoned DBA to skip basic material and jump ahead to where the REAL action is…. Buck’s conversational writing style makes this an enjoyable and refreshing contrast to the majority of tech books written these days.”

—Brad Russell, MCDBA, Visionary Integration Professionals

 

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!

 

Foreword  xviii

 

Chapter 1: Installation and Configuration  1

Chapter 2: Architecture and Tools  35

Chapter 3: Maintenance and Automation  99

Chapter 4: Security  173

Chapter 5: Monitoring and Optimization  237

Chapter 6: High Availability  295

Chapter 7: Notification Services and the Service Broker  365

Chapter 8: Integration Services  399

Chapter 9: Reporting Services  451

Chapter 10: Analysis Services  515

 

Appendix A: Upgrading to SQL Server 2005  581

 

Index  605

Book News Annotation:

After describing the many architectures within SQL Server 2005 that affect the transfer of data into and out of the system, this guide outlines a database maintenance plan, considers security at every point along the data path, explains the tools for monitoring and optimizing database servers, and suggests options for implementing a highly available system. The final chapters discuss notification, integration, reporting, and analysis services.
Annotation ©2006 Book News, Inc., Portland, OR (booknews.com)

Book News Annotation:

After describing the many architectures within SQL Server 2005 that affect the transfer of data into and out of the system, this guide outlines a database maintenance plan, considers security at every point along the data path, explains the tools for monitoring and optimizing database servers, and suggests options for implementing a highly available system. The final chapters discuss notification, integration, reporting, and analysis services. Annotation ©2006 Book News, Inc., Portland, OR (booknews.com)

Synopsis:

“Buck Woody’s new book will help new and experienced users alike in getting productive with SQL Server 2005 quickly. His special attention to security and performance make this an exceptional reference that is sure to remain relevant for some time.”

—Chip Andrews, CISSP, MCDBA, Director of Research and Development Special Ops Security, Inc.

 

“SQL 2005 is the most exciting upgrade to come out of Redmond in years; this book will help you get up and running quickly to take full advantage of it! If you are looking for a book about upgrading to SQL 2005, look no further, this one is all you need. It gives you all you need to take advantage of everything SQL 2005 has to offer, and that is a lot!”

—Doug Ellis, Area Technical Manager, Cognos

 

“Buck Woody provides insight into administering SQL Server 2005 that all developers and database administrators will find useful; the book assumes very little knowledge by providing ‘DBA 101’ sections which will not alienate the experienced reader while providing the necessary introduction to topics for those less experienced.”

—Doug Holland, Visual C# MVP, Precision Objects

 

“SQL Server 2005 is a landmark release and this title does an awesome job of hitting everything new in SQL 2005. It covers new and improved administration tools, and contains an overview of Notification Services, SQL Server Service Broker, Reporting Services, Integration Services, and Analysis Services. As a result, you’ll be able to work on your own SQL Server 2005 solutions quickly and painlessly. Ultimately, this book provides you with a starting point, a roadmap, and then the tools and knowledge to exploit this powerful new database server to its fullest power. So, start your computer and get ready to learn SQL Server 2005!”

—Alexzander N. Nepomnjashiy, SQL Server DBA, NeoSystems NorthWest

 

“A solid introduction to administering SQL 2005. The ‘DBA 101’ sections provide useful tips for the new DBA, good review for the experienced DBA, and the 101 label enables the seasoned DBA to skip basic material and jump ahead to where the REAL action is…. Buck’s conversational writing style makes this an enjoyable and refreshing contrast to the majority of tech books written these days.”

—Brad Russell, MCDBA, Visionary Integration Professionals

 

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!

 

Foreword  xviii

 

Chapter 1: Installation and Configuration  1

Chapter 2: Architecture and Tools  35

Chapter 3: Maintenance and Automation  99

Chapter 4: Security  173

Chapter 5: Monitoring and Optimization  237

Chapter 6: High Availability  295

Chapter 7: Notification Services and the Service Broker  365

Chapter 8: Integration Services  399

Chapter 9: Reporting Services  451

Chapter 10: Analysis Services  515

 

Appendix A: Upgrading to SQL Server 2005  581

 

Index  605

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.

Table of Contents

Pr>

Foreword  xviii

 

Chapter 1: Installation and Configuration  1

Chapter 2: Architecture and Tools  35

Chapter 3: Maintenance and Automation  99

Chapter 4: Security  173

Chapter 5: Monitoring and Optimization  237

Chapter 6: High Availability  295

Chapter 7: Notification Services and the Service Broker  365

Chapter 8: Integration Services  399

Chapter 9: Reporting Services  451

Chapter 10: Analysis Services  515

 

Appendix A: Upgrading to SQL Server 2005  581

 

Index  605

Product Details

ISBN:
9780321397973
Publisher:
Addison-Wesley Professional
Subject:
Client-server computing
Author:
Woody, Buck
Subject:
Database Management - SQL Server
Subject:
Database management
Subject:
Database Management - General
Subject:
Database-SQL
Subject:
Database design
Copyright:
Edition Description:
Trade paper
Series:
Microsoft Windows Server System Series
Publication Date:
June 2006
Binding:
TRADE PAPER
Grade Level:
Professional and scholarly
Language:
English
Illustrations:
Y
Pages:
648
Dimensions:
9.23 x 7 x 1.277 in 885 gr

Related Subjects

Computers and Internet » Database » Design
Computers and Internet » Database » SQL
Computers and Internet » Software Engineering » Software Management

Administrator's Guide to SQL Server 2005
0 stars - 0 reviews
$ In Stock
Product details 648 pages Addison-Wesley Professional - English 9780321397973 Reviews:
"Synopsis" by ,

“Buck Woody’s new book will help new and experienced users alike in getting productive with SQL Server 2005 quickly. His special attention to security and performance make this an exceptional reference that is sure to remain relevant for some time.”

—Chip Andrews, CISSP, MCDBA, Director of Research and Development Special Ops Security, Inc.

 

“SQL 2005 is the most exciting upgrade to come out of Redmond in years; this book will help you get up and running quickly to take full advantage of it! If you are looking for a book about upgrading to SQL 2005, look no further, this one is all you need. It gives you all you need to take advantage of everything SQL 2005 has to offer, and that is a lot!”

—Doug Ellis, Area Technical Manager, Cognos

 

“Buck Woody provides insight into administering SQL Server 2005 that all developers and database administrators will find useful; the book assumes very little knowledge by providing ‘DBA 101’ sections which will not alienate the experienced reader while providing the necessary introduction to topics for those less experienced.”

—Doug Holland, Visual C# MVP, Precision Objects

 

“SQL Server 2005 is a landmark release and this title does an awesome job of hitting everything new in SQL 2005. It covers new and improved administration tools, and contains an overview of Notification Services, SQL Server Service Broker, Reporting Services, Integration Services, and Analysis Services. As a result, you’ll be able to work on your own SQL Server 2005 solutions quickly and painlessly. Ultimately, this book provides you with a starting point, a roadmap, and then the tools and knowledge to exploit this powerful new database server to its fullest power. So, start your computer and get ready to learn SQL Server 2005!”

—Alexzander N. Nepomnjashiy, SQL Server DBA, NeoSystems NorthWest

 

“A solid introduction to administering SQL 2005. The ‘DBA 101’ sections provide useful tips for the new DBA, good review for the experienced DBA, and the 101 label enables the seasoned DBA to skip basic material and jump ahead to where the REAL action is…. Buck’s conversational writing style makes this an enjoyable and refreshing contrast to the majority of tech books written these days.”

—Brad Russell, MCDBA, Visionary Integration Professionals

 

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!

 

Foreword  xviii

 

Chapter 1: Installation and Configuration  1

Chapter 2: Architecture and Tools  35

Chapter 3: Maintenance and Automation  99

Chapter 4: Security  173

Chapter 5: Monitoring and Optimization  237

Chapter 6: High Availability  295

Chapter 7: Notification Services and the Service Broker  365

Chapter 8: Integration Services  399

Chapter 9: Reporting Services  451

Chapter 10: Analysis Services  515

 

Appendix A: Upgrading to SQL Server 2005  581

 

Index  605

spacer
spacer
  • back to top
Follow us on...




Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.