# Monday, March 19, 2012

After a successful TechDays Hong Kong the week before last, I am off to Bangalore today to speak at Tech Ed India 2012! Besides the usual running around and talking with customers, partners, attendees, and MVPs, I’ll be doing three breakout sessions:

Wednesday @ 12:15 : Beyond Scrum: Kanban and Software Kaizen

This is a slight modification of my Introduction to Kanban talk, here are the slides for that one:

On Wednesday afternoon at 2:15, I’ll be doing a session on Big Data Processing with SQL Server 2012 and Hadoop. I don’t really have any slides for this one besides a few from MS DPE, I plan on using all my time in demos. I’ll be talking about Hadoop on Azure, columnstore indicies, data warehouse improvements, and other things that will help you deal with large amounts of data like table partitioning (I know, I know, “Big Data” does not always mean “Big” data. Smile ) This will be a fun session, come see me screw up some live demos. Smile

Lastly, on Thursday at 4:30, I’ll be doing a session on Agile Estimation. I’ve done this one in India a few times before, but my first time at TechEd India. Here are the slides:

If you can’t make that session, I did it last year at TechEd North America and it was live streamed, so the recording is here:

See you all in Bangalore!

posted on Monday, March 19, 2012 2:52:59 AM (Eastern Daylight Time, UTC-04:00)  #    Comments [1] Trackback
# Friday, November 05, 2010

At TechEd Europe 2010 in Berlin, I will be doing three breakout sessions and one panel discussion: Silverlight v HTML5.

My breakout sessions are:

  • Scrum, but
  • Agile Estimation

This is the first time I am formally doing the Scrum, but session, however, Joel and I did it at TechEd North America at our pre-con. We’ll (I invited Joel, even though he is not an “official” speaker to do the session with me) walk the audience through a few slides about Scrum, Kanban, XP and “Agile is about values, not rules” and the “buffet table” approach. After about 10 minutes of us blabbing, we will open it to questions. We are prepared to speak about four scenarios: Scrum/Agile in the Enterprise, Consulting, Remote (and outsourced) teams, and ISVs. Should be fun, and interactive! Bring lots of questions!!!

The Agile Estimation talk is a repeat of my talk last year and we are doing it twice since there is a lot of demand.

The session times are below. When I am not doing sessions, I will be at the Telerik Booth. You can find us at E 83+E84, very close to where we were last year. I’ll be glad to talk to you about the sessions, agile in general, or the Telerik tools. If you check out our CTP of WP7 controls now, we have a special offer for you: As a special gift to all TechEd Europe attendees visiting our booth, you will receive a free license of these controls once they are finally released, if you download the CTP now.

See you in Berlin! Winking smile

Code

Session

Day

Time

DPR301

Scrum, but

Breakout Session

Stephen Forte

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.

Tuesday, November 9

2:30 PM - 3:30 PM

DPR201

Agile Estimation

Breakout Session

Stephen Forte

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.

Thursday, November 11

12:00 PM - 1:00 PM

DPR201 (R)

Agile Estimation (repeat)

Breakout Session

Stephen Forte

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.

Thursday, November 11

6:00 PM - 7:00 PM

posted on Friday, November 05, 2010 5:16:58 AM (Eastern Daylight Time, UTC-04:00)  #    Comments [2] Trackback
# Thursday, November 04, 2010

There has been a lot said about the HTML5 v Silverlight debate in recent days. We have a very timely BOF session at TechEd Europe next week on this very topic. Join Tomislav BronzinMauro Sant'Anna, Joel Semeniuk, David YackDaron Yondem, and myself for a smack-down no holds barred panel discussion on Tuesday November 9th. It will be moderated by Tim Huckaby.

BOF10: Silverlight vs. HTML5 - Interactive Panel

Tuesday, November 9  1:20 PM - 2:05 PM

Join Tim Huckaby as he moderates a distinguished panel of Microsoft Regional Directors and some other pillars of the industry in a interactive panel discussion around the issues, excitement, bold promise and confusion around SilverLight and HTML5.

posted on Thursday, November 04, 2010 4:55:06 AM (Eastern Daylight Time, UTC-04:00)  #    Comments [0] Trackback
# Monday, June 14, 2010

Last week at TechEd North America I did DEV303, Building RESTful Applications with the OData Protocol. I really enjoy doing this session since I get to code on the fly and talk about building applications. At a high level we covered:

  • What is REST, comparison to Web Services (REST is resource based, Web Services is RPC/method based)
  • What is OData, who is using it
  • When to use OData vs RIA Services (OData is for exposing data as a service across boundaries, RIA is for a VB6 style RAD application development)
  • Using WCF Data Services to build an OData Service
  • Consuming the WCF Data Service in Silverlight asynchronously –yes everyone had to suffer and watch me code
  • A Bill Gates joke
  • WCF Data Services Service Operations, Data Interceptors (Query and Change), Data paging
  • Consuming OData Services in ASP.NET (select and add, we even got to see my custom error raise)

You can download the slides and code here.

posted on Monday, June 14, 2010 8:25:55 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [0] Trackback
# Thursday, June 10, 2010

Telerik won the “Best of TechEd” award in the “Best Components and Middleware” category last night at TechEd in New Orleans, LA. Our premium collection was judged as the most innovative and best value over all the other vendors.

All 200+ of the Telerik employees around the world feel honored and those of us here of course took time to celebrate on Bourbon street. Now we’re back to work and hope to live up to our customers high expectations. (If you are still at TechEd, swing by the booth and take a look at the award, we are here until 3pm today when the Expo closes.)

Thanks again to all of our customers, you make us better and we do it for you.

31691_1451994147381_1459091054_31166546_61564_n

Here are the Telerikers left standing late last night in the French Quarter in New Orleans.

posted on Thursday, June 10, 2010 12:34:20 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [0] Trackback
# Monday, June 07, 2010

Yesterday Joel and I did the day long Agile precon at TechEd in New Orleans, LA. We had a great crowd and were able to keep them engaged for 8 hours. You can download the materials here.

We used an “Agile presenting” technique where we put the agenda in an “Agenda Backlog” and we reprioritized after every sprint (agenda item) and let the audience decide what we would talk about next. To our surprise the audience voted against two planned sections and we did two new sections on the fly. We talked about:

  • Agile theory and agile methodologies (XP, Scrum, FDD, DSDM, *DD, Kanban, etc)
  • Intro to Scrum
  • Agile Estimation
  • Challenges to Implementing Agile in General
  • Challenges to Implementing Agile: In the Enterprise
  • Challenges to Implementing Agile: Remote Teams
  • Tools
  • QA and Documentation

We got into a discussion on what happens when the team finishes early, do you stop the sprint, or give them more work to do. (Joel and I both go against the agile literature and give the team more work!)

We also took a few micro-breaks to rest our brain to talk about the iPhone v Android, how I buy Joel clothes, and movie quotes from the Matrix (I know Kung Fu) and What about Bob (Baby Steps).

We also recommended a book, one of my favorite management books of all time: Peopleware. For those of you non-techies reading this blog (I don’t know why!) if you manage teams, this book is also for you.

Hope to do this seminar again soon!

posted on Monday, June 07, 2010 12:04:51 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [1] Trackback
# Friday, June 04, 2010

While connecting flights in Japan today en route to TechEd, the security wanted to re-run my bag. They kinda freaked out as to what was in it. They took everything out that was electronic and ran it again. The electronics took three bins, here is what it was:

  • Dell laptop
  • Laptop plug
  • Adapter (my plug uses Hong Kong prongs)
  • Cat5 wire
  • USB external hard drive
  • Wireless mouse
  • Kindle
  • Kindle wire
  • Bose noise cancellation headphones
  • Zune
  • Zune wire
  • Canon G10 Camera
  • Camera battery charger
  • Camera wire
  • Android Nexus One Phone
  • Charger

By now the only thing left in the bag was my notebook, business cards, a pen, and my passport. I would have taken a photo but they had my camera!

posted on Friday, June 04, 2010 6:31:17 AM (Eastern Daylight Time, UTC-04:00)  #    Comments [1] Trackback
# Tuesday, June 01, 2010

