PowerShell

In this tip we look at some ways you can add logic to your PowerShell scripts to catch errors in your scripts.

In this tip we look at how to use an object that PowerShell provides called MyInvocation. This can assist us with debugging PowerShell code as well as getting some useful information.

In this tip we will walk through how to create a PowerShell module to get a list of files and subfolders of a Windows folder and store this information in a SQL Server table.

In this tip we'll look at working with common PowerShell objects for sets, such as arrays, hash tables, and in some cases strings.

In this tip we look at how we can use PowerShell to analyze the frequency of NULL values in our dataset to see if the data will still be valid based on frequency.

In this tip we look at some techniques you can use to pre-validate data in delimited text files using PowerShell prior to importing the data into SQL Server.

In this tip we look at how to use PowerShell to parse character data that has delimiters.

In this tip we take a look at how we can use IF and SWITCH statements within our PowerShell code to process text data.

In this tip we look at how you can use PowerShell for SSAS Multidimensional using the SQLAS Provider.

In this tip we look at how to change global DNS configuration settings on servers by using PowerShell.

In this tip we will work through some examples with PowerShell using basic CRUD operations to organize and aggregate data with hash tables.

Check out this PowerShell script to get a list of problem drives across your entire SQL Server environment.

Learn about how to bulk copy data from Oracle to SQL Server with PowerShell.

Learn options to save and troubleshoot PowerShell output to minimize the time to debug an issue.

In this tip we take a look at a PowerShell script that can help us run multiple SQL Server tasks at the same time.

In this tip learn how to use PowerShell to help you manipulate text file data.

Learn how to use PowerShell to check or compare values with PowerShell's Compare-Object logic.

In this tip we look at how you can use PowerShell to work with directories and files on your operating system.

With PowerShell, what are some techniques for saving, retaining and tracking file metadata? Check out this tip to learn three techniques.

Read this tip to learn about some of the new things and new ways you can install and use PowerShell.

Learn about PowerShell and Object-Level Math Functions including Round, Floor, Ceiling, Pi, Radians and more.

SSMS 2016 has brought us three new cmdlets for working with SQL Server Logins Add-SqlLogin, Remove-SqlLogin and Get-SqlLogin. Read this tip to learn more.

You need to take an existing SQL query and run it against a SQL Server and then take the results and save them to a different SQL Server without using Linked Servers. Learn how with PowerShell.

In this tip we explore new PowerShell cmdlets that allows us to read and write SQL Server database tables.