1. Professional Microsoft SQL Server 2014 Integration Services (Wrox Programmer to Programmer) (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.
Author(s): Brian Knight, Devin Knight
Distribute Actionable, Timely BI with Microsoft® SQL Server® 2016 and Power BI
Drive better, faster, more informed decision making across your organization using the expert tips and best practices featured in this hands-on guide. Delivering Business Intelligence with Microsoft SQL Server 2016, Fourth Edition, shows, step-by-step, how to distribute high-performance, custom analytics to users enterprise-wide. Discover how to build BI Semantic Models, create data marts and OLAP cubes, write MDX and DAX scripts, and share insights using Microsoft client tools. The book includes coverage of self-service business intelligence with Power BI.
• Understand the goals and components of successful BI
• Build data marts, OLAP cubes, and Tabular models
• Load and cleanse data with SQL Server Integration Services
• Manipulate and analyze data using MDX and DAX scripts and queries
• Work with SQL Server Analysis Services and the BI Semantic Model
• Author interactive reports using SQL Server Data Tools
• Create KPIs and digital dashboards
• Implement time-based analytics
• Embed data model content in custom applications using ADOMD.NET
• Use Power BI to gather, model, and visualize data in a self-service environment
Author(s): Brian Larson
3. SSIS Easy Handbook (2016)
Author(s): Charles Brown
4. SSIS In a Day (2016)
Author(s): Nicole Lyons
Extending SSIS with .NET Scripting is a timeless and comprehensive scripting toolkit for SQL Server Integration Services to solve a wide array of everyday problems that SSIS developers encounter. The detailed explanation of the Script Task and Script Component foundations helps you develop your own scripting solutions, but this book also shows a broad arsenal of readymade and well-documented scripting solutions for common problems. All examples are in both C# and VB.NET, and work for all current versions of SSIS.
SSIS is one of the leading ETL, Data Consolidation, and Data Transformation tools in today’s market. SSIS is used by ETL Developers, DBAs and Data Analysts to transform data as required for different ETL processes. There are many built-in components and tasks to help developers to perform actions. For example, there are tasks for sending and receiving files through FTP, sending an email, and for accessing a wide range of database management systems. Yet there are times when developers require a task or component that does not exist and it would make their life much easier if they could create that task or component, and that is what this book it is about. It shows how to write .NET scripts and use the powerful Microsoft .NET library to implement new functionality as needed.
- Provides a timeless scripting toolkit for all current SSIS versions
- Gives a comprehensive explanation of scripting in SSIS
- Offers a wide array of readymade examples for everyday problems
Author(s): Joost van Rossum, Regis Baccaro
Microsoft SQL Server 2012 Integration Services (SISS) builds on the revolutionary database product suite first introduced in 2005. With this crucial resource, you will explore how this newest release serves as a powerful tool for performing extraction, transformation, and load operations (ETL). A team of SQL Server experts deciphers this complex topic and provides detailed coverage of the new features of the 2012 product release. In addition to technical updates and additions, the authors present you with a new set of SISS best practices, based on years of real-world experience that have transpired since the previous edition was published.
- Details the newest features of the 2012 SISS product release, which is the most significant release since 2005
- Addresses the keys to a successful ETL solution, such as using the right enterprise ETL tool and employing the right ETL architecture in order to meet the system requirements
- Includes additional case studies and tutorial examples to illustrate advanced concepts and techniques
Professional Microsoft SQL Server 2012 Integration Services is a valuable resource that meets the demands and high expectations of experienced SSIS professionals.
Author(s): Brian Knight, Erik Veerman
- Configure and execute Visual Studio in the way that best supports SSIS task development
- Create a class library as the basis for an SSIS task, and reference the needed SSIS assemblies
- Properly sign assemblies that you create in order to invoke them from your task
- Implement source code control via Visual Studio Team Services, or your own favorite tool set
- Code not only your tasks themselves, but also the associated task editors
- Troubleshoot and then execute your custom tasks as part of your own project
Database administrators and developers who are involved in ETL projects built around SQL Server Integration Services (SSIS). Readers should have a background in programming along with a desire to optimize their ETL efforts by creating custom-tailored tasks for execution from SSIS packages.
Author(s): Andy Leonard
Author(s): Dr. Amin Jalali
Book-and-video package gets novices up to speed on Microsoft SQL Server 2012
If you need a practical, hands-on introduction, especially to SQL Server Integration Services (SSIS), this book-and-video package from authority Brian Knight is the perfect solution. Each lesson includes three major components: a description of how each SSIS feature or process works, a tutorial that walks you through the process or technique, and an accompanying video lesson. It’s a complete learning package that will give you the confidence you need to start your first SSIS project.
- Guides novice database administrators and developers who are learning Microsoft SQL Server 2012 and SQL Server Integration Services (SSIS)
- Provides expert instruction from leading SQL Server authority and author, Brian Knight
- Includes a book and a video, complete instruction that includes lessons, hands-on tutorials, and video demonstrations by the author
- Covers the very latest changes and updates in the SQL Server 2012 release
Microsoft SQL Server 2012 Integration Services 24-Hour Trainer makes SQL Server 2012 and SSIS much less intimidating.
Note: CD-ROM/DVD and other supplementary materials are not included as part of the e-book file, but are available for download after purchase.
Author(s): Brian Knight, Devin Knight
This book takes a rational, no-nonsense approach in a compact guide – only 224 pages. The book is written to give you the basics…fast!
Technical Accuracy is assured by Ashvini Sharma, Development Lead, SQL Server Integration Services, Microsoft Corporation.
* Bonus Chapter: “Monitoring SSIS Performance with Scripts”
* Bonus Chapter: “Accessing Web Services with SSIS Scripts”
* Bonus Chapter: “Using SSIS as a Data Service”
* Sample code for the examples in the book
Author(s): Donald Farmer
11. SQL Server 2012 Data Integration Recipes: Solutions for Integration Services and Other ETL Tools (Expert’s Voice in SQL Server) (2012)
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
Author(s): Adam Aspin
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
Author(s): Tim Mitchell, Matt Masson