• Ken Henderson's WebLog

    Answer to the most recent T-SQL challenge

    • 14 Comments
    The simplest rule-compliant solution to the employee-mentor challenge I recently posted is to change the loop such that it iterates through the relationships at more than one speed. Making no other changes to clean up the code, something like this would...
  • Ken Henderson's WebLog

    A Final Note on Borland

    • 13 Comments
    I lamented the slow death of Borland in a recent post and was roundly assailed for it by the Borland community. I speculated that perhaps the other shoe had finally dropped at Borland with the departure of Chief Scientist Danny Thorpe, the latest in a...
  • Ken Henderson's WebLog

    Review: Remote Keyboard for Windows XP Media Center Edition

    • 7 Comments
    If you use a PC running Windows XP Media Center Edition as your home media hub, you’ve probably either already acquired a wireless keyboard of some type or wished you had more than once. I’ve had several and recently switched to Microsoft’s Remote Keyboard...
  • Ken Henderson's WebLog

    A poor man's technique for playing DVDs on Media Center eXtenders

    • 4 Comments
    Today’s entry continues the discussion of Windows XP Media Center Edition and details how to play ripped DVDs on Media Center eXtender devices. An MCX device allows you to view content from a computer running Media Center on another TV. The thought is...
  • Ken Henderson's WebLog

    I'm enjoying every sandwich

    • 6 Comments
    (and my wife has started to make comments...) I'm referring, of course, to Kent Tegels' Enjoy Every Sandwich blog over on GeeksWithBlogs.net. Kent has an affable writing style that I look forward to when I see something come across the wire. He's got...
  • Ken Henderson's WebLog

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

    • 20 Comments
    I'm interested to hear what you consider the biggest potential security issues with SQL Server 2005. I've asked previously about concerns regarding SQLCLR ; today I'm widening the net and asking about the entire product. If you have security concerns...
  • Ken Henderson's WebLog

    Review: Napster for MCE

    • 4 Comments
    If, like me, you use a PC running Windows XP Media Center Edition as your home media hub, you’ve probably ventured into online music services a time or two or at least wanted to. Today, I’ll talk about my experiences using one of these, Napster’s plug...
  • Ken Henderson's WebLog

    TSQL coding challenge

    • 65 Comments
    Today’s entry is another T-SQL puzzle. Steve Kass took the prize for the best solution to my last T-SQL puzzle , and several others came up with some pretty original solutions of their own. I especially liked the ones that were T-SQL specific – ones that...
  • Ken Henderson's WebLog

    Sleeping vs. Yielding

    • 11 Comments
    According to the BOL, the recommended way of yielding to other workers in SQLCLR is to call System.Thread.Sleep(0). Long before Yukon shipped, I had a conversation with a coworker who was responsible for knowing something about SQLCLR, and I asked how...
  • Ken Henderson's WebLog

    Subtle bugs

    • 7 Comments
    Saw some code like this the other day. See if you can tell what’s wrong with it: BOOL bRes=SomeApiThatReturnsBOOL(); if (TRUE==bRes) { SuccessHandler(); } else { FailureHandler(); } The problem is that the API function...
  • Ken Henderson's WebLog

    Memory-mapped files and SQL Server

    • 2 Comments
    Continuing the discussion from yesterday about memory-mapped files, how do they affect SQL Server? Every DLL referenced by the server (Windows libs, Net Libraries, C RTL libs, etc.), every DLL they reference, and so forth, requires virtual memory address...
  • Ken Henderson's WebLog

    Memory-mapped files and how they work

    • 8 Comments
    A key Windows facility that’s been available since NT shipped is the support of memory-mapped files. A memory-mapped file is a file that has been mapped (i.e., not copied) into virtual memory such that it looks as though it has been loaded into memory...
  • Ken Henderson's WebLog

    More on Borland, Danny Thorpe, etc.

    • 1 Comments
    There's been some churn over in the newsgroups re: my post yesterday about my concerns over Borland's future. I decided to respond over there, and I thought it might make sense to repeat that post here for anyone else who took issue with the post. For...
  • Ken Henderson's WebLog

    Goodbye, My Friend

    • 55 Comments
    I guess the other shoe has finally dropped at Borland. Chief Scientist Danny Thorpe has left. He jumped ship for Google in December . I received the news with mixed emotions. On the one hand, it’s a terrible, perhaps fatal, loss for Borland. On the other...
  • Ken Henderson's WebLog

    Cable cards coming soon to Media Center

    • 7 Comments
    For those of you who, like me, use Windows XP Media Center Edition to watch and record television and who, like me, also rely on a set-top box, relief is coming. With the current version of MCE, you’re forced to use an IR blaster to allow MCE to control...
  • Ken Henderson's WebLog

    My little experiment

    • 13 Comments
    Early last month, I wanted to see what it would be like to blog everyday. I wanted to see how it would work into my schedule, and I wanted to see whether it would be a positive thing in the community and something that would help people. So, starting...
  • Ken Henderson's WebLog

    We're hiring!

    • 2 Comments
    If you have deep coding and problem solving skills, live in the DFW area, love SQL Server, and would like a shot at working for Microsoft, contact me via the email link on this page. I can't get into too many details here on the blog, so if you're interested...
  • Ken Henderson's WebLog

    Max worker threads

    • 5 Comments
    Saw an article online the other day that compelled me to respond. The author was suggesting that SQL Server instances with high numbers of user connections would benefit from having their max worker threads setting increased. He tossed around several...
  • Ken Henderson's WebLog

    Know your enemy

    • 2 Comments
    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....
  • Ken Henderson's WebLog

    A trip down memory lane

    • 0 Comments
    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...
  • Ken Henderson's WebLog

    Tee time

    • 6 Comments
    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...
  • Ken Henderson's WebLog

    More about self-reproducing T-SQL

    • 4 Comments
    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...
  • Ken Henderson's WebLog

    T-SQL coding challenge

    • 76 Comments
    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...
  • Ken Henderson's WebLog

    Poem over on my personal blog

    • 9 Comments
    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...
  • Ken Henderson's WebLog

    Sometimes it's better just to waitfor

    • 1 Comments
    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...
Page 2 of 4 (91 items) 1234