I can't seem to find many examples in the way of using the MSSqlServer extension. I have my thing setup, with the MSSql Thing template, and my connection is made, I am just not sure how to proceed with creating a service to do a simple query. Thank you for the help!
Brian, as Pai suggested, the Introduction to ThingWorx course has a separate section called 'Connecting to External Data Sources'. It has examples on how to connect to a SQL database, create queries (and commands) and then bind them to a Mashup.