- 56 SQL Server Disaster Recovery Planning 2329 What’s New in SQL Server Disaster Recovery Planning...2330. - Microsoft SQL Server Options for Disaster Recovery . - Ray has been working with Sybase and Microsoft SQL Server for more than 23 years and has experience in database administra- tion, database design, project management, application development, consulting, course- ware development, and training. - Ray is coauthor of Microsoft SQL Server 2005 Unleashed, Microsoft SQL Server 2000 Unleashed (first and second editions), Microsoft SQL Server 6.5 Unleashed (all editions), Sybase SQL Server 11 Unleashed, and Sybase SQL Server 11 DBA Survival Guide, Second Edition, all published by Sams Publishing. - Paul Bertucci is the founder of Database Architechs (www.dbarchitechs.com), a global database consulting firm with offices in the United States and Paris, France. - Other Sams Publishing books that he has authored or coauthored include the highly popular Microsoft SQL Server 2000 Unleashed, ADO.NET in 24 Hours, Microsoft SQL Server High Availability, and Microsoft SQL Server 2005 Unleashed.. - Paul is a frequent speaker at industry conferences such as Informatica World, Oracle World, MDM Summits, and Microsoft-oriented conferences such as SQL Saturday’s, PASS conferences, Tech Ed’s, and SQL Server User Groups. - He has deployed numerous systems with Microsoft SQL Server, Sybase, DB2, Postgres, MySQL, and Oracle database engines, and he has designed/architected several commercially available tools in the database, data modeling, performance and tuning, data integration, digital DNA, and multidimensional planning spaces. - He lives in the great Pacific northwest (Oregon) with his five children, Donny, Juliana, Nina, Marissa, and Paul Jr. - consulting services in the areas of database administration, database tuning, and database programming using Microsoft Visual Studio. - Chris has more than 15 years of experience with SQL Server and more than 25 years in the field of information technology. - Other Sams Publishing books that he has coauthored include Microsoft SQL Server 2000 Unleashed and Microsoft SQL Server 2005 Unleashed. - He specializes in designing SQL Server and Microsoft .NET–powered solutions using the principles of agile development and the Rational Unified Process. - He was also a coauthor for Microsoft SQL Server 2005 Unleashed and a contributing author for Microsoft SQL Server 2000 Unleashed, both published by Sams Publishing. - Hilary Cotter is a SQL Server MVP with more than 20 years of IT experience working for Fortune 500 clients. - He is the author of a book on SQL Server Replication and coauthor of Microsoft SQL Server 2008 Management and Administration from Sams Publishing. - Hilary has also written numerous white papers and articles on SQL Server and databases.. - I would like to dedicate this book in loving memory of my grand- mother, Gertrude Holdridge, who recently passed away at the. - This book is dedicated to my Mom and Dad. - Her love, kindness, and relentless support have helped me in all aspects of my life, including the creation of this book. - My work on this book is dedicated to my father, Harry Silverstein, a fellow man of letters. - I would also like to thank Neil Rowe at Sams Publishing for providing us the opportunity to write this book and for his seemingly infinite patience as we repeat- edly missed our deadlines.. - I would also like to acknowledge my colleague and friend David Solomon for developing the Word macro used to extract the code listings and examples presented in the chapters so we could make them available on the included CD. - “Administering Policy Based Management” and “Automating SQL Server Tasks Using PowerShell” chapters.. - However, with sacrifice also comes reward in the form of technical excellence and high- quality business relationships. - I would also like to thank many of my clients who embraced SQL Server 2008 and gave me the opportunity to use it in the real world. - Spruce has had tremendous success with SQL Server 2005 and SQL Server 2008.. - I would like to acknowledge the following people for helping make my contribution to this book possible: Ray Rankins, Paul Bertucci, Chris Gallelli, Neil Rowe, Gregory. - You can email or write me directly to let me know what you did or didn’t like about this book—as well as what we can do to make our books stronger.. - When you write, please be sure to include this book’s title and author as well as your name and phone or email address. - Visit our website and register this book at informit.com/register for convenient access to any updates, downloads, or errata that might be available for this book.. - O ver the past decade, SQL Server has established itself as a robust and reliable database platform whose performance, scalability, and reliability meet the implementation needs of businesses and corporations from small desktop applications on up to multiterabyte enterprise-wide systems. - The updates and enhancements in SQL Server 2008 and SQL Server 2008 R2 further solidify its position in the marketplace as a robust enterprise-wide database system that can compete on the same level as the other major enterprise-wide database products, providing a database engine foundation that can be highly available 7 days a week, 365 days a year.. - The position of SQL Server 2008 as a leader in the market of enterprise-wide data- base management systems (DBMS) was confirmed in a report released by Forrester Research on June 30, 2009 (The Forrester Wave: Enterprise Database Management Systems, Q2 2009). - In this report, Forrester analyst Noel Yuhanna indicated that Microsoft along with Oracle and IBM DB2 were the leaders in the DBMS market. - The report from Forrester Research indicated that Microsoft’s strong commitment to its data platform starting with SQL Server 2005 and continuing with the latest iteration of the product, SQL Server 2008, had boosted Microsoft to the top of the DBMS market.. - Key findings in the report concluded that Microsoft received high scores in database programmability, security, availability, and application/data integration, and for deliver- ing the best price performance for most business applications. - The report also acknowledged that Microsoft “has shown increasing focus and commitment to going after the enterprise market,” and that SQL Server 2008 has “enabled Microsoft to take market share in moderately sized to large enterprises, delivering good perfor- mance, scalability, security, and availability functionality.” The report also indicated that. - “five years ago, hardly any enterprises ran multi-terabyte databases with SQL Server to support critical applications. - Today, hundreds of enterprises are running 10-terabyte and larger transactional SQL Server databases.”. - One of the biggest challenges we face writing the SQL Server Unleashed series of books is how to provide comprehensive, in-depth, all-inclusive coverage of all the features of SQL Server within a single book. - Over the past few releases, the number of SQL Server features and components has increased, and many of these features and components (for. - example, SQL Server Integration Services, Reporting Services, and .NET Framework inte- gration) provide material enough to warrant their own separate titles. - ptg and tools of SQL Server 2008 and 2008 R2. - At the same time, there is a wealth of useful information we want to provide on additional SQL Server 2008 features and major components of SQL Server, such as SQL Server Integration Services, Reporting Services, Analysis Services, T-SQL programming, and SQL Server integration with the .NET Framework. - Rather than leave this valuable information out entirely, we decided to include the chapters with this mater- ial on the CD provided with this book. - Also, as in the past, the CD contains all our sample scripts, databases, and other code samples and material that support the book content.. - Our other main goal when writing this book was for it to be more than just a syntax reference. - SQL Server Books Online is a fine resource as a syntax reference. - This book attempts to pick up where Books Online leaves off, by providing, in addition to syntax where necessary, valuable insight, tips, guidelines, and useful examples derived from our many years of experience working with SQL Server. - Although we do provide the core, and sometimes advanced, syntax elements for the SQL commands discussed, SQL Server Books Online provides a much more extensive syntax reference than would make sense to try to duplicate here. - We hope that we have succeeded in meeting the goals we set out for this book and that it becomes an essential reference and source of expert information for you as you work with the either version of SQL Server 2008.. - Although this book includes coverage of SQL Server 2008 R2, most of the material presented applies to SQL Server 2008 as well. - Actually, there are few significant differ- ences in the core product between SQL Server 2008 and SQL Server 2008 R2. - You can be comfortable using this book as a reference for either version of SQL Server 2008.. - When the book discusses features available only in the R2 release, this fact is specifi- cally spelled out in the chapter.. - Who This Book Is For. - This Unleashed book is intended for intermediate- to advanced-level users: for SQL Server administrators who want to understand SQL Server more completely to be able to effec- tively manage and administer their SQL Server environments, and for developers who want a more thorough understanding of SQL Server to help them write better Transact- SQL (T-SQL) code and develop more robust SQL Server applications. - If you are responsible for analysis, design, implementation, support, administration, or troubleshooting of SQL Server 2008, this book provides an excellent source of experiential information for you.. - SQL Server, analyzing and optimizing queries, implementing data warehouses, ensuring high availability, and tuning SQL Server performance.. - This book is for both developers and SQL Server administrators who are new to SQL Server 2008 or SQL Server 2008 R2 as well as those who are already familiar with prior versions of SQL Server. - At the beginning of each chapter is a brief summary of the major changes or new features or capabilities of SQL Server related to that topic. - If you are already familiar with SQL Server, you can use this information to focus on the informa- tion in the chapters that covers the new features and capabilities in more detail.. - This book is intended to provide a behind-the-scenes look into SQL Server, showing you what goes on behind the various wizards and GUI-based tools so you can learn what the underlying SQL commands are. - Although the GUI tools can make your average day-to- day operations much simpler, every database administrator should learn the underlying commands to the tools and wizards to fully unlock the power and capabilities of SQL Server.. - What This Book Covers. - Part I, “Welcome to Microsoft SQL Server”—This part introduces you to the Microsoft SQL Server 2008 environment, the various editions of SQL Server that are available, and the capabilities of each edition in the various Windows environ- ments. - In addition, it provides an overview of and introduction to the new features found in SQL Server 2008 and SQL Server 2008 R2, which are covered in more detail throughout the rest of the book.. - Part II, “SQL Server Tools and Utilities”—This part covers the tools and utility programs that SQL Server 2008 provides for you to administer and manage your SQL Server environments. - You’ll find information on the various management tools you use on a daily basis, such as SQL Server Management Studio and the new SQLCMD command-line query tool, along with information on SQL Server Profiler.. - If you are not familiar with these tools, you should read this part of the book early on because these tools are often used and referenced throughout many of the other chapters in the book.. - Part III, “SQL Server Administration”—This part discusses topics related to the administration of SQL Server at the database server level. - It begins with an overview of what is involved in administering a SQL Server environment and then goes on to cover the tasks related to setting up and managing the overall SQL Server environ- ment, including installing and upgrading to SQL Server 2008 and SQL Server 2008 R2 as well as installing SQL Server clients
Xem thử không khả dụng, vui lòng xem tại trang nguồn hoặc xem
Tóm tắt