Loading…
Type: General clear filter
arrow_back View All Dates
Friday, March 14
 

9:00am MDT

Part 1: Intermediate SQL for Sierra and Polaris
Friday March 14, 2025 9:00am - 10:00am MDT
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.  The agenda for both sessions –
the second session begins at 10:30 Saturday – is as follows; we'll get as far as we can on Friday and resume on Saturday:

  • Understanding the different types and applications of JOINs
  • Common uses of UNIONs
  • Common table expressions (CTEs)
  • Correlated subqueries
  • Creating and using temp tables
  • Understanding and using window functions
  • Writing performant SQL
  • Adopting a consistent style for readability
  • Producing Python- and 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 tangential database topics. I have been working with two Polaris SQL experts to develop examples for the Polaris attendees.

If you have other topics you'd like to cover, please contact me at bgaydos@starklibrary.org in advance of the conference and I will try to work those in to the presentation.
Speakers
avatar for Bob Gaydos

Bob Gaydos

ILS Administrator, Stark County District Library
A career database applications developer and data analyst whose formative years were also spent as a Unix systems administrator and DBA.  Seven years in the library world and enjoying it tremendously.  Wrangler of Sierra, coder of SQL, Python and Linux shell scripts.  Passions... Read More →

Friday March 14, 2025 9:00am - 10:00am MDT
Evergreen F

9:00am MDT

Support Update & Support Center Overview
Friday March 14, 2025 9:00am - 10:00am MDT
Update on Support from Innovative leadership, including an overview of the new Support Center.
Friday March 14, 2025 9:00am - 10:00am MDT
Aspen Ampitheater

10:30am MDT

Executive Leadership Panel
Friday March 14, 2025 10:30am - 11:30am MDT
A Q&A session with a panel of Innovative Executives
Speakers
Friday March 14, 2025 10:30am - 11:30am MDT
Aspen Ampitheater

10:30am MDT

Securing your library data
Friday March 14, 2025 10:30am - 11:30am MDT
Library data security is more important than ever. This session will explore practical strategies to protect patron information and comply with privacy regulations. Attendees will gain insights into potential threats, including phishing attacks and financial motives behind cybercrimes, and learn how to strengthen security without overwhelming staff with technical complexity.

The presentation will cover key security guidelines, emphasizing the importance of email vigilance, multi-factor authentication (MFA), and smart password management. Attendees will also discover technical measures such as vendor credential management, anti-malware tools, and secure backup strategies to safeguard critical systems.
Speakers
Friday March 14, 2025 10:30am - 11:30am MDT
Evergreen C

1:30pm MDT

Electric Libraryland: AI, Copyright, Ownership, and Tomorrow
Friday March 14, 2025 1:30pm - 2:30pm MDT
Libraries are standing at multiple intersections of change where the roads extend not only into different directions, but different dimensions. AI isn't going away and it's coming for your library, whether you like it or not. Indeed, 'whether you like it or not' is the mantra of AI development and innovation. There are questions about the legalities of licensing vs ownership, the foundations of copyright, and the ownership of the past. Let's take a look at the landscape of Electric Libraryland, from traditional libraries to the underground. What happened, what's happening, and what might happen tomorrow? And what might you need to know when tomorrow becomes today?
Speakers
avatar for Daniel Messer

Daniel Messer

ILS Administrator, Library Systems and Services
Your little free Cyberpunk Librarian.Mastodon: https://hackers.town/@CyberpunkLibrarian
Friday March 14, 2025 1:30pm - 2:30pm MDT
Evergreen D

1:30pm MDT

MEEP (Member Exclusive Enhancement Process)
Friday March 14, 2025 1:30pm - 2:30pm MDT
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.
Speakers
avatar for Katie LeBlanc

Katie LeBlanc

Head of Customer CARE/System Administrator, Clinton-Macomb Public Library
avatar for Julie Cole

Julie Cole

Library System Administrator, Langara College
Friday March 14, 2025 1:30pm - 2:30pm MDT
Evergreen F

1:30pm MDT

System Security in an Insecure World
Friday March 14, 2025 1:30pm - 2:30pm MDT
With ransomware and cyber attacks on the rise, a review of how Clarivate handles system security.  It includes a look at the security built into our software, the security of our hosting services, and how we review security with third-party partners.
Speakers
Friday March 14, 2025 1:30pm - 2:30pm MDT
Aspen Ampitheater

3:00pm MDT

Accessibility Matters
Friday March 14, 2025 3:00pm - 4:00pm MDT
Overview of latest changes to accessibility guidelines around the world - and how Clarivate supports accessibility.
Speakers
AQ

Anthony Quinn

User Experience, Clarivate
Friday March 14, 2025 3:00pm - 4:00pm MDT
Aspen Ampitheater

4:30pm MDT

A Day Ending in 'Y' in Florida: Handling Natural and Man-made Disasters
Friday March 14, 2025 4:30pm - 5:30pm MDT
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.
Speakers
avatar for Kristen Marshall

Kristen Marshall

Senior Librarian, Lee County Library System
Friday March 14, 2025 4:30pm - 5:30pm MDT
Evergreen F

4:30pm MDT

LibraryIQ & You: Collaborative Approaches to Vendor Integrations
Friday March 14, 2025 4:30pm - 5:30pm MDT
Minuteman Library Network (MLN) went live with libraryIQ in 2024. MLN is  a particularly tough customer, posing plenty of challenges to both parties. MLN does not prefer to provide direct access to the server, and IQ wasn’t exactly sure what to make of 7,000+ collection codes which led to misinterpreted data on both sides. But thanks to a highly collaborative partnership we were able to work through all conflicts and had a successful launch. Come and learn how a library and vendor both approach the onboarding process and can work together to ensure that the ongoing needs of both parties are met. Co-presented with Sara Roberts and Cori Iannaggi of libraryIQ .
Speakers
avatar for Jeremy Goldstein

Jeremy Goldstein

Data Curation Librarian, Minuteman Library Network
Data Curation Librarian for the Minuteman Library Network, former Steering Committee Member, Beacon Award Winner, SQL oversharer, and owner of far too many comics.
Friday March 14, 2025 4:30pm - 5:30pm MDT
Evergreen D
 
Share Modal

Share this link via

Or copy link

Filter sessions
Apply filters to sessions.
Filtered by Date -