I know our Network Admin is forever suggesting I use powershell. But every time he suggests something I can show him a t-sql script or functin that does it just as well in the management console.
Yes it's another method for doing things in SQL server but for me it just seems like a way for none SQL admins to try to do things SQL server has done perfectly well for a long time now.
This example for instance, I can extract a t-sql script in seconds from the backup wizard, run another script to populate the database names and run the thing very easily inside sql server.
Yes i can eat my rice with chopsticks if I try very hard, but why give myself all the extra work when i can more efficeintly use a spoon?
Years ago a boss of mine asked me how I would change a row of figures on a spreadsheet into a column. I came up with all sorts of automated mathods. He asked me "Why not just type them as a column?"
He then handed me a pen and a pad of paper and said "If you can do it with a piece of paper and a pen, if you can do it the easy way why complicate things?"