August 2005 - Posts
Have updated my
XML articles list in my blog site. I intend to keep an ongoing list of articles that I find useful in the XML feature set in this blog. So keep watching it!
I'm in one blogging mood today!
Ran across this site from the SQL Server development center. Its a video library of the SQL Server team at TechEd 2005. You can either watch the clips online (which did not work for me as it was doing too much buffering) or you can download them (approximately 18MB per piece). Good thing was, I was able to put a face behind Ken Henderson (could not see him clear enough in his SQL Server 2000 Internal book) and Roger Walter.
Wish I could have attended Ken Henderson's session at TechEd, which he mentions to be “UMS Internals”. Have fun!
CLR Integration in SQL Server 2005 has taken the main stage for many a days now. There have been numerous articles about the integration and this is one feature that I'm very interested in. Bob Beauchemin is a noted SQL Server expert and I've been following his blog for quite some time now. I've also read his book: A First Look at SQL Server 2005 for Developers some time back. Its a pretty good book and I'm waiting for the second edition of the same. Recently, Bob gave a talk at SQLDownUnder (a site that provides podcasts for the community of professionals using SQL Server) about the CLR Integration and when to use it against T-SQL etc. Its again a re-statement of what I've heard in the past and read in many articles, but it is still worth listening to (unlike a presentation that you can read while the speaker is speaking, here, you have to have rapt attention to listen to the various thoughts that Bob expresses).
The best thing I liked here was that I was finally able to put a face behind the name “Bob Beauchemin” :-) Till now, I've just heard about him and read his articles, but now, I know how he looks like!
On 29th, July, I gave session at the
Bangalore .NET User Group (called B.NET) about the basics of Service Broker. It was a very good session that I was impressed with myself for conveying the information very clearly as to when SSB can be used and how it compares with other competing technologies. I hope to do Part-II of it very soon with some real application that uses the SSB model.
One of our clients upgraded their SQL Server to SP4 and a procedure that was running fine till SQL Server SP3a suddenly gave an “access violation” error. On searching the internet, it looks like this was a problem earlier in SP3a (under some conditions) that was fixed in SP4! The interesting thing was that the code ran fine when you set the “Max Degree of Parallelism” to 1 (from its default value of 0). Not sure if anyone has ever faced this problem, but we are anxiously waiting for the SQL dumpe from the client, since as the saying always goes: We were not able to replicate it here, in our office on multi-processor machines with the “Max Degree of Parallelism” set to both 1 and 0. The code runs just fine!
No, I did not find this thing :-) I subscribe to David Platt's newsletter (which actually did not publish for the past few months). Today morning, I see it in my mail box and I go hooray, he's back. The first article that caught my eye was Platt's analysis of a serious security bug in Click-Once deployment in VS 2005. It was very interesting to read the article and the issue that he points out is actually quite dangerous if exploited by application developers. You can read about this article here: Platt's NewsLetter.
You should subscribe to his newsletter as it contains some pretty interesting stuff.