I’ll be speaking at TechEd North America in New Orleans next week and hope to have a front row seat to some Microsoft announcements. Microsoft practices CDD or “Conference Driven Development” where major announcements have been made only at large trade shows like PDC, MIX, and TechEd. Since there is no PDC this year, TechEd is an opportunity for Microsoft to make some BI, developer or IT pro announcements. There are two keynotes by “Microsoft executives” and I’ll be looking (hoping) for Microsoft to make the following announcements, in order of probability:

iPhone Development Kit

This one has been rumored for a while. While I am sure we may see some kind of minor Windows Phone 7 announcement at Teched, is there going to be an iPhone SDK for Silverlight and Visual Studio 2010?

Azure Pricing Changes

Windows Azure seems to have been accepted by the Tech community as something that is well architected and very stable, but the general consensus is that it is a tough sell to customers privacy/cloud wise and cost wise. While I don’t have a major problem with Azure pricing, it could have more competitive pricing plans in place in order to do a land grab on adoption.

Silverlight 5.0 Roadmap

It is too early for a beta, but it would be great to have some info on Silverlight 5.0, what it will support, what it will look like, etc. Microsoft has been so quick to ship new iterations of Silverlight that people expect the same out of Silverlight 5.0. For example, Silverlight 2.0 shipped in October 2008 and Silverlight 3.0 beta appeared in March 2009, only 5 months later. Silverlight 3.0 shipped in July 2009 and Silverlight 4.0 beta 1 shipped in November 2009, only 4 months later. Silverlight 4.0 shipped in April 2010, so June 2010 is a reasonable timeframe for Microsoft to talk about Silverlight 5.0 features and design goals, if not a beta timetable.

Windows 8 Sneak Peek

OK I admit it, I love Win7 and have zero complaints or don’t even have a wish list for Win8. But it is the geek inside of me that wants a sneak peek of Win8. I am pretty sure that this will not happen, but Vista shipped in January 2007 and we had an alpha in October 2008, so not unheard of. I don’t need an alpha, just a sneak peek.

SQL Server 2012 Info

Ok, if it too soon to talk about Silverlight and Windows, then why not SQL Server 2012? TechEd is more of an IT Pro conference and it is co-located with the BI Conference, so maybe, just maybe we will get some info on SQL.next.

Steve Ballmer’s Retirement

Don’t laugh. At TechEd in Boston in 2006 it was announced that Bill Gates was retiring. Steve has been in charge a long time, while I don’t expect a leadership transition at this point in time, you never know.

Free Windows 7 Phone

Hey, Google gave out new Android phones at I/O twice. Microsoft gave us all a tablet at the PDC. Why not a phone?

posted on Tuesday, June 01, 2010 10:52:51 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [0] Trackback
# Tuesday, May 25, 2010

Let’s face it, going to a technical conference is good for your career but it’s not a whole lot of fun. You need an outlet. You need to have fun.

Cheap beer and lousy pizza (with a New Orleans twist)

We are bringing back GeekFest! Join us at Pat O’Brien’s for a night of gumbo, beer and hurricanes. There are limited invitations available, so what are you waiting for? If you are attending the TechEd 2010 conference and you are a developer, you are invited. To register pick up your "duck" ticket (and wristband) in the TechEd Technical Learning Center (TLC) at the Developer Tools & Languages (DEV) information desk.

You must have wristband to get in.

Tuesday, June 8th from 8pm – 11pm
Pat O’Brien’s New Orleans
624 Bourbon Street New Orleans, LA 70130

posted on Tuesday, May 25, 2010 1:47:13 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [0] Trackback
# Thursday, April 22, 2010

Last week I spoke at TechEd India and the Visual Studio 2010 launch. It was a great event with over 3,000 attendees, far more than attended the Visual Studio launch in Las Vegas! Senior vice president of the Developer Division at Microsoft, S. Somasegar, did an awesome keynote. I did three sessions:

  • Building applications with OData
  • Building Line of Business Applications with WCF and Silverlight 4.0
  • Building Silverlight Business Applications with RIA Services

Something happened to me that never happened before in my 13+ years of being a professional international speaker: I lost my voice! I was in Indonesia the week before and picked up a small bug and had no voice. This was a new challenge for me, and Microsoft offered to cancel my sessions, but I figured why would I let no voice stop me from delivering my sessions!! So I decided to throw away the slides and just code. I had no voice anyway, so I spoke the universal geek language of code.

I think that the sessions went very well, however, since the code was written on the fly, I don’t have full demos available to download. For the RIA services talk, I ripped off Brad Abrams blog here and basically showed items 1-5, and 8-9. For the WCF/Silverlight session, I ripped off myself, you can see a walk through here on my blog (substitute the music data in my blog with IPL cricket teams since that is what I did in India). For the OData session, I have written a ton on data services here on my blog, and check back after TechEd USA and I will post a full demo with Silverlight 4.0 and the new OData client (which shipped yesterday.)

At TechEd, Telerik also had a booth and I tried to help out the best I could with no voice. We were bum-rushed for the free tee-shirts and we gave away about 300 tee shirts in about 1 minute.

2010-04-13 16.38.42

Telerik also had a party with the Indian MVPs at the Opus Lounge in Bangalore and we had some tee shirts for the MVPs. We made them put them on right there. :)

2010-04-14 20.12.25

We had some epic karaoke and I continued my tradition of singing with an MVP Lead female songs as Abhishek Kant and I sang “Like a Virgin” to bring down the house. What little I had of my voice was now completely gone!

2010-04-14 21.43.23

See you next year TechEd India!

posted on Thursday, April 22, 2010 4:33:08 AM (Eastern Daylight Time, UTC-04:00)  #    Comments [0] Trackback
# Monday, April 12, 2010

I’ll be speaking at TechEd India and the Visual Studio 2010 Launch in Bangalore, India this week. I’ll be doing three sessions:

In addition, Team Telerik will be staffing a booth with Tee-shirts (hopefully if they get out of customs on time!) and live demos of our products and our brand new product to be announced today! See you at my sessions or at the booth!

Technorati Tags: ,

Bookmark and Share
posted on Monday, April 12, 2010 6:13:22 AM (Eastern Daylight Time, UTC-04:00)  #    Comments [2] Trackback
# Saturday, February 06, 2010

Check out my pre-con at TechEd North America, Joel and I will be speaking on Agile. Register here. :)

PRC07 The Agile Methodology Demystified: Implementing Agile in Your Organization

Track: Development Practices

Speaker(s): Joel Semeniuk, Stephen Forte

Agile project management and development methods are being adopted at many development shops. After an introduction to the basics of Agile and Scrum, including: project planning and estimation, the Scrum Master, team, product owner and burn down, and of course the daily Scrum, certified scrum masters Stephen and Joel show many real-world applications of the methodology drawn from their own experience. Negotiating with the business, estimation, and team dynamics are all discussed as well as how to use Scrum in small organizations, large enterprise environments, and consulting environments. Next we discuss using Scrum with virtual teams and an off-shoring environment. We then take a look at some of the planning tools we will use for Agile Estimation, including planning poker, Microsoft Visual Studio Team Foundation Server 2010, and much more. We dive into some agile developer techniques such as TDD, Continuous Integration, and Dependency Injection, and round out the pre-con with a discussion on Agile developer tools and how they can help (and sometimes hinder) the development process. The speakers have a very interactive style so participation is encouraged and there will be plenty of time for Q&A. This seminar is a jump start for preparing for a scrum master certification.

 

Technorati Tags:

Bookmark and Share
posted on Saturday, February 06, 2010 3:56:32 AM (Eastern Standard Time, UTC-05:00)  #    Comments [0] Trackback
# Wednesday, November 11, 2009

For me at least. After delivering three sessions at TechEd Europe, I have to turn around and head home and then turn around and head out to the PDC (I have an agile birds of a feather session there, more info later.)

It was great speaking and I also helped out at the Telerik booth. During the slow time, the whole team took a break and were brave enough to trust me to manage the booth all by myself. (I did not break anything!)

See you all next year!

posted on Wednesday, November 11, 2009 8:51:26 AM (Eastern Standard Time, UTC-05:00)  #    Comments [0] Trackback
# Saturday, November 07, 2009

