<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by John Sansom
»
The Best Database Administrators Automate...
26 posts, Page 3 of 3
««
«
1
2
3
The Best Database Administrators Automate Everything
Rate Topic
Display Mode
Topic Options
Author
Message
ryan.mcatee
ryan.mcatee
Posted Tuesday, April 10, 2012 7:04 AM
SSC Rookie
Group: General Forum Members
Last Login: Today @ 9:35 AM
Points: 43,
Visits: 119
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
John.Sansom
John.Sansom
Posted Tuesday, April 10, 2012 7:20 AM
Old Hand
Group: General Forum Members
Last Login: Friday, May 10, 2013 1:52 AM
Points: 343,
Visits: 1,453
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.sqlbrit.com
The SQLBrit Community Forum
- "There's so more to being a Data Professional than just technology."
Post #1280769
Pedro Palhoto
Pedro Palhoto
Posted Tuesday, April 10, 2012 8:48 AM
Forum Newbie
Group: General Forum Members
Last Login: Thursday, October 18, 2012 8:34 AM
Points: 1,
Visits: 8
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
John.Sansom
John.Sansom
Posted Tuesday, April 10, 2012 8:53 AM
Old Hand
Group: General Forum Members
Last Login: Friday, May 10, 2013 1:52 AM
Points: 343,
Visits: 1,453
Thanks for sharing those resources Pedro! I'm sure they will prove useful to other readers.
John Sansom (
@sqlBrit
) |
www.sqlbrit.com
The SQLBrit Community Forum
- "There's so more to being a Data Professional than just technology."
Post #1280847
pkrudysz
pkrudysz
Posted Friday, April 27, 2012 1:48 AM
SSC Rookie
Group: General Forum Members
Last Login: Tuesday, May 14, 2013 6:10 AM
Points: 48,
Visits: 257
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
John.Sansom
John.Sansom
Posted Friday, April 27, 2012 5:03 AM
Old Hand
Group: General Forum Members
Last Login: Friday, May 10, 2013 1:52 AM
Points: 343,
Visits: 1,453
Indeed obvious and yet so tricky for many to actually do....
Thanks for your comments!
John Sansom (
@sqlBrit
) |
www.sqlbrit.com
The SQLBrit Community Forum
- "There's so more to being a Data Professional than just technology."
Post #1291395
« Prev Topic
|
Next Topic »
26 posts, Page 3 of 3
««
«
1
2
3
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
