25 Books to Read Before You Die
 
 

Recently Viewed clear list


The Powell's Playlist | August 8, 2014

Peter Mendelsund: IMG The Powell's Playlist: Water Music by Peter Mendelsund



We "see" when we read, and we "see" when we listen. There are many ways in which music can create the cross-sensory experience of this seeing...... Continue »
  1. $11.87 Sale Trade Paper add to wish list

spacer

Beginning SQL Server 2005 Administration

by

Beginning SQL Server 2005 Administration Cover

 

Synopses & Reviews

Publisher Comments:

For the first time, SQL Server 2005 provides features that can support large-scale enterprise databases. With this powerful new release, you may find yourself being called upon to perform duties that are no longer strictly "administrative," duties that have become much more complicated and difficult. With that in mind, a team of experienced Microsoft Certified Professionals provides you with the necessary information to be a more competent and successful database developer or administrator.

Beginning with a foundation that features detailed coverage of typical administrative duties, the authors proceed to explain how to build complex data transformations for data import, build distributed data solutions, and maintain the security and integrity of the database. You will be able to apply what you learn to real-world scenarios, and smoothly navigate the vastly changed landscape of SQL Server 2005 administration.

What you will learn from this book

  • How to install, maintain, and manage an SQL Server 2005 installation, including high availability and security considerations
  • Various features such as the Common Language Runtime, SQL Server Integration Services, Notification Service, and the Service Broker
  • How to use the tools that are necessary to manage configuration, backups, restores, security, availability, performance, and monitoring
  • A sampling of some of the more advanced areas and complex jobs of the broadening role of a database administrator in the enterprise

Who this book is for

This book is for both developers and administrators who are responsible for the management and maintenance of an SQL Server 2005 database. Familiarity with relational database concepts and SQL is assumed.

Wrox Beginning guidesare crafted to make learning programming languages and technologies easier than you think, providing a structured, tutorial format that will guide you through all the techniques involved.

Enhance Your Knowledge Advance Your Career

Synopsis:

* The complete overhaul of the 2005 release of SQL Server poses challenges for even the most experienced SQL Server DBAs-this book shows both novices and seasoned DBAs how to navigate the vastly changed landscape of SQL Server administration

* Each chapter begins with a quick overview of the related technologies, followed by a real-world example, with step-by-step instructions that demonstrate how to leverage the technology

* Covers system installation and configuration, optimizing and ensuring high availability, disaster prevention and recovery, managing EndPoints, and performance monitoring, as well as specialized topics such as SQL Server integration services, notification services, and Common Language Runtime

* The companion Web site provides all of the code examples for download, plus links to useful sites

Synopsis:

Enhance Your Knowledge Advance Your Career

Synopsis:

For the first time, SQL Server 2005 provides features that can support large-scale enterprise databases. With this powerful new release, you may find yourself being called upon to perform duties that are no longer strictly "administrative," duties that have become much more complicated and difficult. With that in mind, a team of experienced Microsoft Certified Professionals provides you with the necessary information to be a more competent and successful database developer or administrator.

Beginning with a foundation that features detailed coverage of typical administrative duties, the authors proceed to explain how to build complex data transformations for data import, build distributed data solutions, and maintain the security and integrity of the database. You will be able to apply what you learn to real-world scenarios, and smoothly navigate the vastly changed landscape of SQL Server 2005 administration.

What you will learn from this book

  • How to install, maintain, and manage an SQL Server 2005 installation, including high availability and security considerations
  • Various features such as the Common Language Runtime, SQL Server Integration Services, Notification Service, and the Service Broker
  • How to use the tools that are necessary to manage configuration, backups, restores, security, availability, performance, and monitoring
  • A sampling of some of the more advanced areas and complex jobs of the broadening role of a database administrator in the enterprise

Who this book is for

This book is for both developers and administrators who are responsible for the management and maintenance of an SQL Server 2005 database. Familiarity with relational database concepts and SQL is assumed.

Wrox Beginning guides are crafted to make learning programming languages and technologies easier than you think, providing a structured, tutorial format that will guide you through all the techniques involved.