Next week I will be speaking at one of my favorite events, TechEd Europe, this year held in Berlin. While Barcelona is still my favorite city in the world, I am glad that we are in Berlin this year, since Monday is the 20th anniversary of the Berlin Wall falling, and our world changing forever.

I will be speaking on:

I speak on Tuesday and Wednesday, and the event is SOLD OUT. I hope you were lucky enough to get a ticket. I’ll be hanging out at the Telerik booth when I am not speaking if you want to come and say hi.

image

Technorati Tags: ,
posted on Saturday, November 07, 2009 3:17:24 AM (Eastern Standard Time, UTC-05:00)  #    Comments [0] Trackback
# Saturday, May 30, 2009

Here is the code from Mary and my session about building front ends to SQL Server with spending any money. It is an Access 2007 Front end that consumes the Twitter RESTful API and eventually allows the user to augment that data in Access then dump it back into a SQL Server table via a SQL TVP. Pretty cool.

posted on Saturday, May 30, 2009 7:25:49 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [0] Trackback
# Thursday, May 14, 2009

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

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

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.

posted on Thursday, May 14, 2009 5:43:49 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [0] Trackback
# Wednesday, May 13, 2009

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…

posted on Wednesday, May 13, 2009 10:12:41 AM (Eastern Daylight Time, UTC-04:00)  #    Comments [0] Trackback
# Monday, May 11, 2009

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

posted on Monday, May 11, 2009 11:33:46 AM (Eastern Daylight Time, UTC-04:00)  #    Comments [0] Trackback
# Monday, May 04, 2009

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

DPR206
Tech·Ed Daily Scrum
Stephen Forte
5/13/2009 10:15AM-11:30AM
Room 515B


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

PAN58
Migrating Your Data Tier to SQL Server: Strategies for Survival
Armen Stein; Luke Chung; Mary Chipman; Richard Campbell; Stephen Forte
5/13/2009 9:00AM-10:00AM
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


posted on Monday, May 04, 2009 6:47:50 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [0] Trackback
# Thursday, April 23, 2009

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.

posted on Thursday, April 23, 2009 10:27:03 AM (Eastern Daylight Time, UTC-04:00)  #    Comments [0] Trackback
# Monday, April 06, 2009

clip_image002

Let’s face it, going to a technical conference is good for your career but it’s not a whole lot of fun. You need an outlet. You need to have fun.

Cheap beer and lousy pizza.

We are bringing back GeekFest! Join us at Lucky Strikeclip_image003 for a night of pizza, beer, and bowling. There is limited invitations available, so what are you waiting for? If you are attending the TechEd 2009clip_image003[1] conference and you are a developer, you are invited. To register pick up your "duck" ticket (and wristband) in the TechEd Technical Learning Center (TLC) at the Developer Tools & Languages (DTL) information desk.

You must have wristband to get in.

Monday, May 11, 2009 from 8pm – 11pm
Lucky Strike Lanes at LA Live
800 W. Olympic Blvd Los Angeles, CA 90015

You must have a wristband to attend the party. Pick one up Monday at the Developer Tools and Languages TLC Info Counter.

posted on Monday, April 06, 2009 10:06:30 AM (Eastern Daylight Time, UTC-04:00)  #    Comments [0] Trackback
# Thursday, January 29, 2009

Mary Chipman and I are doing a talk together at TechEd in Los Angeles this May on building solutions “without spending any money.” One of the tricks we will show is using an Access front end utilizing TVPs from the back end SQL Server. She posted a blog on the Access team’s blog about it yesterday. Check it out here.

posted on Thursday, January 29, 2009 1:37:56 PM (Eastern Standard Time, UTC-05:00)  #    Comments [0] Trackback
# Tuesday, November 25, 2008

They filmed my talk at TechEd last week and made if available on the internet. You can watch here. Unfortunately the video of the code (about 85% of the session) is not as clear as I would like but you should be able to see it.

posted on Tuesday, November 25, 2008 9:56:58 AM (Eastern Standard Time, UTC-05:00)  #    Comments [1] Trackback
# Thursday, November 13, 2008

After 4 days at TechEd here in Barcelona, I have done 6 sessions and have 2 to go tomorrow. They are:

DAT02-IS

Data Access Smackdown

Interactive Session

Database Platform

11/14/2008   10:45AM - 12:00PM

DVP04-IS (R)

Tech·Ed Daily Scrum!

Interactive Session

Development Practices

11/14/2008   3:15PM - 4:30PM

posted on Thursday, November 13, 2008 10:06:13 AM (Eastern Standard Time, UTC-05:00)  #    Comments [0] Trackback
# Monday, November 10, 2008

A lot of RDs arrived in Barcelona yesterday to start TechED Europe 2008. We went out for some tapas and sangria last night and the bill came to 779 euros. What happens when you get 15 RDs trying to split the bill with their credit card? Chaos.

 

bill

posted on Monday, November 10, 2008 10:05:26 AM (Eastern Standard Time, UTC-05:00)  #    Comments [2] Trackback
# Saturday, November 08, 2008

Here is a cool TSQL tip I will be showing off next week at TechEd Europe at one of my sessions (Rock Star Common Table Expressions).

Let’s say you have a product table that looks like this:

image

As you can see in the image, we have some duplicate data. You can use a Common Table Expression in SQL Server 2005 or 2008 to look up the “parents” using an aggregate HAVING clause. Then you join to the CTE to the Product table on the Product_Name field as well as the Product_ID field, but using the > indicator, so we only return the “children” or products with a higher product ID. Here is the CTE and code:

--Find the Dupes with a CTE

WITH CTEMinProductRecords

AS

(

 SELECT MIN(Product_ID) AS Product_ID, Product_Name

 FROM Products

 GROUP BY Product_Name

 HAVING COUNT(*) > 1

)

SELECT cte.Product_ID as DupeProductID,

cte.Product_Name as DupeProduct,

p.Product_ID as ParentID, p.Product_Name as ParentProduct,

p.Price as ParentPrice

FROM Products p

JOIN CTEMinProductRecords cte ON

 p.Product_Name = cte.Product_Name

 AND p.Product_ID > cte.Product_ID

Here are the results:

image

Let’s say you want to automatically delete the children. While the business case for this may exist (my old business did have a rule, the higher product id was the dupe), you will want to update all of the “many” tables to the lower product ID first. To then do the delete using the CTE all you have to do is convert the above select statement to a delete statement:

WITH CTEMinProductRecords

AS

(

 SELECT MIN(Product_ID) AS Product_ID, Product_Name

 FROM Products

 GROUP BY Product_Name

 HAVING COUNT(*) > 1

)

DELETE Products

FROM Products p

JOIN CTEMinProductRecords cte ON

 p.Product_Name = cte.Product_Name

 AND p.Product_ID > cte.Product_ID

Enjoy!
posted on Saturday, November 08, 2008 4:30:25 PM (Eastern Standard Time, UTC-05:00)  #    Comments [2] Trackback
# Friday, November 07, 2008

I am a data guy. Maybe that is why the NHibernate Mafia likes to cal me a database weenie. Next week at TechEd Europe I am doing 5 sessions about data. Friday morning I am doing DAT02-IS Data Access Smackdown. As I said before, it is not really a smackdown, but a look at the SP1 technology and then have a discussion on how best to make choices about which technology to use in your projects. One of the things that I love is data as a service. That is one reason why I am so solidly behind the Astoria Project at Microsoft (aka ADO .NET Data Services.)

One thing that I show in the Smackdown session is a simple LINQ to REST demo. Using LINQ you can go against a raw REST based data service. (You can also do this via a proxy, which I will also show at the session and at a later blog post.)

I have a simple Astoria service here. Let’s take a look at how to talk to it via LINQ to REST. First you have to set a reference to System.Data.Services.Client and then pull in the namespace like so:

using System.Data.Services.Client;

Next you have to create an anonymous type to hold your data. Since we are modeling the Customer entity in my Astoria service you have to model the type to have exactly the same data types:

