Microsoft SQL Server 2008 Step by Step

Product Description

Teach yourself SQL Server 2008—one step at a time. Get the practical guidance you need to build database solutions that solve real-world business problems. Learn to integrate SQL Server data in your applications, write queries, develop reports, and employ powerful business intelligence systems.

Discover how to:

Install and work with core components and tools
Create tables and index structures
Manipulate and retrieve data
Secure, manage, back up, and recover databases
Apply tuning plus optimization techniques to generate high-performing database applications
Optimize availability through clustering, database mirroring, and log shipping
Tap business intelligence tools—Reporting, Analysis, and Integration Services

CD features:

Practice exercises and code samples
Fully searchable eBook

Product Details

Paperback: 544 pages
Publisher: Microsoft Press; 1 edition (November 12, 2008)
Language: English
ISBN-10: 0735626049
ISBN-13: 978-0735626041

Creating your MySQL Database: Practical Design Tips and Techniques: A short guide for everyone on how to structure your data and set-up your MySQL database tables efficiently and easily.

Product Description
A short guide for everyone on how to structure your data and set-up your MySQL database tables efficiently and easily.

How best to collect, name, group, and structure your data
Design your data with future growth in mind
Practical examples from initial ideas to final designs
The quickest way to learn how to design good data structures for MySQL
From the author of Mastering phpMyAdmin

In Detail

For most of us, setting up the database for an application is often an afterthought. While you don’t need to be a professional database designer to create a working application, knowing a few insider tips and techniques can make both the process easier and the end result much more effective. This book doesn’t set out to make you an expert in data analysis, but it does provide a quick and easy way to raise your game in this essential part of getting your application right.

What you will learn from this book?

Asking users the …

Microsoft SQL Server 2008 Internals

Product Description
Delve inside the core SQL Server engine—and put that knowledge to work—with guidance from a team of well-known internals experts. Whether database developer, architect, or administrator, you’ll gain the deep knowledge you need to exploit key architectural changes—and capture the product’s full potential.

Discover how SQL Server works behind the scenes, including:
* What happens internally when SQL Server builds, expands, shrinks, and moves databases
* How to use event tracking—from triggers to the Extended Events Engine
* Why the right indexes can drastically reduce your query execution time
* How to transcend normal row-size limits with new storage capabilities
* How the Query Optimizer operates
* Multiple techniques for troubleshooting problematic query plans
* When to force SQL Server to reuse a cached query plan—or create a new one
* What SQL Server checks internally when running DBCC
* How to choose among five isolation levels and two concurrency models when working with multiple concurrent users

About the Author
Kalen Delaney, a Microsoft MVP for SQL Server since 1993, provides advanced SQL Server training to clients worldwide. She …

Accelerated SQL Server 2008

Product Description

The expert tuition and approach to rapid learning in Accelerated SQL Server 2008, one of the first SQL Server 2008 books available, will enable SQL Server and other database professionals to make the leap to the latest release of Microsoft’s flagship database management system quickly. Take full advantage of the new features of SQL Server 2008, know what tools are available, and quickly realize the power and ease of use that SQL Server 2008 has to offer.

Lightning–quick introduction to SQL Server 2008
Written by top experts in the field
Provides a solid grounding in key features and technologies

What you’ll learn

Manage SQL Server installations through the brand–new Declarative Management Framework.
Protect yourself from downtime with high–availability features such as failover clustering.
Speed your applications by taking advantage of new performance–enhancement features in SQL Server 2008.
Find what you need using full–text search.
Store, retrieve, and manage XML in the database.
Derive competitive advantage from business intelligence tools such as Analysis Services and Reporting Services.

Who is …