PowerShell Regular Expression (RegEx) Video Examples for SQL Server

By: Tim Smith | Updated: 2014-09-29 | Comments | Related: More > PowerShell

Problem / Solution

In this video tip, we look at how to use RegEx to find patterns in data strings to look for such things as credit card numbers, SSNs or other string patterns. Tim walks through several examples of how to use RegEx.

Key Learning Items

Basic understanding of RegEx to find patterns in strings
Using PowerShell to find and replace strings using RegEx

Read Companion Tip

Click Here

Using PowerShell with SQL Server Management Objects (SMO)

Retrieve a List of SQL Server Databases and their Properties using PowerShell

Generating SQL Scripts using Windows PowerShell

Setting the PowerShell Execution Policy

PowerShell script to find files that are consuming the most disk space

Monitor a SQL Server Cluster using PowerShell

How to find a specific text string in a SQL Server Stored Procedure, Function, View or Trigger

New PowerShell cmdlets to read and write SQL Server tables

PowerShell Invoke-SQLCmd outputs DataTables you can INSERT into SQL Server

Using PowerShell to Work with Directories and Files

Bulk Copy Data from Oracle to SQL Server

Parsing Strings From Delimiters In PowerShell

How to Query Arrays, Hash Tables and Strings with PowerShell

Getting Started with PowerShell File Properties and Methods

Create File with Content Using PowerShell

Execute SQL Server Stored Procedures from PowerShell

Call SQL Server Stored Procedures with PowerShell using Parameter Objects

Create SQL Server Database with PowerShell

PowerShell for the SQL Server DBA – Environment Setup

PowerShell for the DBA - If Else and Switch statements

PowerShell Regular Expression (RegEx) Video Examples for SQL Server

Problem / Solution

Key Learning Items

Read Companion Tip

Related Articles

Popular Articles

About the author

Comments For This Article