Microsoft SQL Server 2012 Integration Services

Microsoft SQL Server 2012 Integration Services

Paperback Developer Reference (Paperback)

By (author) Wee-Hyong Tok, By (author) Rakesh Parida, By (author) Matt Masson, By (author) Xiaoning Ding, By (author) Kaarthik Sivashanmugam

$42.20
List price $58.12
You save $15.92 27% off

Free delivery worldwide
Available
Dispatched in 2 business days
When will my order arrive?

  • Publisher: Microsoft Press,U.S.
  • Format: Paperback | 672 pages
  • Dimensions: 185mm x 226mm x 36mm | 1,089g
  • Publication date: 25 September 2012
  • Publication City/Country: Redmond
  • ISBN 10: 0735665850
  • ISBN 13: 9780735665859
  • Edition statement: New.
  • Sales rank: 569,709

Product description

Build and manage data integration solutions with expert guidance from the Microsoft SQL Server Integration Services (SSIS) team. See best practices in action and dive deep into the SSIS engine, SSISDB catalog, and security features. Using the developer enhancements in SQL Server 2012 and the flexible SSIS toolset, you'll handle complex data integration scenarios more efficiently-and acquire the skills you need to build comprehensive solutions. Discover how to: * Use SSIS to extract, transform, and load data from multiple data sources * Apply best practices to optimize package and project configuration and deployment * Manage security settings in the SSISDB catalog and control package access * Work with SSIS data quality features to profile, cleanse, and increase reliability * Monitor, troubleshoot, and tune SSIS solutions with advanced features such as detailed views and data taps * Load data incrementally to capture an easily consumable stream of insert, update, and delete activity

Other books in this category

Showing items 1 to 11 of 11
Categories:

Author information

Wee-Hyong Tok is a program manager on the SQL Server Integration Services team. He has worked on several different aspects of the product. Prior to joining Microsoft, Wee Hyong was a Microsoft MVP. He is a frequent presenter at Microsoft conferences. Wee Hyong is deeply passionate about how organizations can make use of business intelligence tools to derive business insights, and make better decisions. Kaarthik Sivashanmugam is a lead software engineer on the SQL Server Integration Services team. Kaarthik joined the team during SQL Server 2005 launch and has been involved in several feature improvements to SSIS since then. Rakesh Parida is a software development engineer on the SQL Server Integration Services team. He has worked on SSIS since SQL Server 2005, and was involved in many of the new features in this release, particularly ETL frameworks, data warehousing, and SSIS based solutions. Matt Masson is a senior software development engineer on the SQL Server Integration Services team. Matt joined the team shortly after the SQL Server 2005 release, and has worked on many aspects of the product. A frequent presenter at Microsoft conferences, he is heavily involved with the SSIS community, and maintains the SSIS Team Blog Xiaoning Ding is a software development engineer on the SQL Server Integration Services team, which he joined in 2007. He has worked on the SSIS engine, SSIS server, security model, and in other areas.

Table of contents

.Gain in-depth understanding of Integration Service capabilities introduced in SQL Server 2012 .Implement Integration Services best practices and design patterns .Master the ETL tool for data extraction, transformation, and loading .Manage performance issues using tuning principles and techniques .Diagnose problems and apply advanced troubleshooting features