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

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

One of the things I’ve often needed to do is move jobs around between instances of SQL Server. I’ll often test a job on one instance, maybe run it for awhile to see if it’s a useful addition to my … Continue reading

Posted in Blog | Tagged , , | Leave a comment

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

Finding the Service Name–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. A quick one today, and this one I remembered without looking anything up. I recently needed the service name … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Getting a VHD into Azure with PoSh

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I thought this would make a nice SQLNewBlogger post, an easy get started one. I used the docs from … Continue reading

Posted in Blog | Tagged , , ,

Delete an Azure SQL Database from PowerShell

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. One of the things I’ve been working on is trying to get my DevOps, continuous delivery pipeline working with … Continue reading

Posted in Blog | Tagged , , ,

Opening the PowerShell ISE from Explorer

This is a cool productivity trip, and one that I ran into by accident. I had heard that I could launch a command prompt by typing cmd in the address. That works, and it’s cool. It even works with ConEmu, … Continue reading

Posted in Blog | Tagged , | 2 Comments

Get Your SQL Server Product Key with Powershell #dbatools

There are lots of tasks that are easily accomplished with both PowerShell and T-SQL. Get-SqlServerKey is a command that will find your product keys. It’s not often you might need this, but it’s a pain to track them down from … Continue reading

Posted in Blog | Tagged , , | 4 Comments

Finding Sysadmins with dba tools–GetDbaRoleMember

I’ve been wandering through the dbatools set of cmdlets, trying to see where various cmdlets are useful, and also practicing some PoSh skills. Recently I noticed there was a Get-DbaRoleMember cmdlet to use. Of course, when I tried to check … Continue reading

Posted in Blog | Tagged , , | 2 Comments