I paste this into the command line every time I do a clean MOSS install.

@set PATH=C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN;%PATH%

So that in the future, I can access STSADM much easier.

I'm constantly amazed when I check my blog stats at how popular an old article I wrote on using Object tags as a replacement for an Iframe has become.  This is obviously an area that people are having trouble finding information, so here is a good starting place to find your solution:

First, my original posting - Alternative to < iframe />

And here are two examples, courtesy of W3C, on IFrame versus Object tag:

The basic IFrame example:

  <IFRAME src="foo.html" width=400 height=500>
  that unfortunately your user agent doesn't support. Alternatively you
  can get the related document <a href="foo.html">here</a>.
  </IFRAME>

Becomes:

  <OBJECT data="foo.html" width=400 height=500>
  that unfortunately your user agent doesn't support. Alternatively you
  can get the related document <a href="foo.html">here</a>.
  </OBJECT>

And the more complex example:

  <IFRAME src="foo.html" width=400 height=500 scrolling=auto
     frameborder=1>
  that unfortunately your user agent doesn't support. Alternatively you
  can get the related document <a href="foo.html">here</a>.
  </IFRAME>

Becomes:

<OBJECT src="foo.html" width=400 height=500>
  <PARAME name=scrolling value=auto>
  <PARAME name=frameborder value=1>
  that unfortunately your user agent doesn't support. Alternatively you
  can get the related document <a href="foo.html">here</a>.
  </OBJECT>

You can visit the W3 Frames page, and find IFRAME vs OBJECT about 2/3rds of the way down the document.  (It's slightly slanted in favor of IFrame and doesn't explain a lot of the security issues around using IFrame in IE.)

http://www.w3.org/TR/WD-frames-970331

A common ask, using MOSS Workflow and InfoPath 2007 with a form library to handle basic business needs such as Travel Request forms.

This isn't anything earth-shaking or new, but it is the really valuable core functionality of MOSS that is fantastic to share with customers.

Keep it on hand for passing off to your clients and their power users that are trying to make SharePoint more valuable for their company:

http://msdn2.microsoft.com/en-us/library/bb267332.aspx

It's also a great 5 minute demo that goes a long way to selling your client on a MOSS install.  (Which is the situation that reminded me to drop a link on the blog.)

I'm working with an EAV schema (Open schema) and wanted to have a full pivot of my data available in a view, even after new fields were added to the source.

I found a clever way to dynamically generate the ID list (and the field list as well) so that you can generate the SQL dynamically.

This is essentially an inline way to do a string concatenation aggregate using the XML functionality in SQL 2005.

Assuming you have a table 'Attribute' with a field 'AttributeID', this is an easy way to create a delimited list (with [], ala pivot style) to generate the SQL for the pivot.  Use the same idea for your field list.

DECLARE @IDList VARCHAR(MAX)

SELECT @IDList = STUFF((SELECT ', [' + AttributeID + ']' AS [text()]
FROM (SELECT DISTINCT CONVERT(VARCHAR, AttributeID) as AttributeID
        FROM Attribute) Y 
        ORDER BY AttributeID
        FOR XML PATH('')), 1, 1, '')

For performance sake, I don't generate the pivot statement live, it is instead updated from a stored procedure when appropriate through a dynamically generated alter view.  I won't bore you with the dynamic sql portion, as I'm sure you already know how to do that.

I see this problem fairly often... You visit the IIS Manager and the left pane is empty, it was unable to connect to localhost.  Further attempts to connect from another machine to configure IIS will also fail.

It appears to be caused by some problem/leak/bug in some of the SharePoint windows services.

A restart of the search and timer services (sometimes I follow with an iisreset) always seems to fix the problem.