{"id":27,"date":"2013-10-30T00:00:00","date_gmt":"2013-01-01T00:00:00","guid":{"rendered":"https:\/\/www.sqlhammer.com\/blog\/editorial-automation"},"modified":"2026-03-18T21:50:13","modified_gmt":"2026-03-18T21:50:13","slug":"editorial-automation","status":"publish","type":"post","link":"https:\/\/sqlhammer.com\/index.php\/2013\/10\/30\/editorial-automation\/","title":{"rendered":"Editorial: Automation"},"content":{"rendered":"<p>Often I find myself thinking to myself, \u201c<em>if only I had one more DBA.\u201d\u00a0<\/em>I\u2019m sure we\u2019ve all said this often enough and probably not just to ourselves, I\u2019m sure the boss gets an ear full every now and again. But, there comes a time when you know you just won\u2019t win. Either the decision makers completely disagree with you and won\u2019t be convinced or maybe they agree with you but don\u2019t have the money to spend on a new employee; either way, you are stuck having to do the job of many all by yourself.<\/p>\n<p>Having been in this situation many times, I\u2019ve learned one very important lesson. If you ever do the same thing twice; don\u2019t let yourself do it a third time. This is where automation comes into play. I\u2019m a firm believer in the benefits of short term costs with long term gains. Often we feel that we don\u2019t have enough time to spend on writing dynamic scripts or putting the effort into researching the necessary methods to develop automated solutions. However, repeatedly I\u2019ve learned that the investment is worth it.<\/p>\n<p>It comes down to how we build ourselves. As DBAs we are continuously expanding our knowledge base and improving our skills. Developing dynamic and reusable scripts and processes is another form of growing. When you become the DBA who can fix a problem in the amount of time it takes to sit down at your desk and press F5, your reputation grows along with the knowledge base that you already work to expand. You begin to set yourself apart from your co-workers because, while they might know how to solve that problem as well as you do, they aren\u2019t capable of jumping to the execution phase of the solution as fast as you are. They don\u2019t have a library of pre-made scripts which are dynamic enough to be applied to unexpected situations.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Often I find myself thinking to myself, \u201cif only I had one more DBA.\u201d\u00a0I\u2019m sure we\u2019ve all said this often enough and probably not just to ourselves, I\u2019m sure the boss gets an ear full every now and again. But, there comes a time when you know you just won\u2019t win. Either the decision makers [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-27","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/posts\/27","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/comments?post=27"}],"version-history":[{"count":1,"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/posts\/27\/revisions"}],"predecessor-version":[{"id":290,"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/posts\/27\/revisions\/290"}],"wp:attachment":[{"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/media?parent=27"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/categories?post=27"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/tags?post=27"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}