publicclass HtcAnywhereHandler
: IHttpHandler { public HtcAnywhereHandler()
{ } publicbool IsReusable
{ get { returnfalse;
} } publicvoid ProcessRequest(HttpContext
context) { FileInfo fi =new FileInfo(context.Server.MapPath("~/htc/"+ context.Request.Url.Segments[context.Request.Url.Segments.Length - 1])); if (fi.Exists
&& fi.Extension.Equals(".htc",
System.StringComparison.InvariantCultureIgnoreCase)) { context.Response.ContentType ="text/x-component";
context.Response.BinaryWrite(File.ReadAllBytes(fi.FullName)); } else context.Response.StatusCode = 404;
} }

• Several weeks before - heard about the RoadTrip on a DotNetRocks episode. Went to the site mentioned, but there wasn't a sign-up form yet. Set an alarm on my phone to remind me to check the site daily.
• A couple of weeks before - The form was there. I filled it in. I then told my wife about it and said that there was a insignificant chance that I might win that. I then realized that this was going to conflict with SqlSaturday in Huntington Beach.
• Monday 4/19 - canceled plans to go to SqlSaturday.
• Tuesday 4/20 - Beta 2 of a certain smart phone OS broke camera support. Boo. Did take a pocket camera with, but didn't take many shots with it.
  
• Friday 4/23 - went to the DotNetRocks RoadTrip event in Phoenix. Got there right at 6 PM. Chatted with Richard and mentioned how cool I thought the RoadTrip ride-along was. He said, "You should go." - They were going to pick me up on Saturday. I texted my wife. I found it rather hard to concentrate during the event.
• Saturday 4/24 - Carl and Richard drove the RV to my house, around 11 am - crazy - got onboard and away we went. Bound for Houston, some 1100 miles away. They opted for driving straight through. Chatted their ears off probably. We jury-rigged the PA speaker to a MP3 player so we could listen to old episodes of Mondays on the drive.
  
  
• Sunday 4/25 - Pulled in to Houston around 9 am. Around 20 hours with the time difference. Got a little sleep in the RV and a little more at the hotel after going for a walk. Later Richard, Tom (driver) and I met up with Zain Naboulsi (MS Dev Evangelist) for dinner and had some spirited discussions over a great dinner. Then just hung out with Richard for a couple of hours chatting about techie nerdy stuff.
• Monday 4/26 - Met up with Dustin Campbell and had really great sushi with everyone. Totally geeked out with Dustin about languages and Visual Studio. Then we went to the MS office, setup and they did the show. It was kinda neat to see them do a second show. Did a video interview with Todd of Telerik about the experience and we discussed some of the cool stuff in SiteFinity 4.0 CTP. Then we went back to the hotel. Sadly, the experience was over. Got about 2 hours of sleep then took a cab to IAH airport and got on my early flight back to PHX.
  
  

Wanted a generic way to pass a DataTable as a parameter to SqlCommand as a TVP (Table Value Parameter). It automatically creates the, IMHO, superfluous User-Defined Table Types. Here's what I have so far:

          
            
              <Runtime.CompilerServices.Extension()>
