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)

November, 2008

  • Travelogue: Three Hours in Barcelona

    A photo-laden documentation of an afternoon out and about in a classic European city. No technical content, but some great pictures, and even a multi-lingual pun!
  • Microsoft Assessment and Planning Toolkit 3.2 Now Available

    The Microsoft Assessment and Planning (MAP) Toolkit 3.2 makes it easier for customers and partners like you to quickly identify what servers, workstations, and network devices are in your IT environment. MAP also provides specific and actionable IT proposals...
  • Thank You, Greg Winston

    If you live long enough and lead a certain sort of life, you end up writing a lot of correspondence that you don’t really want to write when you start writing it. If you’re lucky enough, more of those missives relate to happy things happening in peoples...
  • My Favorite Pieces of Feedback for “SQL Tricks” So Far

    Microsoft is constantly looking for ways to improve the experience of both presenters and delegates at TechEd. Since last year, the feedback system has been enhanced to the point where I’m now able to see my attendees' evaluations, including comments...
  • Database Versioning Demonstration Uploaded

    Fulfilling my promise at TechEd , I’ve finally completed a self-directed demonstration of the database versioning techniques I first presented at last year’s TechEd and which was alluded to during this year’s TechEd SQL Tricks presentations. It’s published...
  • Hello From Barcelona

    Greetings from the Speakers’ Lounge at the Centre Convencions Internacional Barcelona , where TechEd EMEA 2008 Developers is in full swing. Over 3,000 developers from all over the region have gathered to share and learn best practices for the care and...
  • Scripts for “SQL Tricks: Insights from Microsoft IT”

    UPDATED 22 November 2008 with Code Gallery URL. A ZIP file of the scripts from the SQL Tricks: Insights from Microsoft IT presentation I’m giving in Barcelona this week is available for download here . The tricks will be familiar to long-time denizens...
  • TechEd Indexing Presentation Now Available on MSDN Code Gallery

    Well, it took me long enough to figure out how to get this done, didn’t it?  The good news is that I have a brand new tool in my arsenal..  the bad news is that I burned a bunch of precious rural bandwidth trying to upload this material to inappropriate...
  • A Note to the Attendees of Today’s “SQL Tricks” Session

    During today’s session, many of you were sufficiently interested in the “ versioning of database components ” trick that I offered to post the deck from last year’s session here on the blog. Well, I’ve looked at the deck and it’s frankly a little thin...
  • My Latest Reason to be Thankful

    In keeping with the spirit of the season, I thought I’d introduce you to my latest reason to be thankful. As if a wonderful family and an incredible career weren’t enough.. Ever since this city boy relocated to rural Central Florida, his farm girl...
  • What’s The One Thing A Technical Presenter Doesn’t Need?

    A case of laryngitis. Yup. As I mentioned yesterday , my voice got a little flaky towards the end of yesterday’s SQL Tricks presentation here at TechEd EMEA 2008 Developers . By the time I got back to the hotel to call Gale and the family, pretty much...
  • Back In-Country: Greetings From JFK

    Greetings from the Delta terminal at JFK Airport in beautiful South Ozone Park, NY, where I’m currently laying over on my way back to Orlando.  As I was getting up at 6am Barcelona time, my wife was watching Friday night’s episode of David Letterman...
  • SQL Server 2005 SP2 News from Paul Randal

    Thanks to Mohammed Sharaf, who passes along this post from Paul Randal’s blog regarding a corruption issue people are running into in SQL Server 2005 SP2.  Here’s the money quote: The situation is this: a table with a non-unique clustered index ...
  • Cross-Database Connectivity: An Answer For Kyle

    Kyle Schoonover, a former colleague in MSIT, posed the following questions in a comment on October’s cross-version database attachments post : Ward, I'm currently working in MySQL and writing conversion scripts to convert a MySQL database to a SQL 2005...
  • DWWTWT?: November 24-28

    UPDATED 04 Dec. 2008 with month-end statistics. It’s a short work week here in Central Florida. Monday and Tuesday I had my nose to the grindstone, while I’ll spend the rest of the week enjoying my family: Commuting Options...
  • DWWTWT?: November 17-21

    What a life! After a week of being footloose and fancy-free in one of the most cosmopolitan cities in Europe, I was back home in Central Florida, enjoying the telecommute: Commuting Options Selected since 12 June 2006 ...
  • DWWTWT?: November 10-14

    As you’re doubtless aware from reading the public areas of the blog, this week I was footloose (and voiceless) in Barcelona. The trip overseas involved two plane changes while the trip home involved one, which explains the odd number of airline segments...
  • DWWTWT?: November 3-7

    The week saw steady telecommuting in preparation for next week’s trip to Barcelona for TechEd EMEA Developers 2008: Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations Telecommuted...