remove local mssql override, simplify logic

[rwnx]

• ran black on all files
• simplified some of the if logic

[rwnx]

TODO:

• [x] changelog entry
• [x] fix default server (local)