Just a few notes, there's no full Office suite for RT, they only provide a minimal version of it with an RT device (like a Surface RT). It is a full desktop suite, and not a Windows store app suite, although unless you are on a Surface Pro, you cannot have the full Office suite (without circumventing the kernel implementation for minimum signing level required to run programs on the desktop).
The ONLY one I have seen which is provided as both a Window store app and a desktop app is OneNote. And this is great, because on my Surface RT, I use it all the time for notes that I can sync to the cloud using SkyDrive.
are there ~any~ microsoft productivity products (office, visual studio, sql server) that are written as metro aplets?
The answer to this is no. With the exception of OneNote, and perhaps a few others that I have not come across. But there are others instead, that are not provided as desktop apps, available in the Window Store instead. It wouldn't make sense to have a program like Visual Studio as a Windows Store app, because there's just too much there to make it productive, but it would also cost a TON of money to have it re-developed to support ARM processors, and to also design it as a Windows Store App. There's no easy way to take the progress they have already made for x86 based processor architecture version, and port it over as an app, that runs with LESS of a security context as well. The store apps are meant to be a bit more minimal as well. Most RT devices probably wouldn't be able to effectively run Visual Studio, even if they could have it installed. Which is also why the Surface Pro comes with a bit more "power" and a bigger hard drive..
