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)

September, 2008

  • Deprecation of "Old Style" JOIN Syntax: Only A Partial Thing

    UPDATE (15 September 2008): per Adam Machanic's comment , this syntax is in fact deprecated in compatibility mode 9.0 databases (e.g. SQL Server 2005). Thanks, Adam! I learned something interesting recently (well, not too recently; I'll be going through...
  • La Font de Canaletes Works Its Magic

    La Font de Canaletes is a public fountain near the head of La Rambla de Catalunya in what it currently the center of Barcelona, Spain: When I was in Barcelona last November, I reported that I "drank generously from the fountain, hopefully sealing...
  • Don't Like My English? Try Me In Portuguese (and Eleven Other Languages) With Windows Live Translator!

    This is the coolest thing I've seen in quite awhile.. Microsoft Server and Tools (the group that brings you, among others, the MSDN , TechNet , Expression , and CodePlex sites) is leveraging the latest translation technology from Windows Live and Microsoft...
  • Database Programming: Sharing a Temp Table Among Processes

    One of the great things about my involvement with the SQL Ranger community is that I occasionally hear from past Candidates asking for help with issues in the field. So it was earlier this week when Binh Cao, an MCS Senior Consultant II based in San Diego...
  • Nullity: The Gift (of Nothingness) That Keeps On Giving

    Almost three years after the post was originally published in October of 2005, Mark Johansen, author of A Sane Approach to Database Design (an approach I trust it's clear I favor) has left a terrific comment on the Do Not Fear NULLs article which is worthy...
  • Pond's Seventh Law Inspires a Question: Elegance Serving Randomness

    Marc left a great question on a Pond's Laws post from July of 2006 : Hi, I have a flashcard system that randomly pulls a word from the database. I also have a testing module that allows a user to test him or her self on words. For each word the...
  • One Little Thing I Missed..

    ..while we were preparing for our move.. The company chose my 48th birthday (two days before the movers descended on us) as the RTM date for SQL Server 2008.  There's a full download available here (subscription required); the free Express version...
  • Victory! Broadband Connectivity from my Home Office in the Boondocks

    Now the story can be told..  the last couple weeks have not been pretty around here, connectivity wise.  Think of a duck..  paddling like the dickens underwater to keep things going while looking calm and serene from above. Note that if...
  • Springboard Series Virtual Roundtable Tomorrow!

    A note passed through my inbox this morning that may be of interest.. Tomorrow, September 24, at 9am PST, Mark Russinovich will lead a virtual roundtable exploring top of mind performance issues, common misconfigurations, and tips on how to fix them...
  • A Month and a Day in Florida

    We are 32 days in Florida as of today, and so far it's been a marvelous experience. All three boys are thriving in school. I haven't seen so many A's since my mother's book club read The Scarlet Letter. * Good on you, boys! Connectivity in the home...
  • A One-Stop Post for SQL Server Upgrade Considerations

    Mahesh passed along a wonderful bit of research he completed to aid in a platform upgrade, and I'd like to share it here. Here is a series of links to identify discontinued and deprecated features and behavior changes in SQL Server: Discontinued...
  • Mobility, Defined: Greetings From MCO

    MCO, for the groundlocked, is the FAA Airport Code for the airport in Orlando, Florida.  The same broadband card that speaks to the Yagi antenna back home has found broadband-level connectivity in MCO's Terminal A.  It would therefore appear...
  • A Note From Binh's Customer

    Binh Cao's customer left a comment on yesterday's post on global temp tables. Here's the money quote: My research confirms that global temp table does allow the plan to be shared among processes. However now we are forced to deal with the problem...
  • DWWTWT?: September 1-5

    Monday was non-competitive; I telecommuted from my home office in central Florida for the remainder of the week: Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations Telecommuted...
  • DWWTWT?: September 15-19

    This week was 100% telecommuting: Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations Telecommuted 61 Walked 204 Walked to the Bus 17...
  • DWWTWT?: September 29-30

    I'm back home from Redmond and enjoying my "normal" three-room "commute" to my home office: Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations Telecommuted 63 ...
  • DWWTWT?: September 22-26

    This was my first week back in Redmond since moving to Florida. I "celebrated" by walking to work all week: Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations Telecommuted...
  • DWWTWT?: September 8-12

    Monday through Thursday I telecommuted from my home office; Friday I drove to the MSFT sales office in Tampa to pick up and configure a new computer: Commuting Options Selected since 12 June 2006 Mode of Transport Number...