SQL backend and File Store pitfalls

I just returned from a job that first failed monumentally, but that I was able to recover from through some hard research. Better share it for others to avoid.