Book Image

SQL Server 2017 Integration Services Cookbook

By : Christian Cote, Dejan Sarka, David Peter Hansen, Matija Lah, Samuel Lester, Christo Olivier
Book Image

SQL Server 2017 Integration Services Cookbook

By: Christian Cote, Dejan Sarka, David Peter Hansen, Matija Lah, Samuel Lester, Christo Olivier

Overview of this book

SQL Server Integration Services is a tool that facilitates data extraction, consolidation, and loading options (ETL), SQL Server coding enhancements, data warehousing, and customizations. With the help of the recipes in this book, you’ll gain complete hands-on experience of SSIS 2017 as well as the 2016 new features, design and development improvements including SCD, Tuning, and Customizations. At the start, you’ll learn to install and set up SSIS as well other SQL Server resources to make optimal use of this Business Intelligence tools. We’ll begin by taking you through the new features in SSIS 2016/2017 and implementing the necessary features to get a modern scalable ETL solution that fits the modern data warehouse. Through the course of chapters, you will learn how to design and build SSIS data warehouses packages using SQL Server Data Tools. Additionally, you’ll learn to develop SSIS packages designed to maintain a data warehouse using the Data Flow and other control flow tasks. You’ll also be demonstrated many recipes on cleansing data and how to get the end result after applying different transformations. Some real-world scenarios that you might face are also covered and how to handle various issues that you might face when designing your packages. At the end of this book, you’ll get to know all the key concepts to perform data integration and transformation. You’ll have explored on-premises Big Data integration processes to create a classic data warehouse, and will know how to extend the toolbox with custom tasks and transforms.
Table of Contents (18 chapters)
Title Page
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Customer Feedback
Preface

About the Reviewers

Jasmin Azemovic is a university professor, active in the areas of database systems, information security, data privacy, forensic analysis, and fraud detection. His PhD degree was in the field of modeling design and developing an environment for the preservation of privacy inside database systems. He is the author of many scientific-research papers and two books: Writing T-SQL Queries for Beginners Using Microsoft SQL Server 2012 and Securing SQL Server 2012. He is an active member of the professional IT world: Microsoft MVP (Data Platform eight years so far) and a security consultant. He is an active speaker at many IT professional and community conferences.

Marek Chmel is an IT consultant and trainer with more than 10 years of experience. He's a frequent speaker with a focus on Microsoft SQL Server, Azure ,and security topics. Marek writes for Microsoft's TechnetCZSK blog, and since 2012 he's an MVP: Data Platform. Marek is also recognized as a Microsoft Certified Trainer: Regional Lead for Czech Republic for a few years in a row, he holds many MCSE certifications, and on the top of that he's an ECCouncil Certified Ethical Hacker and holder of several eLearnSecurity certifications. Marek earned his MSc (Business and Informatics) degree from Nottingham Trent University. He started his career as a trainer for Microsoft Server courses. Later, he joined AT&T, as a sr. database administrator with a specialization in MSSQL Server, Data Platform, and Machine Learning.

Tomaz Kastrun is an SQL Server developer and data analyst. He has more than 15 years of experiences in the field of business warehousing, development, ETL, database administration, and query tuning. He also has more than 15 years of experience in the fields of data analysis, data mining, statistical research, and machine learning. He is Microsoft SQL Server MVP for data platforms and has been working with a Microsoft SQL Server since version 2000. Tomaz is a blogger, the author of many articles, the coauthor of a statistical analysis book, speaker at community and Microsoft events, and an avid coffee drinker.

Thanks to people who inspired me, the community, and the SQL family. Thank you, dear reader, for doing this. For endless inspiration, thank you Rubi.

Ruben Oliva Ramos is a computer systems engineer with a master's degree in computer and electronic systems engineering, teleinformatics, and networking specialization from University of Salle Bajio in Leon, Guanajuato, Mexico. He has more than five years of experience in developing web applications to control and monitor devices connected with Arduino and Raspberry Pi using web frameworks and cloud services to build IoT applications.

He is a mechatronics teacher at University of Salle Bajio and teaches students on the master's degree in Design and Engineering of Mechatronics Systems. He also works at Centro de Bachillerato Tecnologico Industrial 225 in Leon, Guanajuato Mexico, teaching subjects like: electronics, robotics and control, automation and microcontrollers at mechatronics technician career, consultant and developer projects in areas like: monitoring systems and datalogger data using technologies: Android, iOS, Windows Phone, HTML5, PHP, CSS, Ajax, JavaScript, Angular, ASP, .NET databases: SQlite, mongoDB, MySQL, web servers: Node.js, IIS, hardware programming: Arduino, Raspberry pi, Ethernet Shield, GPS and GSM/GPRS, ESP8266, control and monitor systems for data acquisition and programming.

I would like to thank God for helping me reviewing this book; my wife, Mayte, my sons, Ruben and Dario, for their support while writing this book and in general for their support in all my projects. To my parents and my brother and sister, whom I love.