Tag Archives: powershell

Get Your SQL Server Product Key with Powershell #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 , , | 4 Comments

Finding Sysadmins with dba tools–GetDbaRoleMember

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 , , | 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 , , | Comments Off on Querying My Named Instance in PoSh–#SQLNewBlogger

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 , , | Comments Off on Installing dbatools on WS2012 R2