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

  • 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...
  • Are You Paying To Read This Post? You Don't Have To!

    In the age of the blog, it may well be that republishing is the sincerest form of flattery. The same RSS technology that many of you use to read the blog through wonderful rollers like this one also can be turned to far more nefarious purposes. I'm going...
  • 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...
  • 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...
  • 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...
  • 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....
  • Yet Another Blog You Should Check Out

    The comment space for yesterday's rant about the web site that's charging for access to MSDN and TechNet blog content is busier than any has been for awhile.  I also got this email via the contact mechanism on the blog: I was just about to ask you...
  • 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...
  • SQL Server 2008 February CTP Scheduled For March 13

    Forwarding along a nugget that my inbox served up.. Join the Microsoft SQL Server development team to learn more and ask technical questions about the February CTP release of SQL Server 2008. The web chat starts here at 11 am Pacific Daylight Time...
  • 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 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 ...
  • 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 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...
  • 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 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 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 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 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 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 ...
  • 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 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 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...
  • 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 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 ...
  • 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...