March 2007 Entries
The load balancer I wrote last year never made it into full production. While it was still in Q&A we hit our deadline and we stopped new development as we hit our "busy season". At MaxPreps, once the fall season starts and football is in full swing our architechture gets locked in and we don't make changes to it unless it's to fix problems we missed. So the load balancer went by the wayside. But now it's the time of year where we start preparing for the next year and so it's time to dust of the load balancer and...
As I mentioned in my last post I've begun investigating the SQL Server CLR. I decided after getting warmed up to commit to an entire series of articles and I've just finished the first one on security. I figured it would be the best place to start as I know it's an unknown for a lot of people who are either still considering a SQL 2005 upgrade or have upgraded and aren't sure what to think of the new CLR feature. In fact I'm willing to bet there are a lot of DBAs out there who won't give it a...