Having taken part in several T-SQL Tuesday’s I decided I would finally put my name in to host one. I figured it would be a good way to lose my sanity learn some great ideas from this wonderful SQL community. I figured that since many of you out there set a goal this year to blog more and to learn Powershell then this Topic should help in both of those goals. So the topic I have chosen for this month is Automation! It can be Automation with T-SQL or with Powershell or a mix of both. Give us your best tips/tricks and ideas for making our lives easier through Automation. Now here are all the details you’ll need for a successful T-SQL Tuesday post!
What exactly is T-SQL Tuesday? Words from the Master Adam Machanic (Blog|Twitter)
“Each month a blog will host the party, and about a week before the second Tuesday of the month a theme will be posted. Any blogger that wishes to participate is invited to write a post on the chosen topic. The event is called “T-SQL Tuesday”, but any post that is related to both SQL Server and the theme is fair game. So feel free to post about SSIS, SSRS, Java integration, or whatever other technologies you’re working with in conjunction with SQL Server. Even if your post includes no T-SQL we still want to see it.”
The Rules
1. Your post must go live between 00:00:00 GMT on Tuesday the 8th of February and 00:00:00 GMT on Wednesday the 9th.
2. Your blog post has to link back to the hosting blog and the link must be anchored from the logo (the blue one shown at the top of this post) which must also appear at the top of the post.
3. If trackbacks won’t work properly then please leave a comment below so that your post is accounted for in the roundup.
Extra Points
1. Advertise! Include a reference to T-SQL Tuesday in the title of your post.
2. Tweet! Use the hash tag #TSQL2sDay to follow links and other relevant conversations.
3. Host! Consider hosting T-SQL Tuesday yourself. If you’re interested let Adam Machanic Know. If you’ve participated in two T-SQL Tuesdays previously and you keep up your blog (blog monthly for the last six months) then he’ll put you in the rotation.
Looking forward to reading through all the great submissions!
Sql Insane Asylum (A Blog by Pat Wright) 
Thanks for hosting Pat Wright . I like this topic “Automation”.
Here is my entry
http://sqlserverblogforum.blogspot.com/2011/02/how-to-get-sql-server-critical-errors.html
This is interesting subject and here is my part: http://blog.sqlauthority.com/2011/02/08/sql-server-automation-process-good-or-ugly/
Mine’s at http://sqlblog.com/blogs/rob_farley/archive/2011/02/08/slide-decks-from-recent-adelaide-sql-server-ug-meetings.aspx
Hi Pat, thanks for hosting, this is a great topic and I enjoyed participating!
http://noelmckinney.com/2011/02/t-sql-tuesday-015-%E2%80%93-automation-in-sql-server/
Here ya go! Hope this track back thing works. If not, please let me know!
http://www.bidn.com/blogs/JEBacaniSQLDude/bidn-blog/1515/t-sql-tuesday-015-driving-automation-in-ssrs-that’s-my-topic
Here is my entry just in case the trackback doesn’t work correctly.
My Best Automation JOB Ever (as a DBA
Thanks for hosting. Here’s my submission. 🙂
http://blog.nhaslam.com/2011/02/08/t-sql-tuesday-using-wherescape-red-tsql2sday/
Thanks for another great topic! Here is my entry.
http://sqlblog.hartskeerl.nl/2011/02/08/t-sql-tuesday-15-automation-in-sql-server/
Here’s my post! Thanks for hosting.
“T-SQL Tuesday #015 – Spend time now to save time later”
http://tenbulls.co.uk/2011/02/08/t-sql-tuesday-015-%E2%80%93-spend-time-now-to-save-time-later/
Hey Pat – Awesome Topic! Thanks so much!
http://www.bobpusateri.com/archive/2011/02/t-sql-tuesday-15-automation/
Thanks for hosting this month Pat. A little ironic that I failed to correctly set-up schedule automation on a post about automation 🙂 sorry about that. Here is the URL: http://www.sqlmashup.com/automation-in-sql-server-t-sql-tuesday-015-ts
Thanks for hosting this month, Pat! Here is my post
http://blogs.lessthandot.com/index.php/DataMgmt/DBAdmin/powershell-replace-with-regex
Here’s my submission for this month:
http://sqlblog.com/blogs/jonathan_kehayias/archive/2011/02/08/tsql-tuesday-15-maintaining-your-sanity-while-managing-large-environments.aspx
Here’s mine for this month, thanks!
http://davidbrycehoward.com/archive/2011/02/automationthe-secret-to-happiness-t-sql-tuesday-15/
Here is one more for you Pat. Good Question.
http://chrisshaw.wordpress.com/2011/02/08/automation-and-t-sql-tuesday/
Looks like mine did not pingback properly. Here is the link:
http://www.scarydba.com/2011/02/08/tsql-tuesday-15automation-in-sql-server/
Trackback probably failed because I forgot to link the logo back to here when it first published. Whoops!
Here’s my submission this month:
http://www.airbornegeek.com/2011/02/t-sql-tuesday-15-automation-in-sql-server/
Here’s mine: http://voiceofthedba.wordpress.com/2011/02/08/t-sql-tuesday-15-automation/
I don’t see my pingback:
http://sqlblog.com/blogs/aaron_bertrand/archive/2011/02/08/t-sql-tuesday-15-running-t-sql-workloads-remotely-on-multiple-servers.aspx
Uncertain if my trackbacks ever work. Here’s my post: http://mattvelic.com/aggregate-and-automate/
I am not seeing my pingback/trackback either. My post is at http://nullgarity.wordpress.com/2011/02/08/t-sql-tuesday-my-automation-epiphany/
T-SQL Tuesday #15: Database Mirroring Automation
Woot! Two T-SQL Tuesdays in a row for me!
http://sqlserverio.com/2011/02/08/gather-virtual-file-statistics-using-t-sql-tsql2sday-15/
My post:
The Best Data Modeler is a Lazy Data Modeler
http://blog.infoadvisors.com/index.php/2011/02/08/the-best-data-modeler-is-a-lazy-data-modeler-tsql2sday-post/
One more:
http://agilebi.com/jwelch/2011/02/08/t-sql-tuesday-15-automating-xml-updates-w-powershell/
And mine: http://sqlblog.com/blogs/allen_white/archive/2011/02/08/t-sql-tuesday-015-remaining-on-alert.aspx
Here is mine in case the trackback is unsuccessful.
http://jasonbrimhall.info/2011/02/08/t-sql-tuesday-15-dba-automaton/
Here’s my contribution:
http://sev17.com/2011/02/t-sql-tuesday-15-automation-and-the-ssis-dumper/
Looks like the trackback didn’t work so here’s my link.
http://briandavis78.blogspot.com/2011/02/tsql-tuesday-15-automation.html
Thanks!
Here’s my nickel’s worth.
In casae the trackback doesn’t: http://philergia.wordpress.com
I might be late on this, but I wanted to share anyways!
http://www.the-fays.net/blog/?p=45
Sorry for the delay, my web host thought this was a great day for a brown-out 😦
http://sqlvariant.com/wordpress/index.php/2011/02/powershell-interfaces-with-other-hammers/
PowerShell – The Automator
http://salyoung.dyndns.info/2011/02/08/powershell-the-automator-t-sql-tuesday-15/