Mastering SQL Server 2017 will then demonstrate how you can use Query Store, columnstore indexes, and In-Memory OLTP in your apps. You’ll also learn to integrate Python code in SQL Server and graph database implementations for development and testing. Next, you’ll get up to speed with designing and building SQL Server Integration Services (SSIS) data warehouse packages using SQL server data tools. (Limited-time offer)
Table of Contents
- Introduction to SQL Server 2017
- SQL Server Tools
- JSON Support in SQL Server
- Stretch Database
- Temporal Tables
- Columnstore Indexes
- SSIS Setup
- What Is New in SSIS 2016
- Key Components of a Modern ETL Solution
- Dealing with Data Quality
- Unleash the Power of SSIS Script Task and Component
- On-Premises and Azure Big Data Integration
- Extending SSIS Custom Tasks and Transformations
- Scale Out with SSIS 2017
Download Free PDF / Read Online
Author(s): Miloš Radivojević, Dejan Sarka, William Durkin, Christian Cote and Matija Lah
Publisher: Packt Publishing
Published: August 2019
Format(s): Online
File size: –
Number of pages: 696
Download / View Link(s): This offer has ended.
Free as of 03/25/2022
Publisher: Packt Publishing
Published: August 2019
Format(s): Online
File size: –
Number of pages: 696
Download / View Link(s): This offer has ended.
Free as of 03/25/2022