Archive for the ‘TSQL2sDay’ Category

#TSQL2sDay.. For Whom Do You Log?

This month’s T-SQL Tuesday is being hosted by Aaron Nelson [blog | twitter]; since I’m posting this late in the day, I got a chance to sneak a peek at some of the other entries, and most of them were great technical discussions on how to log, what to log, and why you should log.  […]

June 12, 2012 · stuart · No Comments
Posted in: SQLServerPedia Syndication, TSQL2sDay

#TSQL2sDay 28–Jack of All Trades, Master of None

This month’s topic was chosen by Argenis Fernandez (blog | twitter): "Jack of All Trades, Master of None?".  It’s interesting to me lately because I seem to keep encountering blog posts and articles that ask some variant of this question.  I’m not sure if it’s spurred in part by the recent release of SQL Server […]

March 13, 2012 · stuart · No Comments
Posted in: SQLServerPedia Syndication, TSQL2sDay

#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 · 4 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 · 21 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