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: Database
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 readingSearch for Orphaned Users After a Database Restore
After a database has been restored, users may become orphaned, or disconnected, from the database. You will see an entry for the user in the […]
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 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 readingHow to Turn on xp_cmdshell for SQL 2005
The xp_cmdshell function can be very helpful for running commands on an SQL server. However, turning on the function comes with risks. I’ll discuss those […]
Continue readingHow to Repair a MySQL Database
If a server is shutdown unexpectedly (power outage or hardware failure), one or more MySQL tables can be locked open and may need to be […]
Continue reading