Apress (7-2009) | PDF | 424 pages | 1430219661 | 11.0Mb(rar)

Pro SQL Server 2008 Failover Clustering /by Allan Hirt (Author) .Pro SQL Server 2008 Failover Clustering is dedicated to the planning, implementation, and administration of clustered SQL Server 2008 implementations. Whether deploying a single–instance, two–node cluster or a multiple–node, many–instance cluster for consolidation, this book will detail all of the considerations and pitfalls that may be encountered along the way.

Clustering and high–availability expert Allan Hirt shares his many years of wisdom and experience, showing how to put together the right combination of people, processes, technology, and best practices to create and manage world–class, highly available SQL Server 2008 failover clusters.
* Provides a comprehensive look at SQL Server 2008 failover clustering from the first steps of planning to daily administration
* Goes beyond just SQL Server 2008 and also covers Windows Server 2008 clustering in depth with a SQL Server focus
* Covers how and where virtualization can be used with failover clusters
* Addresses the needs of enterprise–class, 24/7 SQL Server 2008 implementations
* Written by the leading expert on SQL Server failover clustering

 

Learning SQL (second edition) /by Alan Beaulieu (Author) .Updated for the latest database management systems -- including MySQL 6.0, Oracle 11g, and Microsoft's SQL Server 2008 -- this introductory guide will get you up and running with SQL quickly. Whether you need to write database applications, perform administrative tasks, or generate reports, Learning SQL, Second Edition, will help you easily master all the SQL fundamentals.
Each chapter presents a self-contained lesson on a key SQL concept or technique, with numerous illustrations and annotated examples. Exercises at the end of each chapter let you practice the skills you learn. With this book, you will:
* Move quickly through SQL basics and learn several advanced features
* Use SQL data statements to generate, manipulate, and retrieve data
* Create database objects, such as tables, indexes, and constraints, using SQL schema statements
* Learn how data sets interact with queries, and understand the importance of subqueries
* Convert and manipulate data with SQL's built-in functions, and use conditional logic in data statements
Knowledge of SQL is a must for interacting with data. With Learning SQL, you'll quickly learn how to put the power and flexibility of this language to work.

 

  Author: Steven M. Schafer