Tag Archives: powershell

Quick PoSh SQL Provision Databases for New Developers

Posted on October 4, 2018 by

As part of some presentation work, I wanted to demonstrate some onboarding of new developers. To that end, as part of a demo, I wanted to build a script that would take a few parameters and generate some SQL Provision … Continue reading →

Posted in Blog | Tagged , , ,

Hands off dbatools updates

Posted on May 25, 2018 by

I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and incredibly useful for migrations between SQL Servers, but also for various administrative actions. I have a short series on these … Continue reading →

Posted in Blog | Tagged , , | 1 Comment

Jobs in PoSh to Create a Load

Posted on May 23, 2018 by

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 ,

A Great Case for Powershell

Posted on May 21, 2018 by

I think PowerShell is a great addition to the Microsoft stack. Given the previous versions of VBScript, Perl and Python ports, and more on Windows, PowerShell is a great improvement. Even for someone that spent a lot of time in … Continue reading →

Posted in Editorial | Tagged