bulk insert to insert CSV data into a table. dbcc … are the database console commands. if to conditionally execute statements depending on a boolean expression. kill terminates processes. reconfigure, apparently needed sometimes after executing sp_configure. throw statement. while to iterate over a block of statements until a certain condition becomes false.