How to Use Parameters in PowerShell

Every DBA should have basic PowerShell skills. In this article, Greg Moore explains how to write a PowerShell script that takes parameters.

Getting a List of the Striped Backup Files

If you have a list of striped backup files, how can you find the latest backup set? Steve Jones uses dbatools and PowerShell to automate this process.

Using PowerShell to Generate Logins, Server and Database Permissions

Discover how to reduce the pains you might have feel when migrating all the logins and associated permissions from one instance of SQL Server to another.

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.

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.