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…)
Once you have conceptualized and named your security groups and created them in the Database Configuration tool, it’s time to apply them to your userbase, and apply them consistently. Here is a Crystal Report that you can use to see users organized by security group and department. It’s a useful tool for being able to compare users and their permissions as you begin to right-sizing their security profiles. (more…)
So it was the Friday before the Memorial Day weekend, and before leaving for the day I decided to follow my own advice and check my backup solution to ensure it was functioning properly. I’m glad that I did, because it had been silently failing for over a week. Now that it has been fixed I want any early warning system. (more…)
In a day and age when institutions are looking for ways to tighten the belt, network administrators are looking for ways to work smarter and reduce information systems infrastructure. Imagine being able to deploy TMS to multiple venues, while reducing maintenance costs and downtime, improving connectivity and facilitating end-user support. This presentation explores how the Musical Instrument Museum has done just that by deploying TMS as a Windows Server 2008 Remote Application, and shares practical advice and troubleshooting solutions.
Today is officially the start of summer – so while you are enjoying your day off (Happy Memorial Day to you) and thinking towards your much deserved vacation, I’d like you to take a moment to think about something that never gets a day off or a vacation: your automated backup solution. (more…)