THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Adam Machanic

Adam Machanic, Boston-based SQL Server developer, shares his experiences with programming, monitoring, and performance tuning SQL Server. And the occasional battle with the query optimizer.

Invitation to Participate in T-SQL Tuesday #001: Date/Time Tricks

T-SQL Tuesday is the SQL Server blogosphere's first recurring, revolving blog party. The idea is simple: 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 posts must go live on the second Tuesday of the month, by (or before) 23:59 PST. Each post must link back to the host blog's post, and the blogger should make sure that a trackback has been generated and successfully posted to the host blog; if not, a comment should be posted on the host blog with a link, so that the host blogger can find the post. The host blogger will then take all of the posts and within a day or two will compile a "roundup"--a brief summary with links--so that readers can find all of the relevant posts.

Why do this? Several reasons: It's fun, it's going to generate a lot of interesting content, and it's going to bring lots of bloggers into the fold and improve our overall community by creating a lot of links between blogs. Any blogger is invited to participate, whether the blog has been live for six days or six years. If you can write, you should join in the fun.

Rules of engagement for hosts: Although anyone can join in the party, hosting has a slightly higher bar: Your blog must have been active in the last six months ("active" is defined as at least one post per month), and you must have participated in T-SQL Tuesday events on at least two prior occasions. Since that's impossible until we've had two events, I'll host the first two myself. After that it will move around to as many blogs as we can get involved--and I hope that a number of you out there decide to go for it. The host blogger is not required to write a participating post to be included in the roundup, but is free to do so if he or she chooses. Want to host? Contact me through my blog--I'll keep a waiting list and control it centrally so that it doesn't devolve into anarchy too quickly.

So that's that. If you bothered to read the title of this post you're aware that the topic for this month is Date/Time Tricks. Write a blog post that talks about dates and times--this can be based around T-SQL programming, data modeling, ETL, reporting, or whatever else you're using dates and times for (and who isn't?). Make sure that your post goes live on Tuesday, December 8, between 00:00 and 23:59 PST. Make it clear in your post that it's for T-SQL Tuesday, and make sure it links back here. Finally, make absolutely certain that a comment shows up here so that I can find the post.

Questions? Comments? Post here.

Enjoy! I'm looking forward to the start of a great blog tradition in the SQL Server community.

Published Monday, November 30, 2009 1:47 PM by Adam Machanic



Jorge Segarra said:

I'm loving this idea and I'd like to throw my name into the ring to host one sometime.

November 30, 2009 1:03 PM

Mike Walsh said:

Sounds like a good idea. You can throw me into the "willing to host" list. Now to think of something interesting to post about dates.

November 30, 2009 1:29 PM

jamie thomson said:

brilliant idea. i'm in!

November 30, 2009 1:42 PM

Alex K said:


This is a very interesting idea, but why on Tuesday and why for only one day? I think quite a few people are going to be busy on any given weekday. For instance, if something important is going on, I would either forget to publish a blog post, or not have the time to do so...

November 30, 2009 2:46 PM

Adam Machanic said:

Alex: Why on Tuesday? Because that's the day I chose. Why only one day? Because otherwise there's nothing special or memorable about it. If you're too busy to participate, then don't--simple as that. By the way, you do know that you can schedule posts ahead of time, right?

Jorge, Mike, and Jamie--can't wait to see your posts!

November 30, 2009 2:58 PM

Sankar Reddy said:


>>Write a blog post that talks about dates and times

Just to get some clarification on the ground rules, one blogger could write only one post or as many he/she can write?

Do you want to put some rules on the length of the content?

November 30, 2009 7:23 PM

Adam Machanic said:


Write as much or as little as you want. No rules there.

November 30, 2009 7:39 PM

Wes Brown said:

I'm in it to win it! This is a competition right? He who has the most posts wins! WOO HOO! :)

November 30, 2009 10:24 PM

Luke Hayler said:

Hi Adam,

This is a great idea!

So is this only for 'fresh' posts, or can we submit/update older (but relevant) posts to be included?

Looking forward to the first installment.

December 1, 2009 2:16 AM

Phil Brammer said:

I'm in!  Yet another innovative communication mechanism from the SQL Server world!

December 1, 2009 7:40 AM

Adam Machanic said:

Wes: Self-competition :-)

