If you are looking for a really simple way to move datasets from ArcGIS Desktop to Microsoft SQL Server 2008, Vish has you covered. ArcToSQL2008 is an ArcCatalog command to export FeatureClasses to SQL Server 2008.
Much like Fletch deams of being a Laker, we dream of direct connect to SQL Server 2008 from ArcGIS.