If you want to get your hands really dirty, here are some big ideas to contemplate.
FreeTDS includes a little stub of a server, but it could be much more useful. One idea would be to make it a front-end to SQLite, thereby creating for the first time a TDS client & server pair composed entirely of free software.