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)

January, 2009

  • SINGLE_BLOB Size Limit: An Affirmation for Bert

    Bert left a comment on this post pointing out a limitation of “the other OPENROWSET trick” (the one which loads an XML file into a single XML column): I tried this, but had an error because my XML file is 6gB. The SINGLE_BLOB seems to be limited to 2gB...
  • Yet Another Holiday Query: Adam Wants to Play

    If this keeps up, I might need to define a tag for this stuff.. Our old friend Adam Machanic , perhaps inspired by the work of Dirk and Madhivanan , left a comment with his own contribution to the seasonal query pool. He was sufficiently concerned that...
  • Windows 7 Beta Available for Download This Friday, January 9

    Exciting news over on The Windows Blog : the first and only release of the Windows 7 Beta will be available for download here this Friday, January 9. The full details are here , but I'll share some highlights: The beta will only be available for...
  • Another Seasonal Query, Slightly Late..

    On the heels of Christmas Eve’s seasonal query from Dirk Gubbels comes this gem from Madhivanan (with a tip of the hat to Dave Edwards’ link in Log Buffer #129 ). set nocount on select space ( 7 - len ( replicate ( char ( 42 ), no )))+ replicate...
  • Windows 7 Beta Downloads Extended Through February 10

    There’s a new post on The Windows Blog indicating that general availability of the Windows 7 Beta download will end on February 10th.  Here’s the calendar: The shutdown of general availability for the Windows 7 Beta will occur in 3 phases over the...
  • Issue 18 of The Architecture Journal Now Available

    I found out recently that Microsoft publishes a quarterly called The Architecture Journal .  As its website says, its articles are designed to offer perspective, share knowledge, and help you learn the discipline and pursue the art of IT architecture...
  • The Microsoft Certified Master Programs Have Joined the Blogosphere

    If you’re looking for the best high-end training in Microsoft technologies – OCS, Exchange, SharePoint, SQL Server, or Windows Directory – the Microsoft Certified Masters program is where you want to be. The program’s website has always been a great...
  • Cumulative Update Package 3 for SQL Server 2008 Released

    I was two weeks late with my announcement of CU #2 ; this announcement is coming to you on the day of release. Sometimes it’s better to be lucky than good.. Cumulative Update Package 3 for SQL Server 2008 has been released and is available for download...
  • A Moment of Silence, Please

    Per’s already been busy on his new blog .. Up until a few months ago, we had someone on our team who did the Master and MCA marketing for the last two years, and did a great job with it. Today, her mother passed away after some longer term health struggles...
  • Get Well, Steve Jobs

    Sure, he’s a competitor, but some things trump business . Sad news about Steve Jobs’ health today, as what was described last week as a “relatively simple and straightforward” hormone imbalance is now “more complex than.. originally thought.” I know...
  • DWWTWT?: January 1-2

    The New Year begins as the old year ended, with the rest of the week remains non-competitive for the holiday: Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations Telecommuted...
  • DWWTWT?: January 19-23

    Another week of telecommuting from a frosty central Florida: Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations Telecommuted 123 Walked 218 ...
  • DWWTWT?: January 26-30

    Another week of telecommuting from a central Florida much less frosty than it was last week : Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations Telecommuted 128...
  • DWWTWT?: January 5-9

    I spent Monday and Tuesday of the first full week of 2009 extended my holiday break after finding out my boys were out of school two days longer than I thought. From Wednesday on, I was back to work in my home office here in the woods: ...
  • DWWTWT?: January 12-16

    For the first time in almost a month (you’ve got to love the holidaze), I spent a full five days at work in my home office: Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations ...