Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
Expert SQL Server 2005 Integration Services (Programmer to Programmer)

Buy

Developing data processing extraction, transformation, and loading (ETL) solutions is now easier than ever with this practical guide. It shows you how to apply the components of SQL Server 2005 Integration Services (SSIS) to build an enterprise ETL application that scales and performs to your specifications. You'll not only learn how to design and implement the necessary architecture, you'll also find out how to utilize the proper administration techniques.

Written by two SQL Server MVPs, this book first provides you with all the background and foundation information you'll need on scripting and data extraction. It then takes you through the details of data warehousing ETL, error handling, administration, and data integration. By following this approach, you'll quickly discover how to take advantage of SSIS functionality to meet your data integration and processing requirements.

What you will learn from this book

  • Powerful uses of scripting to develop more advanced applications
  • All about the relational database transformation and loading methods for dimension and fact tables
  • Steps for creating sophisticated solutions that easily handle processing errors
  • Best practices for moving between your support and production environments
  • Tips for leveraging SSIS features that make your migrated packages better
  • How to design and tune your packages to achieve the most scalability

Who this book is for

This book is for experienced SQL Server database developers, architects, and administrators who want to build ETL applications using SSIS.

About the Authors

Brian Knight (SQL Server MVP, MCSE, MCDBA) of Green Cove Springs, Florida, is the co-founder of SQLServerCentral.com and JumpstartTV.com. He runs the local SQL Server users group in Jacksonville (JSSUG) and was on the Board of Directors of the Professional Association for SQL Server (PASS). He is a contributing columnist for SQL Server Standard and also maintains a regular column for the database web site, SQLServerCentral.com, as well as doing regular webcasts at JumpstartTV.com. He has co-authored and authored more than nine SQL Server books, including Admin911: SQL Server 2000 (McGraw-Hill Companies, 2001), Professional SQL Server 2000 DTS (Wiley Publishing, 2000), Professional SQL Server 2005 Administration (Wiley Publishing, 2006), and Professional SQL Server 2005 Integration Services (Wiley Publishing, 2006). He has spoken at conferences such as PASS, SQL Connections, and TechEd, as well as at many Code Camps.

Erik Veerman (SQL Server MVP, MCT, MCDBA) is a Mentor for Solid Quality Learning focusing on training, mentoring, and architecting solutions on the SQL Server Business Intelligence (BI) platform. His industry recognition includes Microsoft’s Worldwide BI Solution of the Year and SQL Server Magazine’s Innovator Cup winner. He has designed dozens of BI solutions across a broad business spectrum-telecommunications, marketing, retail, commercial real estate, finance, supply chain, and information technology. His experience with high-volume, multi-terabyte environments and SQL Server 64-bit has enabled clients to scale their Microsoft-based BI solutions for optimal potential. As an expert in OLAP design, ETL processing, and dimensional modeling, he is a presenter, author, and instructor. He led the ETL architecture and design for the first production implementation of SQL Server Integration Services (SSIS) and helped drive the ETL standards and best practices for SSIS on Microsoft’s SQL Server 2005 reference initiative (Project REAL). He also co-authored Professional SQL Server 2005 Integration Services (Wiley Publishing, 2006). As a resident of Atlanta, Georgia, Erik is a leader of the local Atlanta SQL Server User’s Group, a PASS and INETA user group chapter.

(HTML tags aren't allowed.)

A Casual Revolution: Reinventing Video Games and Their Players
A Casual Revolution: Reinventing Video Games and Their Players

The enormous popularity of the Nintendo Wii, Guitar Hero, and smaller games like Bejeweled or Zuma has turned the stereotype of the obsessed young male gamer on its head. Players of these casual games are not required to possess an intimate knowledge of video game history or to devote weeks or months to play. At the same...

Pro SharePoint 2010 Governance (Professional Apress)
Pro SharePoint 2010 Governance (Professional Apress)

Governance is the process of creating policies and rules and assigning roles and responsibilities to make a system work properly. Even if your attitude is “Good Government is Less Government,” very few of us

would want to have no government. In short, governance is the difference between order and chaos.

...
Understanding IPv6: Your Essential Guide to IPv6 on Windows Networks
Understanding IPv6: Your Essential Guide to IPv6 on Windows Networks
When Joe first asked me to write a foreword for this latest edition of Understanding IPv6, I looked to forewords from previous editions as well as other networking books, hoping to draw some inspiration. As will become increasingly obvious, my writing skills are not as honed as Joe’s.

...

Introduction to Statistical Relational Learning (Adaptive Computation and Machine Learning)
Introduction to Statistical Relational Learning (Adaptive Computation and Machine Learning)
Handling inherent uncertainty and exploiting compositional structure are fundamental to understanding and designing large-scale systems. Statistical relational learning builds on ideas from probability theory and statistics to address uncertainty while incorporating tools from logic, databases, and programming languages to represent structure. In...
Wireless Personal Area Networks: Performance, Interconnection, and Security with IEEE 802.15.4
Wireless Personal Area Networks: Performance, Interconnection, and Security with IEEE 802.15.4
Wireless personal area networks and wireless sensor networks are rapidly gaining popularity, and the IEEE 802.15 Wireless Personal Area Working Group has defined no less than three different standards so as to cater to the requirements of different applications. One of them is the low data rate WPAN known as 802.15.4, which covers a broad range of...
Phytochemicals: Nutrient-Gene Interactions
Phytochemicals: Nutrient-Gene Interactions

Understanding phytochemical–gene interactions provides the basis for individualized therapies to promote health as well as prevent and treat disease. The authors of Phytochemicals: Nutrient–Gene Interactions examine the interactions between phytochemicals and the human genome and discuss the impact these interactions have...

©2019 LearnIT (support@pdfchm.net) - Privacy Policy