SQL Server Library

Look for these and other new publications that will soon be available for SQL Server 2008.

Microsoft SQL Server 2008 Administration with Windows Powershell

Authors: Ananthakumar Muthusamy and Yan Pan

Web Site: Wrox

The definitive guide to automating SQL Server admnistration with Powershell scripts

If you're a SQL Server database administrator, this book will make your life easier. Windows PowerShell is an administrative scripting tool that allows you to automate many tasks you're probably currently doing by hand. This nuts-and-bolts guide shows you how to create Windows PowerShell scripts to administer almost every aspect of SQL Server. You'll get a thorough introduction to PowerShell basics and all the PowerShell components that have been integrated into SQL Server 2008, as well as actual administration tasks. The book provides complete scripts that have been tested and proven, saving you hours of effort.

Microsoft SQL Server 2008 Administrator's Pocket Consultant

Author: William R. Stanek

Web Site: Microsoft Press

Get the practical, pocket-sized guide for IT professionals who need to administer, maintain, and optimize SQL Server 2008. Written by award-winning author William Stanek, this portable reference delivers essential details for using SQL Server 2008 to help protect and manage your company’s data—whether automating tasks, creating indexes and views, performing backups and recovery, replicating transactions, tuning performance, managing server activity, importing and exporting data, or performing other key tasks. Featuring quick-reference tables, lists, and step-by-step instructions, this handy, one-stop guide provides fast, accurate answers on the spot—whether you’re at your desk or in the field!

Microsoft SQL Server 2008 Step by Step

Author: Mike Hotek

Web Site: Microsoft Press

Teach yourself how to design and create SQL Server 2008 databases—one step at a time. Work at your own pace through the book’s practical, skill-building lessons and the hands-on practice files on CD. You’ll begin by learning to install and configure SQL Server 2008, design a model database, and work with tables and indexes. Next, you’ll learn techniques to manipulate, maintain, and retrieve data. Finally, you’ll learn more-advanced techniques, such as using views, functions, and triggers. As you complete each lesson, you can hone your skills using the practice exercises on the companion CD. Plus, you can review and download code samples illustrating the author’s own, professional techniques—direct from the companion Web site.

Programming Microsoft SQL Server 2008

Author: Leonard Lobel, Andrew J. Brust, Stephen Forte

Web Site: Microsoft Press

Leverage the latest T-SQL programming enhancements, using table-valued parameters, MERGE, GROUPING SETS, and new date/time and time-zone capabilities
Work with semistructured and unstructured data using XML, and the new "beyond relational" features, such as native file streaming, hierarchical tables, and spatial data types
Automate common administration and maintenance tasks
Work with the new data types, LINQ, the ADO.NET Entity Framework, WPF, and Silverlight Data binding
Write transactional code and implement local and distributed transactions
Use business intelligence tools, such as SQL Server Reporting Services and SQL Server Analysis Services

Many of the book’s examples, exercises, and code samples are available for download from the companion Web site.

Smart Business Intelligence Solutions with Microsoft SQL Server 2008

Author: Lynn Langit, Kevin S. Goff, Davide Mauri, Sahil Malik

Web Site: Microsoft Press

Get expert guidance on SQL Server 2008 technologies, processes, and procedures—and accelerate your proficiency developing smart, business intelligence solutions. This book provides practical, end-to-end coverage on how to envision, plan, develop, test, and deploy a complete SQL Server 2008-based business intelligence solution. First, you’ll build a foundational knowledge of business intelligence systems and components, including case studies of the most common scenarios. Next, you’ll work through the physical and logical design of a business intelligence solution, examining SQL Server tools—including SQL Server Analysis Services, SQL Server Integration Services, and SQL Server Reporting Services—and the problems they solve. Finally, you’ll master core reporting and data-mining techniques.

Microsoft SQL Server 2008 Analysis Services Step by Step

Author: Scott Cameron, Hitachi Consulting

Web Site: Microsoft Press

