Ken Henderson's WebLog

Last Week

I was in Redmond last week on business and had a lot of fun this time around. The trip began and...

Author: MSDN Archive Date: 12/17/2007

SQL Nexus is out!

In case you missed it in my last post, SQL Nexus, the SQL Server performance analysis platform built...

Author: MSDN Archive Date: 12/12/2007

A SQL Profiler trace Swiss Army Knife

Have you ever needed to find your most expensive queries and quickly grew weary of writing T-SQL...

Author: MSDN Archive Date: 12/12/2007

Random thoughts on my trip to the conference

I had a great time on my brief stint in Denver for the PASS Summit. We had a good session and a good...

Author: MSDN Archive Date: 09/23/2007

I'll be at the PASS Summit in Denver

I'm being interviewed on stage Friday afternoon from 2:30-3:45 by PASS president Kevin Kline...

Author: MSDN Archive Date: 09/18/2007

Today is a great day

...and in honor of it, I'm going to be especially cryptic and give you a little word puzzle--an...

Author: MSDN Archive Date: 06/13/2007

Does rebuilding a clustered index rebuild nonclustered indexes?

This came up yesterday with one of our support engineers, so I thought I’d post a brief entry on it....

Author: MSDN Archive Date: 02/27/2007

Update to the latest book's CD

Many have noted that there are some files missing from the CD accompanying my latest book, SQL...

Author: MSDN Archive Date: 02/10/2007

Origins of khen and foo

For those wondering why I use the terms 'khen' and 'foo' so often, here's an article on the...

Author: MSDN Archive Date: 12/15/2006

The new book is out

I've mentioned before that I had a new book coming out. It's finally available on Amazon. Again, I...

Author: MSDN Archive Date: 12/15/2006

SQL Server Support is at the PASS Summit again this year

My friends in Microsoft’s Product Support Services (PSS) group (aka SQL Server Support) are speaking...

Author: MSDN Archive Date: 11/13/2006

Normalizing query text

A conversation with a friend over email got me to thinking that this info might be useful to a few...

Author: MSDN Archive Date: 10/22/2006

Book sample chapter available for download

I mentioned in my last post here that we have a new book coming out in December that focuses on...

Author: MSDN Archive Date: 10/20/2006

New book coming out

Dow Jones' Denis Gobo interviewed me recently about the new book some colleagues and I have got...

Author: MSDN Archive Date: 10/13/2006

Μοviεβrainia is back online

For anyone who cares and is not already subscribed to my MSN Spaces blog, DNS issues with my...

Author: MSDN Archive Date: 08/31/2006

New movie review blog

I'm starting a new movie review blog because I wanted to get familiar with Community Server and...

Author: MSDN Archive Date: 08/29/2006

New blog

My friend Bart Duncan is now blogging. Bart is one of the top SQL Server performance experts in the...

Author: MSDN Archive Date: 07/24/2006

The rest is silence

I've decided to move all religion-related posts to their own blog over on Blogger. From now on,...

Author: MSDN Archive Date: 05/28/2006

Nice article for those concerned about runaway CEO compensation

https://www.calcsea.org/20051218-nytimes.asp The guy in this story is Ethan Berman, my boss when I...

Author: MSDN Archive Date: 05/04/2006

Looking for PC QWERTY keyboard piano software

I used to use a little PC piano program called PianoMan written by Neil Rubenking of PC Magazine...

Author: MSDN Archive Date: 04/25/2006

Blogging from Barcelona

I'm in Barcelona for the PASS Europe Conference. It's been a good conference once again, and we've...

Author: MSDN Archive Date: 02/25/2006

PASS Barcelona

I'm speaking at the 2006 PASS European Conference in Barcelona. Drop by if you're attending. Hope to...

Author: MSDN Archive Date: 02/13/2006

Answer to the most recent T-SQL challenge

The simplest rule-compliant solution to the employee-mentor challenge I recently posted is to change...

