Click here to monitor SSC
  • Av rating:
  • Total votes: 0
  • Total comments: 1
Douglas Reilly

Database Geek of the Week: Richard Hundhausen

12 August 2005

An interview with Richard Hundhausen

by Douglas Reilly

Richard Hundhausen is the author of Building Web Applications with ADO.NET and XML Web Services and Programming ADO.NET, both from Wiley, as well as the upcoming Working with Microsoft Visual Studio 2005 Team System from Microsoft Press. He is also a trainer, teaching numerous courses and speaking at conferences such as VSLive and Tech Ed.

Richard answered the following questions via email.


Tell me how you got involved in database-related work. Was it a natural fit or an accident of convenience?


It was a natural fit. I started writing professional code on the PC in Turbo Pascal 3.0. Back then, the only place you could save your information was in text files or files with a structure you created yourself. When I first saw dBase 2, I fell in love! Is this being recorded? :-)


What do you think about using VB.NET or C# for stored procedures, functions and triggers?


I think it can be abused if we let it. Of all the justifications I’ve seen and heard for using CLR in the database, I say use it when you can leverage the framework to do something that you can’t do, or is very hard to do in T-SQL. The complexity and skill set debates are too subjective, and will result in runaway architectures, because some .NET developers will see this as an opportunity to dispose of the middle tier.


What are the changes in ADO.NET 2.0 that you most look forward to using in production code?


I love the deep support for asynchronous execution. They made it easy, too. If you have a long-running stored procedure or script, call it asynchronously and let the user or service do something else in the meantime. Binary serialization of datasets, batch-mode updates on DataAdapters, and more autonomy for DataTables are cool too.

I think MARS is being over-hyped, because it’s something that worked in classic ADO, and then broke in ADO.NET 1.X. It may not have been as efficient back then as it is in ADO.NET 2.0, but let’s not make a marketing event out of a feature that is essentially a fix.


The client tools for SQL Server 2005, while still in beta, are a huge change from previous client tools. Is there anything that developers will find particularly cool in the new tools?


The integrated toolset of SQL Server Management Studio is great—there’s no more bouncing back and forth between Enterprise Manager and Query Analyzer. From a coding perspective, the ability to generate script from any dialog is important, which is being handled by SQL Management Objects (SMO) behind the scenes.

Industry will be building SMO clients for a long time to come. The first SMO application that the community should build is a service manager replacement. I miss my little green arrow in the system tray!


I do some mobile development work. Has any of your work involved SQL Server 2005 Mobile, formerly SQL Server CE?


Not nearly enough. And what work I have done, I was able to get away with serializing DataSets to disk as XML instead of using proper databases.


You have written a few books. What do you enjoy about the book writing process? What part of it makes you crazy?


Whether it’s good or bad, I like to write conversationally. I’ve been a trainer for about 15 years now, and I’ve become good at explaining technical and abstract concepts to people. Writing books isn’t much different. I’m not formally trained, so things like templates, voice and deadlines drive me nuts. That’s what editors are for, though, to remind you of those details!

Do you know someone who deserves to be a Database Geek of the Week? Or perhaps that someone is you? Send me an email at and include "Database Geek of the Week suggestion" in the subject line.

Douglas Reilly

Author profile:

The late Douglas Reilly was the owner of Access Microsystems Inc., a small software development company specializing in ASP.NET and mobile development, often using Microsoft SQL Server as a database. He died late in 2006 and is greatly missed by the SQL Server community as one of the industry's personalities.

Search for other articles by Douglas Reilly

Rate this article:   Avg rating: from a total of 0 votes.





Must read
Have Your Say
Do you have an opinion on this article? Then add your comment below:
You must be logged in to post to this forum

Click here to log in.

Subject: Anonymous comments disabled
Posted by: AnnaL (view profile)
Posted on: Tuesday, May 22, 2007 at 6:30 AM
Message: Unfortunately due to relentless spamming, we've had to disable anonymous comments on this article.

If you wish to contribute to the debate on this article, you will need to sign in, or join, if you are not already a member.


Top Rated

Continuous Delivery from the 19th Century to TODAY
 It somehow feels like the end of an era. The National Weather Service of the USA's National Oceanic... Read more...

Continuous Delivery: Building a Culture of Trust
 Effective team-based software development has more to do with the organisation than the technology.... Read more...

Chet Ramey: Geek of the Week
 The BASH shell is the most popular UNIX command-line scriptable shell. It became the inspiration for... Read more...

Swizec Teller : Geek of the Week
 Why do programmers work best at night? Is this related to the idea that drinking alcohol improves... Read more...

Jonathan Allen’s Top 10 Favourite Simple Talk Articles
 We asked several well-known readers of Simple-Talk to write about their all-time top ten favourite... Read more...

Most Viewed

The Future of Reflector
 Simple Talk asked freelance writer Bob Cramblitt to sit down with the two people behind the agreement... Read more...

Linus Torvalds, Geek of the Week
 Linus Torvalds is remarkable, not only for being the technical genius who wrote Linux, but for then... Read more...

Bad CaRMa
 From hope and euphoria, to desperation, firings and the ultimate demise of a company. Tim Gorman charts... Read more...

Don Knuth and the Art of Computer Programming: The Interview
 Fifty years after starting the 'Art of Computer Programming', (TAOCP), Don Knuth is still working hard ... Read more...

Driving up software quality - the role of the tester
 Have you ever wondered what a software tester does? Helen Joyce, test engineer at Red Gate software... Read more...

Why Join

Over 400,000 Microsoft professionals subscribe to the Simple-Talk technical journal. Join today, it's fast, simple, free and secure.