Daily Archives: May 23, 2018

Jobs in PoSh to Create a Load

I saw this from Argenis Fernandez, and thought it was wonderful. 1..128 | % { start-job -name ‘job name’ -scriptblock { & sqlcmd -S instanceName -U sa -P ‘iLovePoSh’ -i /home/username/test.sql } } Create 128 threads, each running a background … Continue reading

Posted in Blog | Tagged , | Comments Off on Jobs in PoSh to Create a Load

Pause and Backtrack

One of the main functions for anyone that manages a database is ensuring that they can recover the system in the event of any issues. My view is that restores are the most important skill and task that need to … Continue reading

Posted in Editorial | Tagged , , , | Comments Off on Pause and Backtrack