public class Customer

    {

        public string CustomerID { get; set; }

        public string CompanyName { get; set; }

        public string ContactName { get; set; }

        public string ContactTitle { get; set; }

        public string Address { get; set; }

        public string City { get; set; }

        public string Region { get; set; }

        public string PostalCode { get; set; }

        public string Country { get; set; }

        public string Phone { get; set; }

        public string Fax { get; set; }

 

    }

Next inside of a console application we create a new Uri to point to the Astoria service on my server. Then we will query the service using the Astoria Uri syntax ?$filter= and add that to the Uri. After that is real simple, just loop through the customers and do whatever you want with them. Pretty easy! In a future blog post I will show you how to use the traditional LINQ operands (from, where, select) against an Astoria service.

static void Main(string[] args)

        {

            Console.Title = "Linq to Rest!!";

 

            Uri url = new Uri("http://stevef.goes.com/northwindservice/NorthwindService.svc/");

 

            DataServiceContext ctx = new DataServiceContext(url);

 

            IEnumerable<Customer> customers = ctx.Execute<Customer>(

                New Uri("Customer?$filter=Country%20eq%20'Germany'", UriKind.Relative));

 

            //write it out to the console window

            foreach (var c in customers)

            {

                Console.WriteLine(c.CompanyName);

            }

            //keep the window open

            Console.Read();

        }

posted on Friday, November 07, 2008 11:44:44 AM (Eastern Standard Time, UTC-05:00)  #    Comments [1] Trackback
# Thursday, November 06, 2008

Next week at TechEd Europe I will be doing two talks on Scrum (with one repeat) and we are trying something new at TechEd this year, so let me know what you think.

The talk on Tuesday, DVM309: Using Scrum to Run Your Projects, is a typical TechEd breakout session in lecture format with Q&A encouraged. I’ll go through slides and examples from my experience as a scrum master (and also share some of my experiences from the certified scrum master class.) This is a good overview of Scrum good for beginners or experienced scrum masters trying to scale out scrum.

On Tuesday and Friday we turn the tables in DVP04-IS: The Tech*Ed Daily Scrum! This is an interactive session where I will be passing around a microphone and it will be 100% Q&A, war stories, and interactive, no slides if I can help it. (Come on, ask a lot of questions, tell a lot of war stories make my week a little easier!) I have done the “Daily Scrum” talk about 10 times this year in several places (New York, TechEd US in Orlando, Egypt, Pakistan, Netherlands, Bulgaria, Serbia, Connecticut .NET User Group, etc) and every time it is different and exciting. I always learn something from the audience as well. Everyone is welcome, you will see how Scrum works in the real world as well as real life implementations. Since it is mostly interactive, it is great for people who want to learn about scrum, as well as experts in Scrum. My only rule is no religious warfare, other than that, anything goes! (Just ask the Serbians, it was also the last session of their conference and we all drank beer as we did the Q&A.)

See you all there… If you can’t make it, I hope they will film it and put it online.

posted on Thursday, November 06, 2008 8:20:19 AM (Eastern Standard Time, UTC-05:00)  #    Comments [0] Trackback
# Wednesday, November 05, 2008

Yesterday I showed how there are some new language constructs in TSQL that will be very familiar to C# developers. I will be doing three talks on TSQL next week at TechED Developers in Barcelona and the talks are designed for application developers. (But database geeks will enjoy these sessions as well!) If you write any TSQL code in your applications today, or interact with it, these sessions will give you some advice and help change the way you approach particular problems.

Today I want to show a new feature about using Table Valued Parameters (TVP) in a stored procedure and then calling it from an ASP .NET page or any other .NET client using ADO.NET. A TVP is new in SQL Server 2008, so you can now declare a type of TABLE, insert data into it, and then pass it to a stored procedure. Have you ever passed in a CSV string to a DAL or stored procedure or even an XML data type, then parsed it and executed some SQL? TVP will eliminate that.  Here is an example:

First create a new table for us to play with:

Create Table TVP_TEST

(Field_ID int primary key, Field_DESC varchar(10))

Next create the TVP by declaring a new type. Notice that I have created the type to be exactly the same shape as the underlying table, this is not a requirement, however, it is important to do so if you are going to be doing inserts as we do below.

 

CREATE TYPE TVP_TESTType AS TABLE(

     Field_ID int,

     Field_DESC varchar(10))

 

Next create a variable as type TVP_TESTType and insert some data into it, insert is done the same way we would add data to a normal table. Notice that this only puts data into the variable, NOT the underlying table:

--put data into the type

DECLARE @MyTable as TVP_TESTType

 

--put data into the type

INSERT INTO @MyTable VALUES

     (1, 'Test'), (2, 'Next Test')

 

Now you can insert data into a table very easily (remember @MyTable has to be in scope):

INSERT INTO TVP_TEST

     SELECT * FROM @Mytable

 

To get really useful, let’s create a stored procedure that will accept as a parameter the TVP_TESTType data type and insert data into the TVP_TEST table using the parameter, notice no parsing of CSV strings, etc:

CREATE PROCEDURE usp_ins_MyTable

(@MyTVP as TVP_TESTType READONLY)

As

INSERT INTO TVP_TEST

     SELECT * FROM @MyTVP

You can call this stored procedure as so, as long as @MyTable is in scope and is filled with data:

 

exec usp_ins_MyTable @MyTVP=@MyTable

But what is really exciting is calling this data from a .NET client. If you have an ADO .NET dataset that is the same shape of the TVP you can pass it in from the client to the server, greatly enhancing data access and batch operations.You can pass in a dataset as a parameter using the SqlDbType.Structured as its data type.

 

Here is some code from C#, just remember that ds is our active dataset filled with data and shaped the same way as TVP_TESTType:

 

SqlCommand cmd = new SqlCommand("usp_ins_Portfolio", conn);

cmd.CommandType = CommandType.StoredProcedure;

//add the ds here as a tvp

SqlParameter sp = cmd.Parameters.AddWithValue("@Portfolio", ds.Tables[0]);

//notice structured

sp.SqlDbType = SqlDbType.Structured;

cmd.ExecuteNonQuery();

Pretty easy! Now you can pass data sets in as parameters to a stored procedure, eliminating some funky parsing on either the client or server.

posted on Wednesday, November 05, 2008 10:59:27 AM (Eastern Standard Time, UTC-05:00)  #    Comments [1] Trackback
# Tuesday, November 04, 2008

I am doing a talk next week at TechED Developers in Barcelona about new TSQL enhancements for developers. The session is:

 DAT313 T-SQL Enhancements in SQL Server 2008 : Getting Down and Dirty. it is Wednesday at 1:30 in room 115.

The goal of this talk is to show you some cool new stuff in TSQL but also to show C# and VB developers that TSQL is not all that bad. I get the impression that developers hate TSQL. :)

So the TSQL designers decided to add a few “delighters” to the syntax to make C# and VB developers feel more at home.

The first is variable assignment at declaration time. For example:

DECLARE @MSFT char(4) = 'MSFT'

Print 'Using: ' + @MSFT

The next is using shortcut syntax like += or –+, etc:

UPDATE Portfolio

     SET Qty += 10

     WHERE Symbol='MSFT'

The addition of Table Value Parameters (TVPs) allows you to pass in datasets via ADO.NET in C#/VB as a parameter to a stored procedure, etc, will really  make C# developers life easier (demo soon on the blog). Also cool integration with Google Maps or Virtual Earth and the geospacial data types will make developing apps with location much easier.

There are lots of other cool new features in there for developers, I will post some more on the blog soon.

posted on Tuesday, November 04, 2008 10:20:51 AM (Eastern Standard Time, UTC-05:00)  #    Comments [0] Trackback
# Friday, October 24, 2008

Over the years I have spoken at over 15 Tech*Eds in North America, Europe, and Asia. My favorite place to speak is hands down Barcelona. Mostly because the good show TechEd Europe puts on, but of also the audience, and the fun city that Barcelona is.

Not so sure I will like it this year, I have eight sessions at TechEd! Wow, they are working me hard. Apparently they are repeating a few sessions due to delegates voting on the sessions, so all I can say is THANK YOU and hopefully you will all get a lot of value from the sessions.

