Tag Archives: powershell

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

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

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

Querying My Named Instance 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 was looking at some sample code the other day and it looked like this. cd sqlserver:\sql\localhost\default\databases This allows … Continue reading

Posted in Blog | Tagged , ,

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