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

Trading ETFs: Gaining an Edge with Technical Analysis
Trading ETFs: Gaining an Edge with Technical Analysis

A comprehensive catalog of exchange-traded funds and insights into successful trading techniques

This Second Edition of the bestselling Trading ETFs offers an updated version of the definitive guide to this vital part of the capital markets. It contains numerous new examples of the techniques that author Deron...

Operating Systems: A Spiral Approach
Operating Systems: A Spiral Approach

We have long felt that the traditional approach to teaching about Operating Systems (OSs) was not the best approach. The purpose of this book is to support a different approach to this task. When studying any complex domain of knowledge, the order in which one learns the hierarchy of principles, laws, ideas, and concepts can make the...

Absolute OpenBSD: UNIX for the Practical Paranoid
Absolute OpenBSD: UNIX for the Practical Paranoid

This book takes readers through the intricacies of the OpenBSD platform, and teaches them how to manage the system with friendly explanations, background information, troubleshooting suggestions, and copious examples.

This straightforward, practical, and complete guide to mastering the powerful and complex OpenBSD operating system,...


Beginning Programming with Java For Dummies
Beginning Programming with Java For Dummies

A practical introduction to programming with Java

Beginning Programming with Java For Dummies, 4th Edition is a comprehensive guide to learning one of the most popular programming languages worldwide. This book covers basic development concepts and techniques through a Java lens. You'll learn what goes...

Exploratory Multivariate Analysis by Example Using R (Chapman & Hall/CRC Computer Science & Data Analysis)
Exploratory Multivariate Analysis by Example Using R (Chapman & Hall/CRC Computer Science & Data Analysis)

Full of real-world case studies and practical advice, Exploratory Multivariate Analysis by Example Using R focuses on four fundamental methods of multivariate exploratory data analysis that are most suitable for applications. It covers principal component analysis (PCA) when variables are quantitative, correspondence analysis...

Atomic Force Microscopy: Understanding Basic Modes and Advanced Applications
Atomic Force Microscopy: Understanding Basic Modes and Advanced Applications

This book enlightens readers on the basic surface properties and distance-dependent intersurface forces one must understand to obtain even simple data from an atomic force microscope (AFM). The material becomes progressively more complex throughout the book, explaining details of calibration, physical origin of artifacts, and...

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