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

Anybody can read Kindle books—even without a Kindle device—with the FREE Kindle app for smartphones, tablets and computers.
SQL Server 2012 Data Integration Recipes: Solutions for Integration Services and Other ETL Tools (Expert's Voice in SQL Server)
 
 

SQL Server 2012 Data Integration Recipes: Solutions for Integration Services and Other ETL Tools (Expert's Voice in SQL Server) [Kindle Edition]

Adam Aspin
4.7 out of 5 stars  See all reviews (3 customer reviews)

Print List Price: £29.50
Kindle Price: £24.85 includes VAT* & free wireless delivery via Amazon Whispernet
You Save: £4.65 (16%)
* Unlike print books, digital books are subject to VAT.

Formats

Amazon Price New from Used from
Kindle Edition £24.85  
Paperback £29.50  
Kindle Daily Deal
Kindle Daily Deal: At least 60% 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.

Special Offers and Product Promotions

  • Purchase any Kindle Book sold by Amazon.co.uk and receive £1 credit to try out our Digital Music Store. Here's how (terms and conditions apply)


Product Description

Product Description


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




What you’ll learn



  • Import and export to and from CSV files, XML files, and other text-based sources.


  • Move data between SQL databases, including SQL Server and others such as Oracle Database and MySQL.


  • Discover and manage metadata held in various database systems.


  • Remove duplicates and consolidate from multiple sources.


  • Transform data to meet the needs of target systems.


  • Profile source data as part of the discovery process.


  • Log and manage errors and exceptions during an ETL process.


  • Improve efficiency by detecting and processing only changed data.




Who this book is for

SQL Server 2012 Data Integration Recipes is written for developers wishing to find fast and reliable solutions for importing and exporting to and from SQL Server. The book appeals to DBAs as well, who are often tasked with implementing ETL processes. Developers and DBAs moving to SQL Server from other platforms will find the succinct, example-based approach ideal for quickly applying their general ETL knowledge to the specific tools provided as part of a SQL Server environment.



Product details

  • Format: Kindle Edition
  • File Size: 22391 KB
  • Print Length: 1056 pages
  • Publisher: Apress; 1 edition (14 Nov 2012)
  • Sold by: Amazon Media EU S.à r.l.
  • Language: English
  • ASIN: B00ACC6B8G
  • Text-to-Speech: Enabled
  • X-Ray:
  • Average Customer Review: 4.7 out of 5 stars  See all reviews (3 customer reviews)
  • Amazon Bestsellers Rank: #306,623 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
  •  Would you like to give feedback on images?


More About the Author

Discover books, learn about writers, and more.

Customer Reviews

3 star
0
2 star
0
1 star
0
4.7 out of 5 stars
4.7 out of 5 stars
Most Helpful Customer Reviews
5.0 out of 5 stars Just get it. 22 Feb 2013
Format:Paperback|Verified Purchase
I work with Adam at RAC and heard he had a book coming out.He sent me a chapter relating to some index rebuild framework I was working on and it was excellent; very clear and helpful. So I bought the book... and it doesn't disappoint. It's always good to get other views even when you've been doing it as long as I have and this book is clear, well thought out, well tested and thoroughly excellent, reflecting well the author's capabilities!
I would suggest that, if strapped for cash and embarking on a big SSIS ETL project, get this one book and you'll suddenly be a lot further ahead than you thought!
Comment | 
Was this review helpful to you?
5.0 out of 5 stars Best book of all for SSIS advanced developers 22 Dec 2012
Format:Paperback
This is the perfect book for intermediate to advanced SSIS developers. I have read many books cover to cover. Always, problem and solution books published by Apress are amazing.
Especially, I picked a chapter 'Organising And Optimizing Data Loads'. The author does a fabulous job in explaining the efficient ways to process the data.
He's covered the logging framework really well.
Comment | 
Was this review helpful to you?
4.0 out of 5 stars but this is not bad. 2 Sep 2014
Format:Paperback|Verified Purchase
Big heavy and full of recipes, possibly I should have bought a different book for more detail, but this is not bad.
Comment | 
Was this review helpful to you?
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 5.0 out of 5 stars  1 review
5.0 out of 5 stars Working with SSIS? Buy this book! 15 July 2014
By MrTintin - Published on Amazon.com
Format:Paperback
I heard Adam had a book coming out. He sent me a chapter relating to an index rebuild framework I was working on and it was excellent; very clear and helpful. So I bought the book... and it doesn't disappoint. It's always good to get other views even when you've been doing it as long as I have and this book is clear, well thought out, well tested and thoroughly excellent, reflecting well the author's capabilities!
I would suggest that, if strapped for cash and embarking on a big SSIS ETL project, get this one book and you'll suddenly be a lot further ahead than you thought!
Was this review 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