28

Making SQL Server Talk Using SMS & Telephony

Announcing a mechanism to connect @twilio with SQL server to place telephone calls and text messages in a single line of code through a simple .net library and supplied UDFs!

Have you ever had a need to make your Microsoft SQL Server do some things that maybe it was not designed to do? I know in my experience I have used SQL server to control all sorts of business processes that technically were probably not the core function of a relational database system. Why would I do this? Because it is easy to do... there is a built in job controller and through creative scripting most anything can be accomplished without the need to develop a separate business process controller. 

Sure - there are cases where the transactional cost of this method makes it not feasible - but there are loads of businesses that can get the job done quickly and a solution that lives 100% inside of SQL code is perfect for their needs. The project I am announcing is for the users that fall into this category.

Have you ever heard of Twilio.com? If not check them out... they have a web based API that allows you to rapidly integrate SMS and telephony functions into your application. This project is a wrapper on these powerful API functions that exposes them to a SQL server through UDF integration. The net of this is that you will have a set of user defined functions on your SQL server that allow you to make telephone calls and send text messages in a single line of SQL code.

If you are curious about how this works check out the twiSQL project page and give it a test drive. This project is being released to help support my cause of adoption, if you are motivated to support that is great, but if not the project is free to download and use as you see fit.
Share |

Comments

Joseph
Thursday, January 19, 2012 9:43 AM
_.Have you thought about adding some relevant links to the article? I think it will really enhance my understanding.
Austin
# Austin
Saturday, January 21, 2012 5:08 AM
@Joseph - Sure ill be happy to point you to a few things.

This is the page that is dedicated to this project. It shows simple examples of how to use the project.

http://www.austinhenderson.com/projects/twiSQL.aspx

This is the link to the documentation file that provides a few examples as well.
http://goo.gl/nd8Z9

Hopefully these links will be helpful to get you started, but let me know if you need more information.
Billy
# Billy
Monday, January 21, 2013 5:39 PM
Hello Sir; The short link to the documentation gives this error:

404 - File or directory not found.
The resource you are looking for might have been removed, had its name changed, or is temporarily unavailable.

Thanks;

Billy
Austin
# Austin
Monday, January 21, 2013 5:42 PM
Hmm... well I am not really sure about the short link - maybe they expire. This link works.

http://www.austinhenderson.com/portals/0/assets/projects/twiSQL/twiSQL-Documentation.pdf

Also you can to to the project page and you will see a link on the left side of the page which says PDF (big red letters).

Let me know if I can help more!
Thanks for your interest.

Post Comment


Name (required)

Email (required)

Website

CAPTCHA image
Enter the code shown above in the box below

Copyright © 2017 Copyright 2010 by Austin Henderson