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)

July, 2005

  • Facelift I

    I've given the blog a bit of a facelift.. please click the comment link below and let me know if you like what you see. Actual SQL content will come early next week, in the form of something I've come to call "the OPENROWSET trick." Stay tuned,...
  • Thanks, Scotty..

    Sad news today that James Doohan has passed away .. If you're of a particular age, Star Trek was at the least a presence in your life; for many of us, it was an influence. What my mother called "claptrap" when it premiered shortly after my sixth birthday...
  • Baseball Challenge 2005: A Chance To Give Something Back

    Warning: what follows is a shameless solicitation, directed towards my friends and colleagues in the Puget Sound region and throughout the country, to provide financial assistance to some of the most innocent, wonderful people you will ever meet. If this...
  • A Solution For Stripping Invalid XML Characters From varchar/text Data Structures

    One of the more subtle aspects of converting (n)varchar or (n)text data to XML is the fact that XML is choosy about which characters are permitted and (n)/varchar/(n)text is not. Any T-SQL programmer who runs conversions of this type is likely to run...