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 :-)

Minimally Logged Operations in SQL Server

I'm posting this mostly so I can find it later :) The following article has a great table that defines when operations will be minimall...