04Mar 2013 by Grant Fritchey No Comments

Pro SQL Server 2012 Practices: Chapter 17

HDInsight
I jumped at the opportunity to write a chapter for this book, Pro SQL Server 2012 Practices, because of all the fantastic people writing and the topics that were covered. I reviewed Chapter 12 a few weeks ago and I've been meaning to get this chapter, Big Data for the SQL Server DBA, read & reviewed but I've just been sidetracked. I finally noticed it on my Trello board, weeks out of date, and decided to finally get the job done. Carlos Bossy (b|t) is a great guy and a part of my SQL Family. We run into each other all the time at SQL Saturday's and other events. I've never listened to him present before, and now, after reading his chapter in the book, I'm very sorry. I'll fix…
Read More
03Dec 2012 by Grant Fritchey 6 Comments

HDInsight, Finally

Azure, HDInsight
See this: That's right. The install worked. All I had to do was get a completely clean server set up. No domain controller. Now to get my learn on. Microsoft has a web site with a number of introductory samples. I'll start there and work through them. The very first example gets me set up with some data that it builds by running a Powershell script, importdata.ps1. But I'm not going to just blindly follow along. I want to see what the heck is happening so I can start understanding this stuff. By the way, thank you Microsoft for making the samples in PowerShell and not forcing me to relearn Python or something else. That would have been frustrating. The script is really simple. It has two scenarios you can…
Read More
16Nov 2012 by Grant Fritchey 2 Comments

HDInsight and Buggy Whips

HDInsight
I sat the through the big announcements at the 2011 PASS Summit about the partnership between Microsoft and Hadoop. I recognized it as... interesting, but not necessarily earth shattering. I was aware of the NoSQL movement and understood that it answered a pain point that structured data couldn't really adequately answer, but that was really it. Then I sat through the sessions this year showing the stuff coming out with the Parallel Data Warehouse (PDW) and PolycBAse. Then I watched Dr. Dewitt promise me that I'd be seeing similar functionality within the main SQL Server tool and suddenly... I looked at my structured data knowledge, glanced back at the stuff going on in the keynotes and frankly, they really did look a lot like automobiles. Quick clarification, I've mentioned it…
Read More