May 2005 - Posts

• Why Extended Procedures Have Inherent Performance Issues

  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 Read More... Posted Friday, May 27, 2005 8:16 AM by khen1234 | 1 Comments

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

  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. Read More... Posted Monday, May 23, 2005 12:41 AM by khen1234 | 1 Comments

• Regular Expressions in T-SQL, Part II

  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 Read More... Posted Thursday, May 19, 2005 4:07 PM by khen1234 | 7 Comments

• I'll be speaking at Tech*Ed

  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 Read More... Posted Wednesday, May 18, 2005 6:47 AM by khen1234 | 0 Comments

• Blogging from the hospital

  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 Read More... Posted Saturday, May 14, 2005 4:43 AM by khen1234 | 13 Comments

• Floating point fun

  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'd Read More... Posted Friday, May 13, 2005 5:39 AM by khen1234 | 3 Comments

• Regular Expressions in T-SQL

  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 Read More... Posted Wednesday, May 11, 2005 6:46 AM by khen1234 | 13 Comments

• Blogs I regularly read

  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/feed Read More... Posted Tuesday, May 10, 2005 10:47 PM by khen1234 | 2 Comments

• Be careful with xproc memory allocation

  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 Read More... Posted Sunday, May 08, 2005 10:05 AM by khen1234 | 5 Comments

• Goodbye, Seoul

  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. Read More... Posted Friday, May 06, 2005 4:43 PM by khen1234 | 1 Comments

• Blogging from Seoul

  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 Read More... Posted Sunday, May 01, 2005 5:41 PM by khen1234 | 6 Comments