• Home
  • The Museum System
  • Business Intelligence
  • About Chad

Chad Petrovay

Tips and tricks for cultural heritage data management

Month: May 2009

The Museum System

5 (Often Forgotten) Productivity Tools in TMS

Chad Petrovay 26 May , 2009 3

Schools are closing, and temperatures are rising: Summer is arriving. As end-users are preparing to leave for the traditional family vacation, here are five (often forgotten) tools to help them work smarter.

Tweet
Share
Share
Pin
Continue Reading
Data Governance

Return to Sender: Address Unknown

Chad Petrovay 14 May , 2009

Outside a cubicle at the Walters Art Museum hangs an envelope from a letter, mailed from the UK, bearing the institution’s Baltimore, Maryland address and a prominent stamp “Missent to Thailand.” I’m not sure which is more amusing: that the letter was sent to Thailand, or that this happens with such frequency that the Royal …

Tweet
Share
Share
Pin
Continue Reading
SQL Scripting, The Museum System

Assign Status Flags using an Object Package

Chad Petrovay 12 May , 2009

Object Packages are a great way to collect together disparate artifact records, for whatever reason the package creator decides. By the same token, Status Flags are a great way to identify artifact records with special attributes, or that require special attention. A great time saver would be if you could mass assign a status flag …

Tweet
Share
Share
Pin
Continue Reading
SQL Scripting, The Museum System

Get Location Authority Statistics

Chad Petrovay 11 May , 2009

The Usage Report feature is a great way to keep track of what authority terms have or haven’t been used within TMS. The problem is that the Usage Report feature sometimes isn’t extensive enough – in this case covering the Location Authority. I designed this SQL query to help.

Tweet
Share
Share
Pin
Continue Reading
A row of eight lanes on a running track. Each lane is numbered with a large stencil number, and has starting blocks for the athletes.
The Museum System

Quick Start Guide

Chad Petrovay 09 May , 2009 4

Like many institutions, the seasons are not marked by a change in the weather or the calendar, but instead by the influx of new interns. Invariably, I will get a call requesting access to TMS for them, but their start dates and schedules make scheduling a group training session untenable. Here’s an easy way to …

Tweet
Share
Share
Pin
Continue Reading

Tags

advanced query Alternate Numbers backup solution batch assign bibliography Collective Imagination Constituents contact details Crystal Reports data profiling data quality data scrubbing data security data standards dbconfig digital images end-user support Events freebie Function key intangible objects library system list view Location Authority Locations Authority Media Objects Packages permissions Photosynth preaccession productivity querying Reluctant DBA remote access security group slide deck Social media SQL View statistics status flags text entries training virtual objects webinar

Categories

  • Business Intelligence (6)
  • Data Governance (4)
  • Database Administration (5)
  • Miscellanea (2)
  • SQL Scripting (17)
  • The Museum System (25)
  • xperience Gallery (2)
Chad Petrovay All rights reserved.
Powered by WordPress Theme by alfisahr