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)

March, 2008

  • Non-Technical News: All Is Finally Right With The World..

    Last Tuesday and Wednesday very little was right with the world, as the first two games of the 2008 regular Major League Baseball season were played half a world away, and they started at 3AM Seattle time.  I'm all for globalizing the appeal of the...
  • DWWTWT?: March 31

    The week begins and the month ends with my ninth straight walk. Three tables today, since it's the end of the quarter as well as the month: Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations...
  • DWWTWT?: March 28

    Friday brought a walk through a cold, spitting rain: Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations Telecommuted 37 Walked 172 Walked...
  • DWWTWT?: March 27

    The streak continues with another walk on another cold morning: Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations Telecommuted 37 Walked 171 ...
  • See You At Microsoft Tech·Ed North America 2008 Developers!

    Happy news this week that I'll be traveling to Orlando, Florida the first week of June to attend and present at Microsoft Tech·Ed North America 2008 Developers June 3-6 at the Orange County Convention Center . I'll be revisiting the three presentations...
  • DWWTWT?: March 26

    This morning featured yet another walk down a brisk, slightly damp 156th Avenue NE : Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations Telecommuted 37 Walked...
  • DWWTWT?: March 25

    This morning featured a walk down a brisk 156th Avenue NE : Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations Telecommuted 37 Walked 169 ...
  • DWWTWT?: March 24

    The week begins with a brisk walk on a chilly morning : Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations Telecommuted 37 Walked 168 Walked...
  • DWWTWT?: March 21

    The week ends with yet another brisk morning and another walk to building 40, to listen in on most of Kim Tripp's SQL Ranger talk : Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations...
  • Database Programming: The String Concatenation XML Trick, Finalized

    It's an especially Good Friday when we can close the loop on a technical conversation, and I believe that our modifications to The Technique That Lance Found , also discussed here and here , are complete.  Scott Whigham left a comment on the most...
  • DWWTWT?: March 20

    Another brisk morning, another walk to building 40, this time to listen in on the first day of Paul Randal's SQL Ranger talk : Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations ...
  • DWWTWT?: March 19

    Today featured another walk, this time to building 40 to deliver a SQL Ranger data normalization talk : Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations Telecommuted...
  • Database Programming: The String Concatenation XML Trick, Sans Entitization

    When last we checked in on The Technique That Lance Found , Adam had noted that the method entitizes XML special characters, a state of affairs which limits its utility somewhat.  I tried to leverage Tony Rogerson's technique , which Adam passed...
  • DWWTWT?: March 18

    Today featured a bracing walk on a clear, dry, cool morning : Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations Telecommuted 37 Walked 164 ...
  • R.I.P. Arthur C. Clarke (1917-2008)

    Sad word today from the world of letters that Arthur C. Clarke has passed at 90. While his most remarkable book was made into a most remarkable film (which bears little resemblance to the book, in my opinion), Clarke was an incredibly prolific writer...
  • DWWTWT?: March 17

    Today Gale had a doctor's appointment, so timely discharge of all my obligations required the deployment of internal combustion : Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations...
  • Another Word On For-Fee Aggregators

    One more post before I turn in.. Blogging is about passion and community, which may well be two sides of the same coin.  Our passion makes us a community.  Even though I don't read the output of my fellows in the SQL Server blogosphere nearly...
  • Database Programming: The String Concatenation XML Trick Revisited (Or, Adam Is Right, But We Can Fix It)

    A find shared by one friend leads to correspondence from another.. The redoubtable Adam Machanic left a comment on The Technique That Lance Found which points out that special XML characters in a string will get entitized. As usual, Adam is correct...
  • DWWTWT?: March 14

    Today all three boys had baseball practice, the youngest an hour earlier than the other two. Not only did I drive to work, I spent the late afternoon driving young men in cleats all over Redmond. Not a great day for my carbon footprint : ...
  • DWWTWT?: March 13

    Today is a tough one to call.. I telecommuted most of the morning before taking my wife to her latest doctor appointment (she's allowed to walk without her crutch when she's up to it -- hooray!). We had a nice lunch; then I brought her home and drove...
  • Database Programming: The String Concatenation XML Trick

    Courtesy of my good friend and once-and-always colleague, Lance Larsen, who writes: I recently ran into this little trick. Joining two tables having a one-to-many relationship and stuffing a set of column values from the many side into a single...
  • DWWTWT?: March 12

    Today featured another walk through a dry morning: Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations Telecommuted 37 Walked 163 Walked to...
  • DWWTWT?: March 11

    Today featured a walk through light rain: Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations Telecommuted 37 Walked 162 Walked to the Bus...
  • Don't Forget! SQL Server 2008 Web Chat On Thursday, March 13

    I wanted to mention this one more time, since my previous post on this topic suffers from a cryptic title.. Join the Microsoft SQL Server development team to learn more and ask technical questions about the February CTP release of SQL Server 2008....
  • DWWTWT?: March 10

    The week and the fourth Ranger rotation start with a walk through light rain: Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations Telecommuted 37 Walked ...