May 2008 Entries
Today I was envolved in a discussion thread which revolved around the SQL CLR. Naturally I jumped in in defense of the CLR based on my own experience. But one of the other participants pointed me to a blog post by Paul Nielsen about lessons learned while building a system with a SLA of 35k tps (transactions per second).According to Paul, due to the marshalling requirements of the CLR the string split method eventually becomes much slower than the regular T-SQL solution. Apparenly, it doesn't hold up under a large number of concurrent transactions.Before I go all chicken little and...
It's finally time to dig into what all the buzz with WCF is about. From what I hear it should perform better than WebServices, has better security and be more flexible. But I'm a bit frustrated by some of the documentation out there. So much of what I'm seeing is either glazed over too much for me to immediately apply it (blogs, articles and forums) or it's too high level to get me started quick enough to play with it. So in order to cement what I'm learning about WCF I am planning on writing a series of posts that...
I have been fighting a "permissions" issue with Sql Server Reporting Services (SSRS) for the last few days. When I run my Custom Report Item (CRI) on my local instance of SSRS it works fine. But when I try to install the CRI on a dedicated server running SSRS I was getting the following error:That assembly does not allow partially trusted callers.When I compared my local rssrvpolicy.config file with the one on the server they were identical. So I shouldn't have been getting the permissions error. Things were complicated by the fact that I was trying to troubleshoot the issue...