SQL Server books

View the latest SQL Server books.

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.

Database Administration
Intermediate
Free Ebook Download

Microsoft SQL Server 2012 T-SQL Fundamentals, 1st Edition

Authors: Itzik Ben-Gan

Gain a solid understanding of T-SQL—and write better queries. Master the fundamentals of Transact-SQL—and develop your own code for querying and modifying data in Microsoft SQL Server 2012. Led by a SQL Server expert, you’ll learn the concepts behind T-SQL querying and programming, and then apply your knowledge with exercises in each chapter. Once you understand the logic behind T-SQL, you’ll quickly learn how to write effective code—whether you’re a programmer or database administrator.

Database Administration
Development
Intermediate

Microsoft SQL Server 2012 Reporting Services, 1st Edition

Authors: Stacia Misner

Conquer Microsoft SQL Server 2012 Reporting Services—from the inside out! You’re beyond the basics, so dive right in and really put this report generation application to work! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and workarounds. It’s all muscle and no fluff. Discover how the experts prepare and deliver a variety of interactive and printed reports using SQL Server 2012—and challenge yourself to new levels of mastery.

Business Intelligence
Intermediate

Rapid Review 70-462: Administering Microsoft SQL Server 2012 Databases, 1st Edition

Authors: Randy Muller

Assess your readiness for MCTS Exam 70-462—and quickly identify where you need to focus and practice. This practical, streamlined guide walks you through each exam objective, providing “need to know” checklists, review questions, tips, and links to further study—all designed to help bolster your preparation.

Database Administration
Intermediate

Microsoft SQL Server 2012 Internals, 1st Edition

Authors: Kalen Delaney

Dive deep inside the core engine of Microsoft SQL Server 2012—and put that practical knowledge to work. Led by a team of SQL Server experts, you’ll learn the skills you need to exploit key architectural features. Go behind the scenes to understand internal operations for building, expanding, shrinking, and moving databases—whether you’re a database developer, architect, or administrator.

Database Administration
Intermediate

Training Kit (Exam 70-462): Administering Microsoft SQL Server 2012 Databases, 1st Edition

Authors: Orin Thomas, Peter Ward and Bob Taylor

Ace your preparation for the skills measured by Exam 70-462—and on the job—with this official Microsoft study guide. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce and apply what you’ve learned through real-world case scenarios and practice exercises.

Database Administration
Intermediate

Microsoft SQL Server 2012 Integration Services, 1st Edition

Authors: Wee-Hyong Tok, Rakesh Parida, Matt Masson, Xiaoning Ding and Kaarthik Sivashanmugam

Build and manage data integration solutions with expert guidance from the Microsoft SQL Server Integration Services (SSIS) team. See best practices in action and dive deep into the SSIS engine, SSISDB catalog, and security features. Using the developer enhancements in SQL Server 2012 and the flexible SSIS toolset, you’ll handle complex data integration scenarios more efficiently—and acquire the skills you need to build comprehensive solutions.

Database Administration
Intermediate

Introducing Microsoft SQL Server 2012, 1st Edition

Authors: Ross Mistry and Stacia Misner

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. 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.

Database Administration
Beginner

Microsoft SQL Server 2012 Step by Step, 1st Edition

Authors: Patrick LeBlanc

Your hands-on, step-by-step guide to building applications with Microsoft SQL Server 2012. Teach yourself the programming fundamentals of SQL Server 2012—one step at a time. Ideal for beginning SQL Server database administrators and developers, this tutorial provides clear guidance and practical, learn-by-doing exercises for building database solutions that solve real-world business problems.

Development
Beginner

Microsoft SQL Server 2012 Pocket Consultant, 1st Edition

Authors: William R. Stanek

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!

Database Administration
Beginner

Training Kit (Exam 70-461): Querying Microsoft SQL Server 2012, 1st Edition

Authors: Itzik Ben-Gan, Dejan Sarka and Ron Talmage

Ace your preparation for Microsoft Certification Exam 70-461 with this 2-in-1 Training Kit from Microsoft Press. Work at your own pace through a series of lessons and practical exercises, and then assess your skills with practice tests on CD—featuring multiple, customizable testing options.

Database Administration
Intermediate

Rapid Review 70-461: Querying Microsoft SQL Server 2012, 1st Edition

Authors: Rob Farley

Assess your readiness for MCTS Exam 70-461—and quickly identify where you need to focus and practice. This practical, streamlined guide provides objective overviews, exam tips, “need-to-know” checklists, review questions, and a list of valuable resources—all designed to help evaluate and reinforce your preparation.

Database Administration
Intermediate

Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions, 1st Edition

Authors: Itzik Ben-Gan

Apply powerful window functions in T-SQL—and increase the performance and speed of your queries. Optimize your queries—and obtain simple and elegant solutions to a variety of problems—using window functions in Transact-SQL. Led by T-SQL expert Itzik Ben-Gan, you’ll learn how to apply calculations against sets of rows in a flexible, clear, and efficient manner. Ideal whether you’re a database administrator or developer, this practical guide demonstrates ways to use more than a dozen T-SQL querying solutions to address common business tasks.

Database Administration
Beginner

Training Kit (Exam 70-463): Implementing a Data Warehouse with Microsoft SQL..., 1st Edition

Authors: Dejan Sarka, Matija Lah and Grega Jerkic

Ace your preparation for Microsoft Certification Exam 70-463 with this 2-in-1 Training Kit from Microsoft Press. Work at your own pace through a series of lessons and practical exercises, and then assess your skills with online practice tests—featuring multiple, customizable testing options.

Database Administration
Intermediate

Programming Microsoft SQL Server 2012, 1st Edition

Authors: Leonard Lobel and Andrew Brust

Your essential guide to key programming features in Microsoft SQL Server 2012. Take your database programming skills to a new level—and build customized applications using the developer tools introduced with SQL Server 2012. This hands-on reference shows you how to design, test, and deploy SQL Server databases through tutorials, practical examples, and code samples. If you’re an experienced SQL Server developer, this book is a must-read for learning how to design and build effective SQL Server 2012 applications.

Development
Design
Beginning

Microsoft SQL Server 2008 MDX Step by Step

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

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.

Development
Intermediate

Smart Business Intelligence Solutions with Microsoft SQL Server 2008

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

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.

Business Intelligence
Intermediate

Essential Guide to SQL Server 2008 R2 for the DBA

Authors: Allen Hirt
Website: Download

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

Database Administration
Intermediate

Programming Microsoft SQL Server 2008

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

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.

Development
Intermediate

Microsoft SQL Server 2008 T-SQL Fundamentals

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

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.

Development
Business Intelligence
Intermediate

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!

Database Administration
Beginner

Microsoft SQL Server 2008 Step by Step

Authors: Mike Hotek
Website: Microsoft

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.

Database Administration
Advanced

Microsoft SQL Server 2008 - Implementation & Maintenance

Authors: Mike Hotek
Website: Microsoft

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.

Database Administration
Design
Advanced

Microsoft SQL Server 2008 Reporting Services Step by Step

Authors: Stacia Misner
Website: Microsoft

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.

Business Intelligence
Intermediate

Microsoft SQL Server 2008 Administration with Windows PowerShell

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.

Database Administration
Beginner

Microsoft SQL Server 2008 R2 Administrator's Pocket Consultant

Authors: William R. Stanek
Website: Microsoft

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

Database Administration
Intermediate

There are no results for your query

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