Friday, June 08, 2012

Windows PowerShell script to find all occurrences of a string in files, all subdirectories

(get-childitem -recurse -include *.java | select-string -pattern PrepareStatement | foreach {$_.line}).Count

I developed this fairly quickly to count the occurrences of "PrepareStatement" in *.java in all sub-directories.  Worked like a charm.  Just in case it does you any good :-)

Scripting out existing database mail configuration

SQL Server Central Artical on Scripting out Existing database mail configuration I wanted to save this here so I can easily find it. Sorry ...