Microsoft SQL Server 2005 Management and Administration

( 2 )

Overview

Microsoft SQL Server 2005 Management and Administration, based on Service Pack 2, addresses the challenges database administrators regularly encounter on SQL Server 2005 by providing detailed guidance in the areas of management, administration, security, and monitoring. With coverage of the new features and functionality of SQL Server 2005 Service Pack 2, this book is designed to be comprehensive, resulting in something for all database administrators—from simple tips to tactical solutions. Microsoft SQL Server ...

See more details below
Other sellers (Paperback)
  • All (15) from $1.99   
  • New (4) from $28.72   
  • Used (11) from $1.99   
Microsoft SQL Server 2005 Management and Administration

Available on NOOK devices and apps  
  • NOOK Devices
  • NOOK HD/HD+ Tablet
  • NOOK
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK Study

Want a NOOK? Explore Now

NOOK Book (eBook)
$19.99
BN.com price
(Save 44%)$35.99 List Price

Overview

Microsoft SQL Server 2005 Management and Administration, based on Service Pack 2, addresses the challenges database administrators regularly encounter on SQL Server 2005 by providing detailed guidance in the areas of management, administration, security, and monitoring. With coverage of the new features and functionality of SQL Server 2005 Service Pack 2, this book is designed to be comprehensive, resulting in something for all database administrators—from simple tips to tactical solutions. Microsoft SQL Server 2005 Management and Administration goes far beyond the basic installation and setup information found in many other resources. The book looks at day-to-day administration, best practices, tips, and step-by-step configurations based on real-world examples found in the industry. Unlike others, this book includes not only administration and management details on the Database Engine, but also coverage of other SQL Server 2005 components often overlooked, including Analysis Services, Reporting Services, and more.

Understand how to…

  • Configure and tune the Database Engine, Reporting Services, Analysis Services, Integration Services, and Notification Services
  • Harden a SQL Server implementation
  • Implement SQL Server highavailability alternatives, such as Failover Clustering, Log Shipping, Database Mirroring, and Replication
  • Monitor a SQL Server 2005 infrastructure with Operations Manager 2007, including how to configure the SQL Server Management Pack and install Operations Manager 2007
  • Automate SQL Server routine maintenance
  • Encrypt SQL Server data and communications, including setting up a Certificate Authority
  • Performance tune and troubleshoot a SQL Server environment
  • Create Integration Services packages and transfer data

On the Web:

Download bonus chapters from www.informit.com/title/9780672329562

Introduction 1

Part I Administering SQL Server Components

1 Administering SQL Server 2005 Database Engine 11

2 Administering SQL Server 2005 Analysis Services 67

3 Administering SQL Server 2005 Reporting Services 99

4 Administering SQL Server 2005 Notification Services 149

5 Administering SQL Server 2005 Integration Services 183

6 Administering SQL Server Replication 209

Part II Managing SQL Server 2005

7 Conducting a SQL Server 2005 Health Check 261

8 SQL Server 2005 Maintenance Practices 289

9 Managing and Optimizing SQL Server 2005 Indexes 317

10 Managing Full-Text Catalogs 353

11 Creating Packages and Transferring Data 387

Part III Securing the SQL Server Implementation

12 Hardening a SQL Server 2005 Environment 435

13 Administering SQL Server Security 469

14 Encrypting SQL Server Data and Communications 509

The following chapters are located online:

Part IV SQL Server 2005 Overview (located online)

15 SQL Server 2005 Technology Primer 537

16 Tools of the Trade 571

Part V Disaster Recovery and High Availability (located online)

17 Backing Up and Restoring the SQL Server 2005 Environment 597

18 Administering and Managing Failover Clustering 647

19 Administering and Managing Database Mirroring 691

20 Administering and Managing Log Shipping 721

Part VI Monitoring and Troubleshooting SQL Server (located online)

21 Monitoring SQL Server 2005 753

22 Performance Tuning and Troubleshooting SQL Server 2005 787

Appendix SQL Server 2005 Management and Administration 821

Read More Show Less

Product Details

  • ISBN-13: 9780672329562
  • Publisher: Sams
  • Publication date: 10/17/2007
  • Pages: 604
  • Product dimensions: 5.37 (w) x 8.18 (h) x 1.30 (d)

