Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

The Scary DBA

I have twenty+ years experience in IT. That time was spent in technical support, development and database administration. I work forRed Gate Software as a Product Evangelist. I write articles for publication at SQL Server Central, Simple-Talk, PASS Book Reviews and SQL Server Standard. I have published two books, ”Understanding SQL Server Execution Plans” and “SQL Server 2008 Query Performance Tuning Distilled.” I’m one of the founding officers of the Southern New England SQL Server Users Group and its current president. I also work on part-time, short-term, off-site consulting contracts. In 2009 and 2010 I was awarded as a Microsoft SQL Server MVP. In the past I’ve been called rough, intimidating and scary. To which I usually reply, “Good.” You can contact me through grant -at- scarydba dot kom (unobfuscate as necessary).

Archives: November 2009

SQL Saturday #34/New England Data Camp v2.0


It’s official sports fans. Well, it’s been official since last week since Adam Machanic set up the web site. The New England SQL Server Users Group and the Southern New England SQL Server Users Group are again jointly hosting a full day of SQL Server goodness on January 30th.…

Read more

0 comments, 527 reads

Posted in The Scary DBA on 30 November 2009

XQuery For Idiots


I’m still struggling with learning XQuery. My latest little revelation was small, but vital.

The difference between:

@inXML.nodes('/rss/channel/item')

and

@inXML.nodes('/rss[1]/channel[1]/item')

Is the difference between a 10 minute query and a 4 second query. Kind of shocking really. My understanding is that XQuery assumes there are multiple possible paths that look…

Read more

0 comments, 709 reads

Posted in The Scary DBA on 30 November 2009

SQL Server XQuery For Idiots


I’m still struggling with learning XQuery. My latest little revelation was small, but vital.

The difference between:

@inXML.nodes('/rss/channel/item')

and

@inXML.nodes('/rss[1]/channel[1]/item')

Is the difference between a 10 minute query and a 4 second query. Kind of shocking really. My understanding is that XQuery assumes there are multiple possible paths that look…

Read more

0 comments, 575 reads

Posted in The Scary DBA on 30 November 2009

Slow Blogging


Sorry, I’ve been travelling for three weeks and, except for the posts around the PASS Summit, I’ve been blogging very intermittently. I’m back in town, all travel done. The posts will pick up from this point forward.

Read more

0 comments, 203 reads

Posted in The Scary DBA on 23 November 2009

Record of a PSS Call


Not everyone has the opportunity to call Microsoft Premier Support. For those who have not yet had this experience, I’ll document my most recent, non-critical, call. Critical calls are a different critter entirely.

We were experiencing a very odd error on one server in our system. When a particular procedure…

Read more

0 comments, 205 reads

Posted in The Scary DBA on 17 November 2009

Proof


SQL Rockstar tells me that unless there are photo’s, it didn’t happen. Brad McGehee published some pictures from DevConnections. See, I really do try to get people to buy my book… uh, I mean present technical sessions at conferences.

Note the laptop with the styling stickers from:
SQL PASS
SQL…

Read more

2 comments, 201 reads

Posted in The Scary DBA on 17 November 2009

I have a Tag


That’s a Microsoft Tag. I’m not quite sure what exactly to do with it, but here it is. Evidently you’re supposed to take pictures of it with your phone or something and it will lead you back here. I’ll have try making a sticker out of it or something.

Read more

0 comments, 183 reads

Posted in The Scary DBA on 17 November 2009

Dev Connections Recap


Last week I attended the Dev Connections conference for the first time. It was held in the Mandalay Bay resort in Las Vegas. The conference is different because it doesn’t concentrate on any one technology, but combines a bunch of them; ASP, Sharepoint, SQL Server, Visual Studio & Architects. That…

Read more

2 comments, 247 reads

Posted in The Scary DBA on 17 November 2009

SQL Connections


I’m flying off to the SQL Server Magazine Connections part of DevConnections in Las Vegas later this afternoon. I’m presenting three sessions while I’m there, Wednesday & Thursday. I’m hanging around on Friday. Please track me down if you want to chat. Wednesday I’ll be putting on “Scouting Out Execution…

Read more

0 comments, 178 reads

