THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

James Luetkehoelter

Nearly any SQL topic presented at times in a slightly eclectic manner.

DevTeach and thanks to Peter and Adam

Hi all,

Got back from DevTeach in Montreal this weekend, where I ran into a lot of folks, many from this site. I was really surprised to see the turnout, and the range of content was pretty diverse. I gave three sessions and managed to only annoy 1 or 2 people with my signature oddness. I'm not faking people, that's me when I talk. I highly recommend attending next year's conference - it will be worth it.

One reason I really enjoy speaking at conferences is the interaction *after* my sessions and the questions that follow. I don't know everything. No one does. It's amazing how many things I learn or perspectives I gain each time I attend an event like this.

DevTeach was particularly interesting was running into a friend I hadn't seen since college, who is clearly on the development side of the "fence" (note: one of my goals in life is to tear down that and other "fences"). In casual conversation with him, he said things like "why bother with stored procedures anyway, parameterized queries are just as efficient" or the dreaded "it's only a database after all". Being a friend, I refrained from punching him in the nose. Instead, we had a real, head-to-head discussion. It became clear (to me at least), that the larger problem is that one "side" doesn't seem to understand the other. He had good points. So did I. I walked away from the conversation thinking "hmmm", and I hope he did too.

One topic I'll tackle this week is how Agile development fits in (or doesn't) with the SQL world. Others I have on tap:

  • CTEs (and why doesn't anyone use them)
  • Snapshot Isolation (Hey Tempdb - duck!)
  • Implicit Data Type Conversion (grrrr...)
  • The Null use of Null (there's a joke there - get it?)

And more...

One last thanks to Peter and Adam for giving me a home :)


Published Wednesday, May 23, 2007 9:22 AM by James Luetkehoelter



Adam Machanic said:

Hi James,

Welcome to SQLblog!

I don't see how stored procedures are a "development" vs. "us" thing.  More of a "you either don't understand what you're doing or you're lazy" vs. "you understand separation of duty, encapsulation, and coupling" (respectively). :)

By the way, you have anonymous comments disabled.  Might want to flip that at your leisure.

May 23, 2007 10:09 AM

James Luetkehoelter said:

Thanks - will flip the anonymous content. Whoops.

I agree with the stored procedure comment made, and it hits the nail on the head. There are still too many in the development world that see the database (and the DBA or database developer) as the roadblock. Well, I'll just keep talking until there are no perceived roadblocks (or very few). Hopefully it will happen in my lifetime :)

May 23, 2007 10:21 AM

Matt said:

CTEs - why _doesn't_ anyone else use them? (I do!) Can you share some of the issues?

May 23, 2007 10:27 AM

Adam Machanic said:

Hi James,

Too bad you didn't attend my "Architecting Effective SQL Server Data Access" talk at DevTeach -- check out the deck when you get a chance, I think you'll enjoy it :)

May 23, 2007 10:42 AM

James Luetkehoelter said:

CTEs? Great! Glad to hear it.  Patience you Jedi, writing about them I am!

May 23, 2007 10:44 AM

roman said:

Hi James,

welcome to sqlblog. Glad to see you here, we do need more "oddness" :-)


May 23, 2007 4:09 PM
New Comments to this post are disabled

About James Luetkehoelter

I am passionate about what I do - which is DBA, development, IT and IT business consulting. If you don't know me, haven't met me or have never heard me speak, I'm a little on the eccentric side. One attendee recently described me as being "over the top". Yup, that about says it - because I only speak on topics that I'm passionate about.
Privacy Statement