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)

February, 2009

  • Database Programming: The String Concatenation XML Trick, Revisited

    UPDATED 27 February 2009 for spelling I’ve got to pay more punctual attention to my comment pool.. RBarryYoung’s movingsql.com will be on my blog roll shortly after I get this posted (second attempt; first thwarted by a laptop hang. I have suspended...
  • Database Programming: OBJECT_NAME Takes Two Parameters

    This post is a cousin of sorts to last December’s post regarding the OBJECT_ID function. I learned this from Dirk Gubbels when he sent me a follow-up email to the seasonal T-SQL he passed along (the posting of which spawned a small flood ). This “trick...
  • Database Programming Contest: Adam Machanic Throws Down

    Never let it be said that Adam Machanic lacks style.. Adam left a comment on yesterday’s revisiting of the XML String Concatenation Trick, announcing his T-SQL Challenge: Grouped String Concatenation contest. Read Adam’s post to get all of the particulars...
  • Microsoft Knowledge Base Articles Moving to TechNet and MSDN

    Word today from Christopher Kilborn over at Port 80 that, as part of a larger initiative, Microsoft is relocating much of its Knowledge Base library. The money quote: Microsoft is moving its Developer & IT Professional primary support content...
  • Non-Technical Content: 25 Random Baseball Things About Me

    UPDATED 21 FEBRUARY 2009 in the cold morning light: grammar in the introduction and #s 1, 5, 10, 12, 15, 18, and 20; new links in #1; and new information in #18. UPDATED 21 FEBRUARY 2009 later in the day because I just remembered I've been to Texas...
  • Second Shot with a Side of Career Assist: Just What the Doctor Ordered

    In light of the current state of the economy (not to mention recent news in my own back yard (I can still call it that since we continue, against our deeply held wishes, to own a house in Redmond)), I make it a point to count my blessings every day. ...
  • Cumulative Update Package 2 for SQL Server 2005 Service Pack 3 Released

    Only a day late this time .. Cumulative Update Package 2 for SQL Server 2005 Service Pack 3 has been released and is available for download here . As always, Microsoft recommends that you test this package on another instance before installing it into...
  • Last Day to Start Downloading the Windows 7 Beta

    As previously mentioned , if you want to work with the Windows 7 Beta, you need to start your download today and finish it by this Thursday, 12 February 2009.  Full details are available here . If you want it, go get it!  You need to register...
  • Microsoft Learning Asks a Loaded Question: Are You Certifiable?

    This is a really cool idea.. If you’ve ever considered taking a certification exam but aren’t sure if you’re ready, here’s a fun, risk-free way to practice – Are You Certifiable? , a new on-line game from Microsoft and Fuel Industries. Choose an avatar...
  • Registration Open for Spring 2009 IT Pro Tiki Hut Tour

    I’ve got to say, the title of this post isn’t a sentence I ever saw myself typing..  but that’s before I got Blain Barton ’s email today and followed the link .. Blain’s got all the details, including registration links, but you’re basically invited...
  • Windows 7 Beta Downloads Close in a Week..

    .. and you’ve only got nine days left to finish your download. Here’s a lazy cut-and-paste from my previous post on the topic.. There’s a new post on The Windows Blog indicating that general availability of the Windows 7 Beta download will end on...
  • Free Microsoft Press Virtualization E-Book Available for Download

    Understanding Microsoft Virtualization Solutions, by Mitch Tulloch, the Microsoft Virtualization team and published by Microsoft Press, is available as a FREE download here . This 15mB, 400+ page E-Book covers all current Microsoft virtualization technologies...
  • I Hate to Bring This Up Again..

    ..but, once again, the dark underbelly of human nature has shown itself in my trackback pool.. Back in March of 2008, I went off on a little two - post rant about for-fee aggregators.  At the time, I said: For awhile now, I've been aware that there...
  • DWWTWT?: February 23-27

    February closes with a full week of telecommuting: Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations Telecommuted 148 Walked 218 Walked to...
  • DWWTWT?: February 9-13

    Our weather pendulum continues, as this week’s low temperatures are above last week’s highs, and this week’s highs.. well, it was 85 degrees on Wednesday. A pretty wonderful place to spend the week telecommuting from: Commuting...
  • DWWTWT?: February 16-20

    As predicted last week , another full week of telecommuting has that category rocketing into third place on the list, surpassing None : : Commuting Options Selected since 12 June 2006 Mode of Transport Number of...
  • SQL Server 2008 Service Pack 1 CTP Released

    I’m a day late with this, I’m afraid, but it’s still worthwhile.. As reported yesterday on the Microsoft SQL Server Release Services blog , Microsoft has released the Community Technology Preview (CTP) for SQL Server 2008 Service Pack 1.  It’s available...
  • DWWTWT?: February 2-6

    Another week of telecommuting from a central Florida which is back to frosty mode : Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations Telecommuted 133 Walked...