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