About Me
Submitted by TimBruce on Sat, 2006-04-01 16:49
I am a Database Administrator for Fiserv. I work mostly with Microsoft SQL Server and PostgreSQL database engines. I also do a limited amount of systems administration with both Microsoft Windows and Linux - specifically Novell's SuSE Linux Enterprise Server (SLES).
Table Size in Microsoft SQL Server
Submitted by TimBruce on Wed, 2010-01-27 13:02Sometimes I want to find out how many rows are in each user table in a database. The following SQL helps me determine this.
select 'SELECT COUNT(*) AS ' +
'''' +
RTRIM ( name ) +
'''' +
' FROM ' +
RTRIM ( name )
from sysobjects where type = 'U'
order by name
Default Route on OpenWRT
Submitted by TimBruce on Wed, 2010-01-27 12:59When I create a new linux virtual system and use OpenWRT at home to route out to the internet, I need to add a default route so that I can get out to the Internet. For some versions of linux, it doesn't do it automatically for me (or maybe it's the OpenWRT router and something I've misconfigured as it works for some systems, but not others?). The command to do this is:
Windows COMMAND.COM - Just Say NO
Submitted by TimBruce on Wed, 2009-10-07 20:40Most people I work with know that I spend a lot of time at the Command Line in both Windows and Linux. The Command Line Interface (CLI) gives me a lot of flexibility to quickly do things that I can't do through the Graphical User Interface (GUI).
However, a lot of users aren't aware that there are two different command line interpreters under Windows....and that using the wrong one can cause problems
How to move your MySQL database directory
Submitted by TimBruce on Tue, 2009-10-06 16:25If you have a dedicated database server and the partition with the MySQL database fills up (or starts getting low), you can move your MySQL databases to a different location.
Let’s say you want to move the database to /home/mysql
