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


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

Complex Dynamics in Communication Networks (Understanding Complex Systems)
Complex Dynamics in Communication Networks (Understanding Complex Systems)
Computer and communication networks are among society's most important infrastructures. The internet, in particular, is a giant global network of networks with central control or administration. It is a paradigm of a complex system, where complexity may arise from different sources: topological structure, network evolution, connection and node...
Python Reinforcement Learning Projects: Eight hands-on projects exploring reinforcement learning algorithms using TensorFlow
Python Reinforcement Learning Projects: Eight hands-on projects exploring reinforcement learning algorithms using TensorFlow

Implement state-of-the-art deep reinforcement learning algorithms using Python and its powerful libraries

Key Features

  • Implement Q-learning and Markov models with Python and OpenAI
  • Explore the power of TensorFlow to build self-learning models
  • Eight AI...
Foundations of 3D Graphics Programming: Using JOGL and Java3D
Foundations of 3D Graphics Programming: Using JOGL and Java3D

OpenGL, which has been bound in C, is a seasoned graphics library for scientists and engineers. As we know, Java is a rapidly growing language becoming the de facto standard of Computer Science learning and application development platform as many undergraduate computer science programs are adopting Java in place of C/C++. Released by...

Digital Photography Simplified
Digital Photography Simplified
"...makes a promise that the contents deliver on...Every tip is well explained and features a colourful image example" (Digital Photographer, December 2008)

Are you new to digital cameras? Does new technology make you nervous? Relax! You're holding in your hands the easiest guide ever to digital photography — a book...

Computation Engineering: Applied Automata Theory and Logic
Computation Engineering: Applied Automata Theory and Logic

The computer hardware and software industry is committed to using formal methods. As a result, it is crucial that students who take automata theory and logic courses retain what they have learned and understand how to use their knowledge. Yet many textbooks typically emphasize automata theory only, not logic, thus losing a valuable opportunity...

Mono: A Developer's Notebook
Mono: A Developer's Notebook
This no-fluff, lab-style guide jumps right into Mono 1.0 as you work through nearly fifty mini-projects that introduce you to the most important and compelling aspects of the 1.0 release. You'll learn how to acquire, install, and run Mono on Linux, Windows, or Mac OS X. You'll work with the various Mono components: Gtk#, the Common Language...
©2019 LearnIT (support@pdfchm.net) - Privacy Policy