Best practice to get geometry column from MS SQL DB

Hi there

I’m looking for best practices for reading geometry data from MS SQL DB.

I connected with JDBC, and the geometry column was read in BLOB format. I can’t figure out how to transform it into a geometry column.

There is properly a smart and easy way to do it.

Best regards Oskar