Working with SQL also means looking for tools to do the job. As i love to work with powershell i get sometimes the question "why powershell?"
well this article might give some insight: http://www.midnightdba.com/DBARant/why-is-adopting-powershell-so-hard/ 

Always be aware of scripts you download. Be sure to test it in a save environment. 
https://www.reddit.com/r/sysadmin/comments/741gxy/powershellexe_high_cpu_usage/

Query Parallelism, maxdop etc. Brent Ozar pointed out this articel which is a very nice one.
https://dba.stackexchange.com/questions/215548/maxdop-1-query-hints-and-cost-threshold-for-parallelism

some interesting items https://tomaslind.net/