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)

April, 2009

  • Changing the Default Collation When No User Databases are Present

    UPDATED 13 April 2009: The SAPWD parameter sets the sa password; use BLANKSAPWD if you don’t wish to set one.  I’ve updated the seventh paragraph below accordingly. One of our responsibilities in the ITOE IP Architects group (the artists formerly...
  • So.. *This* Is How Twitter Gets People Into Trouble..

    Consider this post a parable about what can happen if you let Twitter into your life.. I spent part of my day researching a particular capability of the TechSmith Camtasia Studio software my colleague Venkata Raj Pochiraju has been using to record readiness...
  • R.I.P. Jong Ku Kim

    Sad news today that Jong Ku Kim, a Premier Field Engineer with Microsoft Services, on Tuesday lost an 18-month battle with cancer at the age of 39.  He leaves behind a wife, a seven year-old, son, family, friends, and a globe-spanning cadre of colleagues...
  • Yes, It’s True – I’m A Judge in SQL Fool’s RAP Contest

    I’ll say one thing for Michelle Ufford, the SQL Fool : she’s not one to leave a good idea on the table, unseized. Yesterday she and I indulged in a little bit of silliness after I made an innocent tweet about some Risk Assessment Plan work I was doing...
  • Why I Didn’t Write an April Fool’s Post

    I meant to.  I really did. But I got sick last week , and my energy level has been slow enough to come back that my focus was entirely elsewhere until about six last night. I panicked.  I gave fleeting consideration to throwing something hasty...
  • Chris Shaw’s SQL Quiz 4

    UPDATED 25 April 2009 to fix the link to Jimmy’s blog As a consequence of my recent ascension to Twitterato-hood (follow me @sqltwit), I’ve made several new SQL friends over the last couple of weeks.  One of those is Jorge Segarra (a/k/a @SQLChicken...
  • Paul Randal Explains a Performance Bug

    Paul Randal has another must-read post regarding a performance bug which surfaces in earlier versions of SQL Server 2005 and SQL Server 2008 when NOLOCK scans are executed against tables with off-row LOB data.  Both the causal scenario and the nature...
  • I’m Not Sure This is Progress..

    .. but after some serious goading from Jimmy May and Michelle Ufford , I’ve taken the plunge and become a Twitterato. If you’d care to join my community of followers (do I sound like a cultist yet?), you can do so here .  If you’re so inclined, you...
  • Paul S. Randal Has Another Important Survey

    Paul ’s latest survey is a deep dive into the physical layout of your databases. It’s the same basic question, for four different size categories of database: what’s the physical layout of your database, and why? Paul will publish the results on 24...
  • Cumulative Update Package 1 For SQL Server 2008 Service Pack 1 is Available for Download

    Jens , the newly minted MCM:Database (congratulations, Jens!) had this last week .. For those waiting to update their SQL Server 2008 RTM CU4 instances to SP1 without losing their CU4 fixes, the new Cumulative Update Package 1 for SQL Server 2008 Service...
  • SQL Server 2008 Service Pack 1 Now Available for Download

    SQL Server 2008 Service Pack 1 was released earlier this week and is available for download here . There are details on the Data Platform Insider blog, and Jimmy May is an enthusiastic proponent of its supportability and stability enhancements. ...
  • Earth Day Linkfest

    TechNet magazine has released a web-only “Green IT” edition as a companion piece to Mark Pohto’s recent white paper and article in The Architecture Journal. The issue features a valuable collection of new and archived articles on energy efficient computing...
  • DWWTWT?: April 13-17

    Another full week of telecommuting from beautiful central Florida : Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations Telecommuted 178 Walked 218 ...
  • DWWTWT?: April 6-10

    A full week of telecommuting as my health continues to improve :   Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations Telecommuted 173 Walked 218 Walked to the Bus 17 Drove 192 None (did not compete) 143 Other Transportation...
  • DWWTWT?: April 20-24

    More telecommuting from sunny Florida (although today was a bit discombobulated due to Gale’s sinus surgery) : Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations Telecommuted...
  • DWWTWT?: April 27-30

    The month ends with more telecommuting from sunny Florida: Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations Telecommuted 187 Walked 218 Walked...
  • DWWTWT?: April 1-3

    The new month and quarter begin as the old ones ended : with a continued return to productivity from home after last week’s excitement : Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations...