- Format: Kindle Edition
- File Size: 22710.0 KB
- Print Length: 558 pages
- Simultaneous Device Usage: Up to 5 simultaneous devices, per publisher limits
- Publisher: Microsoft Press; 1 edition (28 Jun. 2016)
- Sold by: Amazon Media EU S.à r.l.
- Language: English
- ASIN: B01IPIUTQI
- Text-to-Speech: Enabled
- Word Wise: Not Enabled
- Average Customer Review: 5 customer reviews
- Amazon Bestsellers Rank: #5,127 Free in Kindle Store (See Top 100 Free in Kindle Store)
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
Introducing Microsoft SQL Server 2016: Mission-Critical Applications, Deeper Insights, Hyperscale Cloud Kindle Edition
|New from||Used from|
|Kindle Edition, 28 Jun 2016||
Customers who bought this item also bought
Would you like to tell us about a lower price?
What other items do customers buy after viewing this item?
Top customer reviews
There was a problem filtering reviews right now. Please try again later.
I have written a detailed chapter-by-chapter review of this book on www DOT i-programmer DOT info, the first and last parts of this review are given here. For my review of all chapters, search i-programmer DOT info for STIRK together with the book's title.
This free eBook aims to introduce you to the salient new and enhanced features in SQL Server 2016, how does it fare?
This book, which is subtitled Mission-Critical Applications, Deeper Insights, Hyperscale Cloud is aimed at DBAs, developers, architects, and technical-managers wanting to learn about the major enhancements in SQL Server 2016. It assumes some existing knowledge of SQL Server (perhaps at least one year of experience).
Below is a chapter-by-chapter exploration of the topics covered.
Chapter 1 Faster queries
The book opens with a look at features that enable faster queries. This primarily focuses on in-memory OLTP enhancements, which in many cases lifts the restrictions imposed in its initial release (e.g. you can now have CHECK constraints). Improved parallelism and multithreading capabilities are briefly discussed, as are the various T-SQL enhancements and improved data migration tools.
The chapter continues with a look at improvements made to in-memory analytics (cf. OLAP), and in particular some helpful ideas to reduce the potential contention between OLTP and analytics concurrent processing.
The chapter ends with a look at enhancements to Analysis Services, both multidimentional and tabular models. Whilst these changes are discussed functionally, they are for the most part side-effects of enhancements elsewhere (e.g. in-memory and DAX processing), and thus automatically gained without any specific configuration changes.
I’ve always felt the limitations included in the first version of in-memory OLTP were debilitating for serious SQL Server work, so the removal of many of these restrictions is welcomed.
This chapter is generally easy to read, with useful explanations, tips, example code, diagrams, and links for further information. These traits apply to the whole of the book.
This book aims to introduce you to the salient new and enhanced features in SQL Server 2016, and succeeds easily. It is generally easy to read, with useful explanations, tips, example code, diagrams, and links for further information.
Whilst the book doesn’t cover all the changes, it does cover the major ones. Helpfully, deeper detail is provided in separate boxes, which can be bypassed without disrupting the main flow of the text. It should be noted that, in discussing the enhanced features, it doesn’t spend much time explaining the basics. I suspect the more you know about SQL Server already, the more useful this book will be.
I castigated the previous version of this book (Introducing Microsoft SQL Server 2014) because only half of it related to SQL Server, I have no such concerns with this edition.
It might have been useful to include a section discussing SQL Server changes in terms of some of the industry’s wider trends (e.g. Big Data, social media). As you might expect, there is a degree of marketing associated with this book, however it is not too onerous, just remember other solutions exist, especially with the cloud and Big Data.
Overall, if you want to know more about the new and enhanced features in SQL Server 2016, I can highly recommend this free book.
Would you like to see more reviews about this item?