To clean the quote mess up this works fine, I left out the 2 file variables.

get-content $file | foreach-object { $_ -replace """" ,""} | set-content $file2 -force

Write-Host "Wiley Cyote...

I found another cool use for this code, I reverse engineered it to watch for encryption to complete. Now why have to wait? I scripted a neat SQL in Azure...

Andy, Thanks for the update. In most cases I am under the gun to toss code together and not taking the time to maybe make trhe most efficient I can....

Thomas, I can't agree more with you on that note. I was enagaged to look at a performance issue and I found the Power Plan in Balanaced mode, SO I...

According to the MS article it does not. Here is a good link from Cindy Gross regarding why to change it.

https://blogs.msdn.microsoft.com/cindygross/2011/03/09/power-saving-options-on-sql-server/

This numeric alert value needs "20" quotes around it.
Ed

Gee, I posted another script after deleting this one I did not want to mention any vendor names. Seems the original one is up, oh well..or should I say "Yikes"..

Seems the "particular" 3rd party exe not to mention any names is on 2 different servers and 1 of them it eats the memory in X days to the point it...

Great Deck, I agree with all your points. Sometimes it would be nice to include a DBA in security meetings for playing the other side of the fence such as...

I like your signature also, I have pushed code example my DMV toolkit 2,700 lines of procs to 200+ servers using a simple read_only cursor to read server names form...

I agree, this is the first shop I worked at that it is a requirement to have it turned off. As you noted normally I am use to just using...

Jeff, in our environment it is a security violation to leave this turned on. So we flip it on to use the functionality and then flip it off when done....

Yes there is, no users have access to the Sanitize server and data where this is being performed. We have automated a Sanitization or data masking process where the copy...

Took me a while to dig this one up use: -ExcludeProperty

Notice I tucked it in prior to the convert to html, works well for my reports using html style...

For the convert to html if you include the [ -notype ] at the end of your line of code the 2 PowerShell related columns will not show up in...