• Ken Henderson's WebLog

    Looking for PC QWERTY keyboard piano software

    • 8 Comments
    I used to use a little PC piano program called PianoMan written by Neil Rubenking of PC Magazine fame. I contacted Neil about an update recently, and he tells me that there isn't and won't be one. The main reason is that he wrote the software based on...
  • Ken Henderson's WebLog

    Why some SQL Server components do not work or are not supported when SQL Server is in lightweight pooling mode

    • 8 Comments
    Lightweight pooling mode, also known as fiber mode, uses Windows fibers to service User Mode Scheduler (UMS) workers rather than threads. Windows fibers are lighter weight execution mechanisms than threads, with one thread typically hosting multiple fibers...
  • Ken Henderson's WebLog

    Availability of the Yukon editions of my books

    • 7 Comments
    People have been emailing me quite a bit about when my SQL Server books will be updated for SQL Server 2005. Good news: they will be in print this Monday. Important details: 1. All three books have grown to over 1200 pages each. This is as much due...
  • Ken Henderson's WebLog

    Regular Expressions in T-SQL, Part II

    • 7 Comments
    I've gotten quite a bit of mail from people re: my recent post about regular expression searches in T-SQL . This was actually covered in my last book , so I've been surprised at how many people were unaware that the tools needed to do this were right...
  • 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

    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

    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

    Blogging from Barcelona

    • 7 Comments
    I'm in Barcelona for the PASS Europe Conference . It's been a good conference once again, and we've had a great week. My MS colleagues and I put on our SQL Server Boot Camp again and came away thinking that it was our best one yet. We had sessions in...
  • Ken Henderson's WebLog

    How to Beat Halo 3 in 20 Minutes

    • 6 Comments
    (Or, How to Beat Its Longest Level, The Covenant, in 20 Minutes and Get the Full 3x Time Bonus) (Or, What I Did On the Day after Christmas) (Or, How to Set a New World Record for Speed Play in Halo 3) Over the recent holiday break I decided to...
  • 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

    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

    Your gadget recommendations

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

    64-bit MemToLeave

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

    Blogging from Seoul

    • 6 Comments
    I'm currently in Seoul, South Korea assisting with the first 64-way, 64-bit deployment of SQL Server in the world. The 14 and 1/2 hour flight has left me extremely jet-lagged -- I didn't sleep a wink on the flight. I got here last evening, went to bed...
  • Ken Henderson's WebLog

    Be careful with xproc memory allocation

    • 5 Comments
    With the advent of CLR stored procedures in SQL Server 2005, the custom extended procedure era will hopefully be soon behind us. Xprocs were a good idea and certainly added great functionality to earlier releases of the product, but they can also cause...
  • Ken Henderson's WebLog

    Does it make sense to build MFC GUI apps anymore?

    • 5 Comments
    For most developers, I think the answer has to be "No," especially with the advent of managed code. Some would argue that the answer has been "No" for a long time. Tools like VB made GUI development so much easier than it ever was with MFC that many gave...
  • Ken Henderson's WebLog

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

    • 5 Comments
    I didn't really finish the discussion of what I began in this blog , so I'll do so today. Why do I think .NET is the best thing to happen to software since OOP? Several reasons: 1. Based on what the market has said, software for the PC and for Windows...
  • Ken Henderson's WebLog

    Subtle bugs #3

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

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

    • 5 Comments
    ...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....
  • 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

    Celko on Celko

    • 5 Comments
    I'm starting a little series here featuring interviews with industry luminaries. I figured people might like to hear what they have to say. My first subject is Joe Celko. Q1: Tell us a little about yourself, in case somebody does not know you. A1...
  • Ken Henderson's WebLog

    Random thoughts on my trip to the conference

    • 4 Comments
    I had a great time on my brief stint in Denver for the PASS Summit . We had a good session and a good crowd, and Kevin Kline did a marvelous job of running the whole thing. He had lots of great questions for me during the interview, and the crowd had...
  • Ken Henderson's WebLog

    Last Week

    • 4 Comments
    I was in Redmond last week on business and had a lot of fun this time around. The trip began and ended with a visit to Key Arena in downtown Seattle. Monday night it was the Van Halen concert. I’d already seen Van Halen in Kansas City back in October...
  • Ken Henderson's WebLog

    Does rebuilding a clustered index rebuild nonclustered indexes?

    • 4 Comments
    This came up yesterday with one of our support engineers, so I thought I’d post a brief entry on it. On SQL Server 2005, using ALTER INDEX…REBUILD to rebuild a clustered index does not rebuild its nonclustered indexes by default. If you think about it...
  • Ken Henderson's WebLog

    New book coming out

    • 4 Comments
    Dow Jones' Denis Gobo interviewed me recently about the new book some colleagues and I have got coming out. You can find the interview here . For those who don't know, I am the editor for a new book coming out in December entitled SQL Server 2005 Practical...
Page 2 of 4 (91 items) 1234