• Simplest method is to use STBuffer, the parameter passed is effectively the radius.

    😎

    DECLARE @circle GEOMETRY = geometry::Point(1.00,1.00,0).STBuffer(1);

    SELECT @circle