• Ken Henderson's WebLog

    Favorite web sites

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

    Poll: Do you see SQLCLR as a security threat?

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

    How multiple connections from the same app can kill perf

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

    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

    Leaky code?

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

    Your opinion on the next edition of my architecture book

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

    The best session at the 2005 PASS Summit...

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

    How important is T-SQL portability?

    • 3 Comments
    This came up on a newsgroup recently. I weighed in with my .02 worth and decided to blog about it as well. Question: how important is it to write T-SQL such that it strictly follows the ANSI/ISO standard and will run on other DBMSs unmodified? My answer...
  • Ken Henderson's WebLog

    Political stuff

    • 0 Comments
    For those who enjoy reading such things, a couple of new political ramblings over on my personal blog: http://spaces.msn.com/members/khen1234/PersonalSpace.aspx . I'll post these from time to time over there and may drop notes about them here for those...
  • Ken Henderson's WebLog

    New book promotion

    • 2 Comments
    Addison-Wesley has asked me to mention: Barnes & Noble liked the idea of promoting my books so much last time that they've decided to do it again. For those who don't already have all three of my SQL Server books, B&N is running another 40...
  • Ken Henderson's WebLog

    Don't rely on undocumented features

    • 4 Comments
    I'm as guilty as anyone, but, with the advent of Yukon, I think we're really to the point where many of the undocumented features the user community has come to rely on are no longer needed. The SQL Server development team has made a concerted effort...
  • Ken Henderson's WebLog

    A WAITFOR UNTIL implentation for T-SQL

    • 2 Comments
    You've probably encountered situations where you needed to pause the execution of a stored procedure until some condition became true or needed to run some code when a condition became true. If the condition is time-based, WAITFOR TIME | DELAY can come...
  • Ken Henderson's WebLog

    Blogging from Tech*Ed

    • 1 Comments
    I'm blogging from the speakers' lounge at Tech*Ed. I've had a great week so far. Best sessions to date: 1. Kim Tripp's indexing strategies session was well done and full of useful info. Kim's a training pro, and it shows. 2. Euan Garden's three...
  • Ken Henderson's WebLog

    A technique for ensuring plan stability in SQL Server 2000

    • 19 Comments
    One of the great features in SQL Server is its optimizing query processor. The Sybase version of SQL Server pioneered on-the-fly query optimization, and, even to this day, intrinsic query optimization is one of the most useful features of the product...
  • Ken Henderson's WebLog

    Why Extended Procedures Have Inherent Performance Issues

    • 1 Comments
    To follow up on the recent discussions about regular expressions in T-SQL, I thought it would make sense today to talk about why xprocs have inherent performance issues. While they provide great extensibility to SQL Server, they have intrinsic performance...
  • Ken Henderson's WebLog

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

    • 1 Comments
    This isn't terribly technical in nature, but everyone's talking about it and there are certainly technical elements in it, so I thought I'd link my review of Revenge of the Sith here. It's actually on my non-technical blog over on MSN Spaces.
  • 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

    I'll be speaking at Tech*Ed

    • 0 Comments
    I'll be in Orlando next month speaking at the US edition of Tech*Ed. I think the show is already sold out, so hopefully you've already registered. Come by and see me if you get a chance. I'll be talking about SQL Server's User Mode Scheduler (UMS) architecture...
  • Ken Henderson's WebLog

    Blogging from the hospital

    • 13 Comments
    I'm in the hospital once again with kidney stones. They have a saying in the emergency room here that the severity of the pain one typically experiences with kidney stones is similar to that suffered by women during childbirth. If that's true, it makes...
  • Ken Henderson's WebLog

    Floating point fun

    • 3 Comments
    I've been an advocate of using SQL Server for more than a mere datastore for about as long as I've been working with the product. Too many times, I've walked into development shops only to discover that they're using SQL Server no differently than they...
  • Ken Henderson's WebLog

    Regular Expressions in T-SQL

    • 13 Comments
    Given that a recent blog of mine lamented the dangers of using xprocs, I thought it would be a good time to show some of the wonderful stuff you can do thanks to SQL Server extensibility features such as xprocs and COM objects. It’s not that xprocs or...
  • Ken Henderson's WebLog

    Blogs I regularly read

    • 2 Comments
    Some blogs I regularly read: http://blogs.msdn.com/oldnewthing Written by Raymond Chen, a developer on the MS Windows team. Great stuff if you want to better understand how Windows works, particularly the shell. http://feeds.feedburner.com/sysinternals...
Page 3 of 4 (91 items) 1234