A new year is always a time of great joy and celebration for most of us. For some of us it is a chance to start something new. For a select few, it is time to laze a little and let the haze of winter pass by. To all of you, here is to a great year ahead! Cheers!
TSQL-Tuesday#050: The automation story
Automation plays a huge part in our lives and the DBA profession is no so different. A couple of years ago this topic was shared by Pat Wright. I would like to revisit this again and see how much of our approach has changed.
You could write about, what options you would consider when automating something? Where do you draw the line? What are our preferred tools for automation? T-SQL, PowerShell, VBScript or Batch files(?) or maybe just share something that you automated in the last couple of years.
What is T-SQL Tuesday?
T-SQL Tuesday is a monthly blog party hosted by a different blogger each month. This blog party was started by Adam Machanic (blog|twitter). You can take part by posting your own participating post that fits the topic of the month and follows the requirements below. Additionally, if you are interested in hosting a future T-SQL Tuesday, contact Adam Machanic on his blog.
How to Participate
- Your post must be published between 00:00 GMT Tuesday, January 14th, 2014, and 00:00 GMT Wednesday January 15th, 2013.
- Your post must contain the T-SQL Tuesday logo from above and the image should link back to this blog post.
- Trackbacks should work. But, please do add a link to your post in the comments section below so everyone can see your work.
- Tweet about your post using the hash tag #TSQL2sDay.
By profession, I’m a SQL Server Database Administrator. I love to poke my nose into different corners and see how stuff looks in there. I keep looking for new things to do as my mind refuses to settle on one topic.
SqlChow 
[…] Jan – T-SQL Tuesday #50 – Automation […]
[…] month’s T-SQL Tuesday is about automation, and I thought I’d write about how a few of my favourite applications help me massively in the […]
Thanks for hosting! Mine’s at http://sqlblog.com/blogs/rob_farley/archive/2014/01/14/write-blogpost.aspx
First to post! Here is mine for this month -> http://borishristov.com/blog/t-sql-tuesday-050-automation/
[…] […]
Thank you for hosting! My post can be found here:
Thanks for hosting. My contribution:
http://blogs.lessthandot.com/index.php/datamgmt/dbprogramming/mssqlserver/t-sql-tuesday-50-automation/
Thanks for hosting this month! http://sqlnikon.wordpress.com/2014/01/14/t-sql-tuesday-50-automating-tasks/
[…] can read more entries from this weeks T-SQL Tuesday, hosted by […]
[…] month’s topic comes from @sqlchow who gives us the topic of automation. How would we do it? What would we do? What tools? It’s a great […]
Thanks for hosting, my thougths here:
http://jason-carter.net/professional/t-sql-tuesday-050-automation.html
Just published my contribution as well: http://stuart-moore.com/automation-making-boring-interesting/
[…] month the Tsql2sDay topic is automation – props to our host SqlChow for the topic. Props to Adam Machanic for the rolling […]
Hey SqlChow ! Here’s my submission for the month: A better mousetrap? http://wp.me/p2TlyL-9x
[…] […]
Thanks for hosting. Here is mine: http://sqlity.net/en/1824/5-reasons-automate-tests-t-sql-tuesday-50-automation/
Thank you for hosting. My contribution is here: http://mickeystuewe.com/2014/01/14/t-sql-tuesday-50-automation-equates-to-saved-time
[…] T-SQL Tuesday #050: Automation, how much of it is the same? […]
Thanks for hosting, my entry: http://blog.hoegaerden.be/2014/01/14/t-sql-tuesday-50-automation-automation-automation/
Thanks for hosting; mine is at
http://chrisyatessql.wordpress.com/wp-admin/post.php?post=726&action=edit&message=6&postpost=v2
Here’s mine:
http://realsqlguy.com/sometimes-dirty-job-tsql2sday-50/
Looks like my pingback didn’t make it. Here is the link to my post: http://blog.waynesheffield.com/wayne/archive/2014/01/tsql-tuesday_50_automation_verifying-the-backup-chain/
Thanks for the topic and for hosting!
Thanks for hosting this month!
http://sqlblog.com/blogs/merrill_aldrich/archive/2014/01/14/automation-think-causation-not-correlation.aspx
[…] ← T-SQL Tuesday #050: Automation, how much of it is the same? […]
[…] This blog party was started by Adam Machanic (blog|twitter). You can take part by posting your own participating post that fits the topic of the month. This month, SQLChow blessed us with a topic I am very passionate about. This months T-SQL Tuesday topic is automation. […]
Thanks for hosting. Mine can be found at http://johnsterrett.com/2014/01/14/t-sql-tuesday-50-automation-for-lazydbas/
[…] months T-SQL Tuesday is about automation and I thought I’d write about extending existing automation. One of my favorite scripts for […]
[…] months T-SQL Tuesday is about automation and I thought I’d write about extending existing automation. One of my favorite scripts for […]
[…] This blog party was started by Adam Machanic (blog|twitter). You can take part by posting your own participating post that fits the topic of the month. This month, SQLChow blessed us with a topic I am very passionate about. This months T-SQL Tuesday topic is automation. […]
Here’s mine… I got the right person this time 🙂 http://sql313.com/index.php/menu-main-blog/14-maincat-dba/cat-automate/51-tsql-tuesdays-50 Thanks for hosting!
Heres mine, Thanks for hosting
http://www.allenkinsel.com/archive/2014/01/extending-automation-of-sql-recoveries-using-ola-hallengrens-backup-solution/
Thanks for hosting!
http://blogs.lessthandot.com/index.php/datamgmt/dbadmin/mssqlserveradmin/t-sql-tuesday-50-automating-your-installs/
[…] time once again for that monthly geek party again we like to call T-SQL Tuesday. T-SQL Tuesday #50 is hosted this month by Hemanth.D (Blog|@SQLChow). You are invited to visit his […]
T-SQL Tuesday #50: Doing More With Less http://www.sqlsoldier.com/wp/sqlserver/tsqltuesday50doingmorewithless
And my contribution – http://martincatherall.com/2014/01/15/tsql-tuesday050-automation/.
Cheers for hosting the first T-SQL Tuesday of 2014 and also the 50th edition!
My first participation – hopefully I’m clear! I was in a bit of a hurry due to a snow storm/blizzard – time to head home!
http://allen-mcguire.blogspot.com/2014/01/using-automation-to-help-others-save.html
[…] You can read the invite he posted here. […]
Here is mine http://jasonbrimhall.info/2014/01/14/t-sql-tuesday-050-automating-database-restores/
Mine is here (I don’t think it posted the first time I tried!) : http://www.bidn.com/blogs/KathiKellenberger/sql-server/5878/t-sql-tuesday-50-automation
Thank for hosting this month. My contribution is here:
http://ruirib.net/blog/index.php/2014/01/t-sql-tuesday-50-automation-when-repetition-is-really-what-you-want/
Thanks for revisiting and hosting for the 2014 year. Here’s my contribution http://www.gogorichie.com/2014/01/t-sql-tuesday-050-automation-get-work-done-while-sleeping/
[…] big thank you to Hemanth [T | B] for hosting this year’s first T-SQL Tuesday and to Adam Machanic [B|T] as his initiative just […]
[…] time once again for that monthly geek party again we like to call T-SQL Tuesday. T-SQL Tuesday #50 is hosted this month by Hemanth.D (Blog|@SQLChow). You are invited to visit his […]