Deliver to your Kindle or other device

 
 
 

Try it free

Sample the beginning of this book for free

Deliver to your Kindle or other device

Sorry, this item is not available in
Image not available for
Colour:
Image not available
 

Professional Microsoft SQL Server 2014 Integration Services (Wrox Programmer to Programmer) [Kindle Edition]

Brian Knight , Devin Knight , Jessica M. Moss , Mike Davis , Chris Rock
5.0 out of 5 stars  See all reviews (1 customer review)

Print List Price: £36.99
Kindle Price: £23.74 includes VAT* & free wireless delivery via Amazon Whispernet
You Save: £13.25 (36%)
* Unlike print books, digital books are subject to VAT.

Free Kindle Reading App Anybody can read Kindle books—even without a Kindle device—with the FREE Kindle app for smartphones, tablets and computers.

To get the free app, enter your e-mail address or mobile phone number.

Formats

Amazon Price New from Used from
Kindle Edition £23.74  
Paperback £36.99  
Kindle Daily Deal
Kindle Daily Deal: Up to 70% off
Each day we unveil a new book deal at a specially discounted price--for that day only. Learn more about the Kindle Daily Deal or sign up for the Kindle Daily Deal Newsletter to receive free e-mail notifications about each day's deal.

Book Description

Fill the gap between planning and doing with SSIS 2014

The 2014 release of Microsoft's SQL Server Integration Servicesprovides enhancements for managing extraction, transformation, andload operations, plus expanded in-memory capabilities, improveddisaster recovery, increased scalability, and much more. Theincreased functionality will streamline your ETL processes andsmooth out your workflow, but the catch is that your workflow mustchange. New tools come with new best practices, and ProfessionalMicrosoft SQL Server 2014 Integration Services will keep youahead of the curve. SQL Server MVP Brian Knight is the mostrespected name in the business, and your ultimate guide tonavigating the changes to use Microsoft SQL Server IntegrationServices 2014 to your utmost advantage.

  • Implement new best practices for effective use of SSIS
  • Work through tutorials for hands-on learning of complextechniques
  • Read case studies that illustrate the more advancedconcepts
  • Learn directly from the foremost authority on SSIS

SQL Server Integration Services is a complex tool, but it's thelifeblood of your work. You need to know it inside out, and youmust understand the full potential of its capabilities in order touse it effectively. You need to make sure the right architecture isin place. Professional Microsoft SQL Server 2014 IntegrationServices is your roadmap to understanding SSIS on a fundamentallevel, and setting yourself up for success.



Product Description

Review

This book is suitable for both developers that are newto SSIS development, and experienced developers looking for a morecomplete understanding. I highly recommend it. (IProgrammer, July 2014)

From the Back Cover

A complete guide to Microsoft SSIS, updated for the 2014release

Renowned SQL Server MVP Brian Knight and his expert co–authorsteach you best practices for using all of the features of MicrosoftSQL Server Integration Services (SSIS), including the latestenhancements introduced with the 2014 release of SQL Server. Inaddition to technical updates and additions, the authors also add anew set of best practices for effective use of SSIS, more casestudies, and tutorial examples to illustrate advanced concepts andtechniques.

Professional Microsoft SQL Server 2014 IntegrationServices:

  • Explains how to extract, transform, and load (ETL) data withSSIS
  • Covers each of the many SSIS tasks and Data Flowcomponents
  • Teaches you the most effective techniques for performancetuning SSIS
  • Covers advanced techniques for data cleansing and incrementalloads
  • Shows how to load a data warehouse using built–in components inSSIS
  • Details best practices for manageability and scalability

Product details

  • Format: Kindle Edition
  • File Size: 104787 KB
  • Print Length: 856 pages
  • Page Numbers Source ISBN: 1118850874
  • Publisher: Wrox; 1 edition (17 April 2014)
  • Sold by: Amazon Media EU S.à r.l.
  • Language: English
  • ASIN: B00JSQ3RLG
  • Text-to-Speech: Enabled
  • X-Ray:
  • Word Wise: Not Enabled
  • Average Customer Review: 5.0 out of 5 stars  See all reviews (1 customer review)
  • Amazon Bestsellers Rank: #161,572 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
  •  Would you like to give feedback on images?