A lot of my sessions are interactive, and I mean that. At the Daily Scrum talks we will be passing around a microphone and it will be 100% Q&A, war stories, and interactive, no slides if I can help it. (Come on, ask a lot of questions, tell a lot of war stories make my week a little easier!) I am a certified Scrum Master and use it every day at Telerik, so if you are just curious, getting started, or in the trenches with Scrum, this is a great session for you. The Using Scrum session is more of an overview, but I would love some interaction and Q&A there as well.

The CTE and T-SQL sessions are brand new content and geared to developers: both application developers (C# and VB) and database developers (T-SQL programmers/DBA types), basically anyone who writes TSQL at some point during the day. (And even thought they are titled 2008, you can use most techniques in SQL 2005.) Hopefully they will not only show you some shortcuts, but also some creative ways of thinking. If you are coming from a strict C# and VB perspective, remember I started my life as a VB 3.0 programmer 15 years ago-not a database/TSQL developer, so I gear the session to a wide audience. In the TSQL Enhancements session, I have some pretty cool ADO. NET shortcuts.

And what is this Smackdown session? It is less of a smackdown and more of an overview of the crazy world of Microsoft Data Access. I was given carte-blanche by the TechEd planners, so anything goes!! I’ll be reviewing all of the SP1 technology (EF, LINQ to Entities, Astoria, LINQ to REST, Dynamic Data) and also take a walk down memory lane to use the historical context to try to predict what is next.  Don’t worry we can talk about the EF Vote of No Confidence and my experiences on the EF Council. I am going to reserve the final 15 minutes or so for a group discussion on the future of data access, is it EF/LINQ, is it ORM, is it EF, or is it something different? We also take a peek at Cloud Data and its role in all of this.

If you make it to Friday afternoon at 3:15 for the Scrum talk, bring beer.We’ll need it.

Here are the sessions:

 

DAT01-IS

T-SQL: Tips and Tricks Sharing Fest!

Interactive Session

Database Platform

11/10/2008   5:45PM - 7:00PM

DVP04-IS

Tech·Ed Daily Scrum!

Interactive Session

Development Practices

11/11/2008   9:00AM - 10:15AM

DVM309

Using Scrum to Run Your Projects

Breakout Session

Developer Managers

11/11/2008   1:30PM - 2:45PM

DAT313

T-SQL Enhancements in SQL Server 2008 : Getting Down and Dirty

Breakout Session

Database Platform

11/12/2008   1:30PM - 2:45PM

DAT404

Rockstar Common Table Expressions in SQL Server 2008

Breakout Session

Database Platform

11/13/2008   9:00AM - 10:15AM

DAT01-IS (R)

T-SQL: Tips and Tricks Sharing Fest!

Interactive Session

Database Platform

11/13/2008   1:30PM - 2:45PM

DAT02-IS

Data Access Smackdown

Interactive Session

Database Platform

11/14/2008   10:45AM - 12:00PM

DVP04-IS (R)

Tech·Ed Daily Scrum!

Interactive Session

Development Practices

11/14/2008   3:15PM - 4:30PM

posted on Friday, October 24, 2008 10:38:12 AM (Eastern Daylight Time, UTC-04:00)  #    Comments [0] Trackback
# Friday, June 06, 2008

My buddy Dan Fernandez filmed me on Channel 9 showing Ranking and Windowing and Common Table Expressions from my TSQL talk this week at TechEd. Apparently our discussion of our partying together in Istanbul, Cairo and Las Vegas was censored by the Channel 9 staff. I guess you will have to just use your imagination on that one. :)

posted on Friday, June 06, 2008 7:46:09 AM (Eastern Daylight Time, UTC-04:00)  #    Comments [0] Trackback
# Tuesday, June 03, 2008

On a panel today about when you should and how you should upsize old Access apps to SQL Server.

Session Title: Are we there yet? Successfully navigating the bumpy road from Access to SQL Server

· Date: 6/3/2008

· Time: 1-2pm

· Location: The Tech·Ed Online stage is on the main show floor, off of the main aisle near the south escalators and in front of the partner expo area <see map below>

clip_image001

clip_image002 www.microsft.com/teched

posted on Tuesday, June 03, 2008 8:55:21 AM (Eastern Daylight Time, UTC-04:00)  #    Comments [0] Trackback
# Friday, May 30, 2008

I have two breakout sessions on Wednesday. One on SQL and one on SCRUM. I also have a panel (more on that later.)

Wednesday 8:30am (sorry!)

T-SQL Querying: Tips and Techniques for Microsoft SQL Server 2005 and 2008

Take your queries to the next level! This highly technical (no slides), yet entertaining session focuses solely on advanced querying techniques to get the most out of your SQL Server 2005 and SQL 2008 database. See a series of real-world examples to extract data from your databases in ways you've never seen before. Techniques demonstrated include an ultra-fast way to do crosstab queries in SQL Server, running totals,XQuery and ranking. Along the way, get some insight into how SQL Server works.

Wednesday 2:45:

Tech·Ed Daily Scrum!

One of the most popular Agile project management and development methods, Scrum is starting to be adopted at major corporations and on very large projects. After an introduction to the basics of Scrum like: the Scrum Master, team, product owner, and burn down, and of course the daily Scrum, Stephen shows many real-world applications of the methodology drawn from his own experience as a Scrum Master. Negotiating with the business, estimation, and team dynamics are all discussed as well as how to use Scrum in small organizations, large enterprise environments, and consulting environments. Stephen also discusses using Scrum with virtual teams and even an offshoring environment. The session finishes with a large Q&A on best practices.

posted on Friday, May 30, 2008 9:17:11 AM (Eastern Daylight Time, UTC-04:00)  #    Comments [0] Trackback
# Friday, February 01, 2008

At TechEd Developers in Barcelona, Spain last November, I did an interactive session on ASP.NET Scaling tips. It was such a hit they had to move it to a large room-very difficult to make an interactive session. I took tons of questions and just had a conversation with the audience-and even had some rebel rousers in the back who I had to mock publicly. It was a great session (at least I think so).

Turns out that they filmed it behind my back. That is cool since now it will be published on MSDN Spotlight. You can see it here.

posted on Friday, February 01, 2008 7:29:12 PM (Eastern Standard Time, UTC-05:00)  #    Comments [0] Trackback
# Wednesday, October 31, 2007

I am speaking next week at TechEd in Barcelona, Spain.

DAT302 Database Design Patterns: Architecting the Right Data Model for the Right Application
Mon, Nov 5 17:45 - 19:00 Tent 1


Architecting an application starts with the database. Different applications need different data models. Fifth normal form is great for an OLTP database, but reporting databases need more of a flat denormalized structure and different Web sites need several different types of data models: eCommerce sites need different data models than traditional publishing sites. You need to optimize your data model for your application's performance needs. Concurrent users, data load, transactions per minute, report rendering, and query seek time all determine the type of data model you will need. See how different applications and different parts of an application can use different data models and how you can architect your database to fit into your application's needs and not the other way around.

DAT315 T-SQL Querying: Tips and Techniques
Tue, Nov 6 17:00 - 18:15 Room 117

Take your queries to the next level! This highly technical, yet entertaining session focuses solely on advanced querying techniques to get the most out of your SQL Server 2005 database. See a series of real-world examples to extract data from your databases in ways you've never seen before. Techniques demonstrated include an ultra-fast way to do crosstab queries in SQL Server, running totals and ranking. Along the way you'll get some insight into how SQL Server works and we’ll preview some of the new capabilities in SQL Server 2008 (“Katmai”).

WEB02-IS Top Ten ASP.NET Scaling Tips
Wed, Nov 7 15:45 - 17:00 Room 112

This interactive session pulls together the best methods for improving the scalability of your ASP.NET Web site. See a variety of techniques, including caching, pooling, paging and asynchronous processing. But more importantly, learn a method for ranking each of the techniques according to the benefit to your Web site. By comparing the potential benefit of a technique with its cost to implement, this interactive session will give you a plan for what to do next to most improve your site’s performance.

posted on Wednesday, October 31, 2007 2:10:03 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [0] Trackback
# Saturday, May 26, 2007

