Find SQL Server Installation Date for all Instances with PowerShell

In this tip we look at a PowerShell script you can use to gather information about the installation date for all of your SQL Servers.

Find SQL Server Installation Date for all Instances with PowerShell

In this tip we look at a PowerShell script you can use to gather information about the installation date for all of your SQL Servers.

Securing the password

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.