Here is a recording of the Daily Scrum Q&A talk that Joel and I did at the Enterprise Development and Solutions Conference in New York City earlier this month.

Last week at TechEd and this week up at the Montreal Users Group (yes I spoke in French! :) ), I presented the “Data Access Hacks and Shortcuts” a session where I walk through 5 different scenarios and have 5 solutions/hacks/tips. It is a unique style of presentation and people either love it or hate it. If you hate it, well, no worries, just go find a presentation that works for you. If you loved it, here are the scenarios and download link to the presentation and code:

• Passing a custom .NET collection (that uses IEnunerable) to a Stored Procedure (SQL Server 2008 TVP)
• Using SQL Server Profiler to spy on your LINQ queries and write better LINQ queries (or debug LINQ queries)
• Modeling complex 1 to many relationships as flatter views for better data access
• Binding to REST (ADO .NET Data Services) data in Silverlight, also has a nice hack on dealing with Silverlight asynchronous processing issues
• Using reporting tables and data warehouse tables as part of your application architecture

You can download the slides and code here. Enjoy.

I am spending my off day (no panels, no TLCs, no breakouts) doing MVP interviews for the MVP web site. I have interviewed:

• Dan Griffin
• Billy Hollis
• Bill Wolf (where he trash talks the Mets and Phils)
• Richard Campbell (this is funny since he is the master interviewer)

In addition I was also on 4 panels yesterday, here are the links to watch:

• Migrating Your Data Tier to SQL Server: Strategies for Survival
• The World Turned Upside Down: Development Strategies for Lean Times
• The Data Access Menu: Making Intelligent Choices
• The Most Persistent Microsoft SQL Server Myths (And Why They Are Wrong)

Tonight is the finals of Speaker Idol, hopefully the finals will make it on the web somehow. Tomorrow is my last talk: Data Access Hacks and Shortcuts @ 10:45.

TechEd is going strong, even in this hard economy. Some of the content is already up online for everyone to watch, the first is

The Pros and Cons of Stored Procedures

and

Agile: A process or an Excuse?

More content on the way…

TechEd is about to begin and Richard and I are going to do an awesome data access keynote, all demos, this is going to be fun, no power points:

DAT403
What's New in Microsoft SQL Server 2008
Stephen Forte and Richard Campbell
5/11/2009 1:00PM-2:15PM
Room 151

An Aglie TLC, Joel and I will show off a cool new (and secret) Telerik tool.

DPR04-INT
Tools and Agile Teams
Stephen Forte and Joel Semeniuk
5/11/2009 4:30PM-5:45PM
Blue Thr 2

Two panels, should be fun, these will be recorded and you can view them online at TechEd.com (or somewhere):

PAN67
The Pros and Cons of Stored Procedures
Adam Machanic; Jeffrey Palermo; Maciej Pilecki; Michael Wang; Stephen Forte; Tobias Ternstrom
5/11/2009 9:00AM-10:00AM
501C

PAN59
Agile: A Process or an Excuse?
Chris Menegay; Joel Semeniuk; Richard Campbell; Stephen Forte
5/11/2009 11:00AM-12:00PM
501C

I will be doing 11 sessions at TechEd in Los Angeles next week: four breakouts and one TLC, plus 6 panels. I will also be a speaker idol judge. Should be a lot of fun!

Here are the sessions, notice the 9am Monday morning session on stored procedures, should be a cool discussion:

Full Breakouts:

DAT403
What's New in Microsoft SQL Server 2008
Stephen Forte and Richard Campbell
5/11/2009 1:00PM-2:15PM
Room 151

DAT312
Solve Problems without Spending Money: Microsoft Office Access and Microsoft SQL Server
Mary Chipman; Stephen Forte
5/12/2009 2:45PM-4:00PM
Room 403A

DAT401
Data Access Hacks and Shortcuts
Stephen Forte
5/15/2009 10:45AM-12:00PM
Room 502A

Technical Learning Center Session:

DPR04-INT
Tools and Agile Teams
Stephen Forte and Joel Semeniuk
5/11/2009 4:30PM-5:45PM
Blue Thr 2

On-Line Panels. If you are not attending TechEd, they usually post these online to view for free:

PAN67
The Pros and Cons of Stored Procedures
Adam Machanic; Jeffrey Palermo; Maciej Pilecki; Michael Wang; Stephen Forte; Tobias Ternstrom
5/11/2009 9:00AM-10:00AM
501C

PAN59
Agile: A Process or an Excuse?
Chris Menegay; Joel Semeniuk; Richard Campbell; Stephen Forte
5/11/2009 11:00AM-12:00PM
501C

PAN62
The Most Persistent Microsoft SQL Server Myths (And Why They Are Wrong)
Adam Machanic; Maciej Pilecki; Michael Wang; Stephen Forte; Tobias Ternstrom
5/12/2009 9:00AM-10:00AM
501C

PAN53
The World Turned Upside Down: Development Strategies for Lean Times
Armen Stein; Kent Alstad; Luke Chung; Mary Chipman; Paul Sheriff; Rockford Lhotka; Stephen Forte
5/13/2009 1:00PM-2:00PM
501C

PAN65
The Data Access Menu: Making Intelligent Choices
Kent Alstad; Paul Sheriff; Richard Campbell; Rockford Lhotka; Stephen Forte
5/13/2009 2:00PM-3:00PM
501C

