I have lost count of the amount of people from enterprise customers that ask me "is there a way to store the files outside SQL and only store the metadata and site logic inside sql? The answer used to be:
- Try HP StorageWorks RISS servers… or
- Yes if you use EMC’s Senterra product.
Well, goodbye 3rd party products and hello Microsoft Supported API for storing files outside SQL! Yes, it’s finally here – there is a hotfix that can be requested from here which provides minimal details, but if you’re not keen on a hotfix to implement added functionality then you’ll have to wait for the first service pack to come along. But at least you now know it’s on its way, right!
The hotfix came out at the end of May, so it’s been around for a little while. If someone has had a shot at using it, feel free to post a comment on how you found the API featureset. I imagine that an API .chm file or some online help will venture out around the same time as the service pack is released.