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.
Enjoy!