Skip navigation.
Home
Computer Information for the non-computer literate.....

About Me

Tim BruceI 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

My 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

I 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

Sometimes 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

One 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).

$ cd /path/to/source/dir

$ find . | cpio -pdumv /path/to/destination/dir

The cpio command 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.

Syndicate content