Tag Archives: powershell

Moving Tasks with Copy-SqlJob

More dbatools experimentation for me. This is a great set of Powershell cmdlets that solve simple, handy problems. In this post, I want to look at Copy-SqlJob, which will allow me to easily move jobs from one instance to another. … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Hey Posh, Are My Services Running?–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. In a previous post, I looked at escaping strings. The reason I needed to do this was that I … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Validating a Set of Database Scripts using DLM Automation

The basis of all the DLM Automation from Redgate is a series of PowerShell cmdlets. They might look intimidating or confusing, but they aren’t. This is part of a series of posts that examine how you use each one. Previously … Continue reading

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

Quick PoSh Kills with Stop-DbaProcess

I’ve been trying to get used to using the dbatools cmdlets in PoSh. They help me learn some PowerShell, but they also make some things easier. As a part of my practice, I’m documenting the various items I’ve played with. … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Escaping a Dollar Sign in PoSh–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I’ve been working more with PowerShell lately and ran into a problem I thought would be easy, but it … Continue reading

Posted in Blog | Tagged , , | 10 Comments

More dbatools–Get-DbaTcpPort

After the MVP Summit, I was excited to check out more code and features in all aspects of SQL Server, but since I’d had a quick conversation with Aaron Nelson and Chrissy LeMaire, I decided to tackle another part of … Continue reading

Posted in Blog | Tagged , , | 5 Comments

Getting dbatools in Powershell

I had the chance to watch dbatools in action recently at SQL Saturday Cambridge. I watched a presentation from Chrissy LeMaire (@cl) that was impressive in how easy she made a number of DDL type changes between instances. I decided … Continue reading

Posted in Blog | Tagged , | 1 Comment

Rename a Server with PowerShell

I’m sure many people are experimenting with VMs and SQL Server. If you’re like me, many of you just default to installing Windows 7/10 or Windows Server xx Standard for your testing. Those systems work fine, but I’ve been trying … Continue reading

Posted in Blog | Tagged , , | 2 Comments

More Azure Database Creation in Powershell

I wrote about Azure SQL Database for T-SQL Tuesday #82, but I had a few mistakes in my process, at least from a cost standpoint. Since I’ll probably use this a bit more as I flesh out some CI/CD, I … Continue reading

Posted in Blog | Tagged , , | 3 Comments

PoSh Everywhere

This week we had an announcement that PowerShell has been released as an open source project and is available on some Linux platforms as well as OSX. I was actually talking with someone else that had been informed prior to … Continue reading

Posted in Editorial | Tagged ,