Kalen Delaney

Geek City: Plan Caching Internals

Kalen Delaney — Mon, 23 Aug 2010 17:04:00 GMT

This Friday is the last of my summer seminars. On August 27, I am presenting on plan caching, plan reuse and recompile and plan cache metadata. This is one of my favorite topics to talk about, because a lot of the information is not very widely known,...(read more)

Did You Know: 24 Hours of PASS is happening again, September 15-16

Kalen Delaney — Wed, 11 Aug 2010 18:36:00 GMT

This time, it's being split into two parts, perhaps so that there is more of a chance that some people could attend the entire event! Noon - midnight (GMT) for two days in a row. Here are more details: http://www.sqlpass.org/24hours/fall2010/ I'll be...(read more)

Geek City: My Big Fat Partitioning Query

Kalen Delaney — Mon, 26 Jul 2010 15:45:00 GMT

When SQL Server first introduced table and index partitioning in SQL 2005, it was the same version that all the metadata changed. So I decided that I could learn a lot about metadata and a lot about the organization and storage of partitions if I tried...(read more)

Did You Know? MVP Deep Dives is Deal of the Day at Manning!

Kalen Delaney — Mon, 26 Jul 2010 14:45:00 GMT

If, for who knows what reason, you haven't yet got your copy of the SQL MVP Deep Dives book , you can't pass it up today. It is the "Deal of the Day" at Manning , and you can get it for only $25! Check it out at at: http://www.manning.com/nielsen/ (the...(read more)

Did You Know: My Online Seminar Lasted Almost 5 Hours!

Kalen Delaney — Sun, 25 Jul 2010 00:06:00 GMT

Yesterday was a rebroadcast of the index internals seminar I presented last February, and I had forgotten how long it was. I was in a chat room the whole time, and the questions just kept coming, fast and (not so) furious! Thanks to all the participants...(read more)

Geek City: Index Internals

Kalen Delaney — Mon, 19 Jul 2010 14:15:00 GMT

Once again, I'll be presenting an online seminar through SSWUG . This on is on Index Internals . The presentation lasts over 3 and a half hours, and I'll be online for live chat for over 4 hours. Ask away! We'll look at juicy details of exactly how clustered...(read more)

TSQL Tuesday #8: Those who can, do, and those who want to learn more, teach!

Kalen Delaney — Tue, 13 Jul 2010 14:02:00 GMT

It's time for the eighth T-SQL Tuesday , managed this time by Robert Davis at SQL Server Central . This time, the topic was announced very late, and I was just starting to write a blog post of my own when I saw it. Fortunately, my topic easily fits into...(read more)

Did You Know: Good Stuff!

Kalen Delaney — Wed, 30 Jun 2010 21:33:00 GMT

I know, I promised a technical post after my online seminar today, and I'm still planning on that. There weren't all that many really deep questions, just a lot of basic understanding questions, plus questions about topics I'll be covering in my Plan...(read more)

Did You Know: My next web seminar is this Wednesday!

Kalen Delaney — Mon, 28 Jun 2010 03:40:00 GMT

I know, I haven't made a geeky post in a while... but I promise that I'll do one after this seminar. I'll take some of the best questions that I get during the chat and write them up here. Query Plans Workshop (June 30, 2010) Learn about basic elements,...(read more)

Did You Know? I gave two presentations last week

Kalen Delaney — Mon, 14 Jun 2010 15:05:00 GMT

Even though I didn't make it to TechEd this year, it didn't mean I was quiet last week. On Wednesday, I was in Colorado, giving a talk for the new Colorado PASS User Group, which is a joint venture between 3 different existing groups from Colorado Springs,...(read more)

Did You Know? I'm doing 3 more online seminars with SSWUG!

Kalen Delaney — Fri, 11 Jun 2010 22:46:00 GMT

As I told you in April , I recorded two more seminars with Stephen Wynkoop, on aspects of Query Processing. The first one will be broadcast on June 30 and the second on August 27. In between, we'll broadcast my Index Internals seminar, on July 23. Workshops...(read more)

Geek City: Clearing Plans for a Single Database

Kalen Delaney — Sat, 22 May 2010 00:46:00 GMT

I know Friday afternoon isn't the best time for blogging, as everyone is going home now, and by Monday morning, this post will be old news. But I'm not shutting down just yet, and a something came up this week that I just realized not everybody knew about,...(read more)

Did You Know? What PreCon would I take if I were attending TechEd?

Kalen Delaney — Tue, 18 May 2010 00:27:00 GMT

TechEd starts in 3 weeks, and I'm not going to make it this year. I had very much wanted to visit New Orleans post-Katrina and see the recovery for myself. I attended a couple of TechEd's there many years ago, but my primary reason for visiting that fabulous...(read more)

Did You Know? More online seminars!

Kalen Delaney — Thu, 22 Apr 2010 23:20:00 GMT

I am in Tucson again, having just recorded two more online workshops to be broadcast by SSWUG. We haven't set the dates yet, but we are thinking about offering a special package deal for the two of them. The topics really are related and I think they...(read more)

T-SQL Tuesday #5: My First Cube

Kalen Delaney — Tue, 13 Apr 2010 19:00:00 GMT

It's time for the fifth T-SQL Tuesday , managed this time by Aaron Nelson of SQLVariations . Once again, the deadline came up just too quickly, and I'm on the road this week, so my entry will not be too long. Aaron's topic is reporting and in keeping...(read more)