Tag Archives: powershell

Shutting Off PowerShell Warnings–#SQLNewBlogger

Posted on October 2, 2019 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Not really a SQL Server post, but I ran into this minor issue. While running a script, I saw … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Shutting Off PowerShell Warnings–#SQLNewBlogger

Quick PoSh SQL Provision Databases for New Developers

Posted on October 4, 2018 by way0utwest

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 , , , | Comments Off on Quick PoSh SQL Provision Databases for New Developers

Hands off dbatools updates

Posted on May 25, 2018 by way0utwest

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 way0utwest

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