Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

A Flock of SQL Servers Expand / Collapse
Author
Message
Posted Thursday, August 18, 2011 9:04 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 11:35 AM
Points: 33,102, Visits: 15,213
Comments posted to this topic are about the item A Flock of SQL Servers






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1162221
Posted Friday, August 19, 2011 2:54 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 3:47 AM
Points: 372, Visits: 654
SQL Server twitter spammer?

that could make some money ;)


Ben

^ Thats me!


----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------
Post #1162322
Posted Friday, August 19, 2011 4:29 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 12:01 PM
Points: 1,389, Visits: 6,272
No. Can't find the added value.
Post #1162355
Posted Friday, August 19, 2011 5:08 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 4:19 AM
Points: 559, Visits: 1,161
No way. And no chance of it happening either in a civil service secure environment!
Post #1162371
Posted Friday, August 19, 2011 5:42 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, July 29, 2014 12:58 AM
Points: 354, Visits: 1,869
I completely understand that many responding to this question will be vehemently against such a thing, or cannot fathom a use for connecting your SQL Server to Twitter, but there are many out there who are already doing it and finding value in it. The two main uses I see are: 1) posting system status such that people can subscribe to it as opposed to sending out tons of emails to people who might just be auto-deleting them anyway, and 2) interacting more directly with the users of your application and not giving away any server specific info.

Since introducing Twitter functionality (for free!) into my SQL# (http://www.SQLsharp.com/) CLR library two years ago now, I have gotten a large amount of downloads for the Twitter functions alone. The response has been much more positive than I had expected. I originally integrated the functionality as I simply thought it would be interesting but was not entirely sure of any real use-cases. However, the community responded rather favorably and people have been using it to do more than I could think up on my own. I certainly do not know all of the ways in which people are using the Twitter functions, but I can say that enough people are doing it to render it valid, even if some argue that it shouldn't be done even if it is possible.

Take care,
Solomon...





SQL# - http://www.SQLsharp.com/
Post #1162383
Posted Friday, August 19, 2011 6:32 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 10:40 AM
Points: 1,606, Visits: 4,599
Well, when creating a SQL Server Alert, the options currently include email, pager, SMS message, and Net Send. Tweets are typically for public broadcast. SMS messages are equivalent in functionality, but I think more appropriate for sending messages to a DBA, because they can more easily be received on a cell phone. Would anyone find value in adding Tweet as an option for alerts? Perhaps in a senario where you want to send Tweets to a group of users?
Post #1162411
Posted Friday, August 19, 2011 6:46 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Thursday, July 24, 2014 9:07 AM
Points: 11,157, Visits: 12,899
Eric M Russell (8/19/2011)
Well, when creating a SQL Server Alert, the options currently include email, pager, SMS message, and Net Send. Tweets are typically for public broadcast. SMS messages are equivalent in functionality, but I think more appropriate for sending messages to a DBA, because they can more easily be received on a cell phone. Would anyone find value in adding Tweet as an option for alerts? Perhaps in a senario where you want to send Tweets to a group of users?


With Twitter you can subscribe your phone to Tweets by a specific user (your SQL Server) and receive the tweets via text message (standard rates may apply). You could use this so that people can subscribe as needed. Of course the on-call DBA may forget to subscribe so you should have a backup method as well.

Since I get mail on my phone, I don't really see a need to have the SQL Server tweet. It might be appropriate for severe errors as the text message may beat an email, but then my phone should be ringing too.




Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #1162425
Posted Friday, August 19, 2011 6:59 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, April 25, 2014 10:27 AM
Points: 71, Visits: 671
I'm another DBA who has email access via phone, so I can't see much added value, since I already receive notifications of job failures, account lockouts, etc.

As far as having my applications/database servers read tweets and respond to them - absolutely not. I think that's a Denial of Service attack (even inadvertently) waiting to happen.

Desi

Post #1162432
Posted Friday, August 19, 2011 7:14 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 3:47 AM
Points: 372, Visits: 654
I don't see any purpose for this where DBAs are concerned but some businesses would love it.

Say for example you work for a company like Perkz or Groupon or HotUKDeals whatever. All of your special offers are stored in an SQL Server database, as are the comments and ratings that users give the items. Once an item or offer has had x comments, or x users rated it at 4 stars and above you can trigger the system to tweet it as a 'hot' deal or offer.

When subscribers join up to see what offers and deals you have, your server can start to 'read' their tweets. With a little bit of clever logic the server can link what offers and deals it tweets about to the kind of subjects and products that the subscribers tweet about. E.g. you get a deal in for a 20% discount voucher on some mountain bike retailer, your server 'reads' about your subscriber "Going downhilling with Dangerous Dave on Saturday! Sweet!" picks up 'downhill' as a tag on the mountain bike offer so re-tweets their comment with the voucher details attached.

Doing all this within SQL without having to faff about with writing custom applications to tie SQL in with twitter would be excellent. Totally unimportant to the DBA but awesome for maximizing the effectiveness of a retailer's marketing.


Ben

^ Thats me!


----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------
Post #1162451
Posted Friday, August 19, 2011 7:18 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, June 16, 2014 4:18 PM
Points: 242, Visits: 678
Depending on the kind of service you provide, I can see the value in that letting your geek users know how your server fares. If i notice my favorite service/server is slow as hell, I sure like to know why. I, and am sure others as well, prefer to know why it is slow and when it began much more than to be left in the dark.
This surely invites criticism but also transparency.


--
Thiago Dantas
@DantHimself
Post #1162453
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse