
Sql Server 2016 Developer's Guide: Build Efficient Database Applications For Your Organization With Sql Server 2016
Get the most out of the rich development capabilities of SQL Server 2016 to build efficient database applications for your organizationKey FeaturesUtilize the new enhancements in Transact-SQL and security features in SQL Server 2016 to build efficient database applicationsWork with temporal tables to get information about data stored in the table at any point in timeA detailed guide to SQL Server ...
Paperback: 616 pages
Publisher: Packt Publishing (March 22, 2017)
Language: English
ISBN-10: 1786465345
ISBN-13: 978-1786465344
Product Dimensions: 7.5 x 1.4 x 9.2 inches
Amazon Rank: 552993
Format: PDF ePub djvu book
- 1786465345 epub
- 978-1786465344 pdf
- Dejan Sarka pdf
- Dejan Sarka books
- Computers and Technology epub books
Here Skyclans estiny pdf link Here Nine years among the inians pdf link Read Laughingatmynightmare ebook allnameshiserv.wordpress.com Read While it lasts abbi glines ebook cdodshinal.wordpress.com The roa to cana Read The story of an african farm oxford worlds classics ebook askprofzaidrog.wordpress.com
“It is a comprehensive book on the NEW features of SQL server 2016. It is not for beginners. It is for experienced developers and/or DBAs who wants to know the new potential of SQL Server 2016. Good book, tons of examples and code (scripts) to learn f...”
016, introducing you to multiple new features and enhancements to improve your overall development experienceBook DescriptionMicrosoft 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.What you will learnExplore the new development features introduced in SQL Server 2016Identify opportunities for In-Memory OLTP technology, significantly enhanced in SQL Server 2016Use columnstore indexes to get significant storage and performance improvementsExtend database design solutions using temporal tablesExchange JSON data between applications and SQL Server in a more efficient wayMigrate historical data transparently and securely to Microsoft Azure by using Stretch DatabaseUse the new security features to encrypt or to have more granular control over access to rows in a tableSimplify performance troubleshooting with Query StoreDiscover the potential of R's integration with SQL ServerTable of ContentsIntroduction to SQL Server 2016Review of SQL Server Features for DevelopersSQL Server ToolsTransact-SQL EnhancementsJSON Support in SQL ServerStretch DatabaseTemporal TablesTightening the SecurityQuery StoreColumnstore IndexesIntroducing SQL Server In-Memory OLTPIn-Memory OLTP Improvements in SQL Server 2016Supporting R in SQL ServerData Exploration and Predictive Modeling with R in SQL Server
Leave a Comment