Load SQL Server BCP Data to Hive

Load SQL Server BCP Data to Hive Small Bites of Big Data Cindy Gross, SQLCAT PM As you start learning more about Hadoop you may want to take a look at how the same data and queries work for SQL Server and for Hadoop. There are various ways to do this. For now I’ll showContinue reading “Load SQL Server BCP Data to Hive”

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. ThereContinue reading “What’s all the Buzz about Hadoop and Hive?”

How to Install the PowerShell Cmdlets for Apache™ Hadoop™-based Services for Windows

How to Install the PowerShell Cmdlets for Apache™ Hadoop™-based Services for Windows Small Bites of Big Data Cindy Gross, SQLCAT PM UPDATED JUNE 2013 – The very early version of PowerShell cmdlets I discussed below have been replaced – see Managing Your HDInsight Cluster with PowerShell http://blogs.msdn.com/b/carlnol/archive/2013/06/07/managing-your-hdinsight-cluster-with-powershell.aspx We have a cool new addition to Microsoft’s Apache™Continue reading “How to Install the PowerShell Cmdlets for Apache™ Hadoop™-based Services for Windows”

Hadoop Hive Error: Could not connect client socket, timed_out

Small Bites of Big Data Cindy Gross, SQLCAT PM With the Hadoop on Azure CTP, when you create a Hadoop cluster it expires after a few days to free up the resources for other CTP users. Therefore each time I do a demo or test I am likely to create a new Hadoop cluster. ThereContinue reading “Hadoop Hive Error: Could not connect client socket, timed_out”

Load Data from the Azure DataMarket to Hadoop on Azure – Small Bites of Big Data

Load Data from the Azure DataMarket to Hadoop on Azure Small Bites of Big Data Cindy Gross, SQLCAT PM UPDATED Jun 2013: HadoopOnAzure CTP has been replaced by HDInsight Preview which has a different interface and different functionality. Getting Started with Windows Azure HDInsight Service http://www.windowsazure.com/en-us/manage/services/hdinsight/get-started-hdinsight/  The first step in analyzing data is acquiring thatContinue reading “Load Data from the Azure DataMarket to Hadoop on Azure – Small Bites of Big Data”

24HOP/SQLRally – Fitting Microsoft Hadoop Into Your Enterprise BI Strategy

24HOP/SQLRally – Fitting Microsoft Hadoop Into Your Enterprise BI Strategy Small Bites of Big Data Cindy Gross, SQLCAT PM The world of #bigdata and in particular #Hadoop is going mainstream. At 24HOP 2012 I talked about how a SQL Server professional fits into this big data world. Hadoop generally falls into the NOSQL realm. NOSQLContinue reading “24HOP/SQLRally – Fitting Microsoft Hadoop Into Your Enterprise BI Strategy”

Using the Pi Estimator Sample on HadoopOnAzure CTP – Small Bites of Big Data

Using the Pi Estimator Sample on HadoopOnAzure CTP Small Bites of Big Data Cindy Gross, SQLCAT PM UPDATED Jun 2013: HadoopOnAzure CTP has been replaced with HDInsight Preview. See: How to Run the HDInsight Samples http://www.windowsazure.com/en-us/manage/services/hdinsight/howto-run-samples/  Now that you have created your Hadoop on Azure cluster you can run the sample programs to become familiarContinue reading “Using the Pi Estimator Sample on HadoopOnAzure CTP – Small Bites of Big Data”

Open Ports for HadoopOnAzure CTP – Small Bites of Big Data

Open Ports for HadoopOnAzure CTP Small Bites of Big Data Cindy Gross, SQLCAT PM UPDATED Jun 2013: HadoopOnAzure CTP has been replaced by HDInsight Preview. See Troubleshooting ODBC connectivity to HDInsight http://social.msdn.microsoft.com/Forums/en-US/hdinsight/thread/b4ca52ea-f7cf-420c-959d-53e09f801f7d.       Once you have created your Hadoop on Azure cluster you will likely be moving data in and out of the system. That meansContinue reading “Open Ports for HadoopOnAzure CTP – Small Bites of Big Data”

Creating a Cluster for HadoopOnAzure CTP – Small Bites of Big Data

Creating a Cluster for HadoopOnAzure CTP Small Bites of Big Data Cindy Gross, SQLCAT PM UPDATED Jun 2013: HadoopOnAzure CTP has been replaced with HDInsight Preview which has a different interface: Getting Started with Windows Azure HDInsight Service http://www.windowsazure.com/en-us/manage/services/hdinsight/get-started-hdinsight/ Are you ready to dive into this “Big Data” thing you keep hearing about? A goodContinue reading “Creating a Cluster for HadoopOnAzure CTP – Small Bites of Big Data”

SQL Server 2012 RC0 available

Release Candidate 0 (RC0) of SQL Server 2012 is available for download! That means you can start to experience a feature complete version of the next great SQL release. 🙂 We’re still looking at the first half of calendar year 2012 for the RTM release of SQL Server 2012. FURTHER.  FORWARD.  FASTER. Downloads: Microsoft® SQLContinue reading “SQL Server 2012 RC0 available”