THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Sample Chapters

A blog for sample chapters for SQL Server related books from a variety of publishers.

  • Sample Chapter: "Pro SQL Server Disaster Recovery", Chapter 1: "What is Disaster Recovery?"

    Go to File Gallery to Download

    Many would argue that the single, most important job of a SQL Server database administrator is to be able to recover your database in the event of loss or damage. Pro SQL Server Disaster Recovery helps you meet that goal by showing you how to think about and plan for potential problems. You’ll learn to anticipate and reduce the likelihood of a disaster, and to mitigate the effects of a disaster when one does occur. Perhaps most importantly, you’ll learn how to prepare so that you can return a system to its normal state quickly, ensuring system availability and the continued success and operation of your business.

    Many SQL Server features and technologies are, or can be put to good use in disaster recovery planning. In this book, you’ll learn about powerful tools and features — such as Database Snapshots and Mirroring — for data backup and disaster recovery that are present in SQL Server 2005, and that are enhanced in SQL Server 2008. Also covered are common issues to expect when using these features. This book explores your options by examining the technical details of disaster recovery features and then applying that knowledge to practical scenarios.

    There’s a human side to disaster recovery planning as well. Like few other activities, disaster recovery planning requires that you work closely with a wide variety of people from all across your organization. People skills are as critical to disaster recovery planning as technical skills, and perhaps more so. This book does not leave you in the dark, but provides sound advice on how to keep disaster recovery planning projects on track, how to avoid dangerous scope creep, and how to work effectively with the variety of personality types that you will encounter.

    Disaster recovery planning is really about sleep. When you get the call at 3:00 am that your database is lost, don’t wake up with that icy feeling in your veins. Instead wake up with confidence that you have a plan in place, a plan that you’ve practiced, that management has bought into, a plan that you can execute even while half–asleep to get your database, your company, and your job back on track.

    What you’ll learn

    This book shows you how to implement an effective disaster recovery strategy for SQL Server 2005 databases. It covers:

    • Real–world examples of data loss and what might have been done to prevent it
    • A systematic, problem–based approach to designing a disaster recovery plan
    • Pitfalls one might encounter, and how to deal with them
    • Team dynamics, and the soft–side of disaster planning
    • New technology in SQL Server 2005 and 2008 that takes disaster recovery beyond the simple backup/recovery plan
    • When and why to use disaster recovery features, as opposed to just describing how they work

    Go to File Gallery to Download

  • Sample Chapter: "System Center Operations Manager 2007 Unleashed", Chapter 3: "Looking Inside OpsMgr"

    Go to File Gallery to Download

    System Center Operations Manager 2007 Unleashed is a comprehensive guide to System Center Operations Manager (OpsMgr) 2007. Like its MOM 2005 predecessor, OpsMgr 2007 helps you implement operations management, but with a far different and more holistic approach from MOM 2005’s focus on individual servers.


    This book guides you through designing, deploying, and configuring OpsMgr 2007. You will find detailed information and hands-on experience on topics such as estimating database sizes and designing redundant OpsMgr configurations. You learn how to tackle challenges such as setting up ACS, establishing client monitoring, using and creating synthetic transactions and distributed applications, and developing management packs and reports.


    • Size your OpsMgr databases
    • Architect for redundancy and performance
    • Install or migrate to OpsMgr 2007
    • Secure OpsMgr
    • Back up OpsMgr components
    • Understand how monitors and rules work
    • Manage different aspects, including ACS, client monitoring, synthetic transactions, and distributed applications
    • Extend OpsMgr
    • Develop management packs and reports

    Go to File Gallery to Download

  • Sample Chapter: "Building a Data Warehouse: With Examples in SQL Server", Chapter 1: "Introduction to Data Warehousing"

    Go to File Gallery to Download

    Building a Data Warehouse: With Examples in SQL Server describes how to build a data warehouse completely from scratch and shows practical examples on how to do it. Author Vincent Rainardi also describes some practical issues he has experienced that developers are likely to encounter in their first data warehousing project, along with solutions and advice. The RDBMS used in the examples is SQL Server; the version will not be an issue as long as the user has SQL Server 2005 or later.

    The book is organized as follows. In the beginning of this book (Chapters 1 through 6), you learn how to build a data warehouse, for example, defining the architecture, understanding the methodology, gathering the requirements, designing the data models, and creating the databases. Then in Chapters 7 through 10, you learn how to populate the data warehouse, for example, extracting from source systems, loading the data stores, maintaining data quality, and utilizing the metadata. After you populate the data warehouse, in Chapters 11 through 15, you explore how to present data to users using reports and multidimensional databases and how to use the data in the data warehouse for business intelligence, customer relationship management, and other purposes. Chapters 16 and 17 wrap up the book: After you have built your data warehouse, before it can be released to production, you need to test it thoroughly. After your application is in production, you need to understand how to administer data warehouse operation.

    What you’ll learn

    • A detailed understanding of what it takes to build a data warehouse
    • The implementation code in SQL Server to build the data warehouse
    • Dimensional modeling, data extraction methods, data warehouse loading, populating dimension and fact tables, data quality, data warehouse architecture, and database design
    • Practical data warehousing applications such as business intelligence reports, analytics applications, and customer relationship management

    Who is this book for?

    There are three audiences for the book. The first are the people who implement the data warehouse. This could be considered a field guide for them. The second is database users/admins who want to get a good understanding of what it would take to build a data warehouse. Finally, the third audience is managers who must make decisions about aspects of the data warehousing task before them and use the book to learn about these issues.

    Go to File Gallery to Download

Privacy Statement