I created the he following stored procedure to give me a more clear look at the unallocated and unused space used by my databases. The […]
Continue readingTag: Script
Terminate Connections to an SQL Database
Have you ever tried to restore a database to an SQL server with existing connections? Unless the connections are terminated, the database restore will fail […]
Continue readingList all Connections to an SQL Database
A simple, but useful command, this script will show all connections to an SQL server. Replace Database Name with the name of the database and […]
Continue readingQuery Table Sizes from a SQL Database
I pulled apart a few stored procedures and ended up with this code. Very nice way to query the row count and size for each […]
Continue readingFind string within files on a Linux Server
This is a very useful bit of code, used to search within files on a Linux server. Replace the . after find to search within […]
Continue readingRecursively count the number of files on a Linux server
Simple script to recursively count the number of files on a Linux server. ls -laR | wc -l How this works: ls (lists folder contents), […]
Continue readingSimple MySQL Database Backup
Another simple backup script. This script builds on the rsync file backup to allow daily, monthly, and yearly incremental MySQL database backups. The backup will […]
Continue readingSimple rsync Backup
This is a simple rsync backup that creates daily, monthly, and yearly incremental backups. This type of script would allow for recovery of just about […]
Continue readingQuery a List of Servers from Active Directory
I needed a list of all servers listed in AD. There are many scripts out there that do this, but they didn’t quite fit my […]
Continue readingDisplay Process List Using VBScript
This great VBScript script will display running processes on a Windows workstation. The script queries the Win32_Process from a WMI Object using ExecQuery then loops […]
Continue reading