Tag Archives: powershell

PowerShell $env Variables

I was playing with containers the other day, reading a Simple Talk article on the topic, and noticed the code in PowerShell (PoSh) used the $env:xx syntax for variables. I know I’ve seen this before, but for some reason this … Continue reading

Posted in Blog | Tagged , , | Comments Off on PowerShell $env Variables

Loading All CSV Files with PowerShell

I ran across Denis Gobo’s post about working with names from Social Security cards and wanted to play with the dataset. However, rather than use xp_cmdshell, which I might have, I decided to use PowerShell. I need to repeat this … Continue reading

Posted in Blog | Tagged , , | 2 Comments

Copy-SqlJob, a handy dbatools cmdlet

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 , , | Comments Off on Copy-SqlJob, a handy dbatools cmdlet

I’m on dbatools!

I made the front page of dbatools, as a part of the community that is supporting this project. Along with quite a few others, I’m happy to be there and doing my part to make SQL Server administration and scripting … Continue reading

Posted in Blog | Tagged , , | Comments Off on I’m on dbatools!