Enhance Your Knowledge Advance Your Career

About the Author

Dan Wood (Silverdale, WA) is an Operations Manager and DBA, Microsoft SQL Server Specialist and Trainer for Netdesk Corporation, a Microsoft Gold Certified Partner for Learning Solutions. Dan has been a Microsoft Certified Professional and Trainer since 1999; he is co-author of Beginning Transact-SQL from WROX.  

Chris Leiter (Kent, WA) is a Trainer for Netdesk Corporation.  Chris’s role at Netdesk is focused on Systems Administration and Security.  Chris has been a Microsoft Certified Professional since 1997, and a Trainer since 2001.  

Paul Turley (Seattle, WA) is a Senior Consultant for Hitachi Consulting, where he architects and develops database systems.  He has been a Microsoft Certified Professional and Trainer since 1996, and lead author of Beginning Transact-SQL With SQL Server 2000 and 2005, Professional SQL Server Reporting Services (1st and 2nd editions), and other Wrox database titles.

Table of Contents

Introduction.

Who This Book Is For.

What This Book Covers.

How This Book Is Structured.

What You Need to Use This Book.

Conventions.

Source Code.

Errata.

p2p.wrox.com.

Chapter 1: Introducing SQL Server 2005.

What Is SQL Server 2005?

SQL Server 2005 Editions.

SQL Server 2005 Architecture.

SQL Server 2005 Database Objects.

SQL Server 2005 Databases.

SQL Server 2005 Database Storage.

SQL Server Security.

A (Very) Brief History of SQL Server.

Summary.

Chapter 2: Installing SQL Server 2005.

SQL Server Installation Planning.

SQL Server Setup Application.

Installation Review.

Summary.

Chapter 3: SQL Server 2005 Tools.

SQL Server Management Studio.

Log File Viewer.

SQL Server Business Intelligence Development Studio.

SQL Server Profiler.

Database Engine Tuning Advisor.

SQL Server Configuration Manager.

Reporting Services Configuration Manager.

Command-Line Tools.

Summary.

Chapter 4: SQL Server 2005 Storage Architecture.

The Resource Database.

SQL Server Database Physical Structure.

Summary.

Chapter 5: SQL Server 2005 Databases.

System Databases.

User Databases.

Database Planning.

Creating Databases.

Database Diagrams.

Views.

Synonyms.

Programming Objects.

Summary.

Chapter 6: SQL Server 2005 Security.

SQL Server Authentication Modes.

Principals.

Permissions.

SQL Server Encryption.

Best Practices.

Summary.

Exercises.

Chapter 7: Configuring SQL Server Network Communication.

SQL Server 2005 Network Protocols.

SQL Native Client Configuration.

SQL Server Endpoints.

Summary.

Chapter 8: Automating Administrative Tasks.

Database Mail.

Event Notifications.

SQL Server Agent.

Maintenance Plans.

Best Practices.

Summary.

Exercises.

Chapter 9: Disaster Prevention and Recovery.

Preparing the SmallWorks Database.

Database Recovery Models.

SQL Server 2005 Database Backup.

SQL Server 2005 Backup Types.

Backup Options.

Backup Strategies.

Restoring Databases.

Database Snapshots.

Summary.

Chapter 10: Monitoring SQL Server for Performance.

Monitoring and Optimization Overview.

Tools and Techniques for Monitoring Performance.

Monitoring Database Modifications.

Summary.

Chapter 11: SQL Server High Availability.

Introduction to Availability.

Failover Clustering.

Log Shipping.

Database Mirroring.

Summary.

Chapter 12: Administering SQL CLR Programming Objects.

Databases and Programming.

Is the SQL Language a Relic?

.Net and the CLR.

SQL Server CLR Objects.

Code-Generation Features in Visual Studio.

Programming Support.

Security Options.

Summary.

Chapter 13: Introduction to SQL Server 2005 Integration Services.

About SSIS.

Importing and Exporting Data.

Transforming Data with SSIS.

Summary.

Chapter 14: Introduction to SQL Server 2005 Notification Services.

