Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
Pro SQL Server 2012 Integration Services (Professional Apress)

Buy

Pro SQL Server 2012 Integration Services teaches how to take advantage of the powerful extract, transform, and load (ETL) platform included with Microsoft SQL Server 2012. You’ll learn to build scalable, robust, performance-driven enterprise ETL solutions that save time and make money for your company. You'll learn to avoid common ETL development pitfalls and how to extend the power of your ETL solutions to include virtually any possible transformation on data from any conceivable source. SQL Server Integration Services (SSIS) facilitates an unprecedented ability to load data from anywhere, perform any type of manipulation on it, and store it to any source. 

Whether you are populating databases, retrieving data from the Web, or performing complex calculations on large data sets, SSIS gives you the tools to get the job done.  And this book gives you the knowledge to take advantage of everything SSIS offers.

  • Helps you design and develop robust, efficient, scalable ETL solutions
  • Walks you through using the built-in, stock components
  • Shows how to programmatically extend the power of SSIS to cover any possible scenario

What you’ll learn

  • Create an SSIS package from scratch
  • Deploy an SSIS package to any environment
  • Benchmark the performance of SSIS packages using common tools
  • Optimize SSIS data flows to achieve maximum performance
  • Use .NET to extend the power of the stock SSIS toolkit
  • Profile and scrub data during the ETL process

Who this book is for

Pro SQL Server 2012 Integration Services is for ETL developers, SQL developers, and database administrators at all levels of experience who want to harness the power of SSIS on SQL Server 2012. Whether you are using SSIS to build small, one-off ETL packages in a small shop, or building enterprise-wide ETL solutions in a Fortune 500 company, this book gives you the information you'll need to build powerful, scalable, and efficient ETL solutions at any level of complexity.

Table of Contents

  1. Introducing Integration Services 
  2. BIDS and SSMS 
  3. “Hello World!”—Your First SSIS 2012 Package 
  4. Connection Managers 
  5. Control Flow Basics 
  6. Advanced Control Flow Tasks 
  7. Source and Destination Adapters 
  8. Data Flow Transformations 
  9. Variables, Parameters, and Expressions 
  10. Scripting 
  11. Events and Error Handling 
  12. Data Profiling and Scrubbing 
  13. Logging, Auditing and Data Lineage
  14. Heterogeneous Sources and Destinations 
  15. Data Flow Tuning and Optimization 
  16. Parent-Child Design Pattern 
  17. Dimensional Data ETL 
  18. Building Robust Solutions 
  19. Deployment Model
(HTML tags aren't allowed.)

Pro SQL Server 2012 BI Solutions (Professional Apress)
Pro SQL Server 2012 BI Solutions (Professional Apress)

Business intelligence projects do not need to cost multi-millions of dollars or take months or even years to complete! Using rapid application development (RAD) techniques along with Microsoft SQL Server 2012, this book guides database administrators, SQL programmers, and report specialists in creating practical, cost-effective business...

SQL Server Analysis Services 2012 Cube Development Cookbook
SQL Server Analysis Services 2012 Cube Development Cookbook

If you prefer the instructional approach to a lot of theory, this cookbook is for you. It takes you straight into building data cubes through hands-on recipes, helping you get to grips with SQL Server Analysis Services fast.

Overview

  • Develop Business Intelligence solutions using a multi-dimensional model...
SQL Server 2012 Data Integration Recipes: Solutions for Integration Services and Other ETL Tools (Expert's Voice in SQL Server)
SQL Server 2012 Data Integration Recipes: Solutions for Integration Services and Other ETL Tools (Expert's Voice in SQL Server)

SQL Server 2012 Data Integration Recipes provides focused and practical solutions to real world problems of data integration. Need to import data into SQL Server from an outside source? Need to export data and send it to another system? SQL Server 2012 Data Integration Recipes has your back. You'll find solutions...


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

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...

Office 2010 For Dummies
Office 2010 For Dummies

The latest edition of one of the bestselling Microsoft Office books of all time!

Spend less time figuring out Word, Excel, PowerPoint, Outlook, and Access and more time working on actual projects with this new edition of Office 2010 For Dummies. Filled with straightforward, friendly instruction, this book gets you...

Developer to Designer: GUI Design for the Busy Developer
Developer to Designer: GUI Design for the Busy Developer
In a fantasy world, you design and build the core of your application, the parts that do all the heavy lifting. And the graphical user interface? Well, that’s the domain of the hot-shot sitting one cube over, who went to school to learn how to give users sensible and effective control over the functionality you construct....
©2019 LearnIT (support@pdfchm.net) - Privacy Policy