If you will be at TechEd in Orlando, I will be doing the session: Database Design Patterns on Monday and I was just told that we will repeat it Thursday afternoon as well.

The session is a great sesson. It is listed on the Architecture track. We won't be talking about data modeling but we will be talking about how to design the right database structure for the right situation.

I have 5 demos:

1. A Slowly Changing Dimension

2. Fact Tables

3. Horizontal Partitioning

4. SQL Server 2005 Table and Index Partitioning

5. Vertical Partitioning

 

Code

Title

Date/Time

Room

ARC211

Database Design Patterns: Architecting the Right Data Model for the Right Application

6/4/2007 4:45PM-6:00PM

N310 A

Architecting an application starts with the database. Different applications need different data models. Fifth normal form is great for an OLTP database, but reporting databases need more of a flat denormalized structure and different Web sites need several different types of data models: eCommerce sites need different data models than traditional publishing sites. You need to optimize your data model for your application's performance needs. Concurrent users, data load, transactions per minute, report rendering, and query seek time all determine the type of data model you will need. See how different applications and different parts of an application can use different data models and how you can architect your database to fit into your application's needs—not the other way around.

 

 

posted on Saturday, May 26, 2007 10:08:38 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [0] Trackback
# Monday, November 20, 2006

Catch it here.

posted on Monday, November 20, 2006 10:03:41 PM (Eastern Standard Time, UTC-05:00)  #    Comments [0] Trackback
# Thursday, November 09, 2006

Tech*Ed here in Barcelona is progressing well. Richard and I did the TSQL session yesterday for 500 people as well as recording a .NET Rocks show on Agile Development with Roy Osherove and Kate Gregory.

After we went drinking at the Norway party. What happens at TechED Europe is that each country put on a party for their attendees. Since there is a TechEd in the USA there is no party for Americans. So the Norwegians took pity on us speakers and invited us. Thanks again!

After the party we went to Football!

Today was an XQuery session and now we do the last of the Speaker Idol contest, today at 12:30 pm we see:

Bart De Smet

Dennis Doomen

Luigi Crispo

At 14:45 we do the final round and name a winner!!!

posted on Thursday, November 09, 2006 6:02:26 AM (Eastern Standard Time, UTC-05:00)  #    Comments [0] Trackback
# Tuesday, November 07, 2006

The first wave of the Speaker Idol Contest is today at 19:00 in the expo hall. Come see:

Anthony Harris

Andrew Godleman

Evangelos Hadjichristodoulou (yes that is his real name)

They will all compete for 5 minutes in front of the judges (myself included).

posted on Tuesday, November 07, 2006 11:32:10 AM (Eastern Standard Time, UTC-05:00)  #    Comments [0] Trackback
# Tuesday, October 31, 2006

We return to Barcelona for TechED 2006!  Of course I will be doing some sessions (see below) as well as judging the “Speaker Idol” contest.

See you in Spain!

SQL312 T-SQL Querying: Tips and Techniques

Stephen Forte , Richard Campbell

Wed Nov 8 10:45 - 12:00

Take your queries to the next level! This interactive session focuses solely on advanced querying techniques to get the most out of your SQL Server. See a series of real-world examples to extract data from your databases in ways you've never seen before. Techniques demonstrated include an ultra-fast way to do crosstab queries in SQL Server, running totals and ranking. Along the way you'll get some insight into how SQL Server works and the new capabilities in SQL Server 2005.

 

 

SQL407 XQuery Deep Dive: How to Write and Optimize Your XQuery

Stephen Forte

Thu Nov 9 09:00 - 10:15

SQL Server 2005 provides deeply integrated native support of XML. Besides storing the data as XML, it provides XQuery support as the key to unlock the information stored inside the XML document. This session gives you an introduction to SQL Server's XML and XQuery support and it demonstrates how to write and optimize your XQuery expressions. In particular, it discusses the use of XML Indices and how to read XQuery generated query plans.

 

 

SQLWD04 The Query Governor: SQL CLR in Action

Richard Campbell , Stephen Forte

Thu Nov 9 17:30 - 18:45

See how .NET takes SQL Server 2005 to a whole new level! In this Whiteboard Discussion learn how to build a query governor, a set of tools for evaluating whether or not a query should be run. Most query governors are simple limiters, automatically cancelling queries when they run too long or aborting queries with too high of a cost. The CLR makes it possible to programmatically evaluate the cost of a query without executing it! Combined with some techniques for determining the state of the server, you can build a governor is flexible and smart. This interactive Whiteboard Discussion makes it easy to explore different applications of this technology beyond the query governor.

 

posted on Tuesday, October 31, 2006 3:35:47 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [0] Trackback
# Friday, July 21, 2006

RDs Unplugged!

 

So many people ask me what happens “behind closed doors” at our “RD Only” meetings. People sometimes seem jealous that we have the RD meetings and want to sneak in. They have visions of Bill Gates telling us state secrets or Program Managers giving us builds of the next next next version.

 

Well let me tell you that that never happens. But the meeting are a lot of fun. I think they are “RD Only” to protect the innocent. RDs tend to let loose and do things like get a guitar or harmonica and sing a song.

 

I will give you a glimpse into the secret world of the RD meetings. Thanks to Chad Hower for posting this blog entry of the RDs singing at the RD meeting at TechEd up in Boston last month. Download the videos, you will not be disappointed!

 

I also declared my love for Clemens Vasters by laying on the ground in front of traffic on the street in front of Fenway Park. See the photo here!

 

 

posted on Friday, July 21, 2006 12:00:14 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [0] Trackback
# Monday, June 12, 2006

Tomorrow Richard and I will do Session DAT 417- The Query Governor: SQL CLR in Action. Have you ever wanted to stop a user from running a query BEFORE they ran the query based on certain conditions? Conditions like the state of the server, the user’s role, or the cost of the query? That is what we will show you tomorrow, using XML Showplan, XQuery, TSQL, the CLR inside of SQL Server 2005, and the new EXECUTE AS keyword. We’re on at 2:45 on Tuesday. See you then. Bring your slow queries.

 

You can call it from a client (below) or all in T-SQL, your choice.

 

 

DAT417  The Query Governor: SQL CLR in Action

 

Day/Time: Tuesday, June 13 2:45 PM - 4:00 PM  Room: 151 AB

 

Speaker(s): Richard Campbell, Stephen Forte

 

See how .NET takes SQL Server 2005 to a whole new level! In this session, learn how to build a query governor, a set of tools for evaluating whether or not a query should be run. Most query governors are simple limiters, automatically cancelling queries when they run too long or aborting queries with too high of a cost. Using the CLR, this governor evaluates not only the cost of the query using the XML based query plan, but also the state of the server using Windows Management Instrumentation (WMI). Along with information about the user executing the query, see how you can dynamically assess the state of the server and cancel a query before it runs. This would not be possible without .NET being integrated into SQL Server-see how you can use this technology in your projects!

Track(s): Database Development and Administration Session Type(s): Breakout Session Session Level(s): 400

 

posted on Monday, June 12, 2006 11:53:45 AM (Eastern Daylight Time, UTC-04:00)  #    Comments [0] Trackback
# Sunday, June 11, 2006

TechEd starts today with the keynote. I speak on Tuesday and Friday, see you all in Boston this week!

posted on Sunday, June 11, 2006 4:03:28 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [0] Trackback
# Tuesday, June 07, 2005

For some reason they trusted me to do the first one. It went very well: Ranking and Windowing Functions in SQL Server 2005. After editing, you can view it here: http://www.groktalk.net/blog/

posted on Tuesday, June 07, 2005 11:48:13 AM (Eastern Daylight Time, UTC-04:00)  #    Comments [0] Trackback
# Monday, June 06, 2005

Tuesday 11:25 AM: Using Ranking and Windowing Functions in SQL Server 2005

SQL Server 2005 adds the functionality of a Ranking expression that can be added to your resultset that is based on a ranking algorithm being applied to a column that you specify. This will come in handy in .NET applications for paging and sorting in a grid as well as many other scenarios. We will explore the ROW_NUMBER() function which assigns a running count to each row and compare it to RANK() and DENSE_RANK(). Use these functions to solve complex SQL Problems. Then we will look at custom percentile ranking using NTILE() and look at business and adacemic applications of NTILE. Lastly we will apply windowing functions to all of the 4 ranking functions with PARTITION BY to perform hard code aggregate functions

