PowerShell and Secure Strings

Greg Moore demonstrates how to work with the Get-Credential PowerShell cmdlet and secure strings when authenticating to an SFTP server.

Look up AD user properties using powershell

I realize that this is a bit of a lengthy script for something that you can use a one liner in the power shell:

Example:

Get-ADUser

But I needed to highlight certain properties of given user and take certain actions based on the values. And the result is this power shell script.

Password-less Authentication for Azure AD Guest Accounts with Azure SQL DB with Access Tokens

Learn how we can generate tokens that will give access to resources inside Azure without actually adding new users to your domain.

PowerShell 7 Road Map

A preview of areas of development for the PowerShell 7 release.

Scripting out SQL Server Data as Insert statements via PowerShell

As a companion script with his recent article abou...

Ordering T-SQL Scripts with Git and PowerShell

Learn how you can ensure that scripts are executed in a specific order with Git and PowerShell for use in a Docker container.

Working with SQLSaturday SpeedPASSes – revamped!

30 day countdown to 1.0 starts today!

Today marks the 30 day countdown to dbatools 1.0, which we will be debuting at Data Grillen in Lingen, Germany! These next 30 days are important and I’m writing...

Scripting SQL Server objects with dbatools – Beyond default options

Probably you had the need to script out some objects from a SQL Server instance/database and this is quite easy. You just need to right click on the object...
The...

Is there a UNION in PowerShell

It has been a while ago since I’ve blogged so it seems fitting that this post will be about a question that was asked of me a while ago....