SQL Server Sampler 2016

445 Pages·2016·10.25 MB·English

2
0
1
6
E
BOOKS FOR PROFESSIONALS BY PROFESSIONALS® Asp THE EXPERT’S VOICE® IN SQL SERVER diti
o
in n

S
SQL Server Sampler
Q
L
SQL Server

S
e
r
v
e
Sampler
r

S
a
m
p
l
e —
r
Adam Aspin, Regis Baccaro,
Jason Brimhall, Bryan Cafferky,
Peter Carter, Miguel Cebollero,
Michael Coles, Grant Fritchey,
Jonathan Gennick, Clayton Groom,
Kathi Kellenberger, Dmitri Korotkevitch,
Mike McQuillan, Jay Natarajan,
Robert Pearl, Wayne Sheffield,
Jason Strate, Enrico van de Laar,
and Joost van Rossum
Shelve in:
ISBN 000-0-000-00000-0
Applications/MS Exel
User level:
Beginners
0 000000 000000 SOURCE CODE ONLINE
www.apress.com
PREFACE

SQL Server Sampler: 2016 Edition
Welcome to our SQL Server 2016 sampler! This book is Apress's gift to the community. It represents one
chapter each from all the books we published in calendar year 2015 that relate to SQL server. We hope that
you enjoy this book and find value from it, and that you'll support our authors and their books.
About Apress
Apress Media LLC is a technical publisher devoted to meeting the needs of IT professionals, software
developers, and programmers, with more than 1,000 books in print and electronic formats. Apress
provides high-quality, no-fluff content that helps serious technology professionals build a comprehensive
pathway to career success.
The Apress editorial and production teams work hand-in-hand with all authors to ensure that
their unique voices come through in each book. Apress is committed to supporting the ever-growing
programming community by taking risks on publishing books in niche and nascent technologies.
Based in New York City, Apress strives to promote innovation in publishing, boasting a global
network of authors, editors, technical reviewers, and sales and marketing teams who work together to
provide our readers books and electronic products of the highest quality.
Note Since 2007, Apress has been part of Springer Nature, one of the world's leading scientific, technical,
and medical publishing houses, enabling global distribution of Apress publications.
About our Books
We are proud to publish an extensive range of books in print and electronic formats geared toward
programmers from all areas, including industry bestsellers Pro C# and the .NET Platform by Andrew
Troelsen, CSS Mastery: Advanced Web Standards Solutions by Andy Budd, Beginning Ubuntu Linux: From
Novice to Professional by Keir Thomas, and Beginning iPhone Development: Exploring the iPhone SDK by
Dave Mark and Jeff LaMarche. Our business and software management line, which features titles by a
trove of well-respected authors (including Founders at Work by Jessica Livingston, Coders at Work by Peter
Seibel, and multiple books from the inimitable Joel Spolsky), has helped legions of programmers adapt to
the business side of technology and become more productive.
Apress Beginning books provide a reliable and readable place to start learning something new,
while developers have long relied on Apress Pro books to provide the no-fuss, honest approach that is
1
needed for solving everyday problems and coverage of topics that is broad enough to support their
complete career development. At Expert level, our readers appreciate the accuracy and singular voice that
our books provide for the highest-intensity of topics. Our friends of ED books offer a combination of
inspiration and techniques to help both experienced and novice designers and developers who are
searching for fresh ideas or guidance.

Coupon Code
We are offering a coupon code, good for 30% off the e-book version of each of the 13 SQL server titles
featured in this book. The following code is good at www.springer.com now through December 31, 2016:

PASS2016

Thank you again for your enthusiasm, commitment to learning, and passion for all things SQL server.
Enjoy!

2
PREFACE

Call for Authors
Apress is looking for authors with technical expertise and the ability to explain complicated concepts
clearly. We want authors who are passionate, innovative, and original. Do you have something you’d like
to say back to the industry? We’d love to hear from you.
Apress doesn't work quite the same as more traditional computer book publishers do. For
example, the first question many authors ask a potential publisher is “What are you looking for?” At
Apress, we ask authors these questions instead: “What are you an expert on? What do you have real-world
experience in? What are you passionate about?”
In short, we're more interested in your ideas, expertise, and passions than we are in having you
fill in some hole in our list. If you want to write about XML, that's possible, but we don't want you to write
about XML just because we want you to, nor do we want you to write yet another XML book that's just like
the dozens of "Learn XML" books that exist in various forms already.
Of course, the Apress editorial board will work with you to help ensure that your book is
marketable and ultimately successful, but the first stage of that process has to be for us to hear about your
ideas–not for you to hear about ours!
 Note If you’re interested in writing a book for Apress, the first step is to submit a proposal. Please see our
