I use it for several applicartions. Not sure that there is any difference with the various versions of sql server, except for minor syntax issues.
What did you want to know?
The performance is very good.
I have one application in which I use the admin interface which uses the ORM and I have another application that I just use the template system
for a fairly robust version control, software migration application.
For the 2nd application I just use plain old sql and the pyodbc module.
The django app complains if you don't put a connection string for sql server in the settings file, so I do that just to keep the appl happy.
Let me know what type of information you are interested in.