Share via


Ken Henderson's WebLog

Favorite web sites

I have a number of sites I frequent and do business with, but I'm sure there are plenty of great...

Author: MSDN Archive Date: 10/21/2005

There's no such thing as a query timeout...

...not at least as far as the database engine is concerned, anyway. As frequently as the subject of...

Author: MSDN Archive Date: 10/20/2005

Poll: Do you see SQLCLR as a security threat?

I've been hearing from some folk that they consider the SQLCLR functionality in SQL Server 2005 to...

Author: MSDN Archive Date: 10/19/2005

How multiple connections from the same app can kill perf

It's pretty common for a complex app to make multiple connections to SQL Server. And, on SQL Server...

Author: MSDN Archive Date: 10/18/2005

Your gadget recommendations

I'm considering replacing my SmartPhone (a Motorola MPX200) with something else. I've developed a...

Author: MSDN Archive Date: 10/17/2005

Subtle bugs #3

Today's bug challenge is a design bug. Came across some C code like this awhile back (this is pseudo...

Author: MSDN Archive Date: 10/14/2005

Leaky code?

Here's an excerpt from an sp_OA proc code example in the SQL Server 2000 Books Online: DECLARE...

Author: MSDN Archive Date: 10/13/2005

64-bit MemToLeave

Question: On 64-bit SQL Server, which tends to be larger: the Buffer Pool or the MemToLeave region?...

Author: MSDN Archive Date: 10/12/2005

Your opinion on the next edition of my architecture book

As I think many of you know, I'm updating my SQL Server books for SQL Server 2005. I'm currently...

Author: MSDN Archive Date: 10/10/2005

The best session at the 2005 PASS Summit...

...was probably one I didn't even get to attend. Adam Machanic introduced himself to me at the Mercy...

Author: MSDN Archive Date: 10/04/2005

How important is T-SQL portability?

This came up on a newsgroup recently. I weighed in with my .02 worth and decided to blog about it as...

Author: MSDN Archive Date: 09/06/2005

Political stuff

For those who enjoy reading such things, a couple of new political ramblings over on my personal...

Author: MSDN Archive Date: 09/06/2005

New book promotion

Addison-Wesley has asked me to mention: Barnes & Noble liked the idea of promoting my books so...

Author: MSDN Archive Date: 08/24/2005

Don't rely on undocumented features

I'm as guilty as anyone, but, with the advent of Yukon, I think we're really to the point where many...

Author: MSDN Archive Date: 07/20/2005

A WAITFOR UNTIL implentation for T-SQL

You've probably encountered situations where you needed to pause the execution of a stored procedure...

Author: MSDN Archive Date: 07/08/2005

Blogging from Tech*Ed

I'm blogging from the speakers' lounge at Tech*Ed. I've had a great week so far. Best sessions to...

Author: MSDN Archive Date: 06/09/2005

Why Extended Procedures Have Inherent Performance Issues

To follow up on the recent discussions about regular expressions in T-SQL, I thought it would make...

Author: MSDN Archive Date: 05/27/2005

Revenge of the Prequels: An Ode to "The Director"

This isn't terribly technical in nature, but everyone's talking about it and there are certainly...

Author: MSDN Archive Date: 05/23/2005

Regular Expressions in T-SQL, Part II

I've gotten quite a bit of mail from people re: my recent post about regular expression searches in...

Author: MSDN Archive Date: 05/19/2005

I'll be speaking at Tech*Ed

I'll be in Orlando next month speaking at the US edition of Tech*Ed. I think the show is already...

Author: MSDN Archive Date: 05/18/2005

Blogging from the hospital

I'm in the hospital once again with kidney stones. They have a saying in the emergency room here...

Author: MSDN Archive Date: 05/14/2005

Floating point fun

I've been an advocate of using SQL Server for more than a mere datastore for about as long as I've...

Author: MSDN Archive Date: 05/13/2005

Regular Expressions in T-SQL

Given that a recent blog of mine lamented the dangers of using xprocs, I thought it would be a good...

Author: MSDN Archive Date: 05/11/2005

Blogs I regularly read

Some blogs I regularly read: https://blogs.msdn.com/oldnewthing Written by Raymond Chen, a developer...

Author: MSDN Archive Date: 05/10/2005

Be careful with xproc memory allocation

With the advent of CLR stored procedures in SQL Server 2005, the custom extended procedure era will...

Author: MSDN Archive Date: 05/08/2005

Goodbye, Seoul

The world's first production deployment of SQL Server 2000 on a 64-way, 64-bit machine was a...

Author: MSDN Archive Date: 05/06/2005

Blogging from Seoul

I'm currently in Seoul, South Korea assisting with the first 64-way, 64-bit deployment of SQL Server...

Author: MSDN Archive Date: 05/01/2005

Why you shouldn't compress SQL Server data and log files

Most knowledgable SQL Server DBAs know you shouldn't compress a database's data and log files, but...

Author: MSDN Archive Date: 04/25/2005

Subtle bugs #2

Came across this in some code recently. The code excerpt below is part of a larger cmd line...

Author: MSDN Archive Date: 04/25/2005

Barnes & Noble promotion

<shameless_promotion> Addison-Wesley has asked me to mention that B&N is doing a big...

Author: MSDN Archive Date: 04/22/2005

Why .NET is the best thing to happen to software since OOP, Part II

I didn't really finish the discussion of what I began in this blog, so I'll do so today. Why do I...

Author: MSDN Archive Date: 04/19/2005

My other blog is a Mercedes

For those who don't already know about it, I blog about non-technical things on MSN Spaces at...

Author: MSDN Archive Date: 04/17/2005

Why .NET is the best thing to happen to software since OOP

I read a blog by Mark Russinovich the other day that disturbed me a bit. It always bothers me when...

Author: MSDN Archive Date: 04/17/2005

To VB or not to VB: VB.NET or C# -- which one should you choose?

I get asked pretty often which of these two languages I prefer. I prefer C#. But which one should...

Author: MSDN Archive Date: 04/14/2005

Subtle bugs #1

From time-to-time, I'm going to post a code snippet with a subtle bug in it for people interested in...

Author: MSDN Archive Date: 04/13/2005

Does it make sense to build MFC GUI apps anymore?

For most developers, I think the answer has to be "No," especially with the advent of managed code....

Author: MSDN Archive Date: 04/13/2005

Yukon's management tools

As the creator of a few SQL Server-specific tools myself (Sequin, DataPipe, etc.), I have some...

Author: MSDN Archive Date: 04/13/2005

Availability of the Yukon editions of my books

People have been emailing me quite a bit about when my SQL Server books will be updated for SQL...

Author: MSDN Archive Date: 04/01/2005

<Previous