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...

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.

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...

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...

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...

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...

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...

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...

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...

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....

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...