SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


A Flock of SQL Servers


A Flock of SQL Servers

Author
Message
Steve Jones
Steve Jones
SSC Guru
SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)SSC Guru (62K reputation)

Group: Administrators
Points: 62134 Visits: 19102
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
My Blog: www.voiceofthedba.com
BenWard
BenWard
SSChasing Mays
SSChasing Mays (656 reputation)SSChasing Mays (656 reputation)SSChasing Mays (656 reputation)SSChasing Mays (656 reputation)SSChasing Mays (656 reputation)SSChasing Mays (656 reputation)SSChasing Mays (656 reputation)SSChasing Mays (656 reputation)

Group: General Forum Members
Points: 656 Visits: 827
SQL Server twitter spammer?

that could make some money Wink

Ben

^ Thats me!


----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------
Jo Pattyn
Jo Pattyn
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2740 Visits: 9899
No. Can't find the added value.
P Jones
P Jones
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1221 Visits: 1517
No way. And no chance of it happening either in a civil service secure environment!
Solomon Rutzky
Solomon Rutzky
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1699 Visits: 2965
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/
Eric M Russell
Eric M Russell
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12159 Visits: 10641
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?


"The universe is complicated and for the most part beyond your control, but your life is only as complicated as you choose it to be."
Jack Corbett
  Jack Corbett
SSCoach
SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)

Group: General Forum Members
Points: 18402 Visits: 14893
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:-D). 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
At best you can say that one job may be more secure than another, but total job security is an illusion. -- Rod at work

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
Dizzy Desi
Dizzy Desi
SSC Journeyman
SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)

Group: General Forum Members
Points: 89 Visits: 687
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
BenWard
BenWard
SSChasing Mays
SSChasing Mays (656 reputation)SSChasing Mays (656 reputation)SSChasing Mays (656 reputation)SSChasing Mays (656 reputation)SSChasing Mays (656 reputation)SSChasing Mays (656 reputation)SSChasing Mays (656 reputation)SSChasing Mays (656 reputation)

Group: General Forum Members
Points: 656 Visits: 827
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
----------------------------------------
dant12
dant12
Old Hand
Old Hand (334 reputation)Old Hand (334 reputation)Old Hand (334 reputation)Old Hand (334 reputation)Old Hand (334 reputation)Old Hand (334 reputation)Old Hand (334 reputation)Old Hand (334 reputation)

Group: General Forum Members
Points: 334 Visits: 711
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search