As we all know by now, I hate twitter. Why, why, why do you think I care about when you are picking your nose? Here is a really funny (and accurate!) list of reasons why twitter sucks.

With that backdrop, my good friend Mary Chipman is trying to trying to convince me that some people are twittering useful stuff. She is correct, she twitters here, mostly on SQL Server and other data related stuff. That said, I still won’t use twitter since there is still way too much noise.

Mary and I are doing a session at TechEd next month called “Access and SQL Server: Solve problems without spending money.” In this session we look at a few use cases where it makes sense from both a technological and business perspective to use the wiz-bang features of Access to augment your .NET and SQL Server solutions. We are not advocating using Access as a development platform, just as an augment to your solution. You do this with Excel all the time, why not use a relational engine with build in reporting as well?

Let me give you an example. Let’s say you have an enterprise application written in .NET with a SQL Server back end. You are a PR firm and the system takes inputs from some other systems of press and PR items. Then the data is transformed and put into data warehouse tables and viewed on the web via an ASP.NET app and SQL Server Reporting Services.

Now the boss tells you that you have to track twitter. You protest! But the boss insists. The problem is that twitter has so much junk in it and you can’t accept a raw feed into your enterprise application like you do for press releases, etc. You ask your developers to build an app that will pull in the twitter feeds via its RESTful API and store the tweets locally to give you the ability to rate the tweets relevant or irrelevant and then upload to the enterprise database to flow into the data warehouse and .NET app. They say, sure, but it will take a little while to build the app but they are busy on higher priority stuff, so they can’t get started.

So why not as a stop gap, just build a simple little Access app that uses VBA to call the twitter API and allow you to download the tweets into a local Access table, and then you can scroll through the data and click a “relevant” field as true/false. You can build this mini-solution in about 15 minutes. We’ll show you how.

Now just to be uber geeks, we also will want to get that data back into the enterprise system. The enterprise system has a locked down table structure (good!) so the only way to get data in is via a stored procedure. This stored procedure will only accept a table-valued parameter. Based on Mary’s MSDN white paper, we’ll show you how to do that too.

Hope to see you there, Tuesday May 12th after lunch. We have a few other scenarios to show you, some with Sharepoint (which are really cool), some with agile prototyping, and some using Access reporting for some solutions for annoying power users.

I am over in Bangalore, India speaking at the Great Indian Developer Conference, and as I get on stage for my first session my laptop does not project to the monitor. Oh well, I guess I have to reduce my five gazillion by one trillion screen resolution. Still not working. Tried the old reliable, rebooting. Still no dice. We try another laptop just to make sure it is me, not the monitor, sure enough it is me.

I was the first speaker at the conference and now the conference organizer is sweating. He offers his laptop and I say as long as you have SP1 on it. He said, Windows XP SP1? I was like, not that SP1, Visual Studio 2008 SP1. No dice. Now I was sweating (it was 40C/104F). Did I mention that my session is now 5 minutes late? I determine it is my Win7 video driver and give up trying.

I decide to let fate take over. I make an announcement: “Anyone in the audience have a laptop that I can borrow? One that has a lot of ram and Microsoft Virtual PC 2007 installed?” Blank stares. Now I am getting nervous, brought me back to a time in 2001 where I demoed beta2 of .NET without .NET installed on my machine. Time to hand wave and make jokes about George Bush. (That always worked in Egypt.) Then my hero showed up. Prashant lent me his laptop and we got going and life was good. I had to borrow the generic AV laptop for my Scrum session later in the day and Satheesh lent me his for my last session on Data Access hacks and shortcuts. In Belgium at TechDays Joel did an agile talk with no slides: I wrote the slides on the fly (we were being agile!) Now I will start speaking at conferences without a laptop! (Er, maybe not.)

Last night in my hotel the TV talked about a prison riot. Don’t ask me why, but prison riots always get my attention. I watched the story and it turns out that the inmates were not complaining about the conditions, they were complaining that they were not allowed to watch cricket. Yes, cricket.

So I started to pay attention. The next story was about a huge win by Chennai in the Indian Premier League (IPL).  (Yes more cricket.) Then the next story was about a flamboyant bollywood star who owns a team. They were caught with Paris Hilton or something, but the point was the news wanted to know how this would affect his team. More cricket. Did I mention that there are major national elections going on in India tomorrow. These elections will determine who is the next Prime Minister, but the news can only talk about cricket.

So I did some more investigation. The IPL was started last year. It is an Indian professional league for cricket-club based, representing cities. This is a new concept in India and has been wildly successful. The opening matches were only played a few days ago and season two is under way. Talking to a finance guy about the IPL today, I discovered that the larger markets attracted larger investors who spent a ton of money and have huge payrolls (sounds like the Yankees.) So the smallest market, Rajasthan, the team with the smallest payroll, are the defending champions (sounds almost like the Tampa Bay Rays.)

I was about done with my IPL education when I came across this blog post by fellow Regional Director Vinod Unny. The IPL web site, a site with more hits than you can imagine, streams the matches using Silverlight. The site also has a pretty cool interactive Silverlight based scoreboard where you can get real time stats and drill down into a player’s history. There are even tons of photos using deep zoom. Pretty awesome stuff (even thought it is cricket!)

IPLT20.com is estimated to get over 400 million unique page views from 45 million visits and 10 million unique visitors during this tournament. A huge win for Silverlight and proof that i can’t get away from technology ever, even when investigating a prison riot….