Add smoke tests to the sql-server repo

### Description

Check that the docker container built in the pipeline can run a backfill request.
Streaming is overkill since backfill uses the same code as streaming does.

### Possible solution

_No response_

### Alternatives

_No response_

### Context

_No response_