IF OBJECT_ID ( 'dbo.SpatialTable', 'U' ) IS NOT NULL 
DROP TABLE dbo.SpatialTable; 
GO
CREATE TABLE SpatialTable 
( 
id int IDENTITY (1,1), 
GeogCol1 geography, 
GeogCol2 AS GeogCol1.STAsText() 
); 
GO 
INSERT INTO SpatialTable 
(GeogCol1)
VALUES 
(geography::STGeomFromText('LINESTRING(47.656 -122.360, 47.656 -122.343)', 4326)); 

INSERT INTO SpatialTable 
(GeogCol1) 
VALUES 
(geography::STGeomFromText('POLYGON((47.653 -122.358, 47.649 -122.348, 
47.658 -122.348, 47.658 -122.358, 47.653 -122.358))', 4326)); 
GO

“With the release of Microsoft Office 2007 we can work with a much simpler, standard, XML format called Open XML which opens the door for many types of applications that cannot work via COM. What if you needed to build a scalable web service that processes many documents in high volume? What if you wanted to quickly read or write to these formats from a client application but wanted to have minimal dependencies on other applications? These types of programs do not want to require Microsoft Office be installed to run. The cool thing is you have the tools already with Visual Basic 2008. XML Literals are an easy way to manipulate any kind of XML, including Open XML”

Read Beth Massi's article

Another good example is Adding Image to Word document’s Header

Connect with up to 15 people in different locations and get your point across by showing them what's on your screen. Share, review, and update documents with multiple people in real time.A Windows Live ID (Passport, Hotmail, or MSN) is required to start sessions, but not to join sessions. New in version 1.0: we have added a web based join experience to make SharedView even easier.

Click Here to download

I am featured on MSDN’s channel 9 ( as an audience member ).  I attended a Tool Shed Episode at MS HQ in Tampa and they televised the sessions. 

It’s a good session introducing Windows Live Writer, Silverlight 3, Expression Blend 3, Expression Encoder, and Windows Mobile 6.5.

Watch Tool Shed Episode #4

Now there is no excuse.  I can post much more frequently now due to Live Writer. 

I have had no problems with the blog editor built into my blog.  I just had to live within it’s limitations.

Now I have Live Writer and can WYSIWYG to my blogs content.

To convert a string to a Guid

C#

Guid MyGuid = new Guid(stringValue);

VB

Dim MyGuid As Guid = New Guid(stringValue)

Since it is 2009 it is about time to get up speed with SQL 2008.  Here is the link to down load the fully functional express edition.

http://www.microsoft.com/express/sql/download/

If you are using SSMS 2008 to connectr to a 2005 database you may get the error "Failed to retrieve data for this request (Microsoft.SqlServer.Management.sdk.sfc)”.   SQL 2008 has features that 2005 doesn't have.  Some of those features are displayed as columns in the database browser. This will cause the error to occur.   This in turn will prevent you from being able to connect to your database. This is a known issue with Microsoft and occurs when either a database is in offline mode or when SQL Server Management Studio cannot correctly read one or more databases. Therefore, certain properties of a database cannot be retrieved. However there is a work around for this if you follow the instructions below:

1. Close the error message.
2. Press F7 to open the Object Explorer Details pane.
3. Right-click the column headers, and make sure that only the following columns are selected:
   *Name
   *Date Created
   *Policy Health
   *Owner
4. Right click the Databases node, and then click Refresh.

For more information the please view the Microsoft knowledge base.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;956179

Spatial data represents the shape and physical location of an object.  For example, the object can be a house, business, sub-division, or a county.  SSQL Server 2008 has two new data types GEOMETRY and GEOGRAPHY.  GEOMETRY works with flat objects. GEOGRAPHY considers the shape of the earth. 

GEOGRAPHY and GEOMETRY or CLR data types. Though to implement them you do not need to have CLR enabled on the SQL Server instance.  Microsoft has provided a long list of OGC methods.  These are methods that are part of the independent  Open Geospatial Consortium list of specifications.

Here is a PDF of my presentation SQLSaturday.pdf (806.55 kb)

If you are trying to reference a file that is generated with a handler and you are instead getting the file not found message.

The handle is working fine in Visual Studio but fails to work when deployed to a webserver.

Have your hoster perform the following

In IIS you right click on your App, go to properties, click Virtual Directory Tab, Configuration, Mapping Tab, Add, point the Executable to c:\windows\microsoft.net\framework\v2.0.50727\aspnet_isapi.dll and add the appropriate Extension ("georss") . I had to remove Script Engine and Verify that file exists check boxes and it worked.

this is where I found it. http://forums.asp.net/t/1408510.aspx