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. The call for sponsors and speakers […]

Read More

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...

Read More

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

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 was run with a particularly [&hell...

Read More

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 Batman (defunct) SQL Serverpedia SQL ...

Read More

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. Scary_DBA_Blog_200911172047

Read More

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 makes it a bit more […]

Read More

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 Plan...

Read More

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

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 & butter DBA concerns. That was […]

Read More