Скачать через торрент The Experts Voice in SQL Server - Aspin A. - SQL Server 2012 Data Integration Recipes бесплатно torrent (книга, аудиокнига, журнал, комикс
Внимание!!! AdBlock блокирует показ некоторых скриншотов. Пожалуйста, все вопросы к разработчкикам
Автор
Сообщение
Galfimbul
SQL Server 2012 Data Integration Recipes
Год: 2013 Автор: Aspin A. Издательство: Apress ISBN: 978-1-4302-4792-0 Серия: The Expert''s Voice in SQL Server Язык: Английский Формат: PDF/EPUB Качество: Изначально компьютерное (eBook) Интерактивное оглавление: Да Количество страниц: 1043 Описание: SQL Server 2012 Data Integration Recipes provides focused and practical solutions to real world problems of data integration. Need to import data into SQL Server from an outside source? Need to export data and send it to another system? SQL Server 2012 Data Integration Recipes has your back. You''ll find solutions for importing from Microsoft Office data stores such as Excel and Access, from text files such as CSV files, from XML, from other database brands such as Oracle and MySQL, and even from other SQL Server databases. You''ll learn techniques for managing metadata, transforming data to meet the needs of the target system, handling exceptions and errors, and much more.
What DBA or developer isn''t faced with the need to move data back and forth? Author Adam Aspin brings 10 years of extensive ETL experience involving SQL Server, and especially satellite products such as Data Transformation Services and SQL Server Integration Services. Extensive coverage is given to Integration Services, Microsoft''s flagship tool for data integration in SQL Server environments. Coverage is also given to the broader range of tools such as OPENDATASOURCE, linked servers, OPENROWSET, Migration Assistant for Access, BCP Import, and BULK INSERT just to name a few. If you''re looking for a resource to cover data integration and ETL across the gamut of Microsoft''s SQL Server toolset, SQL Server 2012 Data Integration Recipes is the one book that will meet your needs.
- Provides practical and proven solutions towards creating resilient ETL environments - Clearly answers the tough questions which professionals ask - Goes beyond the tools to a thorough discussion of the underlying techniques - Covers the gamut of data integration, beyond just SSIS - Includes example databases and files to allow readers to test the recipes
About the Author xlv About the Technical Reviewers xlvii Acknowledgments xlix Introduction li Chapter 1: Sourcing Data from MS Office Applications 1 Chapter 2: Flat File Data Sources 61 Chapter 3: XML Data Sources 133 Chapter 4: SQL Databases 179 Chapter 5: SQL Server Sources 241 Chapter 6: Miscellaneous Data Sources 285 Chapter 7: Exporting Data from SQL Server 343 Chapter 8: Metadata 425 Chapter 9: Data Transformation 481 Chapter 10: Data Profiling 559 Chapter 11: Delta Data Management 619 Chapter 12: Change Tracking and Change Data Capture 681 Chapter 13: Organising And Optimizing Data Loads 731 Chapter 14: ETL Process Acceleration 801 Chapter 15: Logging and Auditing 853 Appendix A: Data Types 931 Appendix B: Sample Databases and Scripts 973 Index 989
Опубликовано группой
Внимание! AdBlock блокирует показ скриншотов, все вопросы к разработчикам )))