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
Tim consults for FinTek Development and teaches the course Automating ETL on Udemy. He’s worked with technology since high school, helping his school win its first TCEA award and continues to work in automation, data architecture, back-end development, and smart contract architecture. Tim enjoys testing new technologies early in the diffusion of innovation curve and was an early adopter of NoSQL and smart contract development. He has a blog at http://www.fintekdev.com/ and helps contribute to local technical and financial events in Texas.