Meet the Author

Ross Mistry, MCTS, MCDBA, MCSE Ross Mistry has spent more than nine years in the computer industry and is a seasoned veteran in the Silicon Valley. As a Principal Consultant and Partner with Convergent Computing (CCO), located in the San Francisco Bay area, he has had the opportunity to work with the SQL Server product for two to three years before versions release to the public. His primary focus is implementing and maintaining SQL Server in large enterprise environments with a global presence. He also focuses on Active Directory, Exchange, Operations Manager, and specializes in SQL Server High Availability. He has a strong understanding of how these technologies integrate with one another. Ross has held several roles with Sams Publishing, including lead author, contributing writer, and technical editor. His works include SQL Server 2005 Unleashed, SQL Server 2005: Changing the Paradigm, Exchange Server 2007 Unleashed, SharePoint 2007 Unleashed, SharePoint 2003 Unleashed, and ISA Server 2004 Unleashed. Ross has also written numerous whitepapers and keynote seminars on SQL Server, in which he leverages best practices based on his experiences in the industry.

Chris Amaris, MCSE, CISSP Chris Amaris is the Chief Technology Officer and cofounder of Convergent Computing. He has more than 20 years’ experience consulting for Fortune 500 companies, leading companies in the technology selection, design, planning, and implementation of complex Information Technology projects. Chris has worked with Microsoft SQL since version 4.2 on OS/2. He specializes in database management, messaging, security, performance tuning, systems management, and migration. A Certified Information Systems Security Professional (CISSP) with an Information System Security Architecture Professional (ISSAP) concentration, Certified Homeland Security (CHS III), Windows 2003 MCSE, Novell CNE, Banyan CBE, and a Certified Project Manager, Chris is also an author, writer, and technical editor for a number of IT books, including Network Security for Government and Corporate Executives, Windows Server 2003 Unleashed, Exchange Server 2007 Unleashed, and Microsoft Operations Manager 2005 Unleashed. Chris presents on Messaging, Operations Management, Security, and Information Technology topics worldwide.

Alec Minty, MCSE Alec Minty is a Senior Consultant with Convergent Computing located in the San Francisco Bay area. He has more than 10 years’ industry experience with extensive knowledge designing and implementing enterprise class solutions for a diverse array of organizations. Alec has been an early adopter of database technologies, operations management, systems management, and security technologies. He specializes in designing, implementing, migrating, and supporting complex infrastructures for a variety of large utility, telecommunications, and engineering organizations. Alec’s experience spans the business and technology areas; he has in-depth experience in the deployment, migration, and integration of key business technologies such as SQL Server, Windows, Exchange, Active Directory, ISA, and Identity Management. Alec is coauthor of MOM 2005 Unleashed and is a contributing author on Exchange Server 2007 Unleashed and ISA 2004 Unleashed, all published by Sams Publishing.

Read More Show Less

Read an Excerpt

IntroductionIntroductionWhat Is in This Book?

SQL Server 2005 is Microsoft's product for providing data management and analysis solutions for the enterprise. SQL Server 2005 is a trusted database platform that provides organizations a competitive advantage by allowing them to obtain faster results and make better business decisions. This is all achievable via a new management studio, deep integration with Visual Studio, and a comprehensive business intelligence platform. The product is modular and broken down into the following technologies: database engine, Analysis Services, Integration Services, replication, Reporting Services, Notification Services, service broker, and full-text search.

Because SQL Server has been released for almost two years, organizations are well versed in designing, installing, and implementing SQL Server 2005. However, database administrators are currently facing new challenges, such as how to manage, administer, and monitor their new SQL Server infrastructure based on industry best practices. This book improves the experience these professionals have working with SQL Server.

In addition, this book provides detailed guidance on management, administration, and monitoring. These areas remain challenges to database administrators who have SQL Server already deployed. Because this book assumes the reader has experience with installing SQL Server 2005, it goes far beyond the basic installation and setup information found in hundreds of other resources. Instead, it focuses on day-to-day administration, best practices, and industry case scenarios. All topics and examples covered in this book are based on the new features andfunctionality included with SQL Server 2005 Service Pack 2.

