Video on Text Mining SQL Server Data Using PowerShell

By:   |   Updated: 2014-10-20   |   Comments   |   Related: More > PowerShell


Enter your business email address to
get free SQL Server tips.

Problem / Solution

In this video, we look at some of the basics to text mining data in SQL Server using PowerShell by looking at words and the positions of words.  Tim will show us various PowerShell functions to help mine text data from SQL Server tables.

Key Learning Items
  • Text mining by word count.
  • Text mining by position.
  • Getting counts of words for analysis.
Read Companion Tip

Click Here

Last Updated: 2014-10-20

get scripts

next tip button

About the author
MSSQLTips author Tim Smith Tim Smith works as a DBA and developer and also teaches Automating ETL on Udemy.

View all my tips
Related Resources

Comments For This Article


Recommended Reading

Setting the PowerShell Execution Policy

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

Using PowerShell to Work with Directories and Files

Create File with Content Using PowerShell

Execute SQL Server Stored Procedures from PowerShell

get free sql tips
agree to terms