I have recently come back to DBAing and I was about to use Python to automate most of the tasks. From this thread's discussion I'd better take a better look into Powershell. Currently we don't have access to SSIS (long story) and that is why a full blow language/environment may come in handy. Anyway, here is a list of Python tools/packages I gathered for the current required reporting tasks I have to attend. This might come in handy for someone.

MS-SQL Server connectivity:

http://code.google.com/p/pymssql/

http://code.google.com/p/pyodbc/

Data Warehouse Extract-Transform-Load (ETL):

http://pygrametl.org/

Object-Relational Mapping Frameworks:

http://elixir.ematia.de/trac/wiki

http://www.sqlalchemy.org/

http://sqlobject.org/

Python Language Integrated Query – Expression Trees:

https://github.com/heynemann/pynq/wiki (Pynq)

http://www.codebadger.com/blog/post/2009/06/01/Pythone28099s-LINQ-Equivalents-e28093-filter%28%29-map%28%29-and-list-comprehension.aspx (Native Python LINQ equivalents)

Reporting in Python:

http://www.geraldoreports.org/docs/index.html

https://github.com/lightcaster/xlrep

Python integration with other languages/libraries/architectures:

http://jpype.sourceforge.net/ (Java)

http://pythonnet.sourceforge.net/readme.html (.NET)

http://sourceforge.net/projects/pywin32/?_test=b (Win32 Extensions)

http://www.scipy.org/Weave (C/C++ inline)

Excel and CSV File Integration:

http://stackoverflow.com/questions/4257771/python-writing-to-excel-2007-files-xlsx-files

http://packages.python.org/Pyvot/tutorial.html

http://docs.python.org/library/csv.html

Portable Apps (if you need them):

http://www.portablepython.com/

http://pydev.org/ (+ Eclipse Portable http://portableapps.com/node/28647 )