first go at implementing a SQL Server transport
refactored slightly