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)

June, 2006

  • Database Programming: Slaying The Time Zone Conversion Beast (or at least rendering it comatose)

    Schema and code for performing time zone conversions is discussed.
  • Database Programming: Optional Parameters Revisited

    Frequent visitors might recall a thread earlier in the spring regarding optional parameters to a stored procedure (the earlier posts are here , here , and here ). The question had basically boiled down to whether there was single-statement syntax available...
  • Epilogue: Not All Dreams Come True

    I just wanted to follow up yesterday's post on the Redmond Red Sox. Last night, the boys played in their district championship game against, of all teams, the North Bend Rainiers. They fought hard, but eight unearned runs in the fourth inning proved...
  • New Job, New (non-technical) Blog Feature

    A new, non-technically oriented feature of this blog is unveiled.
  • What Do You Get When You Put 600 Database Developers In A Room?

    Well, earlier this afternoon at least, you got SQL-Fest, which is believed to be the largest SQL Server training event ever held at Microsoft. It was my honor to act as master of ceremonies for this event. The focus of today's session was the new Database...
  • Database Programming: An Incrementally Better Mousetrap For Optional Parameters

    enderC points out that the syntax I proposed in last night's post on optional parameters can be made more readable thusly.. SELECT x FROM dbo . foo WHERE COALESCE ( y1 , @constant ) = COALESCE ( @p1 , y1 , @constant ) AND COALESCE ( y2 , ...
  • DWWTWT?: June 29

    There's a local saying in the Puget Sound area that the true start of summer is July 5th. For the first five years of my residency here, that old saw largely held true. This year, however, summer actually arrived pretty much on time. Another old saw says...
  • DWWTWT?: June 13

    Today, I finished up my office move. Thank goodness the laptop is still working, because my desktop boxes have no connectivity. Other than that minor glitch, the move went swimmingly. I needed to bring in some of my office items that I didn't want...
  • DWWTWT?: June 14

    Today, I not only had meetings in two separate Microsoft campuses (campii?), I also had another appointment and my younger son's sixth grade graduation ceremony. I so needed a car, so.. Walked: 0 Drove: 3 -wp
  • DWWTWT?: June 15

    More transition meetings, so no walking today.. Walked: 0 Drove: 4 -wp
  • DWWTWT?: June 16

    More transition meetings today, so I struck out the first week: Walked: 0 Drove: 5 Monday should be a different story. Have a great weekend! -wp
  • Happy Birthday, Mom

    Today would've been my mom's 79th birthday. I can't call her today. I wish I could. If you can, please, even though tomorrow is Father's Day, call your mother too. -wp
  • DWWTWT?: June 19

    Woot! No transition meetings and no off-site appointments that couldn't be handled via conference call. If you've been following this thread since its inception, your patience is hereby rewarded. Yep, I walked to work today! Thirty minutes door-to...
  • DWWTWT?: June 20

    The penultimate (scheduled) transistion meeting was held this morning across the hallway from my former office, so I of course needed to drive to that one. The good news is that it was finally nice enough to take the top down on my drive back to Main...
  • DWWTWT?: June 21

    No transition meetings on this, the longest day of the year.. a brilliant, sunny, 70ish degree day.. Who needs internal combustion on a day like this? Yep, another walking day! Walked: 2 Drove: 6 Twenty-eight minutes door-to-door inbound; twenty...
  • This Blog Is One Year Old!

    That's right, this humble enterprise, which began its on-line life with a questionable Admiral Stockdale pun, is exactly one year old as of the minute this post was published to the aggregators. This is the 59th post during that period, and 39 of those...
  • DWWTWT?: June 22

    Another beautiful day on the east side of Seattle for the first full day of summer.. temperatures in the high 70s, high cumulus clouds.. a perfect day to walk to work. Yep, two in a row, and a "win" for the week! Twenty-six minutes inbound; no outbound...
  • DWWTWT?: June 23

    Another beautiful day in the Pacific Northwest.. temperatures are near 80 degrees today, and expected to be in the 90s by Monday. This would've been a terrific day to self-propel, but as hinted in yesterday's post , I had a couple of meetings at my...
  • Field of Dreams: Better Living through Youth Baseball

    Databases are important. Databases pay my bills, and presumably those of many of you reading this blog. But there are more important things in life than databases. I’d like to tell you a short story of how faith and perseverance can move mountains. I...
  • DWWTWT?: June 26

    You folks in the midwest and on the eastern seaboard of the United States are probably used to the weather we're getting in Seattle, but for we denizens of the Pacfic Northwest, what we're dealing with here is a heat wave. When I left the house at...
  • DWWTWT?: June 27

    The heat wave currently besetting our area is beginning to abate somewhat; highs only in the mid-80s today. Even though it's a bit warm, I self-propelled today (twenty-seven minutes inbound; twenty-five minutes outbound) which makes the score.. Walked...
  • DWWTWT?: June 28

    Our heat wave has finally broken in the Seattle area. The change actually came on in the early evening last night. When I arrived at Kyle's All-Star practice game at 6, the temperature was about 91 degrees; when we left at 9, it was about 71. According...
  • Good Luck, Robert Scoble

    Late last night, a certain geek-focused corner of the blogosphere worked itself into something of froth over the pending departure from Microsoft of Robert Scoble , a platform evangelist and noted blogger. Robert has also been a part of the Channel...
  • Made In Express Contest Finalists Selected

    I first blogged on this contest way back in March.. well, the twelve finalists have been selected, and all of the work that's going on is pretty cool. Head on over to the Made In Express Contest website and check out the latest details. You're sure to...
  • DWWTWT?: June 30

    Another beautiful day, and a clean sweep for the week! This morning's insight is that it took me 1,029 steps to get from 51st Street to 40th Street (I've got to find some way to entertain myself on these walks), which suggest to me that it ought to be...