Kirk Haselden's Books

Microsoft SQL Server 2005 Integration Services

By: Kirk Haselden

Write a review Read reviews Take a Quiz Solve Book Puzzle

Microsoft SQL Server 2005 Integration Services

By: Kirk Haselden

All medium to large companies have to deal with data being stored in a number of databases, spreadsheets and proprietary applications. Bringing all this data together into one system can be useful to analyzing the business; but can also be quite difficult to do. Integration Services is the next big bet in Microsoft's business intelligence lineup, providing you with true enterprise extract transform and load features (ETL). Microsoft SQL Server 2005 Integration Services concentrates on providing you with real world solutions to real world problems, giving you a head start on various projects. If you are only evaluating Integration Services, you'll be able to focus on the early chapters with the option of drilling down into details in the later chapters where some of the more complex concepts will be discussed in detail. The interesting sidebars peppered throughout the book provide insight into the processes, people and decisions that yielded the final IS product.

Average ratings

N/A

Write a review

Solve jigsaw puzzle

Age

Page Count

742

Publisher

Sams Publishing

Published Date

ISBN 10

0768689988

ISBN 13

9780768689983

Microsoft SQL Server 2008 Integration Services Unleashed

By: Kirk Haselden

Write a review Read reviews Take a Quiz Solve Book Puzzle

Microsoft SQL Server 2008 Integration Services Unleashed

By: Kirk Haselden

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

Average ratings

N/A

Write a review

Solve jigsaw puzzle

Age

Page Count

1050

Publisher

Pearson Education

Published Date

ISBN 10

0768687276

ISBN 13

9780768687279

Microsoft SQL Server 2008 Integration Services Unleashed

By: Kirk Haselden

Write a review Read reviews Take a Quiz Solve Book Puzzle

Microsoft SQL Server 2008 Integration Services Unleashed

By: Kirk Haselden

Average ratings

N/A

Write a review

Solve jigsaw puzzle

Age

Page Count

1050

Publisher

Pearson Education

Published Date

ISBN 10

0768687276

ISBN 13

9780768687279

Book's by Kirk Haselden

Microsoft SQL Server 2005 Integration Services

Microsoft SQL Server 2005 Integration Services

Microsoft SQL Server 2008 Integration Services Unleashed

Microsoft SQL Server 2008 Integration Services Unleashed

Microsoft SQL Server 2008 Integration Services Unleashed

Microsoft SQL Server 2008 Integration Services Unleashed

Username

Password

Username

Password

Password again

Birthday

Email