Hello!
I'm new to this forum as my position changed within the last year from Box Office Manager to a more IT related field of Tessitura Database Manager. I've been learning a great deal through Tessitura training courses offered and the assistance of Tessitura support, however I hit a road block when it comes to anything requiring SQL knowledge which pops up very frequently. Since I didn't come from an IT background, I'm lost when it comes to this and it gets tough when I keep having to go to Consulting and present a charge to Administration to get a task completed. Do any of you have advice on how to gain basic SQL knowledge to do tasks in Tessitura. And if there are any of you who were in this same position, how did you go about learning and moving forward?
Thank you so much,
Melanie
Hi Melanie,
There are plenty of us that have been in your position and there are plenty that are there at the moment. The tessitura community is exceptional when it comes to help so don't be a stranger. Formal SQL training is a good start and don't worry if you feel that imposter syndrome kick in. You'll find yourself on the internet searching queries and ending up in stackoverflow etc for a lot of answers. Things I've found invaluable (especially when getting started)
and this little Query for names of all tables which contain column with name:
SELECT c.name AS 'ColumnName' t.name AS 'TableName' FROM sys.columns c JOIN sys.tables t ON c.object_id = t.object_id WHERE c.name LIKE '%perf_no%' ORDER BY TableName ,ColumnName;
Keep a record of all your code with notes, whether it be a word doc or bitbucket/boostnote/whatever
We're here to help.
Heath