sitecore5.2

From where to download sitecore 6 starter kit

From where to download sitecore 6 starter kit. link of SDN site does not work ? ...

Can I get all the fields in an item (in Sitecore)?

I'm trying to write a sql query to get all the fields in a given item in Sitecore. To say I am stuck is putting it mildly. I'm guessing I have to do some self joining on the fields table, but I'm getting myself in knots. Anyone have any ideas? ...

How can I login programatically into Sitecore ?

How can I login programatiacally into Sitecore ? For example if you would like to connect a small part of the Sitecore API to a desktop application, you would need to login into sitecore first to access the databases etc. Can this be done ? ...