standard proposal form on the next pages—this form gives us the answers to all of the questions we need to
evaluate any new book project.
To get this document sent as a Word file, please contact:

Jonathan Gennick Susan McDermott
Assistant Editorial Director Senior Editor
Databases / Java / Big Data Security / Big Data / Cloud / Enterprise
[email protected] [email protected]
@JonathanGennick @EditorSusanMcD

1
PREFACE

Apress New Book Proposal Form
The following information is required for all new book proposals. However, we are more than happy to
chat with you if you want to discuss potential ideas/topics before filling out a full proposal.
New Print/Digital Proposal
AUTHOR DATA (for all authors)
1. Author's full name:
2. Mailing address:
3. Phone:
4. E-mail:
5. Citizenship:
6. Name to use on cover:
TITLE INFORMATION
Tentative book title:
Subtitle:

SUBJECT MATTER OF YOUR BOOK/PRODUCT
Description: 250-300 words or so—think of it as back cover copy. Use “key words” or searchable terms in
the first paragraph, as well as benefits (e.g., “solves,” “simplifies,” “equips,” “clarifies,” or “explains,” etc.)
1
and content (“supplies,” “shares,” “provides,” “offers,” “contains,” etc.). Roughly 2-3 paragraphs plus
three bullet points detailing content coverage:
AUDIENCE
List expressly who the customers are—by specific job title—and the need this content fills.
WHAT YOU’LL LEARN
Please list 5-6 bullet points that summarize what a reader will be able to do as a result of having read your
book.
KEY WORDS
If you were searching for a book on this topic, what key terms would you search for? Assume a potential
reader does not know you or your book, but is trying to find content based on a specific subject. List
targeted words and short phrases (5-10; more is better):
AUTHOR BIO
Write a brief one-two paragraph biographical statement.
AUTHOR INFORMATION / PLATFORM
 Do you currently speak at industry seminars or conferences? If so, on what topic(s)
and how frequently do you speak?
 Do you or any of your co-authors regularly contribute to any media? Please provide
details (title or publication, circulation, number of unique visitors, etc.)
 Do you participate in any social media (blogs, Facebook, Twitter, LinkedIn, etc.)
that will be leveraged to promote your book? Please provide statistical details
(number of followers/friends/members, etc.) and links.
PAGE COUNT
Approximate number of manuscript pages?

MANUSCRIPT DELIVERY INFORMATION (SCHEDULE)
Three dates needed:
 Due-date for first-draft of first three chapters:
 Due-date for first-full-draft of all chapters:
 Publication month desired (in case book is needed for a specific event):
2
Preface
SELLING POINTS
List three of the most salient sales handles for your book (why is this book a “need to have” product?)
INFORMATION ON THE COMPETITION
List any books/products/ other sources (web offerings, white papers, etc.) with which your book will
compete. Include author, title, publisher, and publication year.
How will your book be different and/or better?
TABLE OF CONTENTS
A description of each chapter that includes:
 Chapter name
 Chapter content/goal
 The first level of headings for the chapter

3
PREFACE

Contents
We asked authors of 2015 titles on SQL Server to select one chapter that best respresents their book that is
useful in isolation. What we ended up with is a mix of material that provides a look into the book content
as whole, but that can be used on its own.
There are 13 titles featured in this e-book. Featured in order according to publication date are the
following:

 Pro T-SQL Programmer's Guide by Miguel Cebollero, Michael Coles, and Jay
Natarajan
 Business Intelligence with SQL Server Reporting Services by Adam Aspin
 Expert T-SQL Functions in SQL Server by Kathi Kellenberger and Clayton Groom
 Healthy SQL by Robert Pearl
 SQL Server T-SQL Recipes by Jason Brimhall, Jonathan Gennick, and Wayne
