Hello!Our Tessitura/IT Manager recently retired after 17 years, and I'm looking for any and all advice you might have on managing that transition. We're on RAMP, so much of our regular maintenance is covered, but I'm worried about all those little things that fall through the cracks. People who have been through this before -- help!
Thank you!
A couple of quick suggestions: - Do an audit of all your SQL Server scheduled jobs (ask for help from the Hosting Services team if necessary) to find jobs created by that admin. When you've had a database admin in place for a long time, it's nearly always a revelation to discover what they had running as automations. - Run a search in SQL Server for all objects in the database owned by the userid of the user who's leaving. Here's a handy reference to a script that does just that. https://dba.stackexchange.com/questions/33551/can-i-retrieve-all-database-objects-owned-by-a-particular-user. You won't immediately, and may not ever, need to alter any of these objects, but knowing what they did create will be very helpful later if custom reports or procedures need to be altered. - Similarly, check for any scheduled reports that belong to that user and plan for who they should be owned by now. Fortunately, version 15 makes this very easy in the updated reports management interface. - And the most basic but perhaps the most overlooked - remember to remove that user's user group access and inactivate their login. Hope all this helps!
Jonathan