It seems like everyone is using Twitter these days to tell people what they're up to. But you might have noticed that you can’t do much with Twitter without using an add-on for it such as TweetDeck or TweetLater. If you’re a fan of T-SQL and want to do more with Twitter, you should check out Tweet-SQL. Tweet-SQL is a Twitter client that lets you use T-SQL to perform tasks in Twitter. Tweet-SQL currently offers more than 30 CLR procedures. (Click here to see a full list of these procedures.) You can use Tweet-SQL to not only update your status on Twitter but also to follow other Twitter users, archive your public timeline and @replies, send direct messages to your followers, delete a status, and even clone Twitter apps.

Installing Tweet-SQL takes less than 10 minutes, according to Rhys Campbell, the creator of Tweet-SQL. (Tweet-SQL works with SQL Server 2005 or later, and requires the .NET Framework 3.5 or later.) You actually use Tweet-SQL within SQL Server Management Studio, which should lessen the learning curve that typically accompanies Twitter clients.

You can view Tweet-SQL data in three ways: as an XML resultset, a relational resultset, or output parameters. According to Campbell, the easiest way to view data if you’re working in just T-SQL is as output parameters.

You can see examples of various ways Tweet-SQL can be used at sqlclrnews.blogspot.com and www.youdidwhatwithtsql.com/tweet-sql-version-2-sneak-peek/45. (My favorite is the TweetWasters clone.) Also, Brent Ozar, an avid Twitter user and SQL Server domain expert at Quest Software, has mentioned a couple of ways to use Tweet-SQL on his blog.

Tweet-SQL 2.0 is expected to be released in a few weeks. Check out Tweet-SQL, and download a free trial version of Tweet-SQL or purchase it for £25, at www.tweet-sql.com. To see Tweet-SQL’s user guide, click here.

Related Articles:

Follow SQL Server Magazine on Twitter