Professional Microsoft SQL Server 2014 integration services / Brian Knight, Devin Knight, Jessica M. Moss, Mike Davis, Chris Rock.

Format:

Book

Author/Creator:

Knight, Brian, author.

Knight, Devin, author.

Moss, Jessica M., author.

Davis, Mike, 1976- author.

Rock, Chris, author.

Language:

English

Subjects (All):

SQL server.

SQL (Computer program language).

Database management.

Database design.

Databases--Development.

Databases.

Physical Description:

1 online resource (1 volume) : illustrations

Edition:

1st edition

Place of Publication:

Wiley 2014

System Details:

text file

Summary:

Fill the gap between planning and doing with SSIS 2014 The 2014 release of Microsoft's SQL Server Integration Services provides enhancements for managing extraction, transformation, and load operations, plus expanded in-memory capabilities, improved disaster recovery, increased scalability, and much more. The increased functionality will streamline your ETL processes and smooth out your workflow, but the catch is that your workflow must change. New tools come with new best practices, and Professional Microsoft SQL Server 2014 Integration Services will keep you ahead of the curve. SQL Server MVP Brian Knight is the most respected name in the business, and your ultimate guide to navigating the changes to use Microsoft SQL Server Integration Services 2014 to your utmost advantage. Implement new best practices for effective use of SSIS Work through tutorials for hands-on learning of complex techniques Read case studies that illustrate the more advanced concepts Learn directly from the foremost authority on SSIS SQL Server Integration Services is a complex tool, but it's the lifeblood of your work. You need to know it inside out, and you must understand the full potential of its capabilities in order to use it effectively. You need to make sure the right architecture is in place. Professional Microsoft SQL Server 2014 Integration Services is your roadmap to understanding SSIS on a fundamental level, and setting yourself up for success.

Contents:

Chapter 1: Welcome to SQL Server Integration Services Chapter 2: The SSIS Tools Chapter 3: SSIS Tasks Chapter 4: The Data Flow Chapter 5: Using Variables, Parameters, and Expressions Chapter 6: Containers Chapter 7: Joining Data Chapter 8: Creating an End-to-End Package Chapter 9: Scripting in SSIS Chapter 10: Advanced Data Cleansing in SSIS Chapter 11: Incremental Loads in SSIS Chapter 12: Loading a Data Warehouse Chapter 13: Using the Relational Engine Chapter 14: Accessing Heterogeneous Data Chapter 15: Reliability and Scalability Chapter 16: Understanding and Tuning the Data Flow Engine Chapter 17: SSIS Software Development Life Cycle Chapter 18: Error and Event Handling Chapter 19: Programming and Extending SSIS Chapter 20: Adding a User Interface to Your Component Chapter 21: External Management and WMI Task Implementation Chapter 22: Administering SSIS Introduction Advertisement End User License Agreement

Notes:

Description based on online resource; title from title page (Safari, viewed December 17, 2014).

OCLC:

899291727