Chad Petrovay

Tag: text entries

  • Select Top 3 * From [Uses for Select]: Part 1

    Select Top 3 * From [Uses for Select]: Part 1

    People generally ask me about resources for learning SQL. SQL is a great language for any database administrator to learn, because it gives you full control of the data, without limiting you to an application’s graphic user interface (GUI). With SQL you can query for records, and add, edit or remove them. This post is not meant as a tutorial on the subject, because great resources, like SQLzoo or O’Reilly’s , already exist. Instead, in this series of posts, I want to highlight why the SELECT statement is the most important of these. (more…)

  • TMS + Social Media

    TMS + Social Media

    Institutions are increasingly engaging with their audiences through social media. This presentation is full of insights into why social networking is an important component of outreach, and explores how TMS can be used to coordinate institution activities on such platforms as Facebook, Twitter, Flickr, Wikipedia, and more.

    (more…)
  • Text Entries in a Single View

    Text Entries in a Single View

    If you’re anything like me, you probably have a stack of SQL views just to simplify report writing. Since text entries are so pervasive to TMS’s operation, I find that I am constantly making use of them in various Crystal Reports. Here’s a time-saver: a SQL view that combines the four tables used for controlling text entries and handling notes.

    (more…)