Professional Microsoft SQL Server 2014 Integration Services (Wrox Programmer to Programmer) - Softcover

Knight, Brian; Knight, Devin; Moss, Jessica M.; Davis, Mike; Rock, Chris

Softcover

ISBN 10: 1118850874 ISBN 13: 9781118850879

Publisher: Wrox, 2014

Synopsis

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 this title

From the Back Cover

A complete guide to Microsoft SSIS, updated for the 2014 release

Renowned SQL Server MVP Brian Knight and his expert co-authors teach you best practices for using all of the features of Microsoft SQL Server Integration Services (SSIS), including the latest enhancements introduced with the 2014 release of SQL Server. In addition to technical updates and additions, the authors also add a new set of best practices for effective use of SSIS, more case studies, and tutorial examples to illustrate advanced concepts and techniques.

Professional Microsoft SQL Server 2014 Integration Services:

• Explains how to extract, transform, and load (ETL) data with SSIS
• Covers each of the many SSIS tasks and Data Flow components
• Teaches you the most effective techniques for performance tuning SSIS
• Covers advanced techniques for data cleansing and incremental loads
• Shows how to load a data warehouse using built-in components in SSIS
• Details best practices for manageability and scalability

About the Author

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.

Wrox Professional guides are planned and written by working programmers to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.

Edition details

• Publisher: Wrox
• Publication date: 2014
• ISBN 10: 1118850874
• ISBN 13: 9781118850879
• Binding: Paperback
• Language: English
• Edition number: 1
• Number of pages: 912