Buy Microsoft SQL Server High Availability - Bookswagon
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Home > Computing and Information Technology > Computer programming / software engineering > Database programming > Microsoft SQL Server High Availability
Microsoft SQL Server High Availability

Microsoft SQL Server High Availability


     0     
5
4
3
2
1



Out of Stock


Notify me when this book is in stock
X
About the Book

Offers example-based coverage for various high availability solutions. * High availability is becoming an increasingly important topic for database administrators, data architects and system architects. * Covers choosing, planning, implementing and administering a high availability solution along with the business justifications. * Paul Bertucci has over 20 years of database experience including consulting for numerous Fortune 500 companies.

Table of Contents:
Introduction.     Five 9s.     Who Is This Book's Intended Audience?     How This Book Is Organized.     Conventions Used in This Book.     Setting Your Goals High! I. UNDERSTANDING HIGH AVAILABILITY. 1. Essential Elements of High Availability.     Overview of High Availability.     Calculating "Availability".       Availability Example-A 24/7/365 Application.     Availability Continuum.     Availability Variables.     General Design Approach for Achieving High Availability.       Development Methodology with High Availability "Built In".       Assessing Existing Applications.       Service Level Agreement.     High Availability Business Scenarios (Applications).       Application Service Provider.       Worldwide Sales and Marketing-Brand Promotion.       Investment Portfolio Management.       Call Before You Dig.     Microsoft Technologies that Yield High Availability.     Summary. II. CHOOSING THE RIGHT HIGH AVAILABILITY APPROACHES. 2. Microsoft High Availability Options.     What High Availability Options Are There?       Fundamental Areas to Start With.       Fault Tolerant Disk: RAID and Mirroring.       Redundant Array of Independent Disks (RAID).       Mitigate Risk by Spreading Out Server Instances.      Building Your HA Solution with One or More of These Options.       Microsoft Cluster Services (MSCS).       SQL Clustering.       Data Replication.       Log Shipping.       Distributed Transactions.     Summary. 3. Choosing High Availability.     Moving Toward High Availability.     Step 1-Launching a Phase 0 (Zero) HA Assessment.       Resources for a Phase 0 HA Assessment.       The Phase 0 HA Assessment Tasks.     Step 2-HA Primary Variables Gauge.     Step 3-Determining the Optimal HA Solution.        A Hybrid High Availability Selection Method.       Cost Justification of a Selected High Availability Solution.       Adding HA Elements to Your Development Methodology.     Summary. III. IMPLEMENTING HIGH AVAILABILITY. 4. Microsoft Cluster Services.     Understanding Microsoft Cluster Services.     Hardware/Network/OS Requirements for MSCS.     How Clustering Actually Works.       The Disk Controller Configuration.       The Disk Configuration.       Network Configuration.       Considerations at the Operating System Level.     Installing MSCS.       Pre-installation.       Installing MSCS-Step 1.       Installing MSCS for the Next Node: Step 2.       Extending Clustering with Network Load Balancing (NLB).     Windows 2003 Options for Quorum Disks and Fail-over.     4-node and 8-node Clustering Topologies.     Summary. 5. Microsoft SQL Server Clustering.     Microsoft SQL Clustering Core Capabilities.       SQL Clustering Is Built on MSCS.       Configuring MS DTC for Use with SQL Clustering.       Laying Out a SQL Cluster Configuration.     Installing SQL Clustering.     Failure of a Node.     Removing SQL Clustering.     Client Test Program for a SQL Cluster.     A Node Recovery.     Application Service Provider-Scenario #1 with SQL Clustering.     Summary. 6. Microsoft SQL Server Log Shipping.     Microsoft Log Shipping Overview.       Data Latency and Log Shipping.       Design and Administration Implications of Log Shipping.     Setting Up Log Shipping.       Before Creating the Log Shipping DB Maintenance Plan.       Using the DB Maintenance Plan Wizard to Create.       Log Shipping.       Viewing Log Shipping Properties.       Changing the Primary Role.       Log Shipping System Stored Procedures.     Call Before You Dig-Scenario #4 with Log Shipping.     Summary. 7. Microsoft SQL Server Data Replication.     Microsoft SQL Server Data Replication Overview.     What Is Data Replication?     The Publisher, Distributor, and Subscriber Metaphor.       Publications and Articles.       Filtering Articles.     Replication Scenarios.       Central Publisher.       Central Publisher with Remote Distributor.       Publishing Subscriber.       Central Subscriber.       Multiple Publishers or Multiple Subscribers.       Updating Subscribers.     Subscriptions.       Pull Subscriptions.       Push Subscriptions.       Anonymous Subscriptions (Pull Subscriptions).     The Distribution Database.     Replication Agents.       The Snapshot Agent.       The Log Reader Agent.       The Distribution Agent.       The Merge Agent.       The Miscellaneous Agents.     Planning for SQL Server Data Replication.       Timing, Latency, and Autonomy of Data.       Methods of Data Distribution.     SQL Server Replication Types.       Snapshot Replication.       Transactional Replication.       Merge Replication.     User Requirements Drive the Replication Design.     Setting Up Replication.       Enable a Distributor.       Enable Publishing/Configure the Publisher.       Creating a Publication.       Creating Subscriptions.     Switching Over to a Warm Standby (Subscriber).       Scenarios That Will Dictate Switching to the Warm Standby.       Switching Over to a Warm Standby (Subscription).       Turning the Subscriber into a Publisher (if Needed).       Insulate the Client Using an NLB Cluster Configuration.     Scripting Replication.     Monitoring Replication.       SQL Statements.       SQL Enterprise Manager.       The Performance Monitor.       Backup and Recovery in a Replication Configuration.       Alternate Synchronization Partners.       Worldwide Sales and Marketing-Scenario #2 with Data Replication.     Summary. 8. Other Ways to Distribute Data for High Availability.     Alternate Ways to Achieve High Availability.       A Distributed Data Approach from the Outset.       Setting Up Access to Remote SQL Servers.       Querying a Linked Server.       Transact-SQL with Linked Servers.     Distributed Transactions.     MS DTC Architecture.       Two-Phase Commit Protocol.     COM+ Applications for HA.     Summary. 9. High Availability Pieced Together.     Achieving Five 9s.     Foundation First.     Assemble Your HA Assessment Team.     Set the HA Assessment Project Schedule/Timeline.     Doing a Phase 0 High Availability Assessment.       Step 1-HA Assessment.       Step 2-Primary Variable Gauge Specification.       High Availability Tasks Integrated into Your Development Life Cycle.     Selecting the HA Solution.     Is the HA Solution Cost Effective?     Summary. 10. High Availability Design Issues and Considerations.     Things to Consider for High Availability.       Hardware/OS/Network Design Considerations.       Remote Mirroring.       Microsoft Cluster Services Design Considerations.       SQL Server Clustering Design Considerations.       Stretch Clustering.       SQL Server Data Replication Design Considerations.       SQL Server Log Shipping Design Considerations.       Distributed Transaction Processing Design Considerations.     General SQL Server File/Device Placement Recommendations.     Database Backup Strategies in Support of High Availability.       Two Backup Approaches for High Availability.       Parallel Striped Backup.       Split-Mirror Backups (Server-less Backups).       Volume Shadow Copy Service (VSS).       Monitoring/Verifying Backups.     Disaster Recovery Planning.       The Overall Disaster Recovery Approach.       The Focus for Disaster Recovery.       Documenting Environmental Details Using SQLDIAG.EXE.       Plan and Execute a Complete Disaster Recovery test.     Software Upgrade Considerations.     High Availability and MS Analysis Services/OLAP.       OLAP Cubes Variations.       Recommended MSAS Implementation for High Availability.     Alternative Techniques in Support of High Availability.       Data Transformation Service (DTS) Packages Used to Achieve HA.       Have You Detached a Database Recently?       Third-party Alternatives to High Availability.       IBM/DB2 High Availability Example.     Summary. 11. High Availability and Security.     Security Breakdowns' Effect on High Availability.       Using an Object Permissions and Roles Method.       Object Protection Using Schema-Bound Views.     Proper Security in Place for HA Options.       MSCS Security Considerations.       SQL Clustering Security Considerations.       Log Shipping Security Considerations.       Data Replication Security Considerations.       General Thoughts on Database Backup/Restore.       Isolating SQL Roles, and Disaster Recovery Security Considerations.     Summary. 12. Future Directions of High Availability.     Microsoft Stepping Up to the Plate.     What's Coming in Yukon for High Availability?       Enhancements in Fail-over Clustering (SQL Clustering).       Database Mirroring for Fail-over.       Combining Fail-over and Scale Out Options.     Data Access Enhancements for Higher Availability.     High Availability from the Windows Server Family Side.       Microsoft Virtual Server 2005.       Virtual Server 2005 and Disaster Recovery.     Other Industry Trends in High Availability.     Summary. Index.

