Sign In Start Free Trial

Book Overview & Buying
Table Of Contents
Feedback & Rating

SQL Server 2017 Developer???s Guide

3.6 (5)

SQL Server 2017 Developer???s Guide

3.6 (5)

Overview of this book

Microsoft SQL Server 2017 is a milestone in Microsoft's data platform timeline, as it brings in the power of R and Python for machine learning and containerization-based deployment on Windows and Linux. This book prepares you for advanced topics by starting with a quick introduction to SQL Server 2017's new features. Then, it introduces you to enhancements in the Transact-SQL language and new database engine capabilities before switching to a different technology: JSON support. You will take a look at the security enhancements and temporal tables. Furthermore, the book focuses on implementing advanced topics, including Query Store, columnstore indexes, and In-Memory OLTP. Toward the end of the book, you'll be introduced to R and how to use the R language with Transact-SQL for data exploration and analysis. You'll also learn to integrate Python code into SQL Server and graph database implementations as well as the deployment options on Linux and SQL Server in containers for development and testing. By the end of this book, you will be armed to design efficient, high-performance database applications without any hassle.

Preface

Preface

Who this book is for

What this book covers

To get the most out of this book

Get in touch

Free Chapter

Introduction to SQL Server 2017

Introduction to SQL Server 2017

Security

Summary

Review of SQL Server Features for Developers

Review of SQL Server Features for Developers

The mighty Transact-SQL SELECT

DDL, DML, and programmable objects

Transactions and error handling

Beyond relational

Summary

SQL Server Tools

SQL Server Tools

Installing and updating SQL Server Tools

New SSMS features and enhancements

SQL Server Data Tools

Tools for developing R and Python code

Summary

Transact-SQL and Database Engine Enhancements

Transact-SQL and Database Engine Enhancements

New and enhanced functions and expressions

Enhanced DML and DDL statements

New query hints

Adaptive query processing in SQL Server 2017

Summary

JSON Support in SQL Server

JSON Support in SQL Server

Why JSON?

What is JSON?

JSON in SQL Server prior to SQL Server 2016

Retrieving SQL Server data in JSON format

Converting JSON data in a tabular format

JSON storage in SQL Server 2017

Validating JSON data

Extracting values from a JSON text

Modifying JSON data

Performance considerations

Summary

Stretch Database

Stretch Database

Stretch DB architecture

Limitations of using Stretch Database

Use cases for Stretch Database

Enabling Stretch Database

Querying stretch databases

SQL Server Stretch Database pricing

Stretch DB management and troubleshooting

Summary

Temporal Tables

Temporal Tables

What is temporal data?

System-versioned temporal tables in SQL Server 2017

What is missing in SQL Server 2017?

Summary

Tightening Security

Tightening Security

SQL Server security basics

Encrypting the data

Row-Level Security

Exploring dynamic data masking

Summary

Query Store

Query Store

Why Query Store?

What is Query Store?

Query Store architecture

Enabling and configuring Query Store

Disabling and cleaning Query Store

Query Store in action

Query Store reports in SQL Server Management Studio

Automatic tuning in SQL Server 2017

Capturing waits by Query Store in SQL Server 2017

Query Store use cases

Summary

Columnstore Indexes

Columnstore Indexes

Analytical queries in SQL Server

Columnar storage and batch processing

Nonclustered columnstore indexes

Clustered columnstore indexes

Summary

Introducing SQL Server In-Memory OLTP

Introducing SQL Server In-Memory OLTP

In-Memory OLTP architecture

Creating memory-optimized tables and indexes

Querying and data manipulation

Data durability concerns

Database startup and recovery

Management of In-Memory objects

Extended events

PerfMon counters

Summary

In-Memory OLTP Improvements in SQL Server 2017

In-Memory OLTP Improvements in SQL Server 2017

Ch-Ch-Changes

Feature improvements

Improvements in the In-Memory OLTP engine

Summary

Supporting R in SQL Server

Supporting R in SQL Server

Introducing R

Manipulating data

Understanding data

SQL Server R Machine Learning Services

Summary

Data Exploration and Predictive Modeling with R

Data Exploration and Predictive Modeling with R

Intermediate statistics – associations

Advanced analysis – undirected methods

Advanced analysis – directed methods

Advanced graphing

Summary

Introducing Python

Introducing Python

Starting with Python

Working with data

Data science with Python

Summary

Graph Database

Graph Database

Introduction to graph databases

Graph features in SQL Server 2017

SQL Graph limitations

Summary

Containers and SQL on Linux

Containers and SQL on Linux

Containers

SQL Server on Linux

Summary

Other Books You May Enjoy

Other Books You May Enjoy

Leave a review - let other readers know what you think

Customer Reviews

3.6 (5)

5 star

20%

4 star

40%

3 star

20%

2 star

20%

1 star

0

Review of SQL Server Features for Developers

Before delving into the new features in SQL Server 2016 and 2017, let's have a quick recapitulation of the SQL Server features for developers that are already available in the previous versions of SQL Server. Please note that this chapter is not a comprehensive development guide; covering all features would be out of the scope of this book. Recapitulating the most important features will help you remember what you already have in your development toolbox, and also understand the need for and the benefits of the new or improved features in SQL Server 2016 and 2017.

This chapter has a lot of code. As this is not a book for beginners, the intention of this chapter is not to teach you the basics of database development. It is rather a reminder for the powerful and efficient Transact-SQL (T-SQL) and other elements included in SQL Server...

Search

Your notes and bookmarks