Tag Archives: powershell

Using Backup-DbaDatabase for a Quick Backup

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 , , , | Leave a comment

Get-DbaPowerShell

When I first saw PowerShell, at TechEd 2006 (ish) and I was enamored. This was a much better environment than VBScript for working in a shell. Then I realized I needed -eq, -gt, etc. and was less excited. These language … Continue reading

Posted in Editorial | Tagged , | Leave a comment

Test Your SQL Memory Setting with dbatools

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 , , | Leave a comment

Test Database Compatability with dbatools

I really like the dbatools project. This is a set 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 , , | Leave a comment

Experimenting with VSCode instead of the ISE

I’ve been playing with PowerShell here and there, learning a few things. As I use the dbatools project, or I saw a tweet from Rob Sewell on using VS Code for PoSh, which I’ve tried, but it felt cumbersome and … Continue reading

Posted in Blog | Tagged , | Leave a comment

Automate Migrations–T-SQL Tuesday #94

It’s T-SQL Tuesday time again, and I’m slightly pressed for time, which is sad. This is a great topic. Rob Sewell hosts this month with his question about what we are going to automate? He’s a PowerShell advocate, so I’m … Continue reading

Posted in Blog | Tagged , , , | Leave a comment

Responsible Log Growth with dbatools

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 , , | Leave a comment

Using Test-DbaOptimizeForAdHoc

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 , ,

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 , ,

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