Next pet project is to move my blog on Community Server to the Cloud. I spend too long making sure my database size does not go over 500 MB, the size limit on my hoster. So once every 3 months I have to do some clean up of the database:
DELETE FROM cs_statistics_Site
DELETE FROM cs_Visits
DELETE FROM cs_Exceptions
DELETE FROM cs_EventLog
To keep the database from going over 500 MB, those above are the tables that keep growing without impacting my blog posts. I have to options, move to Telligent Graffiti or to move my database to the Microsoft Cloud. I don’t think that there is a tool to convert CS2007 to Graffiti.
If I decide to move to the Cloud, this is a bookmark to remember to set up a computer with the Azure SDK for VS2008.
What do I need.
Windows Azure SDK Windows Azure Tools for Microsoft Visual Studio Where to learn.
http://blogs.msdn.com/cloud/archive/2008/10/27/getting-started-windows-azure-tools-for-microsoft-visual-studio.aspx
I recommend to subscribe to http://blogs.msdn.com/cloud and start using the cloud for all your data instead of keeping using hosters databases.
What's next?
I need a token to get access to the storage. Anybody?
Cheers
Al