SQL Server Integration Services Design Patterns

Tim Mitchell, Matt Masson, Andy Leonard , Jessica Moss

$214.95 $171.85

Paperback

Not in-store but you can order this
How long will it take?

Availability Information

We source books from suppliers in Australia and overseas. For books we don't currently have in stock, the time it takes to get them from our suppliers can vary widely - from a few days to a few months - so we check each book with each supplier to determine the expected time it will take to be supplied to us.

We then advise you accordingly. If the time taken to get any book is too long for you, you can let us know and we will cancel or adjust your order, and refund as required.

To find out the anticipated arrival time for specific items prior to ordering, please contact us by phone or email:

Phone +61 2 9264 3111, or 1800 4 BOOKS (1800 4 26657) if outside Sydney:
option 1 Abbey's Bookshop (Crime, History, Science, Kids & more) • info@abbeys.com.au
option 2 Language Book Centre (ESL & Foreign Languages) • language@abbeys.com.au
option 3 Galaxy Bookshop (Sci-fi, Fantasy, Romance, Graphic Novels) • sf@galaxybooks.com.au

QTY:

English

APress
18 December 2014

SQL Server & MS SQL

SQL Server Integration Services Design Patterns is newly-revised for SQL Server 2014, and is a book of recipes for SQL Server Integration Services (SSIS). Design patterns in the book help to solve common problems encountered when developing data integration solutions. The patterns and solution examples in the book increase your efficiency as an SSIS developer, because you do not have to design and code from scratch with each new problem you face. The book's team of expert authors take you through numerous design patterns that you'll soon be using every day, providing the thought process and technical details needed to support their solutions.

SQL Server Integration Services Design Patterns goes beyond the surface of the immediate problems to be solved, delving into why particular problems should be solved in certain ways. You'll learn more about SSIS as a result, and you'll learn by practical example. Where appropriate, the book provides examples of alternative patterns and discusses when and where they should be used. Highlights of the book include sections on ETL Instrumentation, SSIS Frameworks, Business Intelligence Markup Language, and Dependency Services.

Takes you through solutions to common data integration challenges Provides examples involving Business Intelligence Markup Language Teaches SSIS using practical examples

By: Tim Mitchell, Matt Masson, Andy Leonard, Jessica Moss, Michelle Ufford
Imprint: APress
Country of Publication: United States
Edition: 2nd ed.
Dimensions: Height: 254mm, Width: 178mm, Spine: 24mm
Weight: 8.578kg
ISBN: 9781484200834
ISBN 10: 1484200837
Pages: 464
Publication Date: 18 December 2014
Audience: Professional and scholarly , Undergraduate
Format: Paperback
Publisher's Status: Active

1. Metadata Collection Patterns 2. Execution Patterns 3. Scripting Patterns 4. SQL Server Source Patterns 5. Data Cleansing 6. DB2 Source Patterns 7. Flat File Source Patterns 8. Loading a PDW Region in APS 9. XML Patterns 10. Expression Language Patterns 11. Data Warehouse Patterns 12. Loading Parallel Data Warehouse 13. Slowly Changing Dimensions 14. Loading the Cloud 15. Logging and Reporting Patterns 16. Parent-Child Patterns 17. Configuration 18. Deployment 19. Estimating ETL Projects 20. Business Intelligence Markup Language 21. BIML and SSIS Frameworks 22. Appendix A. Evolution of an SSIS Framework

"Tim Mitchell is a business intelligence consultant, database developer, speaker, and trainer. He has been working with SQL Server for more than eight years, working primarily in business intelligence, ETL/SSIS, database development, and reporting. He has earned a number of industry certifications, holds a bachelor's degree in computer science from Texas A&M University at Commerce, and is a Microsoft SQL Server ""Most Valuable Professional"". Tim is a business intelligence consultant for Artis Consulting in the Dallas, Texas area. As an active member of the community, Tim has spoken at venues including numerous SQL Saturday events, Houston Tech Fest, and various user groups and PASS virtual chapters. He is a board member and speaker at the North Texas SQL Server User Group in Dallas, serves as the co-chair of the PASS BI Virtual Chapter, and is an active volunteer for PASS. Tim is an author and forum contributor on SQLServerCentral.com and has published dozens of SQL Server training videos on SQLShare.com. You can visit his website and blog at TimMitchell.net or follow him on Twitter @Tim_Mitchell."

PERHAPS A GIFT VOUCHER FOR MUM?: MOTHER'S DAY

SQL Server Integration Services Design Patterns

Tim Mitchell, Matt Masson, Andy Leonard , Jessica Moss

$214.95 $171.85

Paperback

See Also

Contact Abbeys

Contact Galaxy

Contact Language

Contact Us

About ABBEY'S