SQL Server Links
SQL Server security and roles – Jeremiah Peschka explains each of the roles (db_owner, db_securityadmin, etc) and talks about why you would use each role in the real world.
SSMS 2008 shows missing indexes – when you’re looking at a query execution plan, SSMS shows any missing indexes right in the plan viewer. This even works if someone exports a query plan in SSMS 2005, sends it to you, and you open it in SSMS 2008.
Reproducing deadlocks with only one table – disclaimer, I haven’t tried this code myself yet, but I foudn it so interesting that I had to repeat it here. Normally deadlocks involve a couple of different tables in a single transaction, but Alexander Kuznetsov describes (in detail) a scenario where it’ll happen with just one table. Bookmarking that for my “ugly code for troubleshooting” demos.
Cloud Links
Nothin’ exciting during this holiday week.
The Junk Drawer
US Air Force Blogging Rules of Engagement – do you fire back when someone posts a nasty blog entry about you or your company? Follow the Air Force’s blog combat guidelines. (Surprisingly, this is not a joke, and it’s quite good.)
The Bloggess negotiates with Chipotle – in an effort to make money off her blog, The Bloggess emailed Chipotle about sponsoring her blog – and they responded. More than once.
Jimmy May’s 2008 recap – Jimmy talks about a couple of the challenges he had in 2008. I second his recommendation that everybody watch the movie The Bucket List. Yes, it’s absurdly unrealistic, but you too should have a Bucket List.
Adam Savage beats his dog – okay, not really, but the famed Mythbuster is now on Twitter as DontTryThis, and he had a typo that implied he beat his dog. I corrected him, and he replied:
Adam Savage on Twitter
At the risk of sounding like a twelve year old boy, ADAM SAVAGE TWITTERED TO ME! OMG OMG OMG!
Ahem. Okay, carry on.
If it makes you feel any better, I noticed Adam's reply to you and thought almost the very same thing that you did.
In an unrelated note – how do you like the new comment plug in? I know you've had trouble…
I gotta be brutally honest – I'm not wild about the new comment plugin. There's anti-spam and moderation going on in both WordPress and on IntenseDebate's side, and it makes things more complex. I'm all for simplicity, especially when I'm doing this in my spare time.
I really like the IDEA of IntenseDebate – the thought of being able to follow people's comments around the web is intriguing to me. If somebody I know makes a comment on a blog entry somewhere, I bet I'd find that discussion interesting, and IntenseDebate enables that kind of integrated conversation stuff. It's not "there" yet, but it's close enough that I'm sucking up the pain and living with the plugin for now.
OHMYGOD, ADAM SAVAGE! Seriously, if he shook my hand I would never wash it again. I'm not sure what the twitter equivalent is. Maybe you never clean your monitor screen again?
PS. Thank you, sweet friend.
Adam Savage is on Twitter??!! Is it really HIM?