SQL Endpoint Secrets you need to know

Recently I had a severe problem with SQL endpoints and I was required to build a quick workaround for this....