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, 2007

  • SQL Server 2005 SP2 Maintenance Plans

    Users of SQL Server 2005 maintenance plans should be aware of a change in SP2 that affects existing cleanup tasks until they're updated using the SP2 tools. Full details may be found here . I'll keep you posted on this issue.. -wp
  • RIP John Backus

    Today comes the unhappy news of the passing of John Backus , creator of FORTRAN, the first high-level computer language. T-SQL (and indeed all the other dialects we use to code computers today, from Java to C# to Ada) all rose from FORTRAN's seed....
  • Books OnLine Updated For SP2, Too

    I just found out today that Books OnLine has also been updated recently. The current (February, 2007) version is available for download here . There are several significant changes in this version, including documentation for at least one new showplan...
  • DWWTWT?: March 1

    The month starts with an "empty calendar" day, perfect for telecommuting: Telecommuted: 14 Walked: 78 Walked to the Bus: 13 Drove: 44 Did Not Compete: 40 More tomorrow...
  • DWWTWT?: March 12

    A rainy morning combined with post-work baseball practice for my boys led to use of Gale's van today : Telecommuted: 14 Walked: 78 Walked to the Bus: 13 Drove: 51 Did Not Compete...
  • New To SSIS? Come Take A Guided Tour..

    One of the more interesting and perhaps challenging aspects of a SQL Server 2000 to SQL Server 2005 upgrade is the migration from DTS to SSIS for ETL (Extract-Transform-Load) activities. SSIS isn't an upgrade of DTS, but is in fact an entirely new, and...
  • DWWTWT?: March 19-20

    The week's underway with two driving days due to weather and after-work commitments : Telecommuted: 14 Walked: 78 Walked to the Bus: 13 Drove: 55 Did Not Compete: 42 ...
  • DWWTWT?: March 21-23

    Weather and after-work commitments led to three days of driving : Telecommuted: 14 Walked: 78 Walked to the Bus: 13 Drove: 58 Did Not Compete: 42 Have a great weekend...
  • Updated SQL Server 2005 SP2 Available For Download

    A fix for the maintenance plan issue in SQL Server 2005 SP2 first discussed here is now available for download here . Kudos to the SQL team for publishing this fix so quickly. If you're using SP2, I suggest applying this update ASAP, especially if...
  • DWWTWT?: March 7

    All three of the boys in our house had baseball practices scheduled this afternoon, which led to employment of the van on my part: Telecommuted: 14 Walked: 78 Walked to the Bus: 13 Drove:...
  • DWWTWT?: March 26

    Today the cars got a rest as I telecommuted : Telecommuted: 15 Walked: 78 Walked to the Bus: 13 Drove: 58 Did Not Compete: 42 Hope your week is off to a good start...
  • DWWTWT?: March 6

    This morning was a tad dreary, which was a shame, because the afternoon was in the mid 60s, and would've been ideal walking weather. The morning gloom led to employment of the MG : Telecommuted: 14 Walked: 78 ...
  • DWWTWT?: March 9

    Today I needed to run to Seattle at lunch to pick up some xray film for my doctor's appointment next week. Gale not only lent me the van again today, she joined me on the trip, which was pretty neat. This brings us to a half-a-hundred drives to work...
  • DWWTWT: March 27-30

    The cars rested all week as I telecommuted : Telecommuted: 19 Walked: 78 Walked to the Bus: 13 Drove: 58 Did Not Compete: 42 That makes the totals for the month.. ...
  • DWWTWT?: March 5

    The week commenced with a beautiful day, which would've been perfect for walking to work if I hadn't had to be at my sons' baseball practice at 4:30. This led to employment of the MG : Telecommuted: 14 Walked: 78...
  • DWWTWT?: March 13-16

    Playing a little catch-up today; Tuesday and Wednesday were driving days and Thursday and Friday were non-competitive : Telecommuted: 14 Walked: 78 Walked to the Bus: 13 Drove: 53 ...
  • DWWTWT?: March 2

    The week draws to a close with a steady rain. I'm still not up to walking through such weather, so it was a rainy MG day: Telecommuted: 14 Walked: 78 Walked to the Bus: 13 Drove: 45...
  • DWWTWT?: March 8

    A rainy day combined with a low energy level made for an MG day: Telecommuted: 14 Walked: 78 Walked to the Bus: 13 Drove: 49 Did Not Compete: 40 The weather forecast...