Sie sind bereits eingeloggt. Klicken Sie auf 2. tolino select Abo, um fortzufahren.
Bitte loggen Sie sich zunächst in Ihr Kundenkonto ein oder registrieren Sie sich bei bücher.de, um das eBook-Abo tolino select nutzen zu können.
Fill the gap between planning and doing with SSIS 2014 The 2014 release of Microsoft's SQL Server Integration Services provides enhancements for managing extraction, transformation, and load operations, plus expanded in-memory capabilities, improved disaster recovery, increased scalability, and much more. The increased functionality will streamline your ETL processes and smooth out your workflow, but the catch is that your workflow must change. New tools come with new best practices, and Professional Microsoft SQL Server 2014 Integration Services will keep you ahead of the curve. SQL Server…mehr
Fill the gap between planning and doing with SSIS 2014 The 2014 release of Microsoft's SQL Server Integration Services provides enhancements for managing extraction, transformation, and load operations, plus expanded in-memory capabilities, improved disaster recovery, increased scalability, and much more. The increased functionality will streamline your ETL processes and smooth out your workflow, but the catch is that your workflow must change. New tools come with new best practices, and Professional Microsoft SQL Server 2014 Integration Services will keep you ahead of the curve. SQL Server MVP Brian Knight is the most respected name in the business, and your ultimate guide to navigating the changes to use Microsoft SQL Server Integration Services 2014 to your utmost advantage. * Implement new best practices for effective use of SSIS * Work through tutorials for hands-on learning of complex techniques * Read case studies that illustrate the more advanced concepts * Learn directly from the foremost authority on SSIS SQL Server Integration Services is a complex tool, but it's the lifeblood of your work. You need to know it inside out, and you must understand the full potential of its capabilities in order to use it effectively. You need to make sure the right architecture is in place. Professional Microsoft SQL Server 2014 Integration Services is your roadmap to understanding SSIS on a fundamental level, and setting yourself up for success.
Brian Knight is the founder of Pragmatic Works and co-founder of SQLServerCentral.com and JumpstartTV.com. Devin Knight is a SQL Server MVP, the Training Director at Pragmatic Works, and an author on six SQL Server books. Jessica M. Moss is a well-known architect, speaker, author, and Microsoft MVP of SQL Server business intelligence who has created data warehousing solutions for a variety of industries. Mike Davis, MCTS, MCITP, is the Managing Project Lead at Pragmatic Works, has co-authored several business intelligence books, and regularly speaks at SQL events. Chris Rock is a software developer and program manager at Pragmatic Works, where he develops custom SSIS components and software. Wrox Professional guides are planned and written by working programmers to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.
Inhaltsangabe
Introduction xxvii Chapter 1: Welcome to SQL Server Integration Services 1 Chapter 2: The SSIS Tools 17 Chapter 3: SSIS Tasks 39 Chapter 4: The Data Flow 99 Chapter 5: Using Variables, Parameters, and Expressions 165 Chapter 6: Containers 205 Chapter 7: Joining Data 219 Chapter 8: Creating an End-to-End Package 253 Chapter 9: Scripting in SSIS 275 Chapter 10: Advanced Data Cleansing in SSIS 335 Chapter 11: Incremental Loads in SSIS 363 Chapter 12: Loading a Data Warehouse 381 Chapter 13: Using the Relational Engine 429 Chapter 14: Accessing Heterogeneous Data 453 Chapter 15: Reliability and Scalability 497 Chapter 16: Understanding and Tuning the Data Flow Engine 529 Chapter 17: SSIS Software Development Life Cycle 563 Chapter 18: Error and Event Handling 591 Chapter 19: Programming and Extending SSIS 631 Chapter 20: Adding a User Interface to Your Component 689 Chapter 21: External Management and WMI Task Implementation 715 Chapter 22: Administering SSIS 767 Appendix A: SSIS Crib Notes 821 Appendix B: SSIS Internal Views and Stored Procedures 829 Appendix C: Interviewing for an ETL Developer Position 833 Index 839