Archive for the ‘TSQL2sDay’ Category

#TSQL2sDay Roundup

So the launch was early, and the write-up is delayed.  Time has no meaning….  Truthfully, I’m sorry I didn’t manage to squeeze this summary post in a bit sooner; I have the typical DBA excuse: too much to do, and too little time. One nice thing about this topic is that it seemed to resonate [...]

October 10, 2011 · stuart · 2 Comments
Posted in: Blogging is FUN!, SQLServerPedia Syndication, TSQL2sDay

#TSQL2sDay T-SQL Tuesday 23–Early edition

  Time once again for another edition of T-SQL Tuesday!  What’s that, you say?  Early?  Why yes, indeed.  Due to the potential schedule of conflict of PASS’s Summit 2011 occurring on the second Tuesday of October (the normal date for T-SQL Tuesday), I’ve gotten special permission to bump it up a week.  To participate in [...]

September 27, 2011 · stuart · 16 Comments
Posted in: Blogging is FUN!, SQLServerPedia Syndication, The Social Web, TSQL2sDay

#TSQL2sday: Emulating a FIRST aggregation

Jes Borland is hosting this month’s T-SQL Tuesday, and it’s all about aggregations.  Here’s an old coding trick of mine to emulate a FIRST aggregation in T-SQL.  Say we have a table that has three columns: ID, a uniqueidentifier Name, a varchar that represents something, and DateStored, a datetime that is set when the row [...]

March 8, 2011 · stuart · No Comments
Posted in: SQLServerPedia Syndication, TSQL2sDay

#TSQL2sDay: Resolutions

For this month’s T-SQL Tuesday, Jen McCown asks: So tell us: what techie resolutions have you been pondering, and why?  Are you heading for a certification? An award? Are you looking to pick up CLR because that guy at the Summit said it’s “bitchin’”? Go crazy… I’ve already covered a lot of my techie resolutions [...]

January 11, 2011 · stuart · No Comments
Posted in: SQLServerPedia Syndication, The Social Web, TSQL2sDay

#TSQL2sDay – My Least Favorite SQL Server Myth

  It’s time again for another T-SQL Tuesday, hosted this month by Sankar Reddy; the topic is misconceptions in SQL Server.  It’s been a while since I wrote one of these (I usually forget about them until the following Wednesday), but this topic is a good one.  I’ve had many discussions with people about the [...]

October 12, 2010 · stuart · No Comments
Posted in: SQLServerPedia Syndication, TSQL2sDay

#TSQL2sDay 003: Maslow and relational design

Rob Farley is hosting the third installment of TSQL Tuesday, and it’s a fun one: relationships (in honor of Valentine’s Day).   While I’m not currently in much of a mood to opine on the virtues of love and databases, I did think I wanted to post something a bit more esoteric this time.  Not many [...]

February 9, 2010 · stuart · 2 Comments
Posted in: SQLServerPedia Syndication, TSQL2sDay

#TSQL2sDay 001: Date/Time Issues and Data Modeling

This is my first post for T-SQL Tuesday (thanks, Adam, for the idea!); I’m hoping this will be a continuing block party, and hopefully connect a lot of us SQL bloggers together.  There’s a lot of great content out there, and sometimes it’s just tough to find. Just a few notes before I get started [...]

December 8, 2009 · stuart · One Comment
Posted in: TSQL2sDay