Invitation for T-SQL Tuesday #004: IO

Yes, it is already time for T-SQL Tuesday again (well one week away, time for the invite). I have been thoroughly enjoying T-SQL Tuesday (especially the posts ones from Brad Schulz) but the fact that this is #004 means time is flying too fast lately.

You Don’t Know What T-SQL Tuesday Is Yet?

Adam Machanic (Also on twitter as @AdamMachanic) had a great idea 4 months back – Invite new and existing SQL Server bloggers to post about the same topic on the same day. The results have been excellent – diverse skill sets and data related job roles all posting from differing perspectives on the same issue.

Since this is still early in the game, a quick list of the post roundups from the first 3 topics:

IO, IO, It’s Off To Disk We Go!

IO is on my mind lately. It could be some recent “discussions” with a SAN administrator, clients with disk performance issues or helping developers with some queries that are doing lots and lots of needless reads. It could be that I just changed my son’s diaper and it was heavy on the Output side (time to start potty training, I think…)

Actually, as a DBA, IO is often on my mind. So that is what this month’s theme is: IO.

Like last month’s theme, you could treat this topic in a few different ways. Perhaps some best practices that you have implemented for disk allocation. A professional development topic on working better with your storage administrators? A case study with a vendor or type of storage system? A developer writing about better managing reads in your queries? You could brag about your latest experiment with SSDs? Maybe a walk down memory lane of storage performance even. How about writing a beginners guide to setting up optimal storage? Have some really busy SQL Servers running on a virtual? How is your IO configured?

Well, you get the idea, the post has to have something to do with IO but it doesn’t have to be about T-SQL necessarily.

There’s always rules…

Once again, please note the time is in UTC. I also echo earlier encouragements to feel free to write your post ahead of time and schedule it. The rules are around when the post publishes, not when it is written.These rules are the same as the previous couple of T-SQL Tuesday’s but I’ll recap:

  1. The Post must go live between 00:00:00 UTC on Tuesday the 9th of March and 00:00:00 UTC on Wednesday the 10th. If it isn’t, it can’t be included in the round up post.
  2. Your post must link back to this post here (Trackback or Comment)
  3. It is your responsibility to verify the trackback or comment appears (My commenting system has a difficult time with trackbacks – If I can’t resolve it by next week I will disable it and use standard WP comments but please still verify and add your own comment with a link back to your T-SQL Tuesday post and it will be included in the roundup.

That’s it. Hopefully those aren’t too difficult to follow :-) Remember

Twitter

Not a rule but a great idea. A lot of the folks who read and participate are on twitter. Follow the hashtag #TSQL2sDay and when your post goes live, tweet a link to it with that tag.

Want To Host?

All you have to do is participate in at least two events and let Adam Machanic know. You can tweet him or leave a comment on his blog, all described in his first T-SQL Tuesday Invitation.

If you need any more clarification, leave a comment. I will respond in the comments or update this post if necessary. Have fun thinking of a topic and I look forward to reading the posts!

Share

Tags: , , ,

Trackbacks/Pingbacks

  1. T-SQL Tuesday Topics – Feb 2011 « Voice of the DBA - February 11, 2011

    [...] T-SQL Tuesday #004: IO [...]

  2. T-SQL Tuesday #18 – My CTE « Voice of the DBA - May 10, 2011

    [...] T-SQL Tuesday #004: IO [...]

  3. T-SQL Tuesday #004: IO — Where Are My TempDB Objects? | SQLSoldier - July 8, 2011

    [...] is participating in T-SQL Tuesday #004, hosted this month by Mike Walsh. You are invited to visit his blog to join the party and read more blogs participating in this month’s theme: [...]

  4. TSQL Tuesday #026 – Second Chances | Dave's SQL Blog - January 3, 2012

    [...] Maybe you were just too busy when Michael Swart invited everyone to write about indexes. Or maybe you weren’t quite happy with the CTE post you came up with when Bob Pusateri hosted.  Or maybe you have a ton to say about IO, but like me, you didn’t know anything about T-SQL Tuesday until long after Mike Walsh’s month. [...]

  5. T-SQL Tuesday Topics – Febuary 2012 « Voice of the DBA - February 7, 2012

    [...] T-SQL Tuesday #004: IO [...]

  6. #Meme15 Meets #T-SQL Tuesday « Chris Shaw's Weblog - April 23, 2012

    [...] http://www.straightpathsql.com/archives/2010/03/invitation-for-t-sql-tuesday-004-io/ [...]

  7. T-SQL Tuesday Topics – December 2012 Update « Voice of the DBA - December 10, 2012

    [...] T-SQL Tuesday #004: IO [...]

  8. Inside sys.dm_db_index_physical_stats - Paul S. Randal - January 17, 2013

    [...] to do for a while now, and I finally had the impetus to do it when I heard about today's T-SQL Tuesday on I/O in general being run by Mike Walsh (Twitter|blog). It's a neat idea so I decided to join in this [...]

  9. Log Buffer #182, A Carnival of the Vanities for DBAs - February 22, 2013

    [...] week’s T-SQL Tuesday topic was I/O. There are many links to great blog posts in the comments; three random posts I chose [...]

Leave a Reply