The size of your organisation/company is also very relevant as mentioned above. When in a small organisation, whatever role you have you will always have to wear many hats.
Our organisation traditionally had two SQL elements, one dealt with setting up databases, permissions, managing the introduction of thrid party system databases into our environment, clust performance etc, whilst the...
Cascading deletions do sound efficient and very low maintenance, however the risk of someone accidently running a delete statement on Produciton and the ramifications of that do...