Netherlands: Software

Introductie van Micorosoft SQL Server 2016

Issue link:

Contents of this Issue


Page 8 of 212

ix Introduction might not be for you if you require an in-depth explanation of specific features in SQL Server or if you need a comprehensive listing of all the changes in the product. Our purpose in this book is to acquaint you with the most significant features at a high-level so that you can determine how best to take advantage of these features. Organization of this book This book is divided into nine chapters, each of which focuses on a different benefit that you can experience in the SQL Server family. Chapter 1, "Faster queries," introduces enhancements to In-Memory OLTP, memory-optimized tables, and Analysis Services to make Transact-SQL and analytical queries run faster. In Chapter 2, "Better security," we describe the new security features that give you more options for protecting your data. Chapter 3, "Higher availability," explains the new options for building high-availability solutions. The focus in Chapter 4, "Improved database engine," is the significant database engine enhancements that enable you to better manage performance and storage. Chapter 5, "Broader data access," explains how to work with temporal tables, JSON, and PolyBase. In Chapter 6, "More analytics," we provide an overview of expanded analytical capabilities in Analysis Services tabular models and the new, scalable in-database analytics made possible by SQL Server R Services. Chapter 7, "Better reporting," highlights the improvements to the Reporting Services development environment and the user experience. In the last two chapters, we transition to new data platform features in the cloud by introducing the features that bring Azure SQL Database into greater parity with SQL Server on-premises in Chapter 8, "Improved SQL Database," and by describing how to get started with data warehousing in Azure in Chapter 9, "Introducing Azure SQL Data Warehouse." Conventions and features in this book This book presents information using conventions designed to make the information readable and easy to follow. Boxed elements with labels such as "Note" provide additional information. Text that you type (apart from code blocks) appears in bold. Transact-SQL code is provided to help you further understand concepts by using specific examples. System requirements You will need the following hardware and software to complete the examples in this book: SQL Server 2016 Developer Edition or higher with SQL Server Management Studio. Computer that has a 1.4 GHz or faster x64 processor (2 GHz recommended) 1 GB of memory (4 GB recommended)

Articles in this issue

Archives of this issue

view archives of Netherlands: Software - Introductie van Micorosoft SQL Server 2016