October 2005 - Posts

• Know your enemy

  In The Art of War , Sun Tzu said, "If you know your enemy and know yourself, you need not fear the result of a hundred battles." But, he went on to warn, "If you know yourself but not the enemy, for every victory gained you will also suffer a defeat." Read More... Posted Monday, October 31, 2005 10:08 AM by khen1234 | 1 Comments

• A trip down memory lane

  I've always found the story of the early days of the PC industry to be extremely interesting. One reason for this is that I experienced those early days myself. I have my own memories of them. Another is that the PC's eventual rise to prominence is the Read More... Posted Friday, October 28, 2005 7:50 AM by khen1234 | 0 Comments

• Tee time

  I've always felt that proficiency in the command language of an OS was an essential part of being able to write code for it. I suppose it's possible to write code in a high-level language all day without knowing anything about writing batch files, but Read More... Posted Thursday, October 27, 2005 11:03 PM by khen1234 | 6 Comments

• More about self-reproducing T-SQL

  In yesterday's entry , I talked about self-replicating programs and how educational it can be to construct them. Commonly known in hacking parlance as quines , these self-reproducing programs force us to think about how our language works and are a good Read More... Posted Wednesday, October 26, 2005 11:20 PM by khen1234 | 4 Comments

• T-SQL coding challenge

  This is an oldie, but a goodie. It's an article by Ken Thompson about, among other things, writing self-replicating programs. Thompson is one of my heroes and someone who's had a profound impact on the industry. His list of accomplishments is too long Read More... Posted Tuesday, October 25, 2005 6:02 AM by khen1234 | 68 Comments

• 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 history, politics, and religion. Enough of my friends have been stumped by it that I thought I'd post it publicly to see how many could figure out who it was Read More... Posted Monday, October 24, 2005 8:03 AM by khen1234 | 3 Comments

• Sometimes it's better just to waitfor

  You may have noticed that the sample blocking detection script in KB articles 251004 and 271509 uses WAITFOR in a loop in order to run the sp_blocker_pss NN stored procedure. Ever wonder why that is? Why wouldn’t we schedule the execution of the procedure Read More... Posted Monday, October 24, 2005 7:48 AM by khen1234 | 0 Comments

• Favorite web sites

  I have a number of sites I frequent and do business with, but I'm sure there are plenty of great ones that I don't know about. I'm interested to hear about the ones that you visit often. Here's my list: 1. Books, CDs, and sometimes other stuff: Amazon.com Read More... Posted Friday, October 21, 2005 8:11 AM by khen1234 | 9 Comments

• 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 query timeouts comes up with applications based on SQL Server, people are often surprised to learn that query timeouts are a client-side concept only. Read More... Posted Thursday, October 20, 2005 5:47 AM by khen1234 | 4 Comments

• 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 be a potential security hole. Some have even gone so far as to say that they plan to leave it disabled (it's not enabled by default). When pressed, many Read More... Posted Wednesday, October 19, 2005 9:05 AM by khen1234 | 11 Comments

• 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 2000 and earlier releases, it's also very easy for those types of app to cause perf problems by distributing their workload across their connections unevenly. Read More... Posted Tuesday, October 18, 2005 6:20 AM by khen1234 | 14 Comments

• Your gadget recommendations

  I'm considering replacing my SmartPhone (a Motorola MPX200) with something else. I've developed a real love-hate relationship with my phone. I like all the "smart" functionality, but I hate what a rotten phone it is on occasion. I often go straight from Read More... Posted Monday, October 17, 2005 11:16 AM by khen1234 | 6 Comments

• Subtle bugs #3

  Today's bug challenge is a design bug. Came across some C code like this awhile back (this is pseudo code and has all "work" elements removed from it): void AddID( char * pszObjID) { char szID[8]; //Pad the ID with spaces strcpy(szID," "); strcat(szID,pszObjID); Read More... Posted Friday, October 14, 2005 3:43 PM by khen1234 | 3 Comments

• Leaky code?

  Here's an excerpt from an sp_OA proc code example in the SQL Server 2000 Books Online: DECLARE @object int DECLARE @hr int DECLARE @property varchar(255) DECLARE @return varchar(255) DECLARE @src varchar(255), @desc varchar(255) -- Create an object. EXEC Read More... Posted Thursday, October 13, 2005 5:21 PM by khen1234 | 2 Comments

• 64-bit MemToLeave

  Question: On 64-bit SQL Server, which tends to be larger: the Buffer Pool or the MemToLeave region? Because it usually dominates the user mode portion of 32-bit SQL Server's process address space, it might make sense to assume that the BPool is usually Read More... Posted Wednesday, October 12, 2005 4:40 PM by khen1234 | 5 Comments

• 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 wrestling with something that I've decided to put to a vote. The question before me is whether to include the Windows fundamentals coverage that was in the Read More... Posted Monday, October 10, 2005 11:36 AM by khen1234 | 25 Comments

• 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 Wine Bar outing some of us did Thursday night after the VIP Reception in Las Colinas. He mentioned his "Best Practices for Structured SQL Server Development" Read More... Posted Tuesday, October 04, 2005 11:01 AM by khen1234 | 0 Comments