SQL Server Library

What topics are you interested in?

Show me titles for:

-select-

Essential Guide to SQL Server 2008 R2 for the DBA

More than just an update to SQL Server 2008, R2 is a brand new version. This essential guide will cover the major changes in SQL Server 2008 R2 that DBAs need to know about.
Download this e-Book free

Get it today from:

  • Microsoft

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

Database Administration | Intermediate | Microsoft SQL Server 2008 R2 Administrator’s Pocket Consultant

Authors: William R. Stanek
Website:

Microsoft SQL Server 2008 Administrator's Pocket Consultant, Second Edition, is the ideal, concise, immediate reference you'll want with you at all times as you deal with SQL Server 2008 and SQL Server 2008 R2 administration. Whether you handle administration for 50 users or 5000 users, this hands-on, fast-answers guide focuses on what you need to do to get the job done quickly. With extensive, easy-to-read tables, lists, and step-by-step instructions, it's the portable, readable guide that consistently save you time and minimize system downtime by giving you the right information right now

Available from:

Database Administration | Beginner | Microsoft SQL Server 2008 Administration with Windows PowerShell

SQL Server 2008 Administration
Authors: Ananthakumar Muthusamy and Yan Pan
Website: Wrox

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.

Available from:

  • Wrox
  • Amazon

Database Administration | Beginner | Microsoft SQL Server 2008 Administrator's Pocket Consultant

Microsoft SQL Server 2008 Administrator’s Pocket Consultant
Authors: William R. Stanek
Website: Microsoft

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!

Available from:

  • O'Reilly
  • Amazon

Database Administration | Advanced | Microsoft SQL Server 2008 Step by Step

Programming Microsoft SQL Server 2008
Authors: Mike Hotek
Website:

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.

Available from:

  • O'Reilly
  • Amazon

Development | Intermediate | Programming Microsoft SQL Server 2008

Authors: Leonard Lobel, Andrew J. Brust, Stephen Forte
Website:

Extend your programming skills with a comprehensive study of the key features of SQL Server 2008. Delve into the new core capabilities, get practical guidance from expert developers, and put their code samples to work. This is a must-read for Microsoft .NET and SQL Server developers who work with data access—at the database, business logic, or presentation levels.

Available from:

  • O'Reilly
  • Amazon

Business Intelligence | Intermediate | Smart Business Intelligence Solutions with Microsoft SQL Server 2008

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

Get the end-to-end instruction you need to design, develop, and deploy more effective data integration, reporting, and analysis solutions using SQL Server 2008—whether you’re new to business intelligence (BI) programming or a seasoned pro. With real-world examples and insights from an expert team, you’ll master the concepts, tools, and techniques for building solutions that deliver intelligence—and business value—exactly where users want it.

Available from:

  • O'Reilly
  • Amazon

Business Intelligence | Intermediate | Microsoft SQL Server 2008 Analysis Services Step by Step

Authors: Scott Cameron, Hitachi Consulting
Website:

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

Available from:

  • O'Reilly
  • Amazon

Business Intelligence | Intermediate | Microsoft SQL Server 2008 Reporting Services Step by Step

Authors: Stacia Misner
Website:

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.

Available from:

  • O'Reilly
  • Amazon

Design, Database Administration | Intermediate | Microsoft SQL Server 2008 - Implementation & Maintenance

Authors: Mike Hotek
Website:

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.

Available from:

  • O'Reilly
  • Amazon

Development | Intermediate | Microsoft SQL Server 2008 MDX Step by Step

Authors: Bryan C. Smith and C. Ryan Clay, Hitachi Consulting
Website:

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.

Available from:

  • O'Reilly
  • Amazon

Development, Business Intelligence | Intermediate | Microsoft SQL Server 2008 T-SQL Fundamentals

Authors: Itzik Ben-Gan (Solid Quality Mentors)
Website:

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.

Available from:

  • O'Reilly
  • Amazon

ADDITIONAL SQL SERVER RESOURCES

Microsoft TechNet

Find product documentation and technical articles on TechNet

MSDN

Find product documentation and technical articles on MSDN

More Ways to Learn

Related Links

Site Map

  • Find Us
  • Facebook Twitter YouTube
  • MTNL/BSNL Toll free number: 1800 11 11 00
    Bharti Toll %free number: 1800 102 1100
    Toll number: +91 80 40103000