A man has appeared in court charged with the murder of a mother in the Scottish Borders.