We're thinking of updating our server farms to use Shared Configuration, and we're wondering about the performance penalty for doing so.
We're wondering when the applicationHost.config file is read from the filesystem? Every request? Everytime the app pool recycles?
A user wants the SHOWPLAN permission in order to use Execution Plans to tune a query.
What are the implications of this permission. Is it safe to grant a user? I've seen the security note here, and that doesn't concern me with this user.
Are there any other issues to be aware of? From what I see it doesn't seem like it would be a problem to give a user this permission, even on a production database.
Thanks for the help!
I'm working on a public website that is used by both external visitors and internal employees. I'm after the external visitor hits, but I can't think of a good way to filter out the internal IP ranges.
Using LogParser, what is the best way to filter IISW3C logs by IP range?
This is all I've come up with so far, which can't possibly be the best or most efficient way.
WHERE [c-ip] NOT LIKE (10.10.%, 10.11.%)
Any help is appreciated.