The topic of SQL Server 2005 administration and management is huge, and the size of this book reflects the size of the topic. To help orient you within the book, the following sections describe the various parts and chapters in the book. This book is focused on the administration and management of SQL Server 2005. Apropos to that, the content of the book does not cover the topics of planning, design and installation of the SQL Server 2005 platform. These are broad and deep topics, with books such as Microsoft SQL Server 2005 Unleashed (Sams Publishing, ISBN: 0672328240) dedicated to those topics alone.

However, to facilitate running the steps given throughout the book, the appendix lists the basic steps needed to set up a lab environment with the databases needed to test the procedures given in the book.Part I: Administering SQL Server Components

The administration of the different components of the SQL Server 2005 platform is covered in this part. The administration encompasses the configuration of the various components, including initial setup and adjustments during normal operations.

The chapters in this part cover the administration of the main components of SQL Server 2005.Chapter 1: Administering SQL Server 2005 Database Engine

This chapter focuses on configuring the Database Services component, managing the server, and configuring the database properties of the SQL Server Database Engine after the product has been installed. Managing server and database configuration settings such as memory, processor performance, auditing, database files, and auto growth is covered in depth.Chapter 2: Administering SQL Server 2005 Analysis Services

This chapter focuses on configuring the Analysis Services component for OLAP and business intelligence. Administration topics on how to manage OLAP cubes, partitions, database processing, and storage models are covered.Chapter 3: Administering SQL Server 2005 Reporting Services

Reporting Services is a set of technologies utilized to deliver enterprise web-enabled reporting functionality. This chapter focuses on configuring the Reporting Services component, including Internet Information Services (IIS), and managing the Reporting Services settings.Chapter 4: Administering SQL Server 2005 Notification Services

This chapter focuses on configuring the Notification Services component and managing the notification engine for generating and sending notifications.Chapter 5: Administering SQL Server 2005 Integration Services

Integration Services is Microsoft's extract, transform, and load (ETL) tool for data warehousing and is a platform for building high-performance data integration and workflow solutions. This chapter focuses on installing the Integration Services component, saving packages, and executing packages.Chapter 6: Administering SQL Server Replication

SQL Server Replication is another way of distributing data from a source SQL Server to either one or more target SQL Servers. The chapter focuses on replication components and provides a prelude to the different types of replication scenarios a database administrator can manage, such as Snapshot, Merge, and Transactional Replication.

Step-by-step replication configurations including the new peer-to-peer replication scenario, a new form of high availability, are discussed.Part II: Managing SQL Server 2005

This part of the book covers the management of the SQL Server 2005 platform. This discussion encompasses the routine tasks needed to ensure that the platform is operating properly and at optimal levels.

This part includes topics such as conducting health checks, performing maintenance tasks, and generating indexes to keep SQL Server 2005 operating efficiently.Chapter 7: Conducting a SQL Server 2005 Health Check

On many occasions IT professionals inherit a SQL Server implementation when they join an organization or through consultants who design and implement the SQL solution at their organization. It is imperative these IT professionals manage the new SQL installation; however, they are often unaware of what to review.

This chapter focuses on how to conduct a SQL Server health check so the organization's implementation is fully optimized and adheres to industry best practices.Chapter 8: SQL Server 2005 Maintenance Practices

This chapter focuses on managing and maintaining a SQL Server environment. This discussion includes creating maintenance plans to check database integrity, shrink databases, reorganize indexes, and update statistics. Additionally, this chapter provides recommendations on daily, weekly, monthly, and quarterly maintenance practices that should be conducted on SQL Servers. This also includes managing replication.Chapter 9: Managing and Optimizing SQL Server 2005 Indexes

Similar to an index found in a book, an index in SQL Server is utilized for fast retrieval of data from tables. This chapter focuses on index concepts, ways to design the appropriate index strategy to maximize performance, and data retrieval. In addition, the chapter shares best practices on implementing, managing, and optimizing indexes.Chapter 10: Managing Full-Text Catalogs

More and more of today's applications leverage full text-search capabilities of the back-end database. This chapter covers administration concepts associated with full-text search and step-by-step instructions for performing tasks such as enabling full-text indexing, removing full-text indexing, and best practices for managing full-text indexing.Chapter 11: Creating Packages and Transferring Data