Posted in The Scary DBA on 10 November 2009

Geek of the Week


I made geek of the week. I’m sorry, but I’m excited by that.  I’m very proud to be a geek. Thanks guys.

Read more

0 comments, 183 reads

Posted in The Scary DBA on 6 November 2009

PASS Summit 2009 Day 3


The day started off with a mixed bag. First we had an honestly tearful farewell with Wayne Snyder saying goodbye to Kevin Kline, leaving the board for the first time since PASS was founded. This was followed by a painfully dull session with Dell all about their commitment to bread…

Read more

0 comments, 508 reads

Posted in The Scary DBA on 6 November 2009

PASS Summit 2009 Key Note 3


Dr. David DeWitt

“I’m not a doctor.” This is going to be good. “From 1 to 1000 MIPS” He’s doing great. He was a fantastic last year and I knew this was going to be good. 32 years in academia and only in MS for 1.5 years. He’s the blue…

Read more

0 comments, 178 reads

Posted in The Scary DBA on 5 November 2009

PASS Summit 2009 Key Note 2


Patrick Ortiz from Dell, the platinum sponsor for the PASS Summit.

The goal will be to discuss the Dell Microsoft Practice, Configuration Management, Disaster Recovery and Consolidation. The MS Practice team has server tools, messaging & communications and collaboration & databases. Lots of work going on there.The see the CM,…

Read more

0 comments, 178 reads

Posted in The Scary DBA on 5 November 2009

PASS Summit 2009 Key Note 1


Wow, the bloggers table is empty today!

Nice intro! Good photo’s. I love the Summit!

Bill Graziano is introducing Day 3. He acknowledged Twitter and the bloggers. We rock! Outgoing board members are Greg Low and Pat Wright. These are great guys who’ve busted their butts for the community. Kevin…

Read more

0 comments, 461 reads

Posted in The Scary DBA on 5 November 2009

PASS Summit 2009 – Day 2


Day 2 of the Summit was extremely busy. I missed a breakfast on DMV’s that evidently was one of the hits of the show. Day 2 was kilt day. I wore mine and there were two others, Steve Jones and Bill Fellows. They were a hit. Next year I’d like…

Read more

0 comments, 606 reads

Posted in The Scary DBA on 5 November 2009

PASS Summit Wednesday Key Note 3


More demos using Analysis Services from R2. They’re showing how you can refresh data & reports without having to write a bunch of SSIS packages. That’s pretty cool too. You can actually connect to Excel now and pull data into SSAS to manage the data like it was a database.…

Read more

0 comments, 180 reads

Posted in The Scary DBA on 4 November 2009

PASS Summit Wednesday Key Note 2


Tom Casey of Microsoft on BI.

20% of people that are decision makers within organizations have the tools and information they need. That means that 80% don’t have it. I believe those numbers. Microsoft is very focused on getting BI built into the information platform. You can tell from the…

Read more

0 comments, 205 reads

Posted in The Scary DBA on 4 November 2009

PASS Summit Wednesday Key Note 1


Nice phot montage, included so many friends. I love PASS.

Rushab Mehta launching the Wednesday key note. Unfortunately, this is the DULL, but important, stuff about finances. PASS is a non-profit, volunteer run organization. I’m not going to track this stuff. You can find the full financials on the PASS…

Read more

0 comments, 184 reads

Posted in The Scary DBA on 4 November 2009

PASS Summit 2009 – Day 1


YAAAAAH!

The PASS Summit is pretty amazing. Yesterday I sat through the key notes from Microsoft. I was at the bloggers table where I could hear the speaker and lots of typing. I used to consider myself a blogger, but then I watched Brent Ozar doing and learned that I…

Read more

0 comments, 175 reads

Posted in The Scary DBA on 4 November 2009

PASS Tuesday Key Note – Part 3


Now up is Ted Kummert of Microsoft.

He’s giving us a good overview of some of the technology coming up. He’s showing us his Top 5 reasons to be at PASS

  1. You are part of the world’s largest gathering of SQL Server Professionals – way too true. why aren’t you…

Read more

0 comments, 187 reads

Posted in The Scary DBA on 3 November 2009

Older posts