May, 2005

  • 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

    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

    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

    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

    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

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

    Goodbye, Seoul

    • 1 Comments
    The world's first production deployment of SQL Server 2000 on a 64-way, 64-bit machine was a success. I've had a fantastic time here in Seoul -- both working and after-hours. The food has been great, the people wonderful, and the weather Spring-like....
  • 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

    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

    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...
Page 1 of 1 (11 items)