Luke: The idea is that it would usually be for "fresh" content, yes. But if you want to repost something, it's your blog--you can feel free to do that and I'll link to it. But I will only link if the post goes live on the correct day. I will not link to an older post. So as I told someone on Twitter yesterday, what you might want to do is create a new post that links to some of your previous posts, and perhaps expands on them a bit, and submit that.

Phil: Great, looking forward to your post!

December 1, 2009 9:20 AM

jamiet said:


I think we need a Twitter hashtag for T-SQL Tuesday. Can I suggest:




P.S. I've already used it :)

December 1, 2009 11:02 AM

Adam Machanic said:


Great idea, but I'm pretty sure the hashtags don't support hyphens. At least the Twitter clients I used don't seem to make a link out of your tag. How about the same tag sans hyphen? #tsqltuesday ?

December 1, 2009 11:13 AM

jamiet said:


You're right, it doesn't show up as a hashtag on [Strangely it does on other clients - the perils of "conventions" over specifications!!! :)]

#tsqltuessday it is then! I've changed my tweet accordingly!


December 1, 2009 11:27 AM

Stuart Ainsworth said:

I'm in!  Great idea, Adam.

December 1, 2009 2:58 PM

Rob Farley said:

I'll get something blogged. I'm also happy to "host" sometime.

December 1, 2009 5:20 PM

Madhivanan said:

How about a tag with underscore for better readability like #tsql_tuesday?

December 2, 2009 8:29 AM

Amit Banerjee said:

This is indeed a great idea to get the community going!

December 3, 2009 6:02 AM

Brad Schulz said:

Count me in...

I've got something really wacky ready to publish next Tuesday.


December 4, 2009 2:23 PM

jamiet said:

Might be an idea to encourage everyone to use the same blog tag as well. i.e.:

"T-SQL Tuesday"


December 5, 2009 7:52 AM

SQLvariant said:


I love the idea and would like to host at some point.  Also, what about #TSQL2sDay for the hashtag?  Just a thought on making it a little different, also might help in reminding that it is the 2nd Tuesday.

December 5, 2009 12:48 PM

Adam Machanic said:

Jamie: Definitely a good idea for everyone to use the same tag on their blog in the subject of the post, e.g. "T-SQL Tuesday #001: How to Eliminate all Date/Time Columns From Your Database"

SQLVariant: I like it! Let's go with that. I'll use it on Monday and Tuesday when I remind people to post and hopefully we can get it to stick.

December 5, 2009 2:18 PM

Adam Machanic said:

Jamie, I just realized you meant an actual tag. Yes, that's a good idea too!

December 5, 2009 2:19 PM

David Leibowitz said:

Great idea. Will post content as I can regarding themes. Would be happy to host as well.

Q: if it's based on trackbacks...we're going to have to weed thru the spambots, no?

December 7, 2009 1:16 PM

Adam Machanic said:

David: Most of the SQL blogs don't get hit too hard by SPAM. Are you actually seeing so much that it would be a sufficient effort to weed through it? I go through all of the comments on this entire site once a week and usually delete one or two SPAM posts, but it's never very much.

December 7, 2009 2:37 PM

jamiet said:

Hey Adam,

Best point out "#TSQL2sDay" ASAP, some people have already started using a different hashtag (I won't link to it - don't want to draw attention to it)


December 8, 2009 4:27 AM

SQL and the like said:

There seem to be many different methods being suggested to calculate an age in SQLServer.  Some

December 8, 2009 4:43 AM

Rob Farley said:

December 8, 2009 5:51 AM

Mike Walsh said:

My trackback doesn't seem to like me this morning. I posted a couple thoughts here:

December 8, 2009 7:27 AM


December 8, 2009 9:33 AM

Alan Wood said:

T-SQL Tuesday: Return a range of dates between 2 days:

December 8, 2009 9:41 AM

Brad Schulz said:

Here's my entry... Read at your own risk:

There's gotta be one weirdo at every party, right?


December 8, 2009 10:08 AM

Alastair said:

I was thinking about submitting an entry, but having just read Brad's, I don't think I can compete! Excellent stuff.

December 8, 2009 10:51 AM

Jack Corbett said:

I don't think mine "competes" with anyone's but I put one out there:

December 8, 2009 11:27 AM

Adam Machanic said:

There is no competition to be had. This is a community exercise and all are welcome to participate, unless they do something like take someone else's material and republish it with their own name on it, or something similarly inappropriate.

