Home
The Museum System
Business Intelligence
About ChadChad Petrovay is the Collections Database Administrator at the newly formed Musical Instrument Museum in Phoenix, Arizona. Coming from a background in both archaeology and instructional technology, he spent the last two years managing the collections database at the Walters Art Museum in Baltimore, Maryland, where he instituted web initiatives to increase exposure of the collection through Facebook, Google Earth and ArtStor. He holds a BA in Sociology/Anthropology from St Mary’s College of Maryland, and a Masters in Archaeology (Egypt, Near East, India) from St Chad’s College/Durham University.

Tag: status flags

Select Top 3 * From [Uses for Select]: Part 3

So far, we’ve examined how to use the SELECT statement in SQL to create SQL Views for use in Crystal Reports, and as List Views in TMS. Now we are going to use the SELECT statement to create an alert in TMS. (more…)

May 24, 2016
Assign Status Flags using an Object Package

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 to the contents of an object package. You can, with this little SQL script…
(more…)

May 12, 2009

Chad Petrovay

Tips and tricks for cultural heritage data management

Twenty Twenty-Five

Designed with WordPress