Master your Minecraft
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Tour our stores


    Recently Viewed clear list


    Original Essays | November 7, 2014

    Carli Davidson: IMG Puppies for Sale? Read This First



    Shake Puppies contains an almost unsettling amount of cuteness. There is a good chance after looking through its pages you will get puppy fever and... Continue »

    spacer

Microsoft SQL Server 2012 Integration Services

by

Microsoft SQL Server 2012 Integration Services Cover

 

Synopses & Reviews

Publisher Comments:

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

Synopsis:

Conquer Microsoft® SQL Server® 2012 Integration Services—from the inside out!

Youre beyond the basics, so dive right in and really put SQL Server Integration Services to work! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and workarounds. Its all muscle and no fluff. Discover how the experts perform data integration tasks—and challenge yourself to new levels of mastery.

  • 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

About the Author

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

ForewordIntroductionPart I: OverviewChapter 1: SSIS OverviewChapter 2: Understanding SSIS ConceptsChapter 3: Upgrading to SSIS 2012Part II: DevelopmentChapter 4: New SSIS Designer FeaturesChapter 5: Team DevelopmentChapter 6: Developing an SSIS SolutionChapter 7: Understanding SSIS ConnectivityChapter 8: Working with Change Data Capture in SSIS 2012Chapter 9: Data Cleansing Using SSISPart III: Database AdminChapter 10: Configuration in SSISChapter 11: Running SSIS PackagesChapter 12: SSIS T-SQL MagicChapter 13: SSIS PowerShell MagicChapter 14: SSIS ReportsPart IV: Deep-DiveChapter 15: SSIS Engine Deep DiveChapter 16: SSIS Catalog Deep DiveChapter 17: SSIS SecurityChapter 18: Understanding SSIS LoggingChapter 19: Automating SSISPart V: TroubleshootingChapter 20: Troubleshooting SSIS Package FailuresChapter 21: SSIS Performance Best PracticesChapter 22: Troubleshooting SSIS Performance IssuesChapter 23: Troubleshooting Data Issues

Product Details

ISBN:
9780735665859
Author:
Parida, Rakesh
Publisher:
Microsoft Press
Author:
Ding, Xiaoning
Author:
Masson, Matt
Author:
Sivashanmugam, K
Author:
Sivashanmugam, Kaarthik
Author:
Tok, Wee-Hyong
Author:
hanmugam, Kaarthik
Author:
Xiaoning, Ding
Author:
aarthik
Author:
Sivas
Author:
Wee, Hyong Tok
Subject:
Database Management - General
Subject:
Personal Computers-Desktop Applications-Databases
Subject:
SQL Server Integration Services;SSIS;data cleansing;data extraction;data mining;data transformation
Edition Description:
Trade Paper
Series:
Developer Reference
Publication Date:
20120931
Binding:
TRADE PAPER
Language:
English
Pages:
672
Dimensions:
9 x 7.38 in

Related Subjects

Business » Computers
Computers and Internet » Computer Languages » SQL
Computers and Internet » Computers Reference » General
Computers and Internet » Database » Applications
Computers and Internet » Database » Design
Computers and Internet » Database » SQL
Computers and Internet » Networking » General
Computers and Internet » Personal Computers » Desktop Applications » Databases
Computers and Internet » Software Engineering » Programming and Languages
Computers and Internet » Software Engineering » Software Management

Microsoft SQL Server 2012 Integration Services New Trade Paper
0 stars - 0 reviews
$59.99 In Stock
Product details 672 pages Microsoft Press - English 9780735665859 Reviews:
"Synopsis" by ,

Conquer Microsoft® SQL Server® 2012 Integration Services—from the inside out!

Youre beyond the basics, so dive right in and really put SQL Server Integration Services to work! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and workarounds. Its all muscle and no fluff. Discover how the experts perform data integration tasks—and challenge yourself to new levels of mastery.

  • 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

spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.