Find content in files. Case insensitive and print line number along with file name.

grep "Search Term" filename -in

Find all instances of userid in all .sql files in the current folder.

grep "userid" *.sql -in

Recursive search.

grep "userid" *.sql -in -r

Powershell equivalent

Current directory search.

Select-String -pattern "SearchTerm"

Recursive search.

dir -Recurse | Select-String -pattern "SearchTerm"

Recursive search with include and exclude of folders/files.

dir -Recurse | Select-String -pattern "SearchTerm" -Include *.sql,*vb -Exclude .git,.vs