Program Title: Sproc Talk
Track: Polaris
Program Description: The entirety of Polaris operates on sprocs, which is short for stored procedures. Almost anything you do in Leap or the Staff Client will trigger one or more stored procedures to update the database and present data in some way. But the thing is, those sprocs aren’t just for Polaris, they’re there for you too! If you’ve ever been curious about what’s really going on in the Polaris database and how it functions, we’ll pop the hood and (safely) take a look at some of the thousands of stored procedures you’ll find there. We’ll take a look at what they do and how they’re built. But more importantly, we’ll look at how to build your own stored procedures and how that can help make your library life that much easier! This is an intermediate level talk and all are welcome to attend. However, it will be helpful if you have a familiarity with T-SQL and the basic structure of the Polaris database.
Speaker/ Information: Daniel Messer. ILS Administrator, Library Systems & Services
Sproc Talk - Outline.pdf (226.9 KB)
Sproc Talk.pdf (5.0 MB)