posted on Monday, June 06, 2005 11:55:00 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [0] Trackback

Come to mine today:

DBA304  Advanced Querying Techniques, Tips & Tricks Using Transact-SQL
Speaker(s): Richard Campbell, Stephen Forte
Session Type(s): Breakout
Track(s): Database Administration
Day/Time: Monday, June 6 3:15 PM - 4:30 PM Room: S 310 A
Take your querying to the next level! This session gets away from the fundamentals of SQL queries and into the hard stuff. See two experts in SQL Server compare and contrast querying techniques between SQL Server 2000 and SQL Server 2005. This session has a series of real world examples to show how creative SQL queries can generate solutions in record time. Some techniques you'll learn include how to do crosstab queries that take seconds to execute instead of hours, exploiting sub-queries and taking advantage of self-joining. Along the way, get some insight into how SQL servers work, as well as how SQL Server 2005 is going to make advanced querying even easier.
posted on Monday, June 06, 2005 12:44:10 AM (Eastern Daylight Time, UTC-04:00)  #    Comments [0] Trackback
# Friday, June 03, 2005

With an auction starting on Monday, 22 of the top Tech*Ed speakers, including Microsoft employees (don’t worry we cleared it with Legal <g>), will together to help raise money for an organization that is doing amazing and heroic disaster relief and recovery in Aceh Province, Sumatra, the hardest hit area of the Dec 26th Tsunamis. Just like last time we will auction the time off on eBay, the link will be here in about 24 hours.

 

Although news of the tsunami has largely disappeared from the international press, five months later, the situation on the ground in Aceh remains acute. Many isolated communities have not yet been helped. Aceh Recovery at IDEP (www.acehaid.org) is continuing their efforts to get assistance to the people that are most in need through a dynamic network of local NGOs and partners on the ground in Aceh.

 

Here is the current list of speakers donating their time:

 

Don Box

Jesper Johansson

Richard Campbell

Scott Hanselman

Kimberly Tripp

Michele Leroux Bustamante

Kate Gregory

Juval Lowy

Stephen Forte

Clemens Vasters

Andrew Brust

Carl Franklin

Ingo Rammer

Christian Weyer

Joel Semeniuk

Rockford Lhotka

Patrick Hynds

Tim Landgrave

Tim Huckaby

Jackie Goldstein

John Goodyear

Richard Hundhausen

 

WHAT IS IDEP?
IDEP is a small, Indonesian NGO, based in Ubud, Bali. Completed projects over the years have included community based development, sustainable living initiatives, permaculture training, waste management, organic gardens, recycling, etc. The focus is on helping people to help themselves. IDEP's founding director, Petra Schneider is a US-born, Indonesian citizen. The demonstrated and reproducible success of IDEP's small projects in local communities has earned the team an excellent reputation.

IDEP AND DISASTER RESPONSE/RELIEF/RECOVERY
At the time of the Bali bomb, about two years ago, IDEP was an important element of the network of local NGOs and other supporters that quickly responded to the tragedy, in various ways, not only immediately after the bomb, but during the recovery process for the various communities involved. Following shortly thereafter, IDEP received funding from USAid to create a comprehensive set of disaster management materials for Indonesian communities, aimed at children, families, and local leaders (official and unofficial). The materials are in the Indonesian language and suitable for use in rural and urban settings. These materials, including a booklet for children about Tsunami preparedness, were finished just weeks ago, but had not yet been disseminated to communities. Then the tsunami struck.

WHAT IS ACEH RECOVERY AT IDEP
Only hours after the news of the tsunami reached Bali, the same network of NGOs and individuals in Bali who had been involved in the relief efforts for the Bali bomb, reanimated and went into action. We started something called the "Aceh Aid Bucket Brigade" (see website), creating and deploying one-family-one-bucket multi-material aid packages from the hands of donors in Bali to the field in Sumatra. We began sending highly skilled volunteers, well-matched to the task within two days of the tsunami (Sam Schultz, Lee Downey, Oded Carmi and others). Our relief, and later, recovery programs in response to the Tsunami are now focused on two fronts. One is direct aid from Medan by road to areas around Banda Aceh. The other is this remarkable joint effort (nothing short of heroic), to the islands off the west coast of Sumatra, which as of yet, have not been receiving aid from any other channels that we know of. Read more at www.acehaid.org.

 

posted on Friday, June 03, 2005 5:58:55 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [0] Trackback
# Wednesday, May 25, 2005

At TechED 2005 US in Orlando, you will not want to miss the GrokTalks. Trust me. They break the mold and do not follow the MS party line. Stay tuned...

posted on Wednesday, May 25, 2005 5:12:06 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [0] Trackback
# Thursday, September 16, 2004

Tech Ed is all over for me did three sessions:

SQL Server Notification Services

XML in Yukon

ASP .NET Cache

I had about 400 people in each session and the Notification Services session was one of the top ranked sessions so far with an 8.0. (More on Score Whores and XML this weekend when I get home.)

Now I start counting the days to Kilimanjaro....

posted on Thursday, September 16, 2004 9:37:20 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [21] Trackback
# Wednesday, September 15, 2004

We are all here and Clemens is not. So we got drunk and called him. Too bad for him.

Did two sessions today, SQL Server Notification Services and ASP .NET Cache Engine. Totally rocked about 400 people in each class. XML in Yukon is tomorrow.

posted on Wednesday, September 15, 2004 11:36:52 AM (Eastern Daylight Time, UTC-04:00)  #    Comments [10] Trackback
# Tuesday, September 14, 2004

Ask the experts went great. Replicaiton, OLAP (virtual cubes), sp_ recompile, and Yukon ship dates (don't ask)

We went out for SQL Hera's birthday, but she was lame and went home early before we went to the nighclub.  Went to Punjabi night club and danced for 2 hours straight with Goksin and Sanjay. I am 6 tequila shots in, Malek is an evil man.

2 sessions tomorrow...

posted on Tuesday, September 14, 2004 1:51:16 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [9] Trackback
# Monday, September 13, 2004

Day 1 of TechEd Malaysia went off without a hitch. SQL Hera, Kimberly Tripp, did a 7.5 hour precon while the rest of us took the morning off and visited the Batu Caves, amazing 1,000 foot long limestone stalagmite/tite cave that were used by Hindus as a temple. An amazing thing to think about is the natural cathedial that formed in the caves and the Hindus put in the statues. We had to walk up over 275 steps and jump over ravenous monkeys to get in.

 

There was also a Hindu god that had a cow with boobs. Pretty cool stuff.

 

After an authentic Malaysian lunch at a local dive we headed to the Chinese Buddhist temple. Quite an amazing place. I lit some incense and also washed my face with holy water for luck. I also received a fortune with Chinese fortune sticks.

 

After this fun it was back to the conference center. My first session (1 of 5) is tomorrow.

posted on Monday, September 13, 2004 11:02:32 AM (Eastern Daylight Time, UTC-04:00)  #    Comments [16] Trackback
# Sunday, September 12, 2004

Been traveling in Asia for a 10 days without Internet but now in KL for TechEd 2004!

posted on Sunday, September 12, 2004 9:48:00 AM (Eastern Daylight Time, UTC-04:00)  #    Comments [16] Trackback
# Friday, May 28, 2004

Tech*Ed 2004 is over. :(

I am home and am intstalling all of goodies while sporting my new tee shirts. Got some cool stuff.

The last day saw an arguement over the MVP program vs the RD program. Since I am a member of both, I am going to think about this some and post something up here. I will offend people, not sure who but stay tuned.

posted on Friday, May 28, 2004 6:24:46 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [21] Trackback
# Wednesday, May 26, 2004

Blogs. Sessions. Fellow speakers. Parties. Emails from the office. Drinks at the MSDN Party.

Not too much fun. TechED 2004 rocks.

posted on Wednesday, May 26, 2004 9:45:48 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [15] Trackback
# Monday, May 24, 2004

Our session called From Interoperability to Migration: SQL Server and Linux Databases Working Together which was in Cabana 08 went awesome today. We showed a SQL Server linked Server connecting to an Oracle 10g database running under Red Hat. Enough said.

For all of you that attended, not sure how to get the 2 8gb VPC images to you just yet, but we will find a way. Stay tuned.

I signed many RD Bingo cards. Good luck to everyone.

posted on Monday, May 24, 2004 6:20:19 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [19] Trackback
# Sunday, May 23, 2004

Day 1 of TechEd is going well.  

 

You need to play Regional Director Bingo. Get your bingo cards at the RD booth at 49-50. You can also play the Apprentice .NET game for a chance to be Bill Gates’ apprentice (al la Donald Trump). Well maybe not Bill’s but you will get lots of prizes, etc.

 

Went to my session room at the Cabana area and well there are only about 30 chairs, so come early tomorrow, we have almost 100 people registered for the talk tomorrow on Linux and SQL Server.  

 

Arrived last night and already got drunk with Clemens, Malek, Kathleen and Richard. I have never seen Richard drunk before!!

posted on Sunday, May 23, 2004 4:59:21 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [8] Trackback
# Saturday, May 22, 2004

At JFK International Airport ready to leave for Tech*ED. It is amazing just how many RDs will be there, it is annually the largest gathering of RDs at any given time.

 

I am looking forward to the keynotes, my session and several other sessions, including Clemens’ talk where he actually uses SQL Server in transactions and stuff like that. I guess if the Berlin Wall can fall, Clemens can use SQL Sever. :)

 

Riding out there on the plane with Bill Zack, my Yukon book co-author and co-moderator of the NYC .NET Developers Users Group.

 

If you have never been to TechED before, one note, this year is sold out (11,000 people!) and just get to everything EARLY to avoid the lines. Also pay close attention to the parties, they are fun too. Remember the social interaction is why we come here. Get out and talk your latest project’s architecture with a complete stranger from Minnesota who you meet on the bus going to the attendee party. That is where the real action is at TechEd. I remember last year on the subway in Barcelona at TechED Europe, there was a 4 way conversation between 4 complete strangers (but we all had the red teched bag) about transactions and error handling and where the business logic goes. I don’t even remember the guys names and I am sure that they don’t remember me (besides being a silly American) but it was the best technical talk of the conference!

posted on Saturday, May 22, 2004 12:10:03 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [18] Trackback
# Friday, May 21, 2004

Is what Richard Campbell just said to me on the phone. Our Windows client can now talk to our Linux Oracle Server. Our demos will work for Monday. We have some pretty hard core demos.

DATC02  From Interoperability to Migration: SQL Server and Linux Databases Working Together

Monday, May 24 1:30 PM- 2:45 PM, Cabana 08
Speaker(s): Richard Campbell, Stephen Forte
Track(s): Data Management
"They" say it can be done, now see it in action! This session demonstrates how SQL Server can acts as the gateway to interoperability with Linux databases such as DB2 and Oracle! You'll see a fully functioning Linux-based web application using Red Hat Linux, Apache, PHP and Oracle sharing data with an identically implemented ASP.NET application using SQL Server. This session shows not only how to interoperate, but to use these interoperate capabilities to facilitate a seamless migration from the Linux based system to SQL Server and Windows . This is how migration was meant to be!
posted on Friday, May 21, 2004 3:26:31 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [20] Trackback
# Thursday, May 20, 2004

My pal Tom Howe always seems to be reformatting his computer at conferences the day before he speaks. I always mock him. As I leave for the most important conference of the year, TechED US in San Diego on Saturday, I am reformatting my laptop and reinstalling the OS.

I had some major issues. Boot sector issues (Richard Campbell gave me a few ideas, including messing w/ my BIOS). Video driver problems in XP. WiFi problems in Longhorn. The drive not being NTFS. SHall I go on? I seem to be in for a long night.

Thankfully we are doing our TechED demos off Ricahrd's laptop!! I usually follow my own advice, but the machine really needed a reformat. How many Dell laptops have been to Mt. Everest? I guess like me it just wants to go back.

posted on Thursday, May 20, 2004 3:30:29 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [17] Trackback
# Sunday, May 16, 2004

Last night Malek flew in for a quick stopover in New York on his way to West Va and then San Diego for TechEd. Kathleen and I took him out on the town first for some beers and Mexican food. Then we went to Biddies for some beers with my pals Justin and Jack and the gang. Katlheen somehow managed to get a free beer glass from the bartender, it pays to be a hot blonde. All in all a good time was had by all.

Oh, Richard Campbell now blogs! Holy crap. This is going to be crazy.

Lastly, getting ready for not only teched, but the PDC in Karachi, Pakistan. We expect 1,500 developers, see you there!

 

posted on Sunday, May 16, 2004 12:06:34 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [8] Trackback
# Friday, May 14, 2004

Another successful CTTM (or now called SDC) in the Netherlands. What a great show and 7 RDs where speaking. Richard and I did a dry run of From Interoperability to Migration: SQL Server and Linux Databases Working Together and it went very well. Hopefully we can get Oracle to work and play well on the VPC image before our TechED session in 13 days. This session is quite cool, hope to see you all there.

DATC02  From Interoperability to Migration: SQL Server and Linux Databases Working Together
Monday, May 24 1:30 PM- 2:45 PM, Cabana 08
Speaker(s): Richard Campbell, Stephen Forte
Track(s): Data Management
"They" say it can be done, now see it in action! This session demonstrates how SQL Server can acts as the gateway to interoperability with Linux databases such as DB2 and Oracle! You'll see a fully functioning Linux-based web application using Red Hat Linux, Apache, PHP and Oracle sharing data with an identically implemented ASP.NET application using SQL Server. This session shows not only how to interoperate, but to use these interoperate capabilities to facilitate a seamless migration from the Linux based system to SQL Server and Windows . This is how migration was meant to be!


 

posted on Friday, May 14, 2004 2:30:52 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [18] Trackback
# Tuesday, April 20, 2004

Richard Campbell and I are doing an interoperability session at TechED. We are using RedHat, Oracle, Windows 2003 and SQL Server and showing how they work and play well together. The Oracle 10g database runs on Linux, but Oracle provides support only for Red Hat Linux and SuSE. If you want to run Oracle 10g on any other Linux variant (you know the “free“ ones), you're on your own. It is kind of funny after you pay RedHat and Oracle the total cost it is higher than the Windows/SQL Server version. But Linux is free....I guess only if you don't want to run any business apps or have any support.

posted on Tuesday, April 20, 2004 4:24:37 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [17] Trackback
# Friday, March 19, 2004

Silly me did not know that there was a dasBlog 1.5 up at the gotdotnet workspace. All systems go.

I got my final Tech*Ed Assignment today. I am doing a session with fellow RD Richard Campbell, this should be huge:

From Interoperability to Migration: SQL Server and Linux Databases Working Together
 
"They" say it can be done, now see it in action! This session demonstrates how SQL Server can acts as the gateway to interoperability with Linux databases such as DB2  and Oracle! You'll see a fully functioning Linux-based web application using Red Hat Linux, Apache, PHP and Oracle sharing data with an identically implemented ASP.NET application using SQL Server. This session shows not only how to interoperate, but to use these interoperate capabilities to facilitate a seamless migration from the Linux based system to SQL Server and Windows . This is how migration was meant to be!

posted on Friday, March 19, 2004 1:15:40 PM (Eastern Daylight Time, UTC-04:00)  #    Comments [15] Trackback
# Sunday, January 18, 2004

Tech*Ed 2004 Sessions

 

The Tech*Ed 2004 Web Site is up and running (register today!) and sessions are already on-line. I have two sessions up and ready to go:

 

Create Smart XML-Aware Applications with SQL Server “Yukon

Efficient and Secure Data Retrieval in Your Middle Tier Using Stored Procedures and ADO.NET

 

Tech*ED in the US and Europe are the technical events of the year (and social gatherings too). Hope to see you there. Can’t wait to do some surfing in La Jolla.

posted on Sunday, January 18, 2004 7:42:08 PM (Eastern Standard Time, UTC-05:00)  #    Comments [0] Trackback