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 …
How Clean is your Database?
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 …
Building Dynamic Reports for TMS with Crystal Reports
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 …
A Progress Bar for SQL Scripts
Last year, I was running cursors against massive datasets, and they seemed to run forever. It was like watching paint dry or grass grow, because, while SQL Server Management Studio shows the time elapsed and a running ticker of (1 row(s) affected) messages, there is no indication of what percentage of the dataset has been …
Quick, Hide the Money!
When preparing for training sessions, it is a good idea to elevate your users’ permissions so that they can fully participate in training. However, this can expose users to highly sensitive information – such as valuations – that they would not otherwise have access to. This makes it necessary to hide the money.