Tag Archives: powershell

Installing dbatools on WS2012 R2

This is actually a simple, short post, but writing helps me remember things, and since I had to learn this, I decided to write something short. I have a number of Windows Server 2012 R2 VMs. I need to get … Continue reading

Posted in Blog | Tagged , , | Leave a comment

The (Former) Complexity of PowerShell

When I first looked at PowerShell, it was v1.0, and I was in a TechEd presentation. The language seemed a mile past the VBScript I was using when T-SQL didn’t function well. The ability to access the .NET namespace, work … Continue reading

Posted in Editorial | Tagged , | 2 Comments

Using Out-GridView To Pick Parameters–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I was editing an article on PoSh and learned something cool. I can use Grid-View to surface an object … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Easy Database Space with dbatools

One of the things that I’ve seen DBAs query for is free space in a database. In fact, this is one of the most common questions posted on SQLServerCentral by newbies that are trying to manage their instances and ensure … Continue reading

Posted in Blog | Tagged , , , | 6 Comments

Easily Move Databases with Copy-SqlDatabase

One of the things that people have asked to be implemented for many years is an easy way to copy databases. SSIS has the Copy Database Task, but that has been problematic over time. As a result, while easy, it’s … Continue reading

Posted in Blog | Tagged , , | 3 Comments

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

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