Here’s the deck from my presentation at ‘24 Hours of SQL Pass’.
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.