Recently, at Mercury New Media we had a client request that we upload IIS log files to their server on a nightly basis. The request was to rename IIS logs to follow the requested naming convention and to upload the log files in a zip folder each night. We tossed a few ideas around like console apps, custom services and ultimately settled on a PowerShell script executed by our VM’s task scheduler to fulfill our client’s need. A simple yet effective solution that would be portable and flexible.
Over the last few years there have been scenarios that as a developer I've come across many times and today I thought I'd share some SQL specific scripts that I find myself needing every once in a while and I always have to go hunting for them. This post will consolidate some of the more commonly useful ones that I think will be valuable to other developers as well.