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)

Ward Pond's SQL Server blog

  • DWWTWT?: October 1-2

    The fourth quarter begins with a pair of telecommutes: Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations Telecommuted 268 Walked 218 Walked...
  • DWWTWT?: September 30

    After yesterday’s milestone , the month and quarter conclude with a telecommute (green commute #501): Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations Telecommuted ...
  • DWWTWT?: September 28-29

    The week starts out with a couple of telecommuting days: Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations Telecommuted 265 Walked 218 Walked...
  • Mark Your Calendar: Windows 7 Readiness Webcast on October 6

    The following description of a pending webcast arrived in my inbox earlier this week; I thought it might be of interest to some of you as you prepare for the launch of Windows 7: Is Your Organization Ready for Windows 7? October 6, 2009 12:00 PM Eastern...
  • A Gift From Jens and Jimmy

    Two Microsoft folks frequently featured in this space, Microsoft Certified Masters Jimmy May and Jens Suessmeyer , have joined forces to bring to the world SQLIOSimParser, a tool to parse and interpret the XML output of the Bob Dorr’s SQLIOSim testing...
  • SQL Server 2008 R2 August CTP Available for Download

    If you’re interested in the next release of SQL Server, the BI-focused SQL Server 2008 R2, you’ll be pleased to know that the August CTP is available for download here for MSDN and TechNet members. Here’s the skinny from the download page: SQL Server...
  • DWWTWT?: September 14-25

    These last two weeks have been spent diligently telecommuting from the woods of central Florida: Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations Telecommuted 263...
  • DWWTWT?: September 7-11

    After Monday’s Labor Day holiday, the remainder of the week was spent telecommuting from the woods of central Florida: Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations Telecommuted...
  • Pond’s Twelfth Law: In Your Pursuit of Five Nines, Don’t Practice in Front of the CIO

    After a long hiatus , Pond’s Laws of System Design (or, How to Be a Competent Professional in an Irrational World) returns. Thanks to Jimmy May for a kick-in-the-pants on this topic several months ago; I hope he’ll understand why I just had to wait until...
  • Database Programming: A New String Concatenation Contender for SQL Server 2008

    UPDATED 11:11p 7 September 2009: Based on my latest exchange with Adam (see the comments for this post), compound operators should be avoided for string concatenation due to the ORDER BY bug discused in KB 287515 . The XML variant below is the preferred...
  • DWWTWT?: September 1-4

    The month begins and the week proceeds with an uninterrupted telecommuting stretch: Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations Telecommuted 249 Walked...
  • Database Programming: Did You Know IN Can Do This?

    Courtesy of Jens Suessmeyer comes this little gem purloined from an internal discussion; cut-and-paste this into SQL Server Management Studio and see if you can answer the questions in the comments before you execute the script: --   create and populate...
  • Download a New Browser and Help Feed the Hungry

    I sure wish I’d known about this sooner.. If you haven’t yet downloaded Internet Explorer 8, here’s a great opportunity to acquire some fantastic software and help out some folks less fortunate than we are in the bargain. If you download Internet Explorer...
  • DWWTWT?: August 31

    The month ends and the week begins with a telecommute: Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations Telecommuted 245 Walked 218 Walked...
  • Adam Machanic Likes MERGE, Too

    Hot on the heels of yesterday’s MERGE discussion comes a complementary (and far more detailed) take from Adam Machanic .  It’s a nifty technical discussion, under the banner of an outstanding Dr. Strangelove pun. To see some of the true power of...
  • Database Programming: Why I Like MERGE

    In the wake of last month’s post on my new development efforts in SQL Server 2008, several of you have asked me to go into further detail.  This post is my first effort to answer those questions; right now, we’ll focus on these two , which relate...
  • DWWTWT?: August 17-21

    I took Friday off this week to celebrate the last day of summer vacation with my family after a week of telecommuting: Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations Telecommuted...
  • DWWTWT?: August 10-14

    My energy level has improved markedly through a week of telecommuting: Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations Telecommuted 235 Walked 218...
  • DWWTWT?: August 3-7

    I had gallbladder surgery on Monday and was home Wednesday night. Amazingly, I was back to work from home for the last two days of the week: Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations...
  • At the Onset of My Fiftieth Year

    Those of you who follow me on Twitter or Facebook are aware that I’ve spent the last week and a half dealing with my latest round of health issues.  I returned home yesterday afternoon following a brief hospitalization for diagnosis and removal of...
  • DWWTWT?: July 27-31

    The planned all-driving week was postponed due to several extenuating circumstances, and will hopefully transpire at the beginning of September. I drove Monday and then spent the rest of the week dealing with my gall bladder issue, entering the hospital...
  • Database Programming: What I’ve Learned About SQL Server 2008 (with a little on SQL Server 2005 thrown in)

    With SQLRAP 2.5 out the door a couple of weeks ago, I’ve been free to turn to another project, SIPA, an internal effort to automate storage and retrieval of our group’s diverse intellectual property catalog. I’m acting as both the database architect and...
  • One Giant Leap for an Aspiring Geek: Congratulations, Jimmy May!

    Forty years ago this past Monday, I sat in rapt yet bleary-eyed amazement as a flickering black-and-white picture showed me that people could do anything if they aspire to a shared dream and set their minds to working together to achieve it. As an eight...
  • DWWTWT?: July 20-24

    Two interruptions to work this week: a trip to Ocala on Monday to a water park to celebrate my grandson Alex’s twelfth birthday (fun), and several trips to the DMV on Wednesday (less so): Commuting Options Selected since 12 June...
  • DWWTWT?: July 13-17

    Another week, another batch of telecommutes: Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations Telecommuted 225 Walked 218 Walked to the Bus...