Get Your Twitter Feed into SQL Server with Tweet-SQL

If you’re reading this post, you’re probably a Developer or SQL Server DBA, and you’re probably into Twitter, so you’re probably going to be interested in Rhys Campbell’s Tweet-SQL.

Tweet-SQL is a set of SQL Server stored procedures that let you work with the Open Source Twitter API just by writing T-SQL code. You can do things like:
* Get the list of people you’re following into a database
* Retrieve their messages into a table
* Analyze who’s following who, and figure out who you should be following
* Compile metrics about what’s going on out there

Tweet-SQL Features
* Simple deployment.
* Simple GUI for configuration.
* Stored Procedures for configuration changes with TSQL.
* Over 30 procedures to interact with the Twitter API.
* Flexible ways to deal with resultsets.
* No unfair licensing restricting you to a single Twitter account.
* Free updates for 1 year.

To get started, you’ll need a 30-day eval copy of Tweet-SQL. It’s free to evaluate, and costs £25 at this point of time.

The Twitter API is pretty darned powerful, and it enables you to do things like:
* Find out who your followers are following, which might be people you also find interesting
* Find influential people in your Twitter network
* Get recap reports of what links have been sent out recently, or what hot topics are out there
* Get peoples’ updates without actually following them directly
* Build a web-based equivalent to TweetDeck, with multiple user functionality

For sample scripts, check out SQLCLRNews, Rhys Campbell’s blog where he posts how-to examples for Tweet-SQL.

Add Nuke to your DotNet Applications

If you are creating DotNet Applications using Microsoft Dotnet framework, here is a fully compatible alternate to the same. DotNetNuke is an open-source Web Application Framework ideal for creating and deploying projects such as commercial websites, corporate intranets and extranets, online publishing portals, and custom vertical applications.

DotNetNuke is provided as open-source software, licensed under a BSD agreement. In general, this license grants the general public permission to obtain the software free-of-charge. It also allows individuals to do whatever they wish with the application framework, both commercially and non-commercially, with the simple requirement of giving credit back to the DotNetNuke project community.

DotNetNuke is built on a Microsoft ASP.NET (VB.NET) platform, and is easily installed and hosted. With a growing community of over 440,000 users, and a dedicated base of programming professionals, support for DotNetNuke is always close at hand.

DotNetNuke is designed for use on the Microsoft ASP.NET 2.0, 3.0, and 3.5 platforms using Visual Studio 2005, Visual Studio 2008, or Visual Web Developer.

Key Features:
Easy to install and to host.
Fully extensible and scalable.
Clearly licensed under a BSD-style license.
Constantly evolving through real world trial.
Simply efficient and manageable.
Priority on security.
Fully customizable.
Fully localized.
User-friendly interface.
Easy to access community support.

View the Video Introduction to DotNetNuke (this will open in Windows Media Player)
Download the Video for Offline viewing

You can also check DotNetNuke’s Online Demo

Website: http://www.dotnetnuke.com

Read other posts on Open-Source

EBook: Visual Basic .NET Bible

Description: Visual Basic .NET Bible covers everything you need to get up and runningwith this much changed version of Visual Basic and to begin creating applications for the new Microsoft.NET Platform.

Download Link