Overview.

Introduction to the Notification Services Architecture.

Installing a Notification Services Application.

Summary.

Chapter 15: Introduction to the Service Broker.

Service-Oriented Architecture.

Service Broker Overview.

Service Broker Elements.

Security Considerations for Service Broker.

Creating a Sample Application.

Summary.

Chapter 16: Introduction to Replication.

Replication Overview.

SQL Server Replication Agents.

SQL Server Replication Types.

SQL Server Replication Models.

Replication Tools.

Summary.

Appendix A: Exercise Answers.

Index.

Product Details

ISBN:
9780470047040
Author:
Wood, Dan
Publisher:
Wrox
Author:
Turley, Paul
Author:
l, Chris
Author:
Leiter, Chris
Author:
eiter
Subject:
Database Management - General
Subject:
Database management
Subject:
Database Management - SQL Server
Subject:
Database-SQL
Subject:
Database & Data Warehousing Technologies
Subject:
Programming
Subject:
Database design
Copyright:
Edition Description:
WebSite Associated w/Book
Series:
Wrox Beginning Guides
Publication Date:
20070212
Binding:
Electronic book text in proprietary or open standard format
Grade Level:
General/trade
Language:
English
Illustrations:
Y
Pages:
574
Dimensions:
233.7 x 188 x 33.5 mm 32 oz

Other books you might like

  1. Professional SQL Server 2005...
    Used Trade Paper $16.95
  2. Professional IIS 7 (Programmer to... Used Trade Paper $25.00

Related Subjects

Computers and Internet » Artificial Intelligence » General
Computers and Internet » Database » Applications
Computers and Internet » Database » Design
Computers and Internet » Software Engineering » Software Management

Beginning SQL Server 2005 Administration Used Trade Paper
0 stars - 0 reviews
$17.50 In Stock
Product details 574 pages Wrox Press - English 9780470047040 Reviews:
"Synopsis" by , * The complete overhaul of the 2005 release of SQL Server poses challenges for even the most experienced SQL Server DBAs-this book shows both novices and seasoned DBAs how to navigate the vastly changed landscape of SQL Server administration

* Each chapter begins with a quick overview of the related technologies, followed by a real-world example, with step-by-step instructions that demonstrate how to leverage the technology

* Covers system installation and configuration, optimizing and ensuring high availability, disaster prevention and recovery, managing EndPoints, and performance monitoring, as well as specialized topics such as SQL Server integration services, notification services, and Common Language Runtime

* The companion Web site provides all of the code examples for download, plus links to useful sites

"Synopsis" by , Enhance Your Knowledge Advance Your Career
"Synopsis" by , For the first time, SQL Server 2005 provides features that can support large-scale enterprise databases. With this powerful new release, you may find yourself being called upon to perform duties that are no longer strictly "administrative," duties that have become much more complicated and difficult. With that in mind, a team of experienced Microsoft Certified Professionals provides you with the necessary information to be a more competent and successful database developer or administrator.

Beginning with a foundation that features detailed coverage of typical administrative duties, the authors proceed to explain how to build complex data transformations for data import, build distributed data solutions, and maintain the security and integrity of the database. You will be able to apply what you learn to real-world scenarios, and smoothly navigate the vastly changed landscape of SQL Server 2005 administration.

What you will learn from this book

  • How to install, maintain, and manage an SQL Server 2005 installation, including high availability and security considerations
  • Various features such as the Common Language Runtime, SQL Server Integration Services, Notification Service, and the Service Broker
  • How to use the tools that are necessary to manage configuration, backups, restores, security, availability, performance, and monitoring
  • A sampling of some of the more advanced areas and complex jobs of the broadening role of a database administrator in the enterprise

Who this book is for

This book is for both developers and administrators who are responsible for the management and maintenance of an SQL Server 2005 database. Familiarity with relational database concepts and SQL is assumed.

Wrox Beginning guides are crafted to make learning programming languages and technologies easier than you think, providing a structured, tutorial format that will guide you through all the techniques involved.

Enhance Your Knowledge Advance Your Career

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.