Sharing the Love

SQL Server 2005, SQL Server 2008, SQL Server 2012, TSQL
Just a few blog posts that you ought to go and read. First up, Tom LaRock maintains a listing of SQL bloggers split up into various cleverly named groups to show you where to go to get good information. This really is an excellent collection of bloggers. It's the people I go to when I need information. Some of them are better resources than the Books Online when they post something. Personally, I've made the list for the last several years, but Tom has decided that I'm worth of elevation, so I've gone from the Model database to the Master database. Thanks Tom. One blog that's not on Tom's list is Tom's blog. You should be reading that regularly too. And congratulations to Tom again on making MCM. Next, one…
Read More

HDInsight: Trying again

Misc
And I thought this would be so easy. Latest attempt. I just did an uninstall of HDInsight. Then I found all the Hadoop folders on the drive and removed them. I validated that there were no services left running or anything else that might interfere with a fresh install. Then, I rebooted the server (have you tried turning it off and on again?). After all that, I tried rerunning the HDInsight Community Preview. This time I ran it as an administrator on the system, even though I already am logged in as one. Paranoia at every step is my new approach since there have been no errors until I try to turn the silly thing on. And the install went perfectly. I can see two folders, Hadoop and HadoopFeaturePackSetup. Last…
Read More

HDInsight: First Pass

Azure, SQL Server 2012
I installed HDInsight with no errors. The install is so brain-dead, I couldn't see how there could be errors. But, I decided to fire up the service to start playing with it. That's when I hit the errors. First up, I was getting logon errors for the Hadoop service itself. I tried resolving them manually, but was digging a hole. So, I uninstalled, and reinstalled, figuring I had missed an error message somewhere along the line. After this install, I didn't get logon errors. Instead I got internal errors. Some more investigation and it appears that the service was marked for deletion. The uninstall worked, but somehow wasn't complete. Yay! So, I did another uninstall after rebooting the server. Install #4 coming up.  And we're back to logon errors. Specifically:…
Read More

Treat Yourself to Knowledge

Uncategorized
There's a one day sale going on at Apress today, 11/26/12. All their eBooks are $15. This means you can start learning about query performance tuning, or get started as a DBA, or explore a whole range of topics by different authors presenting some of the best in the business knowledge. Yes, these are all Apress books that I've written on different topics. This is your chance to pick them up at a pretty steep discount. I know I'm heading over there to buy Jason Strate and Ted Krueger's book on indexing. Check mine out. Check Jason & Ted's out. Just find yourself something and treat yourself to some knowledge. Today's a great day to do it.
Read More

Final 2012 Learning Opportunity

Misc, SQL Server 2012
There's still a little time left in the year. I know some businesses have allocated training budgets and if they don't spend the money, they lose it from their budget. So a few of you might still be looking for opportunities to get your learn on. I've got one more big one before the end of the year. You can try heading down to Florida for the Live 360 conference. I'll be there along with several friends (love my #sqlfamily). I'm presenting two sessions, one on setting up an environment for performance testing using the new distributed playback capabilities from SQL Server 2012 and one on introducing the accidental DBA to backups. You can still register here to attend these sessions and all the other great ones being presented. Last…
Read More

Living with the Surface, Maybe

Surface
No major updates at the moment. I still haven't played with remoting through PowerShell. I'm just living with it. Had an interesting problem start today. You can swipe from the sides to get different behaviors. Swipe in from the top or bottom and you get menu choices in the app you're in. Swipe in from the right and you get the Charms. Swipe in from the left... well, you're supposed to get the list of recent apps or the ability to set an app in another window or even switch to the previous application, all depending on how you swipe. Except, mine stopped. Hurrah. I did a bunch of poking around to figure out why this happened, hoping I'm not looking at a hardware issue (oh please, not that). When…
Read More

HDInsight and Buggy Whips

Uncategorized
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

Remote Desktop and Surface

Surface
The Windows RT operating system is not the same as Windows. After all the talk about the upcoming OS and hardware, this should not be a shock to anyone. This means that there are going to be some apps that just won't run on your RT device. OK, not a problem. Because you can always attack to a remote desktop session, right? Maybe. The principal app for doing remote desktop from the RT has a funky name. It's called Remote Desktop. It was not installed on my machine by default. I had to go and get it from the Store. No big deal. The UI is incredibly simple. Enter the name of  the PC you want to connect to. I have not made my Surface a part of my domain…
Read More

Surface Problems With Azure

Surface
I've been posting about the Surface over the last couple of weeks and I've tried really hard to be positive about it. But there are some serious problems with the device. I've already made a stink about the apps, but this time, I want to talk about the Microsoft ecosystem. I'm working more and more with online services. These vary from storage, such as SkyDrive to Amazon Servers to Azure. And Azure is my problem. I sit here, typing into a device that is really, really close to being fully productive despite being extremely small and light. Really close. And, it's supposed to be a major player within the Microsoft world. It's what the new OS was designed for, or so I thought. But, I might have just found my…
Read More

Purpose of the Surface RT

Surface
I'm a little over two weeks with the Surface at this point. I've been travelling all of that time, so I have been using the Surface quite a lot, as I used to my (beloved) Android tablet. It took a little while to get functional enough, upgrading the dysfunctional Office that came installed, figuring out how to get various email set up, learning how to use the touch type, and figuring out the operating system. But, at this time, the Surface is close to functional. Close. But what's it for? First, it's a consumption device. I've got a web browser in my hands, wherever I go, as long as I can get WIFI. That gives me a hefty chunk of the world to work with. I can rent movies. I've…
Read More