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)

March, 2009

  • Database Programming: The OPENROWSET Trick, Revisited

    One of the most popular posts in the history of this little corner of the Internets is one from August, 2005, which describes a method for accessing stored procedure output in a SELECT statement which I’ve come to refer to as “ the OPENROWSET trick ....
  • What I Know Now: Ward’s Epistle to the N00bs

    And I remember what she said to me How she swore that it never would end I remember how she held me, oh so tight Wish I didn't know now what I didn't know then Bob Seger, Against the Wind All you need is love Love is all you need John Lennon and Paul...
  • Paul S. Randal Posts Some Sobering Statistics

    Paul’s name should be familiar to denizens of the SQL Server blogosphere. Along with his wife, Kimberley Tripp , he’s a principal of SQL Skills (home also to the redoubtable Bob Beauchemin , with whom I share a birth date of significance to SQL Server...
  • TechNet White Paper on SQL Server Virtualization Now Available

    Great news today from Mark Pohto: the TechNet White Paper SQL Server Consolidation at Microsoft has just been posted. You can download a Microsoft Word document here , or read it on-line here . In addition to being one of the world’s leading experts...
  • Database Programming: NULL and (NOT) IN Don’t Mix Well

    Jens Suessmeyer is a Microsoft Consultant in Germany who frequently shares his useful techniques and insights both inside Microsoft and in the community at large.  In his latest post , he answers a colleague’s question with a simple yet thorough...
  • Microsoft Hosting Silverlight 2 Developer Contest with $5000 Prize

    This week I’m hoping to get through my backlog of postable material. It makes sense to start with the time-sensitive stuff.. Microsoft is asking game developers to bring their best ideas to light using Silverlight 2, a flexible new platform for delivering...
  • As Spring Approaches, a SQL Blogger’s Thoughts Turn to Daylight and Baseball

    As we progress towards the Ides of March, one of my best friends-who-I’ve-never-met, Jimmy May , notes our annual transition to Daylight Savings Time , in a post he generously concludes with a link to one of this very blog’s oldies but goodies . In...
  • DWWTWT?: March 23-27

    Spent the week dealing with what’s been diagnosed as an intestinal infection. Not recommended and very limiting to productivity, which was nonexistent this week : Commuting Options Selected since 12 June 2006 Mode of Transport...
  • Better Late Than Never: Disaster Recovery Webcast This Morning

    I’m a little late to the party here, but this is pretty apropos of some of our discussions here lately. Brent Ozar is hosting a Disaster Recovery Horror Stories webcast this morning at 11a ET/8a PT.  You can read the full details here . I don’t think...
  • DWWTWT?: March 16-20

    Another full week of telecommuting, this one culminating with a celebration of the vernal equinox : Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations Telecommuted ...
  • DWWTWT?: March 30-31

    The month and quarter end with a return to productivity from home after last week’s excitement : Commuting Options Selected since 12 June 2006 Mode of Transport Number of Invocations Telecommuted 164...
  • IE8 is Here!

    Microsoft’s newest web browser, Internet Explorer 8, was released about three hours ago and is now available for download here . If you want it, go get it! -wp this copyrighted material was originally posted at http://blogs.technet.com/wardpond .  ...
  • DWWTWT?: March 9-13

    After last week’s brief foray into internal combustion, this week marked a return to normal (or at least what passes for normal in these parts) as I returned to a full week of telecommuting : Commuting Options Selected since...
  • DWWTWT?: March 2-6

    Here’s another seasonal query for you : select datediff ( dd , '10/20/2008' , '3/3/2009' ) ----------- 134 The significance of the query was alluded to in last week’s commuting post. This past Tuesday I had to drive to Tampa for a laptop repair...