Unit testing for server-side assets

[David Schwartz 427]

I can't recall ever seeing any discussions about unit testing of server-side assets, like views, stored procs, and functions.

 

Does anybody do it?

[ByteJuggler 45]

We do various types of tests (which would categorise I suppose amongst others as smoke tests, integration tests, golden master tests and regression tests) which do verify behaviours by back-end/server side assets like views and stored procedures.  We do also directly exercise some server side assets directly in some of the automated tests for behaviour and outputs, we probably don't do nearly enough of this.  (We do test bootstrap the entire back-end from scratch.)   There are SQL based unit testing frameworks/tools/approaches, we don't yet do this, but we probably should.  (https://tsqlt.org/ for example.)