Reluctant DBAs are those of us who aren’t formally trained in database administration, but manage through a combination of our wits, technical manuals, and online forums. This crash course will explore best practices for installing, configuring, and maintaining Microsoft SQL Server, and highlight some SQL Server features (and Easter eggs) that can improve your user experience and institutional ROI.
Presented at Collective Imagination. 17-19 December 2021, Online.
(more…)
With staff working from home, many institutions are prioritizing data quality projects. Originally presented at Collective Imagination 2012, this presentation has been updated to reflect changes to The Museum System (TMS), and the availability of new low-cost or free tools. It provides insights into how to prevent, clean, and monitor data quality, with techniques for power users, system administrators, and SQL experts alike.
Presented as a webinar for Gallery Systems. 16 June 2020.
Like many other institutions, The Morgan Library and Museum utilizes TMS to generate reports using templates prepared in Crystal Reports. But the reports and forms we desire most – loan agreements, condition reports, and exhibition checklists – need to be highly dynamic. Instead of typesetting each block of text or every checkbox, the Morgan leverages Crystal Reports’ powerful capabilities to make reports dynamic, flexible and easy to maintain. This presentation dissects some of our most complicated reports to look at the underlying structures and formulae.
Presented at Collective Imagination. 6-8 December 2017, Los Angeles, CA.
Presented as a webinar for Gallery Systems. 25 April 2018.
Your collections database and your collections online footprint are important resources for researchers, but so is your library catalog or OPAC. This presentation will explore ways to promote synergy between and streamline workflow associated with these systems. I will also demonstrate ways to improve accessibility with 3rd party tools.
(more…)
Institutions are increasingly engaging with their audiences through social media. This presentation is full of insights into why social networking is an important component of outreach, and explores how TMS can be used to coordinate institution activities on such platforms as Facebook, Twitter, Flickr, Wikipedia, and more.