A common database administrator task is to transfer data or databases between source and target environments. This chapter focuses on importing, exporting, and transforming data and databases via SQL Server Management Studio and the newly created ETL tool, Integration Services. The chapter covers using packages to transfer data and to automate maintenance tasks.Part III: Securing the SQL Server Implementation

In this part of the book, the important topic of security is addressed.Chapter 12: Hardening a SQL Server 2005 Environment

It is imperative that database administrators secure both the SQL Server installation and the data residing in it. This chapter provides an overview on how to manage a secure SQL Server implementation based on industry best practices so that vulnerabilities and security breaches are minimized.

The following security topics are covered: reducing the attack surface, applying security to dimensions, and securing reports. This chapter goes above and beyond the database engine and also focuses on the other SQL components such as Analysis Services, Reporting Services, and Internet Information Services.Chapter 13: Administering SQL Server Security

This chapter focuses on how to administer SQL Server 2005 for role-based access and SQL authorization. This includes leveraging Active Directory to integrate the SQL Server 2005 security into the enterprise directory for single sign-on capabilities.Chapter 14: Encrypting SQL Server Data and Communications

Securing SQL Server 2005 data while it is in databases and while it is being transmitted over the network is of paramount importance. In today's highly security conscious environment, it is critical that the database platform provide mechanisms to safeguard the integrity and confidentiality of the data no matter where it is.

This chapter covers the various options and methods of ensuring the confidentiality and integrity of the data both on the server and while on the network. The chapter also covers how to integrate with Public Key Infrastructure (PKI) to effectively use certificates in securing the data.

Note - The following sections can be found online. Go to http://www.informit.com/title/9780672329562 to register your book and download these chapters.

Part IV: SQL Server 2005 OverviewChapter 15: SQL Server 2005 Technology Primer

This introductory chapter to SQL Server 2005 provides an overview of features, editions, and components. The Enterprise Edition is covered, as are the Database Services, Analysis Services, Reporting Services, Notification Services, and Integration Services.Chapter 16: Tools of the Trade

This chapter covers the tools used to administer and manage SQL Server 2005. The platform encompasses a multitude of tools, so sometimes even finding the right tool is hard, even if you know the name of the tool.

This chapter gives you a complete overview of all the tools used to administer and manage SQL. This allows you to quickly access all the tools referred to in the book and provides a detailed understanding of the arsenal of SQL tools at your disposal.Part V: Disaster Recovery and High Availability

Accidents happen, even in a perfect world. It is critical that the appropriate mechanism be put in place to ensure that SQL Server 2005 service can stay operational and recover from potential mishaps in the environment.

The chapters in this part address backup, recovery, and the various methods by which SQL Server 2005 can provide high availability.Chapter 17: Backing Up and Restoring the SQL Server 2005 Environment

This chapter focuses on backing up and restoring the SQL Server 2005 environment, which includes the database engine, Analysis Services, Integration Services, and Reporting Services.

In addition, this chapter also focuses on recovery models, backup and restore best practices, and ways to correctly leverage technologies such as restoring a database to the point of failure, conducting online restores, and creating database snapshots.Chapter 18: Administering and Managing Failover Clustering

How to configure and manage a single-instance and multiple-instance high-availability failover cluster is the main focus of this chapter. The chapter includes detailed step-by-step configurations on both single-instance and multiple-instance clusters, including building a Windows Server 2003 cluster. It also includes best practices from the field.Chapter 19: Administering and Managing Database Mirroring

Most database administrators believe database mirroring is the top new feature of SQL Server 2005. This chapter focuses on configuring and managing database mirroring so that organizations can enhance the availability of their SQL Server systems, increase business continuity, and maintain a HOT standby of their database in another geographic location. The chapter includes detailed step-by-step configurations on all three database mirroring modes: high availability, high protection, and high performance.

This chapter also includes best practices from the field, case studies, and discussions of how to integrate database mirroring with other high-availability alternatives such as failover clustering and how to recover from a failed server.Chapter 20: Administering and Managing Log Shipping

