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!
Rules
•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!
29 Responses
Huh, thought I left one here yesterday, but it’s not showing up. Anyway, here’s my entry. Thanks for hosting!
http://awanderingmind.com/2012/06/12/the-value-of-loggingtsql2sday-31/
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/
mine’s at http://www.simple-talk.com/community/blogs/jonathanallen/archive/2012/06/12/110696.aspx
Hack track-back, jack:
http://sqlblog.com/blogs/merrill_aldrich/archive/2012/06/12/t-sql-tuesday-31-paradox-of-the-sawtooth-log.aspx
Better late than never. Bulk-logged Recovery Model and Point-in-time Restore
In case the trackback never makes it…
http://codegumbo.com/index.php/2012/06/12/tsql2sday-for-whom-do-you-log/
My post is on logging in SSIS 2012. Thanks for hosting http://svangasql.wordpress.com/2012/06/12/t-sql-tuesday-31-ssis-2012-logging/
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!
Here’s mine https://sqlvariant.com/2012/06/t-sql-tuesday-31-logging/ – logging the activity of complex, multi-step procedures
Thanks Aaron! http://blogs.lessthandot.com/index.php/DataMgmt/DBAdmin/does-updating-a-column-to
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.
And here’s my own attempt: http://weblogs.sqlteam.com/robv/archive/2012/06/12/t-sql-tuesday-31-logging-tricks-with-context_info.aspx
In case the trackback isn’t working, here’s mine:
http://www.mikefal.net/2012/06/12/t-sql-tuesday-31-logtime-tsql2sday/
And since you twisted my arm, here’s mine 😉
Logging post on LessThanDot.com
Here’s my submission http://tjaybelt.blogspot.com/2012/06/t-sql-tuesday-31-logging.html
Here is mine.
http://chrisshaw.wordpress.com/2012/06/12/t-sql-tuesday-31-logging/
Here’s mine http://datacentricity.net/2012/06/t-sql-tuesday-031-logging/
Here’s mine http://datacentricity.net/2012/06/t-sql-tuesday-031-logging/ – as there doesn’t appear to be a trackback.
Thanks for the question…
http://chrisshaw.wordpress.com/2012/06/12/t-sql-tuesday-31-logging/
My article can be found at:
http://devjef.wordpress.com/2012/06/12/t-sql-tuesday-31-logging/
http://diligentdba.wordpress.com/2012/06/12/tsql-tuesday-31-logging-case-of-the-missing-lsn/
Thanks.
Excellent topic this month. It provoked so much of conversation around me. http://blog.sqlauthority.com/2012/06/12/sql-server-a-quick-look-at-logging-and-ideas-around-logging/
Mine’s at http://sqlblog.com/blogs/rob_farley/archive/2012/06/12/merge-gives-better-output-options.aspx
Thanks for hosting again!