A process in which a spindle pole body is transported to, or maintained in, a specific location in the nuclear envelope. A spindle pole body is a type of microtubule organizing center found in fungal cells.