An authoritative guide to designing effective solutions for datacleansing, ETL, and file management with SQL Server 2008Integration Services
SQL Server Integration Services (SSIS) is the leading tool inthe data warehouse industry, used for performing extraction,transformation, and load operations.
After an overview of SSIS architecture, the authors walk you aseries of real-world problems and show various techniques forhandling them.
<ul>
<li>Shows you how to design SSIS solutions for data cleansing, ETLand file management</li>
<li>Demonstrates how to integrate data from a variety of datasources,</li>
<li>Shows how to monitor SSIS performance,</li>
<li>Demonstrates how to avoid common pitfalls involved with SSISdeployment</li>
<li>Explains how to ensure performance of the deployed solution andeffectively handle unexpected system failures and outages</li>
<li>The companion Web site provides sample code and databasescripts that readers can directly implement</li>
</ul>
This book shows you how to design, build, deploy, and managesolutions to real-world problems that SSIS administrators anddevelopers face day-to-day.

Microsoft SQL Server 2008 Integration Services: Problem, Design, Solution

Computers & Technology

Moss, Jessica M.

Knight, Brian

Veerman, Erik

Hackney, Jay

Programming

Wrox

An in-depth look at the radical changes to the newest release of SISSMicrosoft 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.
<ul>
<li>Details the newest features of the 2012 SISS product release, which is the most significant release since 2005 </li>
<li>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 </li>
<li>Includes additional case studies and tutorial examples to illustrate advanced concepts and techniques </li>
</ul>
Professional Microsoft SQL Server 2012 Integration Services is a valuable resource that meets the demands and high expectations of experienced SSIS professionals.

Professional Microsoft SQL Server 2012 Integration Services

Rock, Chris

Davis, Mike.

Wrox Pr Inc

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. <ul>
<li>Implement new best practices for effective use of SSIS</li> <li>Work through tutorials for hands-on learning of complex techniques</li> <li>Read case studies that illustrate the more advanced concepts</li> <li>Learn directly from the foremost authority on SSIS</li> </ul>
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.

Professional Microsoft SQL Server 2014 Integration Services (Wrox Programmer to Programmer)

Knight, Devin

Networking & Cloud Computing

Leverage the power of SQL and Office to build a complete enterprise BI solution 
The business intelligence world is changing. Hardware is getting more powerful, platforms are getting more capable, and decision timeframes are getting shorter. Microsoft's SQL Server and Office products provide powerful core BI technologies that allow decision makers who rely on Office for basic analytics to tap into a sophisticated BI toolset for both analysis and reporting. Applied Microsoft Business Intelligence reveals the best practices for building complete BI solutions using SQL Server, Reporting, and Analysis Services along with Excel and SharePoint for a more robust business intelligence framework. 
This book shows you how to use the Microsoft business intelligence building blocks to construct synergetic and complete solutions to suit any organization. Organized chronologically by implementation order, it guides you through the data layer, data transformation and quality, the semantic layer, and the presentation layer, and ties it all together with comprehensive case studies. Focusing on best practices rather than specific tools keeps your skills relevant beyond the 2014 SQL release. Comprehensive explanations including architecture, strengths and weaknesses, and practical applications bring you fully up to speed quickly. 
Applied Microsoft Business Intelligence shows you how to: 
<ul>
<li>Design an effective BI architecture that best fits your organization</li> <li>Develop flexible, scalable, tabular and multi-dimensional models</li> <li>Create interactive visualizations with Power View</li> <li>Explore geographic and temporal data with Power Map</li> <li>Implement self-service delivery and an efficient deployment strategy</li> <li>Manage, maintain, and scale the BI environment</li> </ul>

Applied Microsoft Business Intelligence

wiley

See the best price to sell, buy, or rent books by Moss, Jessica M.. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

Books by Moss, Jessica M.