About the Author :
Microsoft SQL Server High AvailabilityAbout the Author Paul Bertucci is the founder of Database Architechs (http://www.dbarchitechs.com) a database consulting firm with offices in the United States and Paris, France. He has more than 24 years of experience doing database design, data architecture, data replication, performance and tuning, distributed data systems, data integration, high availability assessments, and systems integration for numerous Fortune 500 companies including Intel, 3COM, Coca-Cola, Apple, Toshiba, Lockheed, Wells Fargo, Safeway, Texaco, Charles Schwab, Cisco Systems, Sybase, and Honda, to name a few. He has authored numerous articles, standards, and high profile courses such as Sybase's "Performance and Tuning" and "Physical Database Design" courses. Other Sams books that he has authored include the highly popular Microsoft SQL Server 2000 Unleashed and ADO.NET in 24 Hours. He has deployed numerous systems with MS SQL Server, Sybase, DB2, and Oracle database engines, and has designed/architected several commercially available tools in the database, data modeling, performance and tuning, data integration, and multi-dimensional planning spaces. Paul also serves part time as CTO for a strategic planning software company and part time as chief technical advisor for a data integration server software company. Paul received his formal education in computer science and electrical engineering from UC Berkeley (Go Bears!). He lives in northern California with his wife, Vilay, and five children, Donny, Juliana, Paul Jr., Marissa, and Nina. Paul can be reached at pbertucci@dbarchitechs.com or by phone at 925-674-0000. © Copyright Pearson Education. All rights reserved.


Best Sellers


Product Details
  • ISBN-13: 9780768665956
  • Publisher: Pearson Education (US)
  • Publisher Imprint: Sams Publishing
  • Language: English
  • Weight: 1 gr
  • ISBN-10: 0768665957
  • Publisher Date: 05 Nov 2004
  • Binding: Digital download
  • No of Pages: 456


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
Microsoft SQL Server High Availability
Pearson Education (US) -
Microsoft SQL Server High Availability
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

Microsoft SQL Server High Availability

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    Fresh on the Shelf


    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!