Write Better SQL The first of a 2-presentation series delivered over two successive days. The goal is to be largely product-agnostic and to focus more on common concepts without deep dives into the database structure of either product. As these sessions are geared toward those already using Sierra/Polaris SQL, no session time will be devoted to getting connected to a database and writing basic queries. Topics will include: Understanding the different types of joins; common uses of unions; common table expressions (CTEs); adopting a consistent style for readability; producing Excel-friendly output. Audience members are encouraged to chime in at any time to round out the presentation with input from multiple perspectives. Likewise, questions will be encouraged throughout, including on tangential database topics. I will be working with one or more Polaris SQL experts to develop examples for the Polaris attendees.
Come and learn more about the MEEP process. We will discuss the life of an idea and how it gets submitted to then get voted on for enhancement. We will also cover how to get involved and answer any questions you have about the process.
This session is all about fiscal years and funds. From setting up your hierarchy to getting your reports. How to manage your funds and feel confident doing your fiscal year roll over.
I will go over the various disasters that have affected my library system since 2017 (Hurricane Irma (2017), an county-wide cyberattack (2019), Covid (2020), Hurricane Ian (2022), Hurricane Milton (2024)) and what we did before, during, and after to try and lessen the negative impacts on our users. Then it will be opened up to the attendees to share similar experiences, make suggestions, and ask questions. Although I will discuss actions that were done with our ILS (Polaris), I will also talk about what was done with other vendors (i.e. OverDrive) and other general actions (i.e. cyber security training implementation), so it's more of a General forum than necessarily Polaris-specific.
