Microsoft Sql Server 2008 High Availability

( 1 )

Overview

If you are an SQL Server developer, system administrator, or even novice DBA, this book is for you. You only need a basic understanding of how SQL Server works to get you through the installation of SQL Server HA. With clear step-by-step instructions, real-world examples, and plenty of screenshots, this book provides all the support and guidance you will need as you install SQL Server HA options. It starts with an introductory chapter about the Windows domain, domain users, and the handshake methods available ...
See more details below
Paperback
$48.18
BN.com price
(Save 3%)$49.99 List Price
Other sellers (Paperback)
  • All (4) from $51.98   
  • New (3) from $52.32   
  • Used (1) from $51.98   
Sending request ...

Overview

If you are an SQL Server developer, system administrator, or even novice DBA, this book is for you. You only need a basic understanding of how SQL Server works to get you through the installation of SQL Server HA. With clear step-by-step instructions, real-world examples, and plenty of screenshots, this book provides all the support and guidance you will need as you install SQL Server HA options. It starts with an introductory chapter about the Windows domain, domain users, and the handshake methods available with Windows server and covers the different authentication methods available with SQL Server, giving you an insight into the importance of security. Then your journey to installing SQL Server HA starts, covering the concepts of database mirroring, log shipping, clustering, and replication. One appendix covers troubleshooting common issues you may encounter while installing or managing the HA options in your environment; a second appendix provides references to external resources.
Read More Show Less

Product Details

  • ISBN-13: 9781849681223
  • Publisher: Packt Publishing
  • Publication date: 1/20/2011
  • Pages: 308
  • Product dimensions: 7.50 (w) x 9.25 (h) x 0.65 (d)

Meet the Author

Hemantgiri is an SQL Server consultant based in Surat, India. He has been a Microsoft SQL Server MVP three years running; he also moderates multiple SQL Server community forums including sql-server-performance.com and sqlserver-qa.net. He actively participates and speaks at local user group events organized under the aegis of surat-user-group.org, DotNetChaps and CSI Surat chapters, of which he is a founding and active member. He regularly publishes articles on his blog space sql-server-citation.com. He has recently taken up a new initiative – blogging about SQL in his native language Gujarati through his blog sqlservercitation-gujarati.blogspot.com

He has more than 11 years of experience in the IT industry, of which nine years have been as a hard-core DBA focusing on the High Availability area. During his career, he has worked with the top five IT giants of India. In addition to SQL Server, Hemantgiri also possesses excellent knowledge of Windows Server OS(s) and Networking. In his free time, he prefers to watch cartoons, read, and sometimes sketches.

You can reach him via his blog, sql-server-citation.com, twitter, twitter.com/ghemant, or by writing to him at Hemantgiri [at] sql-server-citation.com.

Read More Show Less

Customer Reviews

Average Rating 4
( 1 )
Rating Distribution

5 Star

(0)

4 Star

(1)

3 Star

(0)

2 Star

(0)

1 Star

(0)
Sort by: Showing 1 Customer Reviews
  • Posted Thu Apr 28 00:00:00 EDT 2011

    more from this reviewer

    not simple

    This is not simple.

    The book reflects in part Microsoft's attempt to move further into the data center. For this, high availability is a must. But the underlying technical implications are intricate. An easy way to see this is to turn to Chapter 2. It describes how to install the cluster that makes high availability via ideas like replication. The GUI that Microsoft offers hints at the many details. Then look at the description of how to do this via the command line prompt. Much more compact than the GUI approach. Yet the verbosity of the command line is impressive, and it shows the fragility of trying to type this correctly.

    Going further in Chapter 2, there is the method of installing using an autogenerated Configuration file. It's a flat file, with no (apparent) internal structure beyond 'variable=value' on each executable line. Each variable is minimally documented by a few (well usually just 1) accompanying comment line.

    If you compare the Configuration file with the command line example, the latter now seems far too short! It must have assumed defaults for many variables. For the hard core analysts, tweaking the Configuration file may be the best way to experiment with your cluster.

    Later chapters go further into more details about how a cluster can be structured. Several types of replication are offered, and the discussion encompasses about half the book.

    The chapter about the Log shipping is pretty simple to follow. This is where logs are copied from a primary source to a secondary source, so that the latter can take over if the first fails. Important. But you should spend more of your time on the other, harder parts of the text.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing 1 Customer Reviews

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