Archive for March, 2011

Something new for 2011: bunches of little stuff

OK, it’s the last day of March, and I’m phoning in this blog post.  It’s not that I haven’t spent a lot of time learning something new this month, it’s that I’ve got a pile of stuff to get through before leaving on vacation next week, and I really just don’t have more than 15 [...]

March 31, 2011 · stuart · 3 Comments
Posted in: Something New, SQLServerPedia Syndication

much delayed #sqlsat70 write-up

This write-up will be brief and to the point: SQL Saturday 70 rocked.  K. Brian Kelley (Blog|Twitter) and his team put together a great event (again), and it was a lot of fun catching up with so many SQL people.  Unfortunately, I had a rather severe sinus infection which kept me from really enjoying the [...]

March 28, 2011 · stuart · 3 Comments
Posted in: Conferences, SQL Server, SQLServerPedia Syndication

#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

My interview with #sqlpeople is up!

Totally missed this one a few days ago; my mini-blog with SQLPeople was just posted on March 2.  Thanks to Andy Leonard for pulling this together; it’s been interesting reading about a lot of people I already knew, but didn’t know enough about.

March 7, 2011 · stuart · No Comments
Posted in: SQLServerPedia Syndication, The Social Web