Post reply

Software for sending SMS from SQL Server

  • April 25, 2011 at 1:37 am

    #389365

    Hi all,

    I wanted make a quick mention of dSMS which is an client/server application for sending SMS. It is free and will stay free. It is released as closed source Freeware.

    Because it is SQL-centric I thought I'd mention it on this forum considering the SQL knowledge of the users here. There will be a new version released within a few weeks which supports PDU -> you should be able to use dSMS with most GSM telephones, GSM modems/terminals.

    I hope you will find dSMS interesting!

    edit:

    I want to clarify that the current version 1.1.3 only supports the GSM terminals Cepag GT864-QUAD and Cepag CT63. With the PDU support this limitation should be history.

    http://dsms.fi

  • May 13, 2011 at 4:32 am

    #1324169

    dSMS 1.2 is out now! Read more at dSMS.fi.

  • May 16, 2011 at 1:36 am

    #1324878

    Added some graphics which explains the main functionality of dSMS -> About dSMS.

    I must admit, I had expected some feedback from users on this forum considering the vast SQL knowledge that can be found here. How many of you use SMS? Isn't it common? Technology already yesterdays news?

  • May 17, 2011 at 1:48 am

    #1325634

    A lot of large production shops probably have 24 hour cover or are monitored remotely.

    They would then call the on call DBA directly as you can't always guarantee hearing an SMS at 4am - hearing a phone is hard enough at my age 🙂

  • May 17, 2011 at 1:33 pm

    #1326096

    Nice application - well developed. We have been lucky to find this post here. Saved us a lot of time. Thanks.

  • May 17, 2011 at 2:32 pm

    #1326131

    If you have a set number you want to text you could just use Database Mail and send an email to the phone. For sprint it is usually 3335551212@messaging.sprintpcs.com. Verizon is 3335551212@vtext.com I think..

    CEWII

  • May 18, 2011 at 12:10 am

    #1326241

    jasonmorris (5/17/2011)

    A lot of large production shops probably have 24 hour cover or are monitored remotely.

    They would then call the on call DBA directly as you can't always guarantee hearing an SMS at 4am - hearing a phone is hard enough at my age 🙂

    Yes that would be the most reasonable setup for large environments.

    True too about getting an SMS in the middle of the night, there is absolutely no guarantee the intended recipient actually notices it. I would not.

    Considering the features of dSMS if you wanted to use it for IT/DBA purposes some suggestions could be:

    -setting up SMS Reports that return OS info, database info/state. Very simple setup and you could query your system any time of the day and you don't need Internet.

    -setting up alert groups so that one person easily could send a group message to alert a number of other people when needed. Again no Internet needed.

    -one thing which is easy to implement is for consultants to report time to the office. Just make a SMS Report, send e.g. project number, time spent at customer and your ID and the time has been registered and it will be invoiced. This is very good when doing small jobs at customer's place. The consultant can report the info just as he/she is leaving the customer. A lot of short consultant time is lost due to failure to report.

    The general nature of dSMS opens up limitless possibilities. Every one have custom needs and with dSMS you can do pretty much whatever. You are your own SMS Gateway.

    edit:

    misspelled word

  • May 18, 2011 at 12:16 am

    #1326243

    marashi74 (5/17/2011)

    Nice application - well developed. We have been lucky to find this post here. Saved us a lot of time. Thanks.

    Thank you! You are currently using dSMS?

  • June 2, 2011 at 11:55 pm

    #1333514

    dSMS 1.3.0 released.

    Live Templates are especially useful for reminders. Create an SQL that fetches today's appointments and create a Live Template text and dSMS will create custom SMS for each contact having an appointment.

    E.g.

    “Dear Jane Smith,

    this is a friendly reminder from your dentist that you have an appointment with me at 01:45 PM today.

    Should you have to cancel or have any questions do not hesitate to call number 555 12 43 12.

    Kind Regards

    A. McAllister “

    Changes for dSMS 1.3.0

    ————————-

    Added Live Templates, now possible to create custom (individual) SMS. See user manual for more info (http://dsms.fi/docs).

    Added function for dSMS administrator to delete old messages under ”Settings”.

    Added english Help file (.chm) (work in progress).

    dSMS.Database.Patcher.exe included to patch database schema.

  • August 8, 2011 at 2:06 am

    #1365056

    Changes for dSMS 1.3.2

    ————————-

    ***Changes & fixes made to dSMS Client***

    Columns/fields can be hidden in all lists, width adjusted

    Now possible to clear server log

    Client suggests new Id when adding new member to static recipient group

    Option added to Settings to kill Mobile Partner (HUAWEI) process. This process usually autostarts & blocks COM port when using HUAWEI modem.

    ***General changes & fixes***

    Database Wizard & Patcher now included in Console & Service Server installation

    Added Auto Registration option via Settings (see user manual)

    Dynamic parameter (varchar) value increased from 50 -> 500

    SMS Reports can be marked as open i.e. anyone can request them (for Auto Registration)

    dSMS files are now signed (DigiCert)

    -> Auto-registration schematic <-

  • August 8, 2011 at 2:54 am

    #1365064

    quite a cute app with a very nice idea 🙂

  • August 8, 2011 at 2:59 am

    #1365066

    Thanks!

  • August 12, 2011 at 1:22 am

    #1367741

    dSMS 1.4.0 released. Introducing Simple Information Service

    With Simple Information Services (SIS) it is easy to setup services that customers can request about current offers, opening hours, food menus and so on. It is even easier for the business owner/company to maintain these. SIS notifications have a valid time period so that each week can have a new offer, menu etc. This service is perfect for small business like pizzerias, rental businesses, restaurants, music clubs.

    dSMS 1.4.0 information

  • December 1, 2011 at 7:53 pm

    #1415673

    Looks like the app being discussed is pretty neat - wanted to throw this out for consideration. There is a service called Twilio.com and they have a really cool API for making telephone calls and sending text messages for almost nothing. I built a small DLL and some UDFs to wrap the calls to their API into SQL code. The project is free to download and you can beplacing telephone calls and sending text messages from your SQL server in minutes.

  • December 27, 2011 at 1:52 am

    #1425604

    dSMS 1.5.0 released.

    This version has a new client GUI which makes it even easier to handle SMS communication.

    Various performance issues and bugs have been fixed in both client and server.

    SMS Reports can be set to not generate a reply, this is useful for long-running SMS Reports (asynchronous) where the code it executes itself will generate the reply, not dSMS. This functionality is useful where the dSMS Server receiving an SMS Report request from a person in turn requests the actual SMS Report from another dSMS Server. This is 100% transparent to the person requesting and allows for extended flexibility.

    dSMS homepage

Viewing 15 posts - 1 through 15 (of 19 total)

You must be logged in to reply to this topic. Login to reply