For me, it's mostly T-SQL via SSMS. Often times I use the GUI to create the initial version of the script. I don't see the point in using SQLCMD or other pure CLI tools; it's sort of like washing dishes and clothes by hand.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho