I will be speaking this year at TechEd Europe in Berlin, Germany from November 8th to November 12th. I’ll be doing two talks:

DPR201 - Agile Estimation (Tuesday Nov 9th)

Track: Development Practices

We’re agile, so we don’t have to estimate and have no deadlines, right? Wrong! This session will review the problem with estimations in projects today and then give an overview of the concept of agile estimation and the notion of re-estimation. We’ll learn about user stories, story points, team velocity, and how to apply them all to estimation and iterative re-estimation. We will take a look at the cone of uncertainty and how to use it to your advantage. We’ll then take a look at the tools we will use for Agile Estimation, including planning poker, Visual Studio TFS and much more.

And also with Joel (though he is not listed on the session as the other speaker):

DPR301 - Scrum, but (Thursday November 11th)

Track: Development Practices

Having challenges implementing Scrum in your organization? Have you been using Scrum but need to bend the rules to make it work in your organization? Do you practice a little Scrum with a mix of Kanban? Then this session if for you! Come and learn about implementing Scrum, but with a few changes. We'll look at customizing Scrum in your environment and look specifically at how to implement Scrum for the enterprise, ISVs, consulting and remote teams.

See ya there!

Microsoft is launching Windows Phone 7 today and I fear it may be too late. I, like many Microsoft watchers, was an early adopter of Windows Mobile. I used my Windows Mobile 6.x phone until it broke, and even then, I put tape over it and got another 6 months out of it.

I held out until I arrived in Hong Kong last summer to buy a new phone, a HTC Magic running Android 1.7. I liked it so much, I was one of the first people in Hong Kong to buy a Nexus One back in January-this after I had one of the first sneak peeks at WP7 on Microsoft’s campus in January.

As I used my “Google Phone” as I call it, I soon became dependent on Gmail for my main email communication, and other Google applications for my other daily chores. I use to use hosted Exchange and POP with Outlook and Outlook Web Access, now I am 100% Gmail, I don’t even have Outlook installed on my machine. I frequently show a Hong Kong taxi driver where I am going on Google Maps and use Layer (and a little Foursquare) to find new places to eat and such in Hong Kong all the time. I use the camera on the phone so much that I don’t even carry my point and click anymore. I sit at Starbucks and use the WiFi hotspot from Android 2.2 to work all day. The list goes on.

Google lured me in with a new phone and then before I knew it, I was deep inside the Googleplex and outside of the Microsoftplex.

Today, Windows Phone 7 ships. The problem with Windows Phone 7 is that it is one year too late. Last summer all the people like me with a Windows Mobile 6 phone had a new contact, or broken phone and went with an iPhone or Android. Those customers may never come back. I may not.

Last week I wrapped up a successful high altitude trek and climb in Nepal. I did this to help raise money for Education Elevated, a charity that is building a school and library in rural Nepal.

Kids first, then mountains: We visited two Hillary Schools on the trek, one in Khumjung and the other in Junbesi. We started in Jiri and it took us four days to trek to the first school in Junbese. It then took us another four days to reach Khumjung.  I scoped out the IT training. ;)

As always the kids are super cute.

After the schools, it was time to gain altitude. (Ok both schools are over 3000m/10000’.)  After we visited the Hillary School in Khumjung, we started to gain altitude and the scenery was stunning. We climbed the Gokyo Valley side, not the Everest side that I did in 2008. Even our sherpa’s geeked out and took tons of photos.

We trekked through several small villages over three days. Our sherpa were lazy. :)

After three days we reached the town of Gokyo (15,000’), right on the third glacial lake.

The next morning we climbed Gokyo Ri (5400m/17500’) and the views were amazing, the best I have ever had in Nepal. If you are planning a trip to Nepal, make Gokyo your base and Everest Base Camp your secondary target.

The cool thing about being on top of Gokyo Ri is that you have a 360 paranoiac view of the Everest portion of the Himalayan Range. Here is a video I shot trying to show it off.

We started the climb at 5:15am, I argued with Ngima Sherpa and Kathleen about that, but lost. We got up in about 1.5 hours, just in time for the sunrise. While that is cool, the sun rises directly over Mt. Everest, so the photos (and video above) are not perfect. Sorry, if you want to see a better show of Everest, you will just have to climb Gokyo Ri as well. ;)

