SQL Server 2016 Developer's Guide
eBook - ePub

SQL Server 2016 Developer's Guide

Dejan Sarka, Milos Radivojevic, William Durkin

Share book
  1. 616 pages
  2. English
  3. ePUB (mobile friendly)
  4. Available on iOS & Android
eBook - ePub

SQL Server 2016 Developer's Guide

Dejan Sarka, Milos Radivojevic, William Durkin

Book details
Book preview
Table of contents

About This Book

Get the most out of the rich development capabilities of SQL Server 2016 to build efficient database applications for your organizationAbout This Bookā€¢ Utilize the new enhancements in Transact-SQL and security features in SQL Server 2016 to build efficient database applicationsā€¢ Work with temporal tables to get information about data stored in the table at any point in timeā€¢ A detailed guide to SQL Server 2016, introducing you to multiple new features and enhancements to improve your overall development experienceWho This Book Is ForThis book is for database developers and solution architects who plan to use the new SQL Server 2016 features for developing efficient database applications. It is also ideal for experienced SQL Server developers who want to switch to SQL Server 2016 for its rich development capabilities. Some understanding of the basic database concepts and Transact-SQL language is assumed.What You Will Learnā€¢ Explore the new development features introduced in SQL Server 2016ā€¢ Identify opportunities for In-Memory OLTP technology, significantly enhanced in SQL Server 2016ā€¢ Use columnstore indexes to get significant storage and performance improvementsā€¢ Extend database design solutions using temporal tablesā€¢ Exchange JSON data between applications and SQL Server in a more efficient wayā€¢ Migrate historical data transparently and securely to Microsoft Azure by using Stretch Databaseā€¢ Use the new security features to encrypt or to have more granular control over access to rows in a tableā€¢ Simplify performance troubleshooting with Query Storeā€¢ Discover the potential of R's integration with SQL ServerIn DetailMicrosoft SQL Server 2016 is considered the biggest leap in the data platform history of the Microsoft, in the ongoing era of Big Data and data science. Compared to its predecessors, SQL Server 2016 offers developers a unique opportunity to leverage the advanced features and build applications that are robust, scalable, and easy to administer.This book introduces you to new features of SQL Server 2016 which will open a completely new set of possibilities for you as a developer. It prepares you for the more advanced topics by starting with a quick introduction to SQL Server 2016's new features and a recapitulation of the possibilities you may have already explored with previous versions of SQL Server. The next part introduces you to small delights in the Transact-SQL language and then switches to a completely new technology inside SQL Server - JSON support. We also take a look at the Stretch database, security enhancements, and temporal tables.The last chapters concentrate on implementing advanced topics, including Query Store, columnstore indexes, and In-Memory OLTP. You will finally be introduced to R and how to use the R language with Transact-SQL for data exploration and analysis.By the end of this book, you will have the required information to design efficient, high-performance database applications without any hassle.Style and approachThis book is a detailed guide to mastering the development features offered by SQL Server 2016, with a unique learn-as-you-do approach. All the concepts are explained in a very easy-to-understand manner and are supplemented with examples to ensure that youā€”the developerā€”are able to take that next step in building more powerful, robust applications for your organization with ease.

Frequently asked questions

How do I cancel my subscription?
Simply head over to the account section in settings and click on ā€œCancel Subscriptionā€ - itā€™s as simple as that. After you cancel, your membership will stay active for the remainder of the time youā€™ve paid for. Learn more here.
Can/how do I download books?
At the moment all of our mobile-responsive ePub books are available to download via the app. Most of our PDFs are also available to download and we're working on making the final remaining ones downloadable now. Learn more here.
What is the difference between the pricing plans?
Both plans give you full access to the library and all of Perlegoā€™s features. The only differences are the price and subscription period: With the annual plan youā€™ll save around 30% compared to 12 months on the monthly plan.
What is Perlego?
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1 million books across 1000+ topics, weā€™ve got you covered! Learn more here.
Do you support text-to-speech?
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more here.
Is SQL Server 2016 Developer's Guide an online PDF/ePUB?
Yes, you can access SQL Server 2016 Developer's Guide by Dejan Sarka, Milos Radivojevic, William Durkin in PDF and/or ePUB format, as well as other popular books in Computer Science & Data Warehousing. We have over one million books available in our catalogue for you to explore.



SQL Server 2016 Developer's Guide

SQL Server 2016 Developer's Guide

Copyright Ā© 2017 Packt Publishing
All rights reserved. No part of this book may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, without the prior written permission of the publisher, except in the case of brief quotations embedded in critical articles or reviews.
Every effort has been made in the preparation of this book to ensure the accuracy of the information presented. However, the information contained in this book is sold without warranty, either express or implied. Neither the authors, nor Packt Publishing, and its dealers and distributors will be held liable for any damages caused or alleged to be caused directly or indirectly by this book.
Packt Publishing has endeavored to provide trademark information about all of the companies and products mentioned in this book by the appropriate use of capitals. However, Packt Publishing cannot guarantee the accuracy of this information.
First published: March 2017
Production reference: 1150317
Published by Packt Publishing Ltd.
Livery Place
35 Livery Street
B3 2PB, UK.
ISBN 978-1-78646-534-4


