Microsoft SQL Server 2008 Integration Services Unleashed

4,14 valoración promedio
( 7 valoraciones por Goodreads )
 
9780672330322: Microsoft SQL Server 2008 Integration Services Unleashed

Microsoft SQL Server Integration Services is Microsoft’s powerful platform for building enterprise-level data integration and data transformation solutions. It’s a powerful product, but it’s also complex and can be confusing if you don’t have a clear map for the journey. Microsoft SQL Server 2008 Integration Services Unleashed will be the only book you’ll need to harness the power that Integration Services provides.

 

Through clear, concise explanations and samples, you’ll grasp a clear understanding of working in the Integration Services environment, including how to set up stock components, how to use the various designer features, and how to gain practical knowledge on configuring, deploying, securing, and managing packages. Sample packages are provided to reinforce the discussion and quickly help you gain hands-on experience, and more complex topics such as Data Flow Task internals and tuning, advanced transformations, and writing custom components are all illustrated in easy-to-understand graphics. In addition, there are several custom tasks and transformations and two useful utilities with full source code available for you to use and study, including an ADO.NET destination, a text file encryption task, and a data profiling transform.

 

Detailed information on:

  • Using the powerful Integration Services tools to create solutions without the need to write lines of code
  • Creating packages programmatically or developing custom tasks via the Integration Services object
  • Building robust packages to solve common requirements
  • Securing packages for different environments
  • Using often overlooked or unknown platform features
  • Setting up all the stock components, including data flow components, tasks, Foreach enumerators, connection managers, and log providers
  • Writing robust and useful custom tasks
  • Building packages that seamlessly deploy to other environments
  • Writing custom data flow adapters and transforms
  • Using script tasks and components
  • Easily modifying configurations for multiple packages simultaneously
  • Writing a Task UI that looks just like the stock tasks
  • Tapping into the power of Integration Services for accessing heterogeneous data sources
  • Using expressions to make packages more responsive to the environment
  • Migrating your DTS packages with no stress

 

Kirk Haselden is the Group Program Manager for the Microsoft Master Data Management product forthcoming in the next wave of Office SharePoint Services and owns the long term strategy, vision, planning, and development of that product. Kirk has been with Microsoft for 12 years in various groups including Hardware, eHome, Connected Home, SQL Server, and Office Business Platform. He was the development manager for Integration Services and the primary designer for the runtime, as well as many of the tasks. He has written a number of articles for SQL Server Magazine, speaks regularly at industry events, writes profusely on his personal and MSDN blog, and holds 35 patents or patents pending.

 

Category: Microsoft SQL Server

Covers: Microsoft SQL Server 2008 Integration Services

User Level: Intermediate—Advanced

 

$59.99 US / $71.99 CAN / £38.99 Net UK

 

"Sinopsis" puede pertenecer a otra edición de este libro.

About the Author:

Kirk Haselden is the group program manager for the Microsoft Master Data Management product forthcoming in the next wave of Office SharePoint Services and owns the longterm strategy, vision, planning, and development of that product. Kirk has been with Microsoft for 12 years in various groups including Hardware, eHome, Connected Home, SQL Server, and Office Business Platform. He was the development manager for Integration Services and the primary designer for the runtime and many of the tasks. Prior to Microsoft, Kirk worked for several small startup companies building educational, dental, and online software. Kirk has a bachelor of arts degree in accounting and information systems from the University of Utah. He has written a number of articles for SQL Server Magazine, speaks regularly at industry events, writes profusely on his personal and MSDN blog, and holds 35 patents or patents pending. Kirk is married and the father of five wonderful children. He enjoys family time, photography, snow skiing, wake boarding, racquetball, motorcycle riding, hiking, breathing, drinking, and eating. He’s always wearing hideous Hawaiian shirts, shorts, and sandals, except in the winter, when he also wears socks. He once lived in Wichita, Kansas, and thinks it’s funny when people talk about themselves in third person.

Excerpt. © Reprinted by permission. All rights reserved.:

Microsoft¨ SQL Serverª 2008 Integration Services Unleashed

Microsoft® SQL Server™ 2008 Integration Services Unleashed

Foreword

It’s a real pleasure to write the foreward to this latest edition of SSIS Unleashed. A lot has changed since the first edition. SQL Server has a new edition, the business environment is ever more challenging, and Kirk and I both have new jobs.

SQL Server 2008 includes many enhancements in its Business Intelligence platform in general and several key improvements in its Integration Services component, which is the subject of this book. The new pipeline improvements and support for persistent lookups will help your SSIS packages scale to unprecedented levels. The addition of change data capture and the new Merge SQL statement will make it easier for you to write cleaner, simpler SSIS packages.

These enhancements come at a good time. We live in an interconnected world that makes ETL (Extract, Transform, and Load) more important than ever. As of this writing, the economy is in turmoil and companies everywhere need an accurate, current, three hundred and sixty degree view of their business. Responsible, proactive IT departments integrate data from across the enterprise to present a complete view of the business to their business users. Further, leading companies are accustomed to sharing data with business partners and customers. Think of code sharing among airlines or telecom companies that download call-level detail information to their customers. Many companies purchase data from syndicated data providers, and the Internet has grown to become a rich data source to companies that want to deepen their relationship with consumers. All of these business activities are well served by ETL tools, specifically SQL Server 2008 Integration Services.