After a short rest, we trekked to a village below the Cho la pass (5400m/17500’). The pass was very, very hard, straight up in the snow for over an hour, a lot of the time you are on your hands and knees.

Look at me climb (Yes the is Bollo Sherpa behind me, he did it in sneakers):

Our shepra’s are too cool for school on top of the pass. (But they did take the Cliff bars I gave them.)

The view from the pass is pretty stunning:

Once you are up over the pass you think the hard part is over, right? Ha! Now you have to walk in-between two Himalayan peaks (taller than anything other than about 15 mountains in the world) in the snow over a crevasse ridden field. (Thank god for my  crevasse rescue training in Alaska! I had to teach Kathleen how to probe for crevasses!)

After a few hours in the snowfield, we finally reached our destination. After about 7 hours of climbing and trekking, it was about 1pm (we started super early to avoid the wind and sun making the crevasses unstable.) After lunch, we pushed on 3 more hours to Loboche village at about 5000m/16000’.

The next day we pushed on to Everest Base Camp and then headed down the mountain.

A few days later we were back in Kathmandu dreaming about our next Nepalese trek!

On Monday I am leaving for a 3 week trek to visit the Hillary School in Kumjum, Nepal as well as Everest Base Camp. The goal of this trip is to raise money for the Education Elevated charity that I have been working with (see last year’s school work project write up here.)

We’ve raised a ton of money so far, but you can still donate here. For those of you who have donated already, thanks!

See you when I am off the mountain. ;)

If you use Telerik software, why not tell the world how much by voting for the 2010 DevProConnections Community Choice Awards. Voting is open now and Telerik is nominated in 16 of the total 26 categories! While it’s great to take home awards like our recent Best of TechEd 2010 trophy, there is something unique about letting the voters on the Interwebs determine your fate.

What do you need to do? Vote today!

And then remind your co-workers, Twitter followers, Facebook friends, LinkedIn connections, DNUG members, and anyone else you see to vote in this year’s awards, too. To help you successfully cast your ballot for Telerik’s nominations this year, here is a quick voting guide for the categories where you’ll find us:

• Category (Telerik Product)
• Add-In (Telerik JustCode)
• Charting & Graphics Tool (Telerik RadChart for ASP.NET AJAX)
• Community Resource (Telerik’s Community )
• Component Set (Telerik RadControls for ASP.NET AJAX)
• Content Management System (Telerik Sitefinity Web CMS)
• Grid (Telerik RadGrid for ASP.NET AJAX)
• Navigation Control (Telerik RadMenu for ASP.NET AJAX)
• Online Editor (Telerik RadEditor for ASP.NET AJAX)
• Printing/Reporting Tool (Telerik Reporting)
• Project Management/Defect Tracking (Telerik TeamPulse)
• Scheduling/Calendar Tool (Telerik RadScheduler for ASP.NET AJAX)
• Silverlight Product (Telerik RadControls for Silverlight)
• Testing/QA Tool (Telerik WebUI Test Studio)
• Training (Telerik Training)
• Utility (Telerik OpenAccess ORM)
• Free Tool (Telerik OpenAccess ORM Express)

Vote in the DevProConnections Community Choice Awards. (Voting closes September 21st.)

On Saturday, November 6th, 2010, from 8:00 AM until 6:00 PM, the Fairfield / Westchester developer community will be holding their 4th annual Code Camp! The event will be hosted by CITI, a unit of The University of Connecticut School of Business, on the Stamford, CT Campus.

The continuing goal of the Code Camps series is to provide an intensive developer-to-developer learning experience that is fun and technically stimulating. The primary focus is on delivering programming information and sample code that can be put to practical use. The event is free.

This is an event by the developer community, for the developer community. The content is original and developed by you. Let's work together to make this event a success.
To apply for a speaking slot, please first register as a speaker here: http://bit.ly/fwccspeaker.

Then, with the email address you registered with on the speaker page, please add as many abstracts as you’d like here: http://bit.ly/fwccsession. Submit on anything you’d like related to .NET development.

Thursday, September 16, 2010
Paul Sheriff: Unit Testing Basics in Visual Studio

