SQL Server Books
Microsoft SQL Server 2012 Pocket Consultant
Authors: Stacia Misner and Ross Mistry
Microsoft Portable and precise, this pocket-sized guide delivers ready answers for the day-to-day administration of SQL Server. Zero in on core support and maintenance tasks using quick-reference tables, instructions, and lists. You’ll get the focused information you need to save time and get the job done—whether at your desk or in the field!
Introducing Microsoft SQL Server 2012
Authors: Stacia Misner and Ross Mistry
Microsoft SQL Server 2012 is Microsoft’s first cloud-ready information platform. It gives organizations effective tools to protect, unlock, and scale the power of their data, and it works across a variety of devices and data sources, from desktops, phones, and tablets, to datacenters and both private and public clouds. Introducing Microsoft® SQL Server® 2012 explores the exciting enhancements and new capabilities engineered into SQL Server, ranging from improvements in operation to those in reporting and management. Written by Stacia Misner and Ross Mistry, this book is for anyone who has an interest in SQL Server 2012 and wants to understand its capabilities, including database administrators, application developers, and technical decision makers.
Microsoft SQL Server 2008 R2 Administrator’s Pocket Consultant
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.
Microsoft SQL Server 2008 Administration with Windows PowerShell
Authors: Ananthakumar Muthusamy and Yan Pan
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 Step by Step
Authors: Mike Hotek
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
Authors: Leonard Lobel, Andrew J. Brust, Stephen Forte
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.
Smart Business Intelligence Solutions with Microsoft SQL Server 2008
Authors: Lynn Langit, Kevin S. Goff, Davide Mauri, Sahil Malik
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.
Microsoft SQL Server 2008 Analysis Services Step by Step
Authors: Scott Cameron, Hitachi Consulting
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
Authors: Stacia Misner
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.
Microsoft SQL Server 2008 - Implementation & Maintenance
Authors: Mike Hotek
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
Authors: Bryan C. Smith and C. Ryan Clay, Hitachi Consulting
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
Authors: Itzik Ben-Gan (Solid Quality Mentors)
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.
Essential Guide to SQL Server 2008 R2 for the DBA
Authors: Allen Hirt
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.
Click to download the eBook.