BorderLayoutBoxedLayoutOpenLayoutMaximum textMedium textSmall text


Register
Wednesday, March 10, 2010
MyStreamMinimize
Print  

A SQLCLR Twitter Client

Posted by Jason on Sunday, September 21, 2008 to SQL Server 2008, CLR, social networking
1688 Views | 13 Comments | Article Rating

image The product is TweetSQL. It is not out yet but you can see some details here and follow @rhyscampbell. You probably just uttered a profanity at the thought of it on production server. I did when I first heard of it. I even had a day dream moment where I pictured myself going all street fighter on a jr DBA who installed it prod box. Sure, install it on your test box and tweet when you do something cool like write a custom policy with ExecuteSQL() or write a script to only generate indexes. But production? Hell no.

Later, @AlanBarber made a point.

@statisticsio we're using twitter right now for status and error messages at my company. Surprisingly a nice tool to keep tabs on everything

Hhrmm, I do use twitter to communicate more than the telephone. Maybe not as much email and IM yet but if the bread and butter database fails over, some one better reach out an touch me. More ways the better. Email, SMS, and a phone call from the monitoring already happens. Why not a tweet too? This could be especially important if you do not have SMS capabilities by default. Of course, this is not something you want to go crazy with and pay attention to security. The launch of Yammer whose focus is the enterprise could bring about more usage like this.

I will tell you this… There is not much worse than having your boss call you to tell you there is a major SQL outage. The conversation goes so much better when you call him to let him know there is a problem with the SQL Server and you are on it like a hound dog on a pork chop.

email it! |   |   |   |  | 
Permalink     13 Comments  

Rate this Post:
COMMENTS:

Thanks for the plug. I'm going to prepare a preview version of Tweet-SQL after I return from holiday (est. end of October). If all works out well I plan to produce a similar one for facebook [URL]www.fb-sql.com[/URL], digg, and salesforce.
I see the CLR as an exciting addition to the SQL Server toolset but I do appreciate why you might be concerned. I'd like to blog about this and include your input if you're willing.
Rhys

posted @ Monday, September 22, 2008 4:16 AM by Rhys


Hi Rhys. Are you going to release it open source?

Testing bbcode
[URL=www.fb-sql.com]www.fb-sql.com[/URL]

posted @ Monday, September 22, 2008 9:44 AM by Jason


Hi Jason,

That's not currently part of the plan as I fancy trying my hand as a independent software developer. But if thing don't work out commercially I would certainly consider doing so. In general I will be looking to release some free software with each product (the Twitter SSIS component for example.)

Cheers,

Rhys

posted @ Monday, September 22, 2008 9:56 AM by Rhys


Are you sure it's a good idea for production notices? What kind of uptime and guaranteed delivery SLAs does Twitter have? Will Twitter notify you if it has an internal problem and its systems are going down for a while? Perhaps if Twitter offers this as a premium service it could make some revenue, but just using the basic free service to do this stuff is probably not a good choice in my opinion.

posted @ Monday, September 22, 2008 11:45 AM by Adam Machanic


I wouldn't suggest twitter alone either but it could be a good supplement with an RSS feed for creative uses.

posted @ Monday, September 22, 2008 1:35 PM by JasonMassie


This is hilarious; what an interesting

posted @ Monday, September 22, 2008 5:04 PM by Jason Cumberland


Everybody who thinks Twitter is more reliable than their SQL Servers, please take one step forward. Alright, ready, aim, you're fired.
Now if you're still standing, please point at your company's internet security staff - the guys who are letting Twitter through the firewall. Hey, it's not polite to use that finger.
In all seriousness, it makes perfect sense for shops that put SQL Servers in the DMZ. If you put SQL in the DMZ where it can't be managed by your normal management tools, and maybe can't be monitored by your normal monitoring tools, then you're probably the kind of shop that would be cool with using CLR-based tools to send your

posted @ Monday, September 22, 2008 7:03 PM by Brent Ozar


Jason, something wrong with your site? It appears to be truncating comments ... could both Jason and Brent have hit submit too soon? Seems a bit too coincidental.

posted @ Monday, September 22, 2008 8:17 PM by Adam Machanic


I saw that and I am working on it.

posted @ Monday, September 22, 2008 8:27 PM by Jason


We all know about twitter reliability which they have been very upfront about. How about SMS? Have you ever had a message delivered many hours after it was sent? I certainly have.

Many companies now host bits of technology outside the company server rooms, i.e. salesforce, ziff leads and so on. Us tech guys are still going to have to manage and integrate these systems. Why not via CLR Web Services? Isolate it on a separate box if you wish, lock down routes to the internet, ensure you're running with minimal permissions.

Now of course I don't think there are many companies out there yet that view Twitter as business critical but what about those using Amazon or Ebay web services? I think these people would be interested in a similar SQL Server based solution for these services.

Is anyone familiar with DBAmp, www.forceamp.com? This is a tool for replicating and managing salesforce data. This uses xp_cmdShell to execute an external process to do its magic. Is this approach better is anyone's view?

Cheers

Rhys

posted @ Tuesday, September 23, 2008 3:29 AM by Rhys


I answer a lot of questions regarding SQLCLR on both the MSDN Forums and the SQLServerCentral Forums. Personally, I think a lot of stuff gets stuffed into SQLCLR that has no business in a SQL Server. Memory is one of the #1 issues that people have trouble with, and it generally has to do with AppDomains unloading because of Memory Pressure, and not just on 32 bit machines. Adjusting memory settings can usually fix the problem, but then that begs the question, why would I want to pull memory from my BPool to run a process that could be running elsewhere.

The biggest arguement that I get is that it needs to be a data driven process, and the data is changing in SQL. That almost seems like a valid argument until you consider that since .NET 2.0, the SqlDependency has existed, and this can easily be registered against a SQL Table, and Service Broker will trigger an event when the data in the table changes. This would make a much more robust solution in my opinion because the monitoring app is now not on the SQL Server, and the entire BCL can safely be used to build the app. Having SQLCLR to tell me that the SQL Server is down doesn't really make a whole lot of sense to me. If SQL goes down, then so does your monitoring. I learned about this one first hand when I was using SQL Agent to call stored procedures to track my servers early on. It only took one crash to move to a different method.

Not to take away from the idea, I just think it is somewhat misplaced in its implementation. I think that unless you would have written a Xproc to do this kind of thing, you probably shouldn't be doing it in SQLCLR.

posted @ Friday, October 03, 2008 1:31 PM by Jonathan Kehayias


posted @ Sunday, June 07, 2009 2:14 PM


posted @ Monday, November 16, 2009 12:54 PM


Name (required)

Email (required)

Website


Simple BBCode can be used like [url=http://example.com]Example[/url] and [B]

Copyright 2006 by Statistics IO, My SQL Server Blog