Sheffield
 Pro SQL Server Wait Statistics by Enrico van de Laar
 Expert SQL Server In-Memory OLTP by Dmitri Korotkevitch
 Introducing SQL Server by Mike McQuillan
 Extending SSIS with .NET Scripting by Joost van Rossum and Regis Baccaro
 Pro PowerShell for Database Developers by Bryan Cafferky
 Expert Performance Indexing in SQL Server by Grant Fritchey and Jason Strate
 Pro SQL Server Administration by Peter Carter
 SQL Server AlwaysOn Revealed by Peter Carter

On the following pages you will see the book opener, its Table of Contents, and the author-selected
chapter from each.

We hope you enjoy this resource, and look forward to the possibility of working with you in the future.
1
Pro T-SQL
Programmer’s Guide
4th Edition
Miguel Cebollero
Jay Natarajan
Michael Coles
Pro T-SQL Programmer’s Guide
Copyright © 2015 by Miguel Cebollero, Jay Natarajan, and Michael Coles
Th is work is subject to copyright. All rights are reserved by the Publisher, whether the whole or part of the
material is concerned, specifi cally the rights of translation, reprinting, reuse of illustrations, recitation,
broadcasting, reproduction on microfi lms or in any other physical way, and transmission or information
storage and retrieval, electronic adaptation, computer software, or by similar or dissimilar methodology now
known or hereafter developed. Exempted from this legal reservation are brief excerpts in connection with
reviews or scholarly analysis or material supplied specifi cally for the purpose of being entered and executed
on a computer system, for exclusive use by the purchaser of the work. Duplication of this publication or
parts thereof is permitted only under the provisions of the Copyright Law of the Publisher’s location, in its
current version, and permission for use must always be obtained from Springer. Permissions for use may be
obtained through RightsLink at the Copyright Clearance Center. Violations are liable to prosecution under
the respective Copyright Law.
ISBN-13 (pbk): 978-1-4842-0146-6
ISBN-13 (electronic): 978-1-4842-0145-9
Trademarked names, logos, and images may appear in this book. Rather than use a trademark symbol
with every occurrence of a trademarked name, logo, or image we use the names, logos, and images only
in an editorial fashion and to the benefi t of the trademark owner, with no intention of infringement of the
trademark.
Th e use in this publication of trade names, trademarks, service marks, and similar terms, even if they are
not identifi ed as such, is not to be taken as an expression of opinion as to whether or not they are subject to
proprietary rights.
While the advice and information in this book are believed to be true and accurate at the date of publication,
neither the authors nor the editors nor the publisher can accept any legal responsibility for any errors or
omissions that may be made. Th e publisher makes no warranty, express or implied, with respect to the
material contained herein.
Managing Director: Welmoed Spahr
Lead Editor: Jonathan Gennick
Technical Reviewer: Edgar Lanting
Editorial Board: Steve Anglin, Gary Cornell, Louise Corrigan, Jim DeWolf, Jonathan Gennick,
Robert Hutchinson, Michelle Lowman, James Markham, Matthew Moodie, Jeff Olson,
Jeff rey Pepper, Douglas Pundick, Ben Renow-Clarke, Gwenan Spearing, Matt Wade, Steve Weiss
Coordinating Editor: Jill Balzano
Copy Editor: Tiff any Taylor
Compositor: SPi Global
Indexer: SPi Global
Artist: SPi Global
Cover Designer: Anna Ishchenko
Distributed to the book trade worldwide by Springer Science+Business Media New York,
233 Spring Street, 6th Floor, New York, NY 10013. Phone 1-800-SPRINGER, fax [phone],
e-mail [email protected] , or visit w ww.springeronline.com .
For information on translations, please e-mail [email protected] , or visit w ww.apress.com .
Apress and friends of ED books may be purchased in bulk for academic, corporate, or promotional use.
eBook versions and licenses are also available for most titles. For more information, reference our Special
Bulk Sales–eBook Licensing web page at w ww.apress.com/bulk-sales .
Any source code or other supplementary materials referenced by the author in this text is available to
readers at at www.apress.com/9781430245964 . For detailed information about how to locate your book’s
source code, go to w ww.apress.com/source-code/ .