Ward Pond's SQL Server blog

Ruminating on issues pertinent to the design and development of sound databases and processes under Microsoft SQL Server 2008, SQL Server 2005, and SQL Server 2000 (while reserving the right to vent about anything else that's on my mind)

May, 2008

  • Database Programming: Operator Precedence in DTS is a Matter of Inheritance

    This post will (hopefully) close a thread which runs here and here . When we last addressed this issue, I mentioned that an answer to the operator precedence question for DTS raised by Scott R. would depend on either my research or the kindness of...
  • Database Programming: Operator Precedence In SQL Server

    [UPDATED 9 May 2008; the information presented doesn't exactly answer Greg's question. There's an update here ; and DTS is discussed here ] I received an inquiry yesterday from Greg Husemeier, who I met when he came to Redmond for the SQL Ranger program...
  • Non-Technical News: Lessons from Benihana and Brandon Roy

    Yesterday was a big day in our household. In addition to our two resident mothers, we also commemorated our eldest son's sixteenth birthday. Earlier in the week, after a delicate negotiation, we agreed on a blended celebration dinner at the Benihana restaurant...
  • Eighteen Days Until TechEd Developers North America 2008!

    This afternoon, I attended a briefing for TechEd North America 2008 presenters and staff, and yesterday I got my booth schedule for the event.  I've got my Hands-On Lab for SQL Tricks finished, and I was happily surprised to hear earlier this week...
  • Database Programming: Operator Precedence In SSIS

    This morning's post on Operator Precedence was a little misleading, as Scott pointed out in his comment: The example expression highlighted in green above (A <> 0 AND B / A > 1) is said to evaluate differently in SQL 2000 and SQL 2005,...
  • Career News: Goin' Mobile

    I'm goin' home And when I wanna go home I'm goin' mobile Well, I'm gonna find a home And we'll see how it feels Goin' mobile Keep me movin' - Goin' Mobile , Pete Townsend ( The Who ) Frequent readers of this space will know that I only break out the...
  • DWWTWT?: May 8

    Thursday saw a walk on a sunny, cool morning: Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations Telecommuted 38 Walked 198 Walked to the...
  • DWWTWT?: May 7

    The week reaches its midpoint with a walk on 156th Avenue NE on an almost-drizzling, cool morning: Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations Telecommuted ...
  • DWWTWT?: May 2

    The week ends with a walk on 156th Avenue NE on a dry, cool morning: Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations Telecommuted 38 Walked 194...
  • DWWTWT?: May 12

    The week begins with a milestone walk on yet another sunny, cool morning: Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations Telecommuted 38 Walked ...
  • DWWTWT?: May 15

    Thursday brought the first t-shirt-and-sandals walk of the season. If the weather predictions are accurate, I may be breaking out my shorts tomorrow: Commuting Options Selected since 12 June 2006 Mode of Transport Number...
  • DWWTWT?: May 6

    The week continues with a walk on 156th Avenue NE on a cloudy but dry morning: Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations Telecommuted 38 Walked...
  • DWWTWT?: May 16

    The warm weather prophesied yesterday came to pass, at least in sufficient measure to allow the deployment of a t-shirt, shorts, and sandals in combination for the first time this season. With such gorgeous weather and a green commuting streak which reaches...
  • DWWTWT?: May 5

    The week begins with a walk on 156th Avenue NE on a dry, temperate morning: Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations Telecommuted 38 Walked ...
  • DWWTWT?: May 1

    The new month begins with a return to form as I took a walk on 156th Avenue NE on a dry, cool morning: Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations Telecommuted ...
  • DWWTWT?: May 19-23

    The week was non-competitive following a burst appendix: Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations Telecommuted 38 Walked 204 Walked...
  • DWWTWT?: May 26-30

    The week was again non-competitive following a burst appendix the evening of May 17: Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations Telecommuted 38 Walked...
  • DWWTWT?: May 13

    The dry streak ended, but the latest walking streak continued through a steadily increasing drizzle: Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations Telecommuted ...
  • DWWTWT?: May 14

    Mid-week brought another walk down 156th Avenue NE, this one through a dry, temperate morning: Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations Telecommuted 38...
  • DWWTWT?: May 9

    The week ends with another walk on another sunny, cool morning: Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations Telecommuted 38 Walked 199 ...