Invitation to T-SQL Tuesday #15 Automation in SQL Server

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!

66 responses to “Invitation to T-SQL Tuesday #15 Automation in SQL Server

  1. Pingback: Tweets that mention Invitation to T-SQL Tuesday #15 Automation in SQL Server | Sql Server Insane Asylum --

  2. Pingback: @SqlAsylum opens Invitation to T-SQL Tuesday #15 Automation in SQL Server | sqlmashup

  3. Pingback: Automation in SQL Server | T-SQL Tuesday #015 #TSQL2sday | sqlmashup

  4. Pingback: SQL SERVER – Automation Process Good or Ugly « Journey to SQL Authority with Pinal Dave

  5. Pingback: Rob Farley : Slide-decks from recent Adelaide SQL Server UG meetings

  6. Here is my entry just in case the trackback doesn’t work correctly.
    My Best Automation JOB Ever (as a DBA

  7. Here’s my post! Thanks for hosting.
    “T-SQL Tuesday #015 – Spend time now to save time later”

  8. Pingback: T-SQL Tuesday #15: Automation | Bob Pusateri - The Outer Join

  9. 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:

  10. Pingback: Automation and T-SQL Tuesday « Chris Shaw’s Weblog

  11. Pingback: Database Automagic | Allen Kinsel - SQL DBA

  12. Trackback probably failed because I forgot to link the logo back to here when it first published. Whoops!

    Here’s my submission this month:

  13. Pingback: T-SQL Tuesday #15 – Automation « Voice of the DBA

  14. Pingback: February 2011 T-SQL Tuesday: Aggregate and Automate | Matt Velic

  15. Uncertain if my trackbacks ever work. Here’s my post:

  16. Pingback: T-SQL Tuesday #15: Database Mirroring Automation | SQLSoldier

  17. Pingback: Allen White : T-SQL Tuesday #015:Remaining on Alert

  18. Pingback: Ad Hoc Automation On TSQL Tuesday « Philergia

  19. Here’s my nickel’s worth.

    In casae the trackback doesn’t:

  20. Pingback: T-SQL Tuesday #015 – Automation in SQL Server « DBA Star

  21. I might be late on this, but I wanted to share anyways!

  22. Sorry for the delay, my web host thought this was a great day for a brown-out 😦

  23. Pingback: The Best Data Modeler is a Lazy Data Modeler – #tsql2sday Post | InfoAdvisors' Blog

  24. Pingback: T-SQL Tuesday Topics – Feb 2011 « Voice of the DBA

  25. Pingback: A Variety of Interpretations « Voice of the DBA

  26. Pingback: TSQL2sday #015 – Automation in SQL Server « Nancy Hidy Wilson's Blog

  27. Pingback: T-SQL Tuesday #18 – My CTE « Voice of the DBA

  28. Pingback: How to get the SQL server critical errors via mail using native T-SQL Script « SqlserverBlogForum

  29. Pingback: TSQL Tuesday #026 – Second Chances | Dave's SQL Blog

  30. Pingback: T-SQL Tuesday Topics – Febuary 2012 « Voice of the DBA

  31. Pingback: #Meme15 Meets #T-SQL Tuesday « Chris Shaw's Weblog

  32. Pingback: T-SQL Tuesday Topics – December 2012 Update « Voice of the DBA

  33. Pingback: T-SQL Tuesday #050: Automation, how much of it is the same? | SqlChow

  34. Pingback: Less Than Dot - Blog - Awesome

  35. Pingback: Less Than Dot - Blog - Awesome

  36. Pingback: T-SQL Tuesday #50 – Automation -When repetition is really what you want | R4

  37. Pingback: Slide-decks from recent Adelaide SQL Server UG meetings – LobsterPot Blogs

  38. Pingback: T-SQL Tuesday #15: Database Mirroring Automation – SQLSoldier

  39. Pingback: T-SQL Tuesday #015 – Automation in SQL Server – T-SQL Tuesday

  40. Pingback: 2011 T-SQL Tuesdays – T-SQL Tuesday

  41. Pingback: T-SQL Tuesday Participation Over the Years | SQL RNNR

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s