Professional Microsoft SQL Server 2014 Integration Services

  • 15h 4m
  • Brian Knight, Chris Rock, Devin Knight, Jessica M. Moss, Mike Davis
  • John Wiley & Sons (US)
  • 2014

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.

About the Authors

Brian Knight is the founder of Pragmatic Works and co-founder of SQLServerCentral.com and JumpstartTV.com.

Devin Knight is a SQL Server MVP, the Training Director at Pragmatic Works, and an author on six SQL Server books.

Jessica M. Moss is a well-known architect, speaker, author, and Microsoft MVP of SQL Server business intelligence who has created data warehousing solutions for a variety of industries.

Mike Davis, MCTS, MCITP, is the Managing Project Lead at Pragmatic Works, has co-authored several business intelligence books, and regularly speaks at SQL events.

Chris Rock is a software developer and program manager at Pragmatic Works, where he develops custom SSIS components and software.

In this Book

  • Welcome to SQL Server Integration Services
  • The SSIS Tools
  • SSIS Tasks
  • The Data Flow
  • Using Variables, Parameters, and Expressions
  • Containers
  • Joining Data
  • Creating an End-to-End Package
  • Scripting in SSIS
  • Advanced Data Cleansing in SSIS
  • Incremental Loads in SSIS
  • Loading a Data Warehouse
  • Using the Relational Engine
  • Accessing Heterogeneous Data
  • Reliability and Scalability
  • Understanding and Tuning the Data Flow Engine
  • SSIS Software Development Life Cycle
  • Error and Event Handling
  • Programming and Extending SSIS
  • Adding a User Interface to Your Component
  • External Management and WMI Task Implementation
  • Administering SSIS
SHOW MORE
FREE ACCESS

YOU MIGHT ALSO LIKE

Course Exploring SecOps Tools: SQL Injection Testing Using sqlmap
Rating 5.0 of 3 users Rating 5.0 of 3 users (3)
Course Working with Microsoft Azure SQL: Using Transact-SQL for Queries & Transactions
Rating 4.7 of 11 users Rating 4.7 of 11 users (11)
Book Building Custom Tasks for SQL Server Integration Services: The Power of .NET for ETL for SQL Server 2019 and Beyond, Second Edition`