Introducing Microsoft SQL Server 2016

Mission-Critical Applications, Deeper Insights, Hyperscale Cloud

by Stacia Varga, Denny Cherry, Joseph D'Antoni

DescriptionTable of ContentsDetailsHashtagsReport an issue

Book Description

Build your database management knowledge with the technical open book, Introducing SQL Server 2016. Get an overview of the SQL Server 2016 features - from in-memory performance and enhanced security to end-to-end mobile business intelligence and advanced analytics.

Learn about faster queries, improved security, higher availability, and state-of-the-art database engines; Broaden your data access, get deeper insights from business intelligence analytics, and make your reporting more robust; Expand your data warehouse options with SQL Data Warehouse and Azure SQL Database enhancements.

This open book is licensed under a Open Publication License (OPL). You can download Introducing Microsoft SQL Server 2016 ebook for free in PDF format (8.6 MB).

Table of Contents

Chapter 1
Faster queries
Chapter 2
Better security
Chapter 3
Higher availability
Chapter 4
Improved database engine
Chapter 5
Broader data access
Chapter 6
More analytics
Chapter 7
Better reporting
Chapter 8
Improved Azure SQL Database
Chapter 9
Introducing Azure SQL Data Warehouse

Book Details

Subject
Computer Science
Publisher
Microsoft Press
Published
2016
Pages
215
Edition
1
Language
English
ISBN13 Digital
9781509301959
ISBN10 Digital
150930195X
PDF Size
8.6 MB
License
Open Publication License

Related Books

Data Science with Microsoft SQL Server 2016
R is one of the most popular, powerful data analytics languages and environments in use by data scientists. Actionable business data is often stored in Relational Database Management Systems (RDBMS), and one of the most widely used RDBMS is Microsoft SQL Server. Much more than a database server, it's a rich ecostructure with advanced analytic capab...
Microsoft SQL Server Notes for Professionals
The Microsoft SQL Server Notes for Professionals book is compiled from Stack Overflow Documentation, the content is written by the beautiful people at Stack Overflow....
SQL Server Internals: In-Memory OLTP
The SQL Server 2016 In-Memory OLTP engine (a.k.a. Hekaton) is designed to exploit terabytes of available memory and high numbers of processing cores. It allows us to work with memory-optimized tables and indexes, and natively compiled stored procedures, in addition to the disk-based tables and indexes, and T-SQL stored procedures, that SQL Server h...
Learning Microsoft SQL Server
Microsoft SQL Server is a relational database management system developed by Microsoft. It is an unofficial and free Microsoft SQL Server ebook created for educational purposes. All the content is extracted from Stack Overflow Documentation, which is written by many hardworking individuals at Stack Overflow....
Introducing Windows Server 2016
Windows Server has powered a generation of organizations, from small businesses to large enterprises. No matter what your role in IT, you can be guaranteed you that have touched Windows Server at some point in your career or at very least you have seen it from afar! This book introduces you to Windows Server 2016, which is the next version of Windo...
Migrating SQL Server Databases to Azure
SQL Server is Microsoft's relational database management system (RDBMS). SQL Server can now be hosted entirely in Microsoft Azure, either in a hosted virtual machine (VM) or as a hosted service. Hosting a virtual machine in Azure is known as infrastructure as a service (IaaS), and hosting a service in Azure is known as platform as a service (PaaS)....