Kalen Delaney

Did You Know: Early Spring Warm Up in Florida!

Kalen Delaney — Tue, 02 Feb 2010 22:52:00 GMT

No, this is not an early response to the next T-SQL Tuesday topic. Rob Farley will be hosting that one, and wants us to write about relationships. So getting warm doesn't refer to a nice cozy relationship by the fire, while the snow is relentless in Chicago...(read more)

Geek City: More About Row Overflow Columns

Kalen Delaney — Sat, 30 Jan 2010 22:37:00 GMT

In my earlier post about the maximum number of row-overflow columns , I just got a comment from someone wanting to know WHY they couldn't get the number I reported… that is, 308 long varchar columns, of which 307 will be stored off page in row-overflow...(read more)

Did You Know: My Online Seminar is Scheduled!

Kalen Delaney — Sat, 30 Jan 2010 17:58:00 GMT

I mentioned here that I had recorded my first seminar with SSWUG. It has been scheduled for February 12th, starting 9AM Pacific Time, and is over 3 hours of content. I will be available on live chat during the seminar to answer questions. Registration...(read more)

Did You Know? Three events that brought me here

Kalen Delaney — Fri, 22 Jan 2010 04:36:00 GMT

I was tagged by Paul Randal, to tell you about three events that brought me to this point in my life today. It's interesting timing, because one of my teachers was just talking about a book he had just read, called "The Tipping Point", which dealt with...(read more)

T-SQL Tuesday #002: Non-aggregated columns in a GROUP BY query

Kalen Delaney — Tue, 12 Jan 2010 00:00:00 GMT

It's time for the second T-SQL Tuesday , once again managed by Adam Machanic. Since my first T-SQL Tuesday post dealt with my long years with the SQL Server product, I decided to continue in that vein. Adam asked for us to write something about a puzzle...(read more)

Did You Know? I'm doing online seminars!

Kalen Delaney — Fri, 08 Jan 2010 22:43:00 GMT

I filmed my first seminar at Stephen Wynkoop's incredible studio in Tucson last Tuesday. It was a terrific experience; Stephen just made it seem so easy, and he has the perfect setup for doing the filming. The seminar "Index Internals and Best Practices"...(read more)

Did You Know? Yet Another Gift From Manning

Kalen Delaney — Mon, 28 Dec 2009 03:40:00 GMT

Here's another one-day-only offer, for Monday, December 28th: $15 off any purchase This includes MEAP (Manning Early Access Program), ebooks or print books from Manning's catalog: http://www.manning.com/catalog/by/subject/ And of course it includes the...(read more)

Did You Know? A Holiday Gift From Manning

Kalen Delaney — Thu, 24 Dec 2009 16:30:00 GMT

Christmas Day Only! Dec 25: Season's Savings from Manning - 50% off everything! This includes MEAP (Manning Early Access Program), ebooks or print books And of course it includes the SQL Server MVP Deep Dives book! Here's the Manning site for that book:...(read more)

Geek City: Exploring the Transaction Log Structure

Kalen Delaney — Tue, 22 Dec 2009 00:48:00 GMT

As I mentioned last October, my PASS preconference seminar was a whole day about the transaction log . I told the attendees all kinds of things about the structure of the log, and told them about one of the best tools for exploring the structure: the...(read more)

T-SQL Tuesday #001: My Datetime FAQ

Kalen Delaney — Tue, 08 Dec 2009 18:49:00 GMT

I am rising to Adam's challenge for his very first T-SQL Tuesday , and blogging about datetime issues. Since I just finished a 9-hour teaching day in Stockholm, and I'm incredibly jetlagged, I decided to keep this simple. I'm very much looking forward...(read more)

Geek City: How Many Rows?

Kalen Delaney — Mon, 07 Dec 2009 17:59:00 GMT

In my last post, I told you I'd post something technical before I left for Sweden. I almost made it. I wrote this in the Seattle airport, but wasn't able to post it until I got to Stockholm. For as long as I've been working with SQL Server, I've been...(read more)

Did You Know: You can Learn SQL Internals in Sweden!

Kalen Delaney — Tue, 01 Dec 2009 00:33:00 GMT

The class next week was full, but we just had two cancellations today. So now you have a chance to take my SQL Server Internals and Tuning class next week, at the wonderful Cornerstone Training Center , right outside of Stockholm. (I promise I'll have...(read more)

Geek City: Intent to Update

Kalen Delaney — Fri, 20 Nov 2009 00:33:00 GMT

In the last couple of months, I've told you about Intent Locks and UPDATE locks. I want to just provide a wrap up to those posts that talks about both of these aspects of locking. You can think of both of these locking aspects as although SQL Server to...(read more)

Geek City: UPDATE Locks

Kalen Delaney — Fri, 13 Nov 2009 21:48:00 GMT

UPDATE locks are not really a separate kind of lock, but rather are a hybrid of SHARED and EXCLUSIVE locks. And contrary to what you might think, UPDATE locks are not just acquired for UPDATE operations. A transaction acquires this kind of lock when SQL...(read more)

Did You Know? I'll be teaching a public course in Florida!

Kalen Delaney — Thu, 12 Nov 2009 22:21:00 GMT

The Boston class was so successful, both for me and for all the attendees, that I have been persuaded to do another public class on the East Coast. This one is being arranged by Scott Klein, of the South Florida SQL Server Users' Group, and will be held...(read more)