Twitter Data on SQL Azure

Here’s the deck from my presentation at ‘24 Hours of SQL Pass’.

24 Hours of SQL Pass - SQL Azure

View more presentations from Lynn Langit.

To try out SQL Azure with no credit card, no hassle, 30 days – use this code DPWE02

The Twitter parser source code (CodePlex) is here.  What this does is as follows:
1) Edit the UnitTest1.cs for your particular hashtag
2) Configure the connection string to point to a local SQL Server (or you can point directly to SQL Azure)
3) Run the Unit Tests to pull a tweet stream based on the hashtag and to format as JSON data.
4) The Unit Tests will also create a simple database (3 tables) and populate that with the JSON tweet data.

image

Enjoy!