Hi everybody!
My name is Daniel Hardegree and I'm currently the Box Office Manager at our organization. We've been on Tessitura for almost three years and we have a pretty small staff and only a handful of us really use Tessitura beyond just selling tickets. We've discovered that there is STRONG need for someone who can fulfill more of a comprehensive Systems Admin/DBA/Systems Analyst/General IT role, and I'm looking to move into that position. I'm in the process of gathering details to compose a job proposal to our executive staff and I was hoping some of you guys would be able to point me in the right direction on some of the details. I'm mostly looking to see what kind of training and resources one would need for this position.
Here's a little background on myself. I've been the box office manager for 5 years and am the closest thing to a Tessitura Superuser at our organization. I ran point on the majority of our implementation process with oversight from our university's IT project manager and staff. I am currently in school pursuing a B.S. in Information Systems so I'm already on the path for this kind of role. I do have some basic SQL skills and understanding but not any practical experience with it.
As mentioned above I really need to discover what all training and resources I would need for this role. Anything you can provide would be greatly beneficial, and I look forward to your responses.
Thanks!
Daniel Hardegree said:I do have some basic SQL skills and understanding but not any practical experience with it.
Are you a RAMP licensee? If you don't already have it, ask for SSMS access to your Test database (where you can't cause too much trouble). That will be an invaluable place to play while you learn more about SQL from other sources, and in doing so you will also be learning more about the guts of how Tessitura works. I've honestly learned more about how our organization functions by understanding how the database is tied together than any activity or discussion with staff members.
The other skill that is often handy when it comes to Tessitura is a grounding in C# and .Net. As Tessitura expands their offerings for HTML Templates and Interceptors the value of that skill will increase.
Yes, we are on RAMP and I do have access to SSMS. I will definitely play around in the test environment to gain some understanding. Thanks for the tip!
A way to get started there is to create some lists in the client, then go to manual edit and copy that code into your SSMS query window. From there you can start making edits to see how things change.
Especially when it comes to custom report writing, look at the ones which do similar things to what you want to do. The easiest way to learn to write a report and/or procedure is to copy an existing one and make slight modifications to what you want to do.
Also, never underestimate the value of looking at the "Show Query" part of List Manager on complex lists.