Should You Use CLR Capabilities?
My particular question about CLR capabilities is that I have enjoyed using them for years. Now, considering the utilization of Azure I find they are not available. The reason, you don’t have direct access to disk subsystems in the Azure world, and CLR assemblies require a path in order to work.
Sounds like a broken record…you can’t use that feature in Azure or SQL Azure because you don’t have access to the disk subsystem. But it makes sense. Still, it is a limiting feature I wonder if Microsoft is interested in resolving. I’m pleased that they started out with the restrictions rather than letting customers stomp on each others deployments. But these restrictions continue to cause mature applications to not be ported to SQL Azure for one reason or another.
Still, this is the same reasoning that many professionals have warned against when CLR assemblies were first released in SQL Server 2005. The point was that any code written in CLR would not port to any other data engine directly, and to most engines, there is no counterpart.
I liked the performance and power and found it useful. I thought, I’m using Microsoft for a long time to come. I really didn’t think Microsoft would, themselves, put out a release not supporting their own capabilities, at least if I was willing to pay enough money. Well, I was wrong.
So, what do you think? Were the early professionals correct in their recommendation not to use CLR assemblies in SQL Server? Is SQL Azure a simple example of what they were talking about? Send in your comments to btaylor@sswug.org.
Cheers,
Ben
SSWUGtv
With Stephen Wynkoop
Don’t miss this episode of SSWUGtv where Stephen interviews Josef Richberg, talking about SSIS. Joseph covers common mistakes, things to know and tips – all for SSIS and SQL Server.
Watch the Show
Reader Feedback – Fastest Disks
Russ writes:
Interesting article on SAN vs DAS disk performance. We use a cheap solution that delivers amazing results. We have been using a DAS pci Revo drive that delivers 230,000 IOPS and up to 1.9GBS. There are some more modern drives now that deliver even better performance. It would be interesting to see Linchi’s test results updated to include SSD results vs. modern SAN and DAS spinning disk performance.
$$SWYNK$$
Featured White Paper(s)
SharePoint 2010 Enables the Enterprise
Written by KnowledgeLake
read more)
Featured Script
Asynchronous SMTP alternative to SQLMail
Use these proceures in conjunction with the xp_smpt_sendmail extended stored procedure avaialable from www.sqldev.net to crea… (read more)