Professional Microsoft SQL Server 2014 Integration Services und über 1,5 Millionen weitere Bücher verfügbar für Amazon Kindle. Erfahren Sie mehr
EUR 47,20
  • Alle Preisangaben inkl. MwSt.
Nur noch 4 auf Lager (mehr ist unterwegs).
Verkauf und Versand durch Amazon.
Geschenkverpackung verfügbar.
Möchten Sie verkaufen?
Zur Rückseite klappen Zur Vorderseite klappen
Anhören Wird wiedergegeben... Angehalten   Sie hören eine Probe der Audible-Audioausgabe.
Weitere Informationen
Alle 2 Bilder anzeigen

Professional Microsoft SQL Server 2014 Integration Services (Wrox Programmer to Programmer) (Englisch) Taschenbuch – 6. Juni 2014

Alle 2 Formate und Ausgaben anzeigen Andere Formate und Ausgaben ausblenden
Amazon-Preis Neu ab Gebraucht ab
Kindle Edition
"Bitte wiederholen"
"Bitte wiederholen"
EUR 47,20
EUR 24,26 EUR 50,42
52 neu ab EUR 24,26 2 gebraucht ab EUR 50,42

Wird oft zusammen gekauft

Professional Microsoft SQL Server 2014 Integration Services (Wrox Programmer to Programmer) + jQuery: Das universelle JavaScript-Framework für das interaktive Web und mobile Anwendungen
Preis für beide: EUR 77,19

Die ausgewählten Artikel zusammen kaufen
Jeder kann Kindle Bücher lesen — selbst ohne ein Kindle-Gerät — mit der KOSTENFREIEN Kindle App für Smartphones, Tablets und Computer.


Mehr über die Autoren

Entdecken Sie Bücher, lesen Sie über Autoren und mehr



"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." (I Programmer, July 2014)


A complete guide to Microsoft SSIS, updated for the 2014 release
Renowned SQL Server MVP Brian Knight and his expert co-authors teach you best practices for using all of the features of Microsoft SQL Server Integration Services (SSIS), including the latest enhancements introduced with the 2014 release of SQL Server. In addition to technical updates and additions, the authors also add a new set of best practices for effective use of SSIS, more case studies, and tutorial examples to illustrate advanced concepts and techniques.
Professional Microsoft SQL Server 2014 Integration Services:
* Explains how to extract, transform, and load (ETL) data with SSIS
* Covers each of the many SSIS tasks and Data Flow components
* Teaches you the most effective techniques for performance tuning SSIS
* Covers advanced techniques for data cleansing and incremental loads
* Shows how to load a data warehouse using built-in components in SSIS
* Details best practices for manageability and scalability

Welche anderen Artikel kaufen Kunden, nachdem sie diesen Artikel angesehen haben?

In diesem Buch (Mehr dazu)
Ausgewählte Seiten ansehen
Buchdeckel | Copyright | Inhaltsverzeichnis | Auszug | Stichwortverzeichnis | Rückseite
Hier reinlesen und suchen:


Es gibt noch keine Kundenrezensionen auf
5 Sterne
4 Sterne
3 Sterne
2 Sterne
1 Sterne

Die hilfreichsten Kundenrezensionen auf (beta) 4 Rezensionen
5 von 5 Kunden fanden die folgende Rezension hilfreich
Outstanding Integration Services resource 2. Juni 2014
Von Faiz Farazi - Veröffentlicht auf
Format: Taschenbuch
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.
2 von 3 Kunden fanden die folgende Rezension hilfreich
Gain a professional level of understanding of SSIS 7. Juli 2014
Von Ian Stirk - Veröffentlicht auf
Format: Taschenbuch

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).
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.
Written by high level experts; too wordy for its own good. 10. November 2014
Von Jaewoo Kim - Veröffentlicht auf
Format: Taschenbuch
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.

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.

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.
Five Stars 26. Dezember 2014
Von John R. Wells - Veröffentlicht auf
Format: Taschenbuch Verifizierter Kauf
Tons of information!
Waren diese Rezensionen hilfreich? Wir wollen von Ihnen hören.