Teach yourself to use SQL Server 2008 Analysis Services for business intelligence—one step at a time. You'll start by building your understanding of the business intelligence platform enabled by SQL Server and the Microsoft Office System, highlighting the role of Analysis Services. Then, you’ll create a simple multidimensional OLAP cube and progressively add features to help improve, secure, deploy, and maintain an Analysis Services database. You'll explore core Analysis Services 2008 features and capabilities, including dimension, cube, and aggregation design wizards; a new attribute relationship designer; designer AMO warnings; and using dynamic management views to monitor resources. And as you complete each lesson, you can hone your skills using the practice exercises from the companion CD.

Microsoft SQL Server 2008 Reporting Services Step by Step

Author: Stacia Misner

Web Site: Microsoft Press

Teach yourself to design, create, view, and manage SQL Server 2008 reports—one step at a time. You’ll begin by building a solid foundation with the tools and techniques for using SQL Server Reporting Services, mastering the fundamentals of installing and working with reports. Next, you’ll design and develop reports progressively—adding calculations, interactivity, queries, charts, and models. You’ll then deploy and administer reports to the reporting server. Finally, you’ll learn to use Reporting Services as a development platform. Once you’ve completed each lesson, you can hone your skills using the practice exercises from the companion CD. Plus, you can review and download code samples illustrating the author’s own, professional techniques—direct from the companion Web site.

MCTS Self-Paced Training Kit (Exam 70-432): Microsoft SQL Server 2008 - Implementation and Maintenance

Author: Mike Hotek

Web Site: Microsoft Press

Announcing an all-new SELF-PACED TRAINING KIT for SQL Server 2008—Implementation and Maintenance. This 2-in-1 kit includes the official Microsoft study guide, plus practice tests on CD. It comes packed with the tools and features exam candidates want most—including in-depth, self-paced training based on final exam content; rigorous, objective-by-objective review; exam tips from expert, exam-certified authors; and customizable testing options. It also provides real-world scenarios, case study examples, and troubleshooting labs for the skills and expertise you can apply to the job. Work at your own pace through the lessons and lab exercises. Then assess yourself using 300+ practice and review questions on the CD. You get detailed explanations for right and wrong answers.

Microsoft SQL Server 2008 MDX Step by Step

Author: Bryan C. Smith and C. Ryan Clay, Hitachi Consulting

Web Site: Microsoft Press

Teach yourself SQL Server 2008 Multidimensional Expressions (MDX) language—one step at a time. You’ll begin with an introduction to the fundamentals of MDX language and the business intelligence landscape. Next, you’ll develop queries for various business scenarios, starting with basic concepts and then progressing to more advanced features and demonstrating their practical applications. Finally, you’ll explore the most critical and commonly used features of the language. Once you’ve completed each lesson, you can hone your skills using the practice exercises from the companion CD. Plus, you can review and download code samples illustrating the author’s own, professional techniques—direct from the companion Web site.

Microsoft SQL Server 2008 T-SQL Fundamentals

Author: Itzik Ben-Gan (Solid Quality Mentors)

Web Site: Microsoft Press

This essential reference is designed for database developers and administrators who need to write queries and develop code using Transact-SQL (T-SQL), the Microsoft implementation of the standard SQL language. Guided by SQL Server guru Itzik Ben-Gan, you’ll walk through the steps for writing queries, including retrieving and modifying data, with an overview of programmable objects supported by SQL Server 2008. Rather than focusing just on the syntactical elements of T-SQL, however, this book explains the logic behind the language—helping you develop a true, core understanding of the elements and how to use them. You will learn to think in terms of sets, and follow real-world best practices for T-SQL programming.

Microsoft SQL Server 2008: A Beginner’s Guide

Author: Dusan Petkovic

Web Site: www.mhprofessional.com

Description: Deploy and manage SQL Server 2008 with ease. Completely revised from the ground up, the new edition of this popular beginner's guide covers the latest version of Microsoft SQL Server. You will get a rigorous introduction to all of the new and improved features, including the administration, development, and Business Intelligence tools. This is the ideal resource for serious database novices, or anyone upgrading from the previous version of the software.

Microsoft SQL Server 2008 New Features

Author: Mike Otey

Web Site: www.mhprofessional.com