Subject:
You must register athttps://www.clicktoattend.com/invitation.aspx?code=149443 in order to be admitted to the building and attend.
Everyone knows that they should be writing better test cases for their applications, but how many of us really do it? In Visual Studio unit testing is an integrated part of the development environment. So there is no longer any reason to avoid not doing test driven development and automated unit testing. In this seminar you will learn how to architect your applications to make testing quicker and easier. You will learn to use the tools in Visual Studio to help you do the testing.
You will Learn
1. How to architect for test driven development
2. Creating test cases
3. Using the Visual Studio Unit Testing tools.

Speaker:
Paul D. Sheriff is the President of PDSA, Inc. (www.pdsa.com), a Microsoft Partner in Southern California. Paul acts as the Microsoft Regional Director for Southern California assisting the local Microsoft offices with several of their events each year and being an evangalist for them. Paul has authored literally hundreds of books, webcasts, videos and articles on .NET, WPF, Silverlight and SQL Server. Paul can be reached via email at PSheriff@pdsa.com. Check out Paul's new code generator 'Haystack' at www.CodeHaystack.com.

Date:
Thursday, September 16, 2010

Time:
Reception 6:00 PM , Program 6:15 PM

Location: 
Microsoft , 1290 Avenue of the Americas (the AXA building - bet. 51st/52nd Sts.) , 6th floor

Directions:
B/D/F/V to 47th-50th Sts./Rockefeller Ctr
1 to 50th St./Bway
N/R/W to 49th St./7th Ave.

See also:

• Part I: When to build your data warehouse
• Part II: Building a new schema
• Part III: Location of your data warehouse
• Part IV: Extraction, Transformation, and Load

In Part I we looked at the advantages of building a data warehouse independent of cubes/a BI system and in Part II we looked at how to architect a data warehouse’s table schema. In Part III, we looked at where to put the data warehouse tables. In Part IV, we are going to look at how to populate those tables and keep them in sync with your OLTP system. Today, our last part in this series, we will take a quick look at the benefits of building the data warehouse before we need it for cubes and BI by exploring our reporting and other options.

As I said in Part I, you should plan on building your data warehouse when you architect your system up front. Doing so gives you a platform for building reports, or even application such as web sites off the aggregated data. As I mentioned in Part II, it is much easier to build a query and a report against the rolled up table than the OLTP tables.

To demonstrate, I will make a quick Pivot Table using SQL Server 2008 R2 PowerPivot for Excel (or just PowerPivot for short!). I have showed how to use PowerPivot before on this blog, however, I usually was going against a SQL Server table, SQL Azure table, or an OData feed. Today we will use a SQL Server table, but rather than build a PowerPivot against the OLTP data of Northwind, we will use our new rolled up Fact table.

To get started, I will open up PowerPivot and import data from the data warehouse I created in Part II. I will pull in the Time, Employee, and Product dimension tables as well as the Fact table.

Once the data is loaded into PowerPivot, I am going to launch a new PivotTable.

PowerPivot understands the relationships between the dimension and fact tables and places the tables in the designed shown below. I am going to drag some fields into the boxes on the PowerPivot designer to build a powerful and interactive Pivot Table. For rows I will choose the category and product hierarchy and sum on the total sales. I’ll make the columns (or pivot on this field) the month from the Time dimension to get a sum of sales by category/product by month. I will also drag in Year and Quarter in my vertical and horizontal slicers for interactive filtering. Lastly I will place the Employee field in the Report Filter pane, giving the user the ability to filter by employee.

The results look like this, I am dynamically filtering by 1997, third quarter and employee name Janet Leverling.

This is a pretty powerful interactive report build in PowerPivot using the four data warehouse tables. If there was no data warehouse, this Pivot table would have been very hard for an end user to build. Either they or a developer would have to perform joins to get the category and product hierarchy as well as more joins to get the order details and sum of the sales. In addition, the breakout and dynamic filtering by Year and Quarter, and display by month, are only possible by the DimTime table, so if there were no data warehouse tables, the user would have had to parse out those DateParts. Just about the only thing the end user could have done without assistance from a developer or sophisticated query is the employee filter (and even that would have taken some PowerPivot magic to display the employee name, unless the user did a join.)

Of course Pivot Tables are not the only thing you can create from the data warehouse tables you can create reports, ad hoc query builders, web pages, and even an Amazon style browse application. (Amazon uses its data warehouse to display inventory and OLTP to take your order.)

I hope you have enjoyed this series, enjoy your data warehousing.