SQLvariations: SQL Server, a little PowerShell, maybe some Tableau Rotating Header Image

T-SQL Tuesday #31 – Logging

I’m excited to be hosting this month’s T-SQL Tuesday.  This month we’re talking about logging.  Logging comes in many form and fashions.  If you think about it, when you go to the grocery store with at big list, Do you put the items in the cart and then check them off the list?  If so, isn’t that a kind of write-ahead log?

I point that out because I don’t want anyone to constrain themselves to talking about logging within just SQL Server.  Please bring your ideas for file transfers, report generating, performance gathering, uptime monitoring and the like.  But don’t stop there!  This is an open invite to anyone that does anything in the SQL Server community.

If Karla Landrum ( blog | twitter ) wants to explain to us how on Earth she keeps track of all these SQL Saturdays around the world, that’s logging!  If Tim Radney ( blog | twitter ) wants to tell us how he makes sure he keeps in touch with all of the chapters he’s responsible for as a PASS Regional Mentor, that’s logging!

How you keep track of blog ideas, white papers you read, or however it is you life-hack *your* SQL world: please share it with us!

•Your post must be published between 00:00 GMT Tuesday June 12th, 2012, and 00:00 GMT Wednesday June 13th, 2012
•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 if you don’t see one please link to your post in the comments section below so everyone can see your work

Optional, but highly encouraged…
•Include a reference to T-SQL Tuesday in the title of your post
•Tweet about your post using the hash tag #TSQL2sDay
•Consider hosting T-SQL Tuesday yourself. Adam Machanic keeps the list.


P.S.  Since I’m the host, any PowerShell topic on logging is cool too!


  1. Huh, thought I left one here yesterday, but it’s not showing up. Anyway, here’s my entry. Thanks for hosting!


  2. Well, my solution is very simple. In fact I beleive that I dont understood the stuff. But here it go…-> http://shellyourexperience.wordpress.com/2012/06/12/my-solution-to-t-sql-tuesday-31-logging/

  3. […] blog entry is participating in T-SQL Tuesday #31, hosted this month by Aaron Nelson (Blog|@SQLVariant). You are invited to visit his blog to join […]

  4. Here’s my T-SQL Tuesday post (non-tech but it counts!): http://marlonribunal.com/t-sql-tuesday-31-logging/

    And, I’m no longer a T-SQL Tuesday virgin!

  5. Greg Lucas says:

    Here’s mine http://sqlvariant.com/2012/06/t-sql-tuesday-31-logging/ – logging the activity of complex, multi-step procedures

  6. Thanks for hosting Aaron! My post is “T-SQL Tuesday #31 – Reporting Services Logs” at http://blogs.lessthandot.com/index.php/DataMgmt/ssrs/t-sql-tuesday-31-reporting.

  7. And since you twisted my arm, here’s mine 😉
    Logging post on LessThanDot.com

  8. Greg M Lucas says:

    Here’s mine http://datacentricity.net/2012/06/t-sql-tuesday-031-logging/ – as there doesn’t appear to be a trackback.

  9. […] One of the more subtle things about MERGE is the power of the OUTPUT clause. Useful for logging. […]