A Flock of SQL Servers

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQLServerCentral.com » Editorials » A Flock of SQL Servers

29 posts, Page 1 of 3

1 2 3 »»»

A Flock of SQL Servers

Rate Topic

Display Mode

Topic Options

Author

Message

Steve Jones - SSC Editor

Posted Thursday, August 18, 2011 9:04 PM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 3:26 PM
Points: 31,425, Visits: 13,738

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

BenWard

Posted Friday, August 19, 2011 2:54 AM

Old Hand

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 7:23 AM
Points: 324, Visits: 531

SQL Server twitter spammer?

that could make some money ;)

Ben

^ Thats me!

----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

Post #1162322

Jo Pattyn

Posted Friday, August 19, 2011 4:29 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 12:17 AM
Points: 1,329, Visits: 4,304

No. Can't find the added value.

Post #1162355

P Jones

Posted Friday, August 19, 2011 5:08 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, May 20, 2013 7:35 AM
Points: 515, Visits: 1,016

No way. And no chance of it happening either in a civil service secure environment!

Post #1162371

Solomon Rutzky

Posted Friday, August 19, 2011 5:42 AM

SSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 9:37 AM
Points: 285, Visits: 1,378

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

Eric M Russell

Posted Friday, August 19, 2011 6:32 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 1:53 PM
Points: 1,164, Visits: 3,335

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?

"Wise people understand the 10,000 things without going to each one.
They know them without having to look at each one,
and they transform all without acting on each one." - The Tao Te Ching: Verse 47

Post #1162411

Jack Corbett

Posted Friday, August 19, 2011 6:46 AM

SSChampion

Group: General Forum Members
Last Login: Friday, May 17, 2013 12:22 PM
Points: 10,571, Visits: 11,871

Eric M Russell (8/19/2011)

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 BigGrin

). 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

Dizzy Desi

Posted Friday, August 19, 2011 6:59 AM

Valued Member

Group: General Forum Members
Last Login: Thursday, April 11, 2013 10:27 AM
Points: 70, Visits: 656

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

BenWard

Posted Friday, August 19, 2011 7:14 AM

Old Hand

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 7:23 AM
Points: 324, Visits: 531

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

dant12

Posted Friday, August 19, 2011 7:18 AM

SSC Veteran

Group: General Forum Members
Last Login: Monday, May 13, 2013 2:19 PM
Points: 242, Visits: 656

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 »

29 posts, Page 1 of 3

1 2 3 »»»

Permissions