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).
PG Day 2010 Presentation
Submitted by TimBruce on Sun, 2010-07-18 08:32My slide presentation from PDX PG Day 2010 in Portland, Oregon.
The presentation was created in Open Office (the .ODP file - Postgresql (OSCON).odp), but I've also created a PPT version (Postgresql (OSCON).ppt) exported from Open Office.
PostgreSQL on Windows - Presentation
Submitted by TimBruce on Fri, 2010-04-16 18:38I just completed a presentation for my local PostgreSQL User Group (the Portland PUG) and gave it last Thursday. I need to add some updates to clarify things and round out some of it, but here it is as I gave it.
Hopefully there are others who will find it useful.
As a side note, there are NOTES on some of the slides to go along with the material being presented.
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 SQL Server 2000 database. The following SQL helps me determine this.
Copying files - preserving attributes
Submitted by TimBruce on Wed, 2010-01-27 13:00One way to do this is:
Supposedly, the following will work to copy a file (or group of files) from a directory and preserve the attributes (ownership and permissions).
Thecommand is a copy command designed to copy files into and out of a cpio or tar archive,
automatically preserving permissions, times, and ownership of files and
subdirectories.