Description: Take immediate advantage of the new capabilities of SQL Server 2008This book offers full details on all the innovative features and benefits available in SQL Server 2008. You will get a comprehensive overview of the new and improved enterprise data management capabilities, developer functions, Business Intelligence tools, and security enhancements. This is the perfect guide for decision-makers, developers, and DBAs preparing for upgrades or migration.

Microsoft SQL Server 2008 Data and Analytics

Author: Doug Harts

Web Site: www.mhprofessional.com

Published: To be published Spring 2009

A practical guide to the next-generation Business Intelligence tools available in SQL Server 2008

This book will help DBAs and business intelligence architects work with the latest 3-D visualization techniques that revolutionize data reporting, analysis, and measurement in SQL Server 2008. You will appreciate the complete end-to-end explanation of the real-time visual representation of metrics and trends.

Microsoft SQL Server 2008 Analytics and Data Visualization begins with an overview of how these new tools, acquired from Dundas, fit into the SQL Server 2008 BI stack. You will learn strategies for data mining and advanced analytics. The book explains the full range of cutting-edge data visualization tools, including several customizable charts, map solutions for geographic data, illustrative gauges, and detailed calendars. An eight-page full-color insert highlights dazzling examples of 3-D visuals that convey business metrics in innovative ways.

Delivering Business Intelligence with Microsoft SQL Server 2008

Author: Brian Larson

Web Site: www.mhprofessional.com

Published: To be published Fall 2008

A practical guide to maximizing the Business Intelligence tools in the new SQL Server release. With help from this fully updated bestselling book, database professionals will be able to transform disparate enterprise data into actionable Business Intelligence. Covering all the new and improved BI features available in SQL Server 2008, the book shows you how to put timely, mission-critical information in the hands of employees across the organization. Delivering Business Intelligence with Microsoft SQL Server 2008 begins with a discussion of BI, defining what it is and why it is important in today's business environment. After laying this foundation, the book works through the entire BI lifecycle: defining the analysis database; analyzing the data; mining the data; and delivering BI. Several analysis databases will be built and used for examples throughout the book.

Microsoft SQL Server 2008 Reporting Services

Author: Brian Larson

Web Site: www.mhprofessional.com

The bestselling guide to Microsoft's number-one Business Intelligence tool--updated for the latest release This hands-on guide explains how to create, manage, and deliver traditional and interactive reports with SQL Server 2008 Reporting Services. You will find fully up-to-date coverage of all of the new and improved features available in this powerful server-based reporting solution.

Microsoft SQL Server 2008 Reporting Services covers the entire report-building and distribution process, including data extraction, integration with desktop and Web applications, and end-user access. Filled with more than 60 practical, reusable report and code samples, this book helps you improve business decision-making in the organization by getting the right information to the right people at the right time.

Data Mining with Microsoft SQL Server 2008

Author: Jamie MacLennan

Web Site: Amazon

Published: To be published Fall 2008

This book is a major update to the popular 2005 edition—with more than 100 new pages. The new edition for SQL Server 2008 is written by key members of the SQL Server 2008 data mining team at Microsoft Data mining is the foundation of Microsoft's move into the Business Intelligence (BI) marketplace; the tutorials in this in-depth book show data analysts, data miners, and developers how to use SQL Server 2008 to solve real-world BI problems, with numerous real-world examples The book examines each of the major data mining algorithms supported by this Microsoft tool, including naive bayes, decision trees, time series, clustering, associations rules, and neural networks. Also cover integration with Office 2007, data mining diagrams, for Visio 2007, mining OLAP databases, data mining with SQL Server Integration Services 2008, and more.

Pro SQL Server 2008 Mirroring

Author: Robert L Davis

Web Site: Amazon or Apress

Published: September 1, 2009

Pro SQL Server 2008 Mirroring is your complete guide to planning, using, deploying, and maintaining database mirroring as a high-availability option. Mirroring protects you by maintaining one or more duplicate copies of your database for use in the event the primary copy is damaged. It is a key component of any production-level, high-availability solution. This book covers the full spectrum of database mirroring, taking you from the planning phase through the implementation to the maintenance phase and beyond.

Send Feedback