_ Sub AddTableParameter(ByVal cmd As SqlCommand, ByVal n AsString, ByVal dt As DataTable) Static typeXlat As Dictionary(Of
System.Type, SqlDbType) If typeXlat IsNothingThen typeXlat =New Dictionary(Of
System.Type, SqlDbType) typeXlat.Add(GetType(Int64),
SqlDbType.BigInt) typeXlat.Add(GetType(Int32),
SqlDbType.Int)
typeXlat.Add(GetType(Int16),
SqlDbType.SmallInt) typeXlat.Add(GetType(Byte),
SqlDbType.TinyInt) typeXlat.Add(GetType(SByte),
SqlDbType.TinyInt) typeXlat.Add(GetType(Boolean),
SqlDbType.Bit) typeXlat.Add(GetType(String),
SqlDbType.VarChar) typeXlat.Add(GetType(Byte()),
SqlDbType.VarBinary) typeXlat.Add(GetType(DateTime),
SqlDbType.DateTime) typeXlat.Add(GetType(DateTimeOffset),
SqlDbType.DateTimeOffset) typeXlat.Add(GetType(Char),
SqlDbType.Char)
typeXlat.Add(GetType(Single),
SqlDbType.Real) typeXlat.Add(GetType(Double),
SqlDbType.Float) typeXlat.Add(GetType(Decimal),
SqlDbType.Decimal)
typeXlat.Add(GetType(Guid),
SqlDbType.UniqueIdentifier) typeXlat.Add(GetType(Xml.XmlDocument),
SqlDbType.Xml) EndIf'assembly
the typename and specDim tabletypedef AsNew List(Of String) Dim parm AsNew SqlParameter(n,
SqlDbType.Structured) parm.Value = dt ForEach c As DataColumn In dt.Columns Dim s As SqlDbType = SqlDbType.Variant If typeXlat.ContainsKey(c.DataType) Then s = typeXlat(c.DataType)
tabletypedef.Add(c.ColumnName +"
"+ s.ToString) NextDim tabledef =String.Join(",",
tabletypedef.ToArray) Dimtypename="autotype_"+ tabledef
parm.TypeName="["+typename+"]"'create
the type if needed Using cmd2 =New SqlCommand("select
count(*) from sys.types where is_table_type=1 and name='"+typename+"'",
cmd.Connection) If cmd2.ExecuteScalar() = 0 Then cmd2.CommandText ="create
type ["+typename+"]
as table("+ tabledef +")" cmd2.ExecuteNonQuery() EndIfEnd Using 'add
the parm referencing the typename cmd.Parameters.Add(parm) EndSub
            
            

            
            
          
        

1. Make a virt using Windows 2003 R2 w/ SP2
2. Add web server role
   
3. Windows Update
4. Install WSS3 w/ SP2 which gets me the Window Internal Database (not limited to 4GB) for SharePoint content.
5. Let the Configuration Wizard do its magic.
6. Install Search Server 2008 Express
7. Let the Configuration Wizard do its magic again but don't let it replace your WSS3 site - tell it to make a new search site on a random port.
8. Turn on the "Office SharePoint Server Search Web Parts" site collection feature on the WSS3 site
9. Install SharePoint Designer 2007
10. Open the Search Server site's /results.aspx page
11. Save as to WSS3 site as /results.aspx (with Don't save for the images/css junk)
12. Add a Search Box webpart to the /default.aspx page of your wss3 site setting the "Target search results page URL" to /result.aspx
    

EXEC sys.sp_configure N'show advanced options', N'1'  RECONFIGURE WITH OVERRIDE
GO
EXEC sys.sp_configure N'max server memory (MB)', N'256' -- <== mod this value to around 1/4 of installed memory - 1024 max
GO
RECONFIGURE WITH OVERRIDE
GO
EXEC sys.sp_configure N'show advanced options', N'0'  RECONFIGURE WITH OVERRIDE
GO

sqlcmd -S localhost\MICROSOFT##SSEE -E -i sqlconfig.txt
sqlcmd -S localhost\OFFICESERVERS -E -i sqlconfig.txt

If Me.enumfield.Equals(value) <> true Then

If Not Object.Equals(Me.enumfield ,Value) Then

If boolean_resultsThen

If Notboolean_resultsThen

<System.Runtime.Serialization.DataMemberAttribute()>
_
PublicProperty CompareOperator() As SearchService.CompareOperator
Get
ReturnMe.CompareOperatorField
EndGet
Set
If (Me.CompareOperatorField.Equals(value)
<> true) Then
Me.CompareOperatorField = value
Me.RaisePropertyChanged("CompareOperator")
EndIf
EndSet
EndProperty

<System.Runtime.Serialization.DataMemberAttribute()>
_
PublicProperty CompareOperator() As SearchService.CompareOperator
Get
ReturnMe.CompareOperatorField
EndGet
Set
If
Not Object.Equals(Me.CompareOperatorField,value)Then
Me.CompareOperatorField = value
Me.RaisePropertyChanged("CompareOperator")
EndIf
EndSet
EndProperty