Microsoft SQL Server 2012 with Hadoop
By Debarchan Sarkar
Publisher: Packt Publishing
Final Release Date: August 2013
Pages: 96

In Detail

With the explosion of data, the open source Apache Hadoop ecosystem is gaining traction, thanks to its huge ecosystem that has arisen around the core functionalities of its distributed file system (HDFS) and Map Reduce. As of today, being able to have SQL Server talking to Hadoop has become increasingly important because the two are indeed complementary. While petabytes of unstructured data can be stored in Hadoop taking hours to be queried, terabytes of structured data can be stored in SQL Server 2012 and queried in seconds. This leads to the need to transfer and integrate data between Hadoop and SQL Server.

Microsoft SQL Server 2012 with Hadoop is aimed at SQL Server developers. It will quickly show you how to get Hadoop activated on SQL Server 2012 (it ships with this version). Once this is done, the book will focus on how to manage big data with Hadoop and use Hadoop Hive to query the data. It will also cover topics such as using in-memory functions by SQL Server and using tools for BI with big data.

Microsoft SQL Server 2012 with Hadoop focuses on data integration techniques between relational (SQL Server 2012) and non-relational (Hadoop) worlds. It will walk you through different tools for the bi-directional movement of data with practical examples.

You will learn to use open source connectors like SQOOP to import and export data between SQL Server 2012 and Hadoop, and to work with leading in-memory BI tools to create ETL solutions using the Hive ODBC driver for developing your data movement projects. Finally, this book will give you a glimpse of the present day self-service BI tools such as Excel and PowerView to consume Hadoop data and provide powerful insights on the data.

Approach

This book will be a step-by-step tutorial, which practically teaches working with big data on SQL Server through sample examples in increasing complexity.

Who this book is for

Microsoft SQL Server 2012 with Hadoop is specifically targeted at readers who want to cross-pollinate their Hadoop skills with SQL Server 2012 business intelligence and data analytics. A basic understanding of traditional RDBMS technologies and query processing techniques is essential.

Product Details
Recommended for You
Customer Reviews

REVIEW SNAPSHOT®

by PowerReviews
oreillyMicrosoft SQL Server 2012 with Hadoop
 
4.7

(based on 3 reviews)

Ratings Distribution

  • 5 Stars

     

    (2)

  • 4 Stars

     

    (1)

  • 3 Stars

     

    (0)

  • 2 Stars

     

    (0)

  • 1 Stars

     

    (0)

100%

of respondents would recommend this to a friend.

Pros

  • Easy to understand (3)
  • Well-written (3)

Cons

    Best Uses

    • Novice (3)
    • Student (3)
      • Reviewer Profile:
      • Developer (3)

    Reviewed by 3 customers

    Sort by

    Displaying reviews 1-3

    Back to top

     
    4.0

    Review of SQL Server 2012 with Hadoop

    By Anindita

    from Hyderabad,India

    About Me Developer

    Verified Reviewer

    Pros

    • Accurate
    • Concise
    • Easy to understand
    • Well-written

    Cons

    • Too basic

    Best Uses

    • Intermediate
    • Novice
    • Student

    Comments about oreilly Microsoft SQL Server 2012 with Hadoop:

    Overall complete coverage of SQL Server 2012 integration with Hadoop, hive.A must read book for beginners who is going to start a project on hadoop with SQL.

    (1 of 1 customers found this review helpful)

     
    5.0

    Highly recommended

    By SQLDudette

    from TX

    About Me Developer, Educator

    Pros

    • Easy to understand
    • Helpful examples
    • Well-written

    Cons

    • Overpriced

    Best Uses

    • Novice
    • Student

    Comments about oreilly Microsoft SQL Server 2012 with Hadoop:

    Got me going real easy in Hadoop. Nice explanations and illustrations make life easier for a SQL user. Little overpriced though!

    (3 of 3 customers found this review helpful)

     
    5.0

    Perfect for a beginner

    By Data Dork

    from United States

    About Me Developer, Sys Admin

    Verified Reviewer

    Pros

    • Accurate
    • Concise
    • Easy to understand
    • Helpful examples
    • Well-written

    Cons

      Best Uses

      • Novice
      • Student

      Comments about oreilly Microsoft SQL Server 2012 with Hadoop:

      I have been a SQL DBA for last decade or so and wanted to get along with the current market hype of Big Data. This book is a perfect guide to get you started with Big Data and BI technologies. It will suit you more if you have a SQL background.

      Displaying reviews 1-3

      Back to top

       
      Buy 2 Get 1 Free Free Shipping Guarantee
      Buying Options
      Immediate Access - Go Digital what's this?
      Ebook: $23.99
      Formats:  ePub, Mobi, PDF