Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

The Best Database Administrators Automate Everything Expand / Collapse
Author
Message
Posted Tuesday, April 10, 2012 7:04 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, October 7, 2013 6:39 AM
Points: 47, Visits: 133
John.Sansom (4/9/2012)
Hi Ryan,

Consider that the article theme is to encourage the development of a mind set that looks to automate all processes, where applicable. It is not the aim of the article to explicitly identify what those processes are, as these are too varied from one Data Professional role to another i.e. the processes are often context specific.

How would you suggest that the article could provide what you would consider to be sufficient depth, whilst at the same time not being process/scenario specific?

Thanks for your comments.



I understand. The article left me wondering "are you talking about me, or just system admins that do database backups and whatnot?" After re-reading the article (slowly this time), it appears to be written for DBAs, but I see now these concepts can apply to everyone in the field.
Post #1280755
Posted Tuesday, April 10, 2012 7:20 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, August 18, 2014 2:47 AM
Points: 349, Visits: 1,552
Thanks for your feedback Ryan! If something is not clear then I want to know about it and I appreciate you taking the time to explain your thinking.


John Sansom (@sqlBrit) | www.johnsansom.com
Post #1280769
Posted Tuesday, April 10, 2012 8:48 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 23, 2013 8:21 AM
Points: 1, Visits: 9
John.Sansom (4/6/2012)
Wait, do people even still use Python?


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 )
Post #1280843
Posted Tuesday, April 10, 2012 8:53 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, August 18, 2014 2:47 AM
Points: 349, Visits: 1,552
Thanks for sharing those resources Pedro! I'm sure they will prove useful to other readers.


John Sansom (@sqlBrit) | www.johnsansom.com
Post #1280847
Posted Friday, April 27, 2012 1:48 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, March 4, 2014 8:41 AM
Points: 48, Visits: 266
Good article, but rather obvious (who would have thought - automate )

One sentence that has value to me is: "The key thing with automation contrary to typical DBA practices is to not necessarily use the most appropriate tool or technology for the job but to use whatever tool that you can to get the job automated and done.". That is a good point.
Post #1291315
Posted Friday, April 27, 2012 5:03 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, August 18, 2014 2:47 AM
Points: 349, Visits: 1,552
Indeed obvious and yet so tricky for many to actually do....

Thanks for your comments!








John Sansom (@sqlBrit) | www.johnsansom.com
Post #1291395
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse