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

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

Jorge Segarra — Mon, 30 Nov 2009 18:03:56 GMT

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

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

Mike Walsh — Mon, 30 Nov 2009 18:29:26 GMT

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.

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

jamie thomson — Mon, 30 Nov 2009 18:42:19 GMT

brilliant idea. i'm in!

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

Alex K — Mon, 30 Nov 2009 19:46:00 GMT

Adam,

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

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

Adam Machanic — Mon, 30 Nov 2009 19:58:27 GMT

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!

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

Sankar Reddy — Tue, 01 Dec 2009 00:23:53 GMT

Adam,

>>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?

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

Adam Machanic — Tue, 01 Dec 2009 00:39:14 GMT

Sankar,

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

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

Wes Brown — Tue, 01 Dec 2009 03:24:05 GMT

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

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

Luke Hayler — Tue, 01 Dec 2009 07:16:07 GMT

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.

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

Phil Brammer — Tue, 01 Dec 2009 12:40:46 GMT

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

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

Adam Machanic — Tue, 01 Dec 2009 14:20:49 GMT

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!

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

jamiet — Tue, 01 Dec 2009 16:02:15 GMT

Adam,

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

#tsql-tuesday

-Jamie

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

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

Adam Machanic — Tue, 01 Dec 2009 16:13:21 GMT

Jamie,

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 ?

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

jamiet — Tue, 01 Dec 2009 16:27:50 GMT

Adam,

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

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

-Jamie

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

Stuart Ainsworth — Tue, 01 Dec 2009 19:58:06 GMT

I'm in! Great idea, Adam.

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

Rob Farley — Tue, 01 Dec 2009 22:20:23 GMT

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

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

Madhivanan — Wed, 02 Dec 2009 13:29:36 GMT

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

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

Amit Banerjee — Thu, 03 Dec 2009 11:02:59 GMT

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

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

Brad Schulz — Fri, 04 Dec 2009 19:23:47 GMT

Count me in...

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

--Brad

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

jamiet — Sat, 05 Dec 2009 12:52:15 GMT

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

"T-SQL Tuesday"

-Jamie

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

SQLvariant — Sat, 05 Dec 2009 17:48:55 GMT

Adam,

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.

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

Adam Machanic — Sat, 05 Dec 2009 19:18:43 GMT

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.

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

Adam Machanic — Sat, 05 Dec 2009 19:19:20 GMT

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

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

David Leibowitz — Mon, 07 Dec 2009 18:16:20 GMT

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?

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

Adam Machanic — Mon, 07 Dec 2009 19:37:13 GMT

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.

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

jamiet — Tue, 08 Dec 2009 09:27:23 GMT

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)

-Jamie

Age calculation with SQL Server

SQL and the like — Tue, 08 Dec 2009 09:43:45 GMT

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

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

Rob Farley — Tue, 08 Dec 2009 10:51:51 GMT

In case my Trackback doesn't turn up for some reason... http://msmvps.com/blogs/robfarley/archive/2009/12/08/t-sql-tuesday-a-date-dimension-table-with-computed-columns.aspx

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

Mike Walsh — Tue, 08 Dec 2009 12:27:00 GMT

My trackback doesn't seem to like me this morning. I posted a couple thoughts here: http://www.straightpathsql.com/blog/2009/12/8/t-sql-tuesday-001-dates-and-time.html

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

Tue, 08 Dec 2009 14:33:49 GMT

My contribution to this great idea of T-SQL Tuesday: http://www.bluedog67.com/blog/post/T-SQL-Tuesday-Introduction-to-Effective-Dating.aspx

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

Alan Wood — Tue, 08 Dec 2009 14:41:21 GMT

T-SQL Tuesday: Return a range of dates between 2 days: http://sqlserver.posterous.com/t-sql-tuesday-return-a-range-of-dates-between

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

Brad Schulz — Tue, 08 Dec 2009 15:08:07 GMT

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

http://bradsruminations.blogspot.com/2009/12/friday-13th-2009-cluster-of-terror.html

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

--Brad

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

Alastair — Tue, 08 Dec 2009 15:51:17 GMT

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

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

Jack Corbett — Tue, 08 Dec 2009 16:27:15 GMT

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

http://wiseman-wiseguy.blogspot.com/2009/12/t-sql-tuesday-001-dates-and-times.html

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

Adam Machanic — Tue, 08 Dec 2009 16:31:05 GMT

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.

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

andyleonard — Tue, 08 Dec 2009 17:15:07 GMT

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!

http://sqlblog.com/blogs/andy_leonard/archive/2009/12/08/t-sql-tuesday-001-a-couple-ssis-date-expressions.aspx

:{> Andy

T-SQL Tuesday #001: My Datetime FAQ

Kalen Delaney — Tue, 08 Dec 2009 18:50:34 GMT

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

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

Jen McCown — Tue, 08 Dec 2009 19:41:20 GMT

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

T-SQL Tuesday #001: Exploring "Fuzzy" Interval Islands Using SQLCLR

Adam Machanic — Tue, 08 Dec 2009 20:13:02 GMT

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

T-SQL Tuesday #001: Splitting Date/Time Ranges and Intersections

The Rambling DBA: Jonathan Kehayias — Tue, 08 Dec 2009 20:18:05 GMT

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

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

Jen McCown — Tue, 08 Dec 2009 20:18:08 GMT

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

Same link: http://bit.ly/78uEMI

Unambiguous date formats : T-SQL Tuesday #001

SSIS Junkie — Tue, 08 Dec 2009 20:23:42 GMT

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

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

Adam Machanic — Tue, 08 Dec 2009 20:30:20 GMT

Jen: No worries, your trackback came through.

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

Stuart Ainsworth — Tue, 08 Dec 2009 21:34:57 GMT

In case the trackback didn't make it:

http://codegumbo.com/index.php/2009/12/08/tsql2sday-001-datetime-issues-and-data-modeling/

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

SQLvariant — Wed, 09 Dec 2009 01:33:26 GMT

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"

http://sqlvariant.com/wordpress/index.php/2009/12/t-sql-tuesday-date-time-tricks-with-the-datetime-data-type/

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

Rob Farley — Wed, 09 Dec 2009 10:29:46 GMT

Alex's got missed... http://sqlblog.com/blogs/alexander_kuznetsov/archive/2009/12/08/t-sql-tuesday-001-yesterday-it-worked-today-it-s-not-working.aspx

Book Review - oldie but a goodie - Inside SQL 2005 Query Tuning and Optimization

Rob Farley — Fri, 19 Feb 2010 07:37:50 GMT

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

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

StefBauer — Wed, 14 Apr 2010 12:47:25 GMT

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

@stefbauer

T-SQL Tuesday #006: "What About BLOB?"

Michael Coles: Sergeant SQL — Mon, 03 May 2010 23:56:45 GMT

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

T-SQL Tuesday #006: Tiger/Line Spatial Data

Michael Coles: Sergeant SQL — Tue, 11 May 2010 23:35:21 GMT

This month’s T-SQL Tuesday post is about LOB data http://sqlblog.com/blogs/michael_coles/archive/2010/05/03/t-sql-tuesday-006-what-about-blob.aspx

PASS Summit 2010: Epilogue

Stacia Misner — Mon, 15 Nov 2010 21:36:20 GMT

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

Un-SQL Friday: Don't Be a Port in the Storm

Adam Machanic — Fri, 19 Nov 2010 17:00:21 GMT

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

A Year of Tuesdays: T-SQL Tuesday Meta-Roundup

Adam Machanic — Tue, 07 Dec 2010 18:43:18 GMT

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

T-SQL Tuesday 24: Ode to Composable Code

Merrill Aldrich — Tue, 08 Nov 2011 06:54:06 GMT

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

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

Chris Yates — Tue, 12 Jun 2012 18:56:50 GMT

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

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

nick — Fri, 21 Dec 2012 06:52:04 GMT

I took grapefruitmoon.net's example and simplify it further

http://blog.ediot.net/2012/12/how-to-get-date-range-in-list-table.html

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

Ed Watson — Thu, 14 Feb 2013 13:07:48 GMT

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

SQLGator

http://SQLGator.com