More About the Authors

Discover books, learn about writers, and more.

Customer Reviews

4 star
0
3 star
0
2 star
0
1 star
0
5.0 out of 5 stars
5.0 out of 5 stars
Most Helpful Customer Reviews
3 of 4 people found the following review helpful
Format:Paperback
Hi,

I have written a detailed chapter-by-chapter review of this book on www DOT i-programmer DOT info, the first and last parts of this review follow:

A popular SQL Server Integration Services (SSIS) book receives an upgrade for 2014 – how does it fare?

This is a revised version of a popular SSIS book, updated for SQL Server 2014. SSIS allows you to extract, transform and load (ETL) data. The tool can be used by a variety of users (developers, DBAs, and casual users) and at various levels of expertise.

The introduction highlights the importance of SSIS in transforming and moving data, in a speedy manner. Compared with other related products (e.g. Informatica and DataStage), SSIS is cheap, in that it comes free with SQL Server – similar products can cost many thousands of dollars. The book’s initial chapters are aimed at developers that are new to SSIS, while the later chapters contain patterns and practices targeted at more experienced developers.

Chapter 1 Welcome to SQL Server Integration Services
The chapter starts with a short history of SSIS, with its roots in Data Transformation Services (DTS), evolving into SSIS in SQL Server 2005. Each successive new version of SQL Server typically adding new features and enhanced functionality, this was especially so of SQL Server 2012.

The Import and Export Wizard is introduced as an entry point into SSIS, allowing simple movement and transformation of data. For more complex solutions, SQL Server Data Tools (SSDT) is used, this is where most SSIS work is done.
Read more ›
Comment | 
Was this review helpful to you?
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 4.8 out of 5 stars  4 reviews
6 of 6 people found the following review helpful
5.0 out of 5 stars Outstanding Integration Services resource 2 Jun. 2014
By Faiz Farazi - Published on Amazon.com
Format:Paperback
Brian Knight’s Professional Microsoft SQL Server 2014 Integration Services is an excellent resource for IT professionals needing to make effective use of this ETL tool.I had worked with SSIS 2008 but found it somewhat clumsy and lacking in completeness. Now wanting to get back into SSIS with version 2014 I was looking for a resource to help me go deep and make it really a great work tool. This book did the trick. Brian Knight emphasis and explanations on the data flow task and Joining Data were very helpful.
1 of 1 people found the following review helpful
4.0 out of 5 stars Written by high level experts; too wordy for its own good. 10 Nov. 2014
By Jaewoo Kim - Published on Amazon.com
Format:Paperback
Some books are far better off providing visualization rather than more words. This book seems to have focused on having as many words as possible to fill up a thick book. I would like to have seen more downloadable code examples, which was sufficient in quantity and quality, but still not enough to my liking.

Is this book comprehensive? I think it is the most comprehensive book on SSIS I have read. Would I want to read this book from the beginning to end? No, and I am a very fast reader.

On the bright side, the book is written by SSIS experts with many years of experience and its shows. They cover not only SSIS but many parts of data warehousing, SSAS, T-SQL, and even C# codes. I think this is the most authoritative book on SSIS I have read.

I also think the book could have included hypothetical problem and solutions (although it implicitly provides that in the code samples).

It is too bad, the book could have been just as effective with about half the words.

Pros:
1)Written by group of SSIS experts.
2)Comprehensive coverage of SSIS and related data warehousing and SSAS concepts.
3)Detailed coverage. This isn't just an overview.

Cons:
1)Wordy. It is as if the authors were paid by the number of words they have written.
2)Lacking in specific hypotheticals and solutions. For me, I want to know how to use SSIS to solve a problem, not necessarily on how SSIS works to an exacting detail.
3)Scant coverage of MDX and DMX. Yes, very few organizations use them, but I also think they could have covered it a little bit.
3 of 4 people found the following review helpful
5.0 out of 5 stars Gain a professional level of understanding of SSIS 7 July 2014
By Ian Stirk - Published on Amazon.com
Format:Paperback
Hi,

