Befriending Dragons

Transform Tech with Anti-bullying Cultures

Leave a comment

What’s all the Buzz about Hadoop and Hive?

What’s all the Buzz about Hadoop and Hive?

Why it Matters for SQL Server Peeps

Small Bites of Big Data

Cindy Gross, SQLCAT PM

On September 20, 2012 we have another 24 Hours of PASS event! This PASS Summit Preview will give you a taste of what is coming at this year’s PASS Summit. There are 190+ technical sessions this year at the Summit, and you’ll get a preview of 24 of them at the #24HOP event tomorrow! Come hear about some of the hottest topics and features in the SQL Server, BI, and data world.

One of the big buzzwords over the last year or so is Hadoop, and the most familiar part of Big Data and Hadoop to most SQL Server professionals is Hive. Do you wonder what it is and why you should jump in now while it’s still new and growing by leaps and bounds? I have just the #24HOP session for you!

#24HOP: What’s all the Buzz about Hadoop and Hive? – Why it Matters for SQL Server Peeps

Everyone is buzzing about Hive and trumpeting the virtues of Hadoop. But what does it mean? Why does it matter to a SQL Server and/or BI professional? Come get a taste of the Hive honey and see why this new technology is worth buzzing about!

During this talk I’ll give a very high level overview of Big Data, Hadoop, and Hive (for the nitty gritty details come to the Summit!). I’ll also go through why Hive matters in the SQL Server world, what a SQL Server Peep might end up doing in a Hive world, and why it is important for you as a SQL Server Peep to jump in and get your feet wet with Hive now.

Once you’ve heard this #24HOP talk I hope you’ll be fired up about Hive and more anxious than ever to sign up for the  PASS Summit to learn even more about Hadoop, Hive, Big Data, and all things BI and SQL Server. I’ll be co-presenting at the Summit with SQL Server PM Dipti Sangani:

SQLCAT: Big Data – All Abuzz About Hive [BIA-305-A]
Session Category: Regular Session (75 minutes)
Session Track: BI Platform Architecture, Development & Administration
Speaker(s): Cindy Gross, Dipti Sangani

Got a bee in your bonnet about simplifying access to Hadoop data? Want to cross-pollinate your existing SQL skills into the world of Big Data? Join this session to see how to become the Queen Bee of your Hadoop world with Hive and gain Business Intelligence insights with HiveQL filters and joins of HDFS datasets. We’ll navigate through the honeycomb to see how HiveQL generates MapReduce code and outputs files to answer your questions about your Big Data.

After this session, you’ll be able to democratize access to Big Data using familiar tools such as Excel and a SQL-like language without having to write MapReduce jobs. You’ll also understand Hive basics, uses, strengths, and limitations and be able to determine if/when to use Hive in combination with Hadoop.

I hope you’ve enjoyed this small bite of big data! Look for more blog posts soon on the samples and other activities.

Note: the CTP and TAP programs are available for a limited time. Details of the usage and the availability of the CTP may change rapidly.

UPDATE 9/28/12 – demo steps to load the AdventureWorks data to Hive are available at

Leave a comment

No new certifications for SQL 2008 R2

Some of you may be wondering if you should get the SQL Server 2008 certifications or wait for new SQL Server 2008 R2 certifications. There’s no point in waiting, because there will not be any new exams for R2. See the blog below for the reasons why. If you want to get a SQL Server certification, go ahead and prepare for the SQL Server 2008 exams.

Why the SQL Server 2008 Certifications Don’t Cover R2

SQL Server Certification

Levels/types of certification, each having a prerequisite of the one before it.

·         MCTS = Pass one test in a given technology area

·         MCITP = Pass one or more tests that relate to a skill area within a product. For SQL Server the three MCITP options are Administrator, Developer, or BI.

·         MCM/Master = Pass 3 tests and a lab exercise as part of 3 weeks of rigorous training

For a nice visual representation, see

Click through on any exam listed in the above links for details on what to study for each exam. Start on the “Microsoft Certified Technology Specialist” tab as those exams are prerequisites for MCITP.

For example, you may wish to take the Database Development exam for SQL 2008 (70-433). Click on Skills Measured for areas to practice/study. Click on Preparation Materials for potential classes, books, practice tests, and more. SQL BOL and blogs are also good prep tools. Let me know which areas you want to learn more about and I can either explain them directly and/or offer links to good study material.