SQL

Deleting millions of rows from SQL

Posted on

Occasionally you can end up with very large databases that you need to purge old data from. Unfortunatly you cant delete all the old data in 1 chunk since it will cause you SQL server to stop serviceing anything else (and potentially fill up your logs). Below is a little script I used to delete […]

SQL

Reporting on space used in a SQL database

Posted on

I had the need today to look at a database and quickly identify which tables were taking up the most space. Since there are over 400 tables, doing this by hand wasn’t going to work. Below is the TSQL script I created based on the sp_spaceused stored procedure to catalog the data and output it […]

VMware

Removing old hardware when P2V’ing systems

Posted on

Click Start, click Run, type cmd.exe, and then press ENTER. Type set devmgr_show_nonpresent_devices=1, and then press ENTER. Type Start DEVMGMT.MSC, and then press ENTER. Click View, and then click Show Hidden Devices. Expand the Network Adapters tree. Right-click the dimmed network adapter, and then click Uninstall.

Linux

Renaming a Redhat system

Posted on

Occasionally you need to rename a server, and in Linux this could be very difficult (depending on the flavor you are running). Here are the easy steps to rename a Redhat system. Edit /etc/sysconfig/network Change the line that says HOSTNAME Reboot

Linux

VMware – No volume groups found

Posted on

I recently P2V’d several RHEL and RHAS servers which failed to boot when powered on. They would begin booting and then report “No volume groups found” and “Kernel panic – not syncing: Attempted to kill init!”. After a lot of searching, I found the following link with the key information: http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1002402 Resolution steps: Boot the […]