As in the first edition, Kirk Haselden is your enthusiastic and capable guide. His deep passion for data and its value to companies and to users has guided his career for many years. He was the Development Manager who delivered SSIS in SQL Server 2005. That effort helped cement SQL Server 2005 as a leader in the data warehousing and business intelligence markets. By 2006 Microsoft customers were asking for help in managing “master data.” I turned to Kirk to start and lead a team that would go on to research the MDM market and, in 2007, begin implementation of Microsoft’s SharePoint Master Data Services product. I can’t wait to see the results of Kirk’s latest effort.

In the meantime, you have this latest edition of SSIS Unleashed. As in the first edition, you get a development manager’s—and insider’s—view of the product. Kirk takes you inside the product and provides the insight that will help you optimize your use of the product, and your impact on your organization. He provides advice that goes beyond just ETL and addresses good practices that will help you beyond your data integration work. For example, in the new chapter on troubleshooting, Kirk exhorts you to avoid the fuss in the first place, providing a simple roadmap to keeping your implementations simple from the start. Other new chapters cover advance packages, the profiling task, the ADO.NET destination, and other new components. Whether you are migrating from SQL Server 2005 to SQL Server 2008, or if SQL Server 2008 is your first SQL Server experience, you will be well served by this book.

As always, it’s been a privilege and a pleasure to work with Kirk. His passion and energy are infectious. His care and concern for customers is inspiring. And his writing continues to be top-notch. I hope you enjoy this book.

Bill Baker, CTO Visible Technologies
November 2008, Seattle, WA


© Copyright Pearson Education. All rights reserved.

"Sobre este título" puede pertenecer a otra edición de este libro.

Los mejores resultados en AbeBooks

Edición internacional
Edición internacional

1.

Haselden
ISBN 10: 0672330326 ISBN 13: 9780672330322
Nuevos Tapa blanda Cantidad: 5
Edición internacional
Librería
Romtrade Corp.
(STERLING HEIGHTS, MI, Estados Unidos de America)
Valoración
[?]

Descripción Estado de conservación: New. Brand New Paperback International Edition.We Ship to PO BOX Address also. EXPEDITED shipping option also available for faster delivery. Nº de ref. de la librería AUSBNEW-46827

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 28,41
Convertir moneda

Añadir al carrito

Gastos de envío: GRATIS
A Estados Unidos de America
Destinos, gastos y plazos de envío

2.

Haselden, Kirk
Editorial: Sams Publishing (2009)
ISBN 10: 0672330326 ISBN 13: 9780672330322
Nuevos Paperback Cantidad: 2
Librería
Murray Media
(North Miami Beach, FL, Estados Unidos de America)
Valoración
[?]

Descripción Sams Publishing, 2009. Paperback. Estado de conservación: New. Nº de ref. de la librería P110672330326

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 45,77
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 2,55
A Estados Unidos de America
Destinos, gastos y plazos de envío

3.

Kirk Haselden
Editorial: Sams Publishing (2009)
ISBN 10: 0672330326 ISBN 13: 9780672330322
Nuevos Paperback Cantidad: 1
Librería
Ergodebooks
(RICHMOND, TX, Estados Unidos de America)
Valoración
[?]

Descripción Sams Publishing, 2009. Paperback. Estado de conservación: New. 1. Nº de ref. de la librería DADAX0672330326

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 52,64
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 3,40
A Estados Unidos de America
Destinos, gastos y plazos de envío

4.

Haselden, Kirk
Editorial: Sams Publishing
ISBN 10: 0672330326 ISBN 13: 9780672330322
Nuevos PAPERBACK Cantidad: 1
Librería
Cloud 9 Books
(Wellington, FL, Estados Unidos de America)
Valoración
[?]

Descripción Sams Publishing. PAPERBACK. Estado de conservación: New. 0672330326 New Condition. Nº de ref. de la librería NEW6.0332101

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 52,68
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 4,25
A Estados Unidos de America
Destinos, gastos y plazos de envío

5.

Kirk Haselden
Editorial: Sams Publishing (2009)
ISBN 10: 0672330326 ISBN 13: 9780672330322
Nuevos Tapa blanda Cantidad: > 20
Librería
Palexbooks
(Sanford, NC, Estados Unidos de America)
Valoración
[?]

Descripción Sams Publishing, 2009. Estado de conservación: New. Brand new! Please provide a physical shipping address. Nº de ref. de la librería 9780672330322

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 57,50
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 2,56
A Estados Unidos de America
Destinos, gastos y plazos de envío

6.

Kirk Haselden
Editorial: Sams Publishing (2009)
ISBN 10: 0672330326 ISBN 13: 9780672330322
Nuevos Paperback Primera edición Cantidad: 1
Librería
Irish Booksellers
(Rumford, ME, Estados Unidos de America)
Valoración
[?]

Descripción Sams Publishing, 2009. Paperback. Estado de conservación: New. book. Nº de ref. de la librería 0672330326

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 84,03
Convertir moneda

Añadir al carrito

Gastos de envío: GRATIS
A Estados Unidos de America
Destinos, gastos y plazos de envío

7.

Haselden, Kirk (Not Available)
Editorial: Sams (2009)
ISBN 10: 0672330326 ISBN 13: 9780672330322
Nuevos Paperback Cantidad: 1
Librería
Revaluation Books
(Exeter, Reino Unido)
Valoración
[?]

Descripción Sams, 2009. Paperback. Estado de conservación: Brand New. 1st edition. 758 pages. 9.00x7.00x1.75 inches. In Stock. Nº de ref. de la librería zk0672330326

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 79,42
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 6,71
De Reino Unido a Estados Unidos de America
Destinos, gastos y plazos de envío