ebook img

Contents at a Glance PDF

445 Pages·2016·10.25 MB·English
by  
Save to my drive
Quick download
Download
Most books are stored in the elastic cloud where traffic is expensive. For this reason, we have a limit on daily download.

Preview Contents at a Glance

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 (201) 348-4505, 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/ .

Description:
Expert SQL Server In-Memory OLTP by Dmitri Korotkevitch Expert Performance Indexing in SQL Server by Grant Fritchey and Jason Strate.
See more

The list of books you might like

Most books are stored in the elastic cloud where traffic is expensive. For this reason, we have a limit on daily download.