We're using xp_cmdshell for ETL's that run via java command line for a data warehouse. It is vendor supported so wasn't our decision, but it works well. We've set up...

I pondered that for a moment before posting, but really not too worried if the world might know service account names. No different than actual user accounts (easily pulled from...

We went to individual accounts when we were at a couple dozen servers. Now that we're at a couple hundred we're very happy we did. Administrative overhead is minimal, and...