The focus of this chapter is on configuring and managing log shipping. The chapter includes step-by-step instructions on how to configure and maintain one or more "warm" standby databases typically referred to as secondary databases. Similar to the other chapters in this part, this chapter includes real-world examples and industry best practices.Part VI: Monitoring and Troubleshooting SQL Server

When SQL Server 2005 is in operation, it is critical to monitor, tune, and troubleshoot the platform. Understanding what the platform is doing and resolving issues as they arise are key for the long-term health of the database environment.Chapter 21: Monitoring SQL Server 2005

This chapter covers the native tools included with SQL Server for monitoring the SQL environment, including databases, performance, and auditing. Detailed explanations on how to utilize performance and optimization tools such as the Performance Monitor and SQL Server Profiler are included in this chapter. The chapter also covers using Operations Manager 2007 to monitor SQL Server 2005. This is Microsoft's premier tool for monitoring the Windows operating system and applications such as SQL Server 2005.Chapter 22: Performance Tuning and Troubleshooting SQL Server 2005

After the SQL Server 2005 platform is placed in operation and is being monitored, it is important to take action on the findings that are uncovered. It is often difficult to anticipate real-world loads during the development phase of application deployment; thus, it is critical to adjust the parameters of the SQL Server 2005 platform to optimize the performance after it is deployed. And frequently you need to troubleshoot the performance of SQL Server 2005 to address problems that are uncovered by the monitoring.

This chapter focuses on how to tune and troubleshoot the performance of the SQL Server 2005 platform and the specific components, including the use of the Database Engine Tuning Advisor. The chapter also covers industry best practices in tuning the SQL platform.Appendix

The appendix, "SQL Server 2005 Management and Administration," covers additional material that was not directly in line with the content of the book but that is potentially important to readers when using the examples given in the book.

The topics include the following:

  • Basic installation of SQL Server 2005 including all components

  • Installation of SQL Server 2005 Service Pack

  • Configuration of the AdventureWorks OLTP sample database

  • Configuration of the AdventureWorks OLAP sample database

  • Basic installation of Certificate Service

  • Basic installation of Operations Manger 2007

The appendix provides you with step-by-step instructions on how to conduct a basic installation of all the components that make up SQL Server 2005 and the supporting services such as certificate service. The installation is a prerequisite for following the examples in this book.

© Copyright Pearson Education. All rights reserved.

Read More Show Less

Table of Contents

Introduction 1

Part I Administering SQL Server Components

1 Administering SQL Server 2005 Database Engine 11

2 Administering SQL Server 2005 Analysis Services 67

3 Administering SQL Server 2005 Reporting Services 99

4 Administering SQL Server 2005 Notification Services 149

5 Administering SQL Server 2005 Integration Services 183

6 Administering SQL Server Replication 209

Part II Managing SQL Server 2005

7 Conducting a SQL Server 2005 Health Check 261

8 SQL Server 2005 Maintenance Practices 289

9 Managing and Optimizing SQL Server 2005 Indexes 317

10 Managing Full-Text Catalogs 353

11 Creating Packages and Transferring Data 387

Part III Securing the SQL Server Implementation

12 Hardening a SQL Server 2005 Environment 435

13 Administering SQL Server Security 469

14 Encrypting SQL Server Data and Communications 509

The following chapters are located online:

Part IV SQL Server 2005 Overview (located online)

15 SQL Server 2005 Technology Primer 537

16 Tools of the Trade 571

Part V Disaster Recovery and High Availability (located online)

17 Backing Up and Restoring the SQL Server 2005 Environment 597

18 Administering and Managing Failover Clustering 647

19 Administering and Managing Database Mirroring 691

20 Administering and Managing Log Shipping 721

Part VI Monitoring and Troubleshooting SQL Server (located online)

21 Monitoring SQL Server 2005 753

22 Performance Tuning and Troubleshooting SQL Server 2005 787

Appendix SQL Server 2005 Management and Administration 821

Read More Show Less

Customer Reviews

Average Rating 5
( 2 )
Rating Distribution

5 Star

(2)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing all of 2 Customer Reviews
  • Anonymous

    Posted March 13, 2014

    Spottedsnow

    [Okay!] ~Spottedsnow

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted March 13, 2014

    Neroclaw

    Sure.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing all of 2 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)