Dejan Sarka
MiloÅ” Radivojević
William Durkin
Copy Editor
Vikrant Phadke
Tomaž KaŔtrun
Project Coordinator
Nidhi Joshi
Commissioning Editor
Amey Varangaonkar
Safis Editing
Acquisition Editor
Vinay Argekar
Tejal Daruwale Soni
Content Development Editor
Aishwarya Pandere
Production Coordinator
Shraddha Falebhai
Technical Editor
Vivek Arora

About the Authors

Dejan Sarka, MCT and SQL Server MVP, is an independent trainer and consultant who focuses on the development of database and business intelligence applications, located in Ljubljana, Slovenia. Besides his projects, he spends around half of his time on training and mentoring. He is the founder of the Slovenian SQL Server and .NET Users Group. Dejan is the main author and co-author of many books and courses about databases and SQL Server. He is a frequent speaker at many worldwide events.
I would like to thank everybody involved in this book, especially to my co-authors, MiloÅ” and William, to the content development editor, Aishwarya, and to the technical editor, Vivek.
MiloÅ” Radivojević is a database consultant in Vienna, Austria. He is a Data Platform MVP and specializes in SQL Server for application developers and performance and query tuning. Currently, he works as a principal database consultant in bwin (GVC Holdings)ā€”the largest regulated online gaming company in the world. MiloÅ” is a co-founder of PASS Austria. He is also a speaker at international conferences and speaks regularly at SQL Saturday events and PASS Austria meetings.
I would like to thank my co-authors, Dejan Sarka and William Durkin. It has been a pleasure and privilege working with you guys! It was also a pleasure to work with editors, Aishwarya Pandere and Vivek Arora, in the production of this book. I'd also like to thank, Tomaž KaŔtrun, for his prompt and helpful review. Finally, I would like to thank my wife, NataŔa, my daughter, Mila, and my son, Vasilije, for all their sacrifice, patience, and understanding while I worked on this book.
William Durkin is a DBA and data platform architect for CloudDBA. He uses his decade of experience with SQL Server to help multinational corporations achieve their data management goals. Born in the UK and now based in Germany, he has worked as a database developer and DBA on projects ranging from single-server installations, up to environments spanning five continents using a range of high-availability solutions. William is a regular speaker at conferences around the globe, a Data Platform MVP and is the chapter leader of a German PASS chapter.
I would like to thank, Dejan and MiloÅ”, for involving me in this book, it has been a challenge but a lot of fun! I would also like to thank Aishwarya and Vivek, for their editorial support. Last but certainly not least, thanks to my wife, Birgit, and son Liam, for your support and patience.

About the Reviewer

Tomaž KaŔtrun is a SQL Server developer and data analyst. He has more than 15 years of experience in business warehousing, development, ETL, database administration and query tuning. He also has more than 15 years of experience in the fields of data analysis, data mining, statistical research, and machine learning.
He is a Microsoft SQL Server MVP for data platforms and has been working with Microsoft SQL Server since version 2000.
Tomaž is a blogger, author of many articles, co-author of statistical analysis books, speaker at community and Microsoft events, and avid coffee drinker.
Thanks to the people who inspire me, the community, and the SQL family. Thank you, dear reader, for reading this. For endless inspiration, thank you Rubi.


For support files and downloads related to your book, please visit www.PacktPub.com.
Did you know that Packt offers eBook versions of every book published, with PDF and ePub files available? You can upgrade to the eBook version at www.PacktPub.com and as a print book customer, you are entitled to a discount on the eBook copy. Get in touch with us at [email protected] for more details.
At www.PacktPub.com, you can also read a collection of free technical articles, sign up for a range of free newsletters and receive exclusive discounts and offers on Packt books and eBooks.
Get the most in-demand software skills with Mapt. Mapt gives you full access to all Packt books and video courses, as well as industry-leading tools to help you plan your personal development and advance your career.

Why subscribe?

  • Fully searchable across every book published by Packt
  • Copy and paste, print, and bookmark content
  • On demand and accessible via a web browser

Customer Feedback

Thanks for purchasing this Packt book. At Packt, quality is at the heart of our editorial process. To help us improve, please leave us an honest review on this book's Amazon page at https://www.amazon.com/dp/1786465345.
If you'd like to join our team of regular reviewers, you can e-mail us at [email protected]. We award our regular reviewers with free eBooks and videos in exchange for their valuable feedback. Help us be relentless in improving our products!


Microsoft SQL Server is developing faster than ever in its nearly 30 years history. The newest version, SQL Server 2016, brings many important new features. Some of these new features just extend or improve features that were introduced in the previous versions of SQL Server, and some of them open a completely new set of possibilities for a database developer.
This book prepares the readers for more advanced topics by starting with a quick introduction of SQL Server 2016's new features and a recapitulation of the possibilities database developers had already in the previous versions of SQL Server. Then, the new tools are introduced. The next part introduces small delights in the Transact-SQL language, then the book switches to a completely new technology inside SQL Serverā€”JSON support. This is where the basic chapters finish, and the more complex chapters start. Stretch database, security enhancements, and temporal tables are medium-level topics. The last chapters of the book cover advanced topics, including Query Store, columnstore indexes, and In-Memory OLTP. The final two chapters introduce R and R support in SQL Server and show how to use the R language for data exploration and analysis beyond that which a developer can achieve with Transact-SQL.
By reading this book, you will explore all of the new features added to SQL Serv...

Table of contents