Author: MSDN Archive Date: 02/11/2006

A Final Note on Borland

I lamented the slow death of Borland in a recent post and was roundly assailed for it by the Borland...

Author: MSDN Archive Date: 02/09/2006

Review: Remote Keyboard for Windows XP Media Center Edition

If you use a PC running Windows XP Media Center Edition as your home media hub, you’ve probably...

Author: MSDN Archive Date: 02/09/2006

I'm enjoying every sandwich

(and my wife has started to make comments...) I'm referring, of course, to Kent Tegels' Enjoy Every...

Author: MSDN Archive Date: 02/07/2006

Poll: What are your biggest security concerns for SQL Server 2005?

I'm interested to hear what you consider the biggest potential security issues with SQL Server 2005....

Author: MSDN Archive Date: 02/07/2006

Review: Napster for MCE

If, like me, you use a PC running Windows XP Media Center Edition as your home media hub, you’ve...

Author: MSDN Archive Date: 02/06/2006

TSQL coding challenge

Today’s entry is another T-SQL puzzle. Steve Kass took the prize for the best solution to my last...

Author: MSDN Archive Date: 02/03/2006

Sleeping vs. Yielding

According to the BOL, the recommended way of yielding to other workers in SQLCLR is to call...

Author: MSDN Archive Date: 02/02/2006

Subtle bugs

Saw some code like this the other day. See if you can tell what’s wrong with it: BOOL...

Author: MSDN Archive Date: 02/01/2006

Memory-mapped files and SQL Server

Continuing the discussion from yesterday about memory-mapped files, how do they affect SQL Server?...

Author: MSDN Archive Date: 01/31/2006

Memory-mapped files and how they work

A key Windows facility that’s been available since NT shipped is the support of memory-mapped files....

Author: MSDN Archive Date: 01/30/2006

More on Borland, Danny Thorpe, etc.

There's been some churn over in the newsgroups re: my post yesterday about my concerns over...

Author: MSDN Archive Date: 01/24/2006

Goodbye, My Friend

I guess the other shoe has finally dropped at Borland. Chief Scientist Danny Thorpe has left. He...

Author: MSDN Archive Date: 01/23/2006

Cable cards coming soon to Media Center

For those of you who, like me, use Windows XP Media Center Edition to watch and record television...

Author: MSDN Archive Date: 12/01/2005

My little experiment

Early last month, I wanted to see what it would be like to blog everyday. I wanted to see how it...

Author: MSDN Archive Date: 11/18/2005

We're hiring!

If you have deep coding and problem solving skills, live in the DFW area, love SQL Server, and would...

Author: MSDN Archive Date: 11/08/2005

Max worker threads

Saw an article online the other day that compelled me to respond. The author was suggesting that SQL...

Author: MSDN Archive Date: 11/07/2005

Know your enemy

In The Art of War, Sun Tzu said, "If you know your enemy and know yourself, you need not fear the...

Author: MSDN Archive Date: 10/31/2005

A trip down memory lane

I've always found the story of the early days of the PC industry to be extremely interesting. One...

Author: MSDN Archive Date: 10/28/2005

Tee time

I've always felt that proficiency in the command language of an OS was an essential part of being...

Author: MSDN Archive Date: 10/28/2005

More about self-reproducing T-SQL

In yesterday's entry, I talked about self-replicating programs and how educational it can be to...

Author: MSDN Archive Date: 10/27/2005

T-SQL coding challenge

This is an oldie, but a goodie. It's an article by Ken Thompson about, among other things, writing...

Author: MSDN Archive Date: 10/25/2005

Poem over on my personal blog

For those interested in such things, there's a poem over on my personal blog having to do with...

Author: MSDN Archive Date: 10/24/2005

Sometimes it's better just to waitfor

You may have noticed that the sample blocking detection script in KB articles 251004 and 271509 uses...

Author: MSDN Archive Date: 10/24/2005

Next>