Appears to have bricked my drive

if windows sees it then it should be detectable in the BIOS.

What does disk management say about the drive? Does it show any RAW unpartitioned space?

If it is still under warranty sandisk should be able to replace it if you cant get it working.