I have written a detailed chapter-by-chapter review of this book on www DOT i-programmer DOT info, the first and last parts of this review are given here. For my review of all chapters, search i-programmer DOT info for STIRK together with the book's title.

A popular SQL Server Integration Services (SSIS) book receives an upgrade for 2014 - how does it fare?

This is a revised version of a popular SSIS book, updated for SQL Server 2014. SSIS allows you to extract, transform and load (ETL) data. The tool can be used by a variety of users (developers, DBAs, and casual users) and at various levels of expertise.

The introduction highlights the importance of SSIS in transforming and moving data, in a speedy manner. Compared with other related products (e.g. Informatica and DataStage), SSIS is cheap, in that it comes free with SQL Server - similar products can cost many thousands of dollars. The book's initial chapters are aimed at developers that are new to SSIS, while the later chapters contain patterns and practices targeted at more experienced developers.

Chapter 1 Welcome to SQL Server Integration Services
The chapter starts with a short history of SSIS, with its roots in Data Transformation Services (DTS), evolving into SSIS in SQL Server 2005. Each successive new version of SQL Server typically adding new features and enhanced functionality, this was especially so of SQL Server 2012.

The Import and Export Wizard is introduced as an entry point into SSIS, allowing simple movement and transformation of data. For more complex solutions, SQL Server Data Tools (SSDT) is used, this is where most SSIS work is done.

The architecture of SSIS is outlined, with the major components being:
*Packages (comparable to executables, containing workflow and business logic)
*Control Flow (the brain of the package, orchestrating workflow)
*Data Flow (heart/pump, moving and transforming data from source to destination)
*Variables (allow dynamic evaluation of expressions and decision making)
*Parameters (like variables, allow package to be dynamic)
*Error Handling and Logging (useful for troubleshooting and auditing)

An outline of the common Control Flow tasks is given, together with common sources, destinations, and transformations used by the Data Flow component. Finally, an overview of the various editions of SQL Server is given.

This chapter puts SSIS into context, and provides an overview of what to expect in the rest of the book. The summary list of Control Flow tasks, together with the summary list of Data Flow sources, destinations and transformations, are useful for getting an early understanding of the potential functionality of SSIS. The chapter contains useful links to more detailed chapters. Helpful examples are provided, together with plenty of screenshots and an easy reading style (as it is throughout the book).
.
.
.
Conclusion
This book aims to take you to a professional level of understanding of SSIS, and I think it succeeds admirably. The book is an easy read, the authors have taken the time to explain things in a clear yet concise manner. The book assumes no previous knowledge of SSIS, and will take your level of understanding to around level 8 (out of 10). The book as a whole has a good flow between chapters.

The book is replete with step-by-step examples, with good use of screenshots to further aid understanding. Most of the examples are based on the sample Microsoft databases, allowing you follow along, any additional files can be downloaded from the publisher. There's a helpful (if short) summary at the end of each chapter, and useful links between the chapters. There are plenty of incidental tips introduced during the discussions (e.g. use the Union All transform as a dummy destination).

As the authors admit in Chapter 1, SSIS in SQL Server 2014 is very similar to SSIS in SQL Server 2012, very little has changed. Indeed, perhaps 95% of this book is the `same' as the SQL Server 2012 version of this book. I would suggest if you have the 2012 version of the book you don't need this version. Similarly, if you deal with SQL Server 2012 and don't have an SSIS book, you could use this 2014 version of the book. Perhaps publishers should produce a book(let) of changes that exist between the two book versions too.

However joyous it may be for the authors, I found the religious references in the acknowledgments both comical and disconcerting (e.g. I want to thank god). If you swap `god' with Huitzilopochtli or Zeus you'll understand what I mean.

This book is suitable for both developers that are new to SSIS development, and experienced developers looking for a more complete understanding. I highly recommend it.
5.0 out of 5 stars Five Stars 26 Dec. 2014
By John R. Wells - Published on Amazon.com
Format:Paperback|Verified Purchase
Tons of information!
Were these reviews helpful?   Let us know
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

Search Customer Discussions
Search all Amazon discussions
   


Look for similar items by category