December 8, 2009 11:31 AM

andyleonard said:

Hi Adam,

  Cool idea! I'm interested in hosting one of these in the future.

  I put together some SSIS Expressions for basic date formatting - now I don't have to recreate them anymore!

:{> Andy

December 8, 2009 12:15 PM

Kalen Delaney said:

I am rising to Adam's challenge for his very first T-SQL Tuesday , and blogging about datetime issues.

December 8, 2009 1:50 PM

Jen McCown said:

Hey Adam, here's my "Remix! Optimized: Query by Hour, Day, Week, or Month" post for TSQL Tuesday:!-Optimized-Query-by-Hour2c-Day2c-Week2c-or-Month.aspx

December 8, 2009 2:41 PM

Adam Machanic said:

When working with time intervals, we often want to ask a couple of basic questions: Which time periods

December 8, 2009 3:13 PM

The Rambling DBA: Jonathan Kehayias said:

At the end of November, Adam Machanic put out the invite to join a weekly blog party called TSQL Tuesday

December 8, 2009 3:18 PM

Jen McCown said:

Hm, that link's not going to work well. Trying HTML: <a HREF="!-Optimized-Query-by-Hour2c-Day2c-Week2c-or-Month.aspx">Remix! Optimized: Query by Hour, Day, Week, or Month</A>

Same link:

December 8, 2009 3:18 PM

SSIS Junkie said:

One of the most commonly used data types in SQL Server is [datetime] which unfortunately has some vagaries

December 8, 2009 3:23 PM

Adam Machanic said:

Jen: No worries, your trackback came through.

December 8, 2009 3:30 PM

Stuart Ainsworth said:

December 8, 2009 4:34 PM

SQLvariant said:

Nothing overly special, just 4 things that I find that I use pretty often:

"T-SQL Tuesday Date, Time, tricks with the DateTime Data Type"

December 8, 2009 8:33 PM

Rob Farley said:

December 9, 2009 5:29 AM

Rob Farley said:

I've moved my blog here, and thought I'd start with a book review. This is a post that I've been meaning

February 19, 2010 2:37 AM

StefBauer said:

This is such a great concept! Add me to the list of "willing to host".


April 14, 2010 8:47 AM

Michael Coles: Sergeant SQL said:

Invitation for T-SQL Tuesday #006: "What About BLOB?" It's getting warm outside just in time for the

May 3, 2010 7:56 PM

Michael Coles: Sergeant SQL said:

May 11, 2010 7:35 PM

Stacia Misner said:

Another PASS Summit has come and gone, and a good time was had by all. The song at the opening keynote

November 15, 2010 4:36 PM

Adam Machanic said:

My good friends Sean and Jen, the Midnight DBAs , have decided to blatantly copy me. Un-SQL Friday is

November 19, 2010 12:00 PM

Adam Machanic said:

Just over a year ago I kicked off T-SQL Tuesday , "a recurring, revolving blog party." The idea was simple:

December 7, 2010 1:43 PM

Merrill Aldrich said:

I love the T-SQL Tuesday tradition, started by Adam Machanic and hosted this month by Brad Shulz . I

November 8, 2011 1:54 AM

Chris Yates said:

Adam, if the opportunity ever presents itself I would enjoy hosting a TSQL Tuesday. Thanks!

June 12, 2012 2:56 PM

nick said:

I took's example and simplify it further

December 21, 2012 1:52 AM

Ed Watson said:

Adam, I have a good idea for a topic if you need someone for next month.


February 14, 2013 8:07 AM
New Comments to this post are disabled

About Adam Machanic

Adam Machanic is a Boston-based SQL Server developer, writer, and speaker. He focuses on large-scale data warehouse performance and development, and is author of the award-winning SQL Server monitoring stored procedure, sp_WhoIsActive. Adam has written for numerous web sites and magazines, including SQLblog, Simple Talk, Search SQL Server, SQL Server Professional, CoDe, and VSJ. He has also contributed to several books on SQL Server, including "SQL Server 2008 Internals" (Microsoft Press, 2009) and "Expert SQL Server 2005 Development" (Apress, 2007). Adam regularly speaks at conferences and training events on a variety of SQL Server topics. He is a Microsoft Most Valuable Professional (MVP) for SQL Server, a Microsoft Certified IT Professional (MCITP), and an alumnus of the INETA North American Speakers Bureau.

This Blog


Privacy Statement