Often we find ourselves troubleshooting outages which may have been caused by the physical server or virtual machine being unreachable rather than the database service itself being unavailable. End-users don’t know this. They simply call and say that the application or database is not working. We may try to access the database via SSMS or SQL Developer. If that fails, […]

Recently, I had a Windows Server whose E drive was close to filling up. The problem is that we couldn’t find which files were filling up the drive. It wasn’t the database or any other known program yet there were 80GB unaccounted for. In an attempt to determine which files have been filling up the drive, I created a powershell […]