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.

Doug:

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

Richard:

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? :-)

Doug:

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

Richard:

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.

Doug:

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

Richard:

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.

Doug:

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?

Richard:

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!

Doug:

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

Richard:

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.

Doug:

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

Richard:

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 editor@simple-talk.com 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.


Poor

OK

Good

Great

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

We don't need Source Control: we're Database Developers
 As part of our long-running series of articles where we ask working database developers how database... Read more...

The Proposals Conundrum
 When you work for a small software development (or any services) company, one of the major challenges... Read more...

David Heinemeier Hansson: Geek of the Week
 Ruby on Rails, the open-source web application framework, grew out of David Heinemeier Hansson's work... Read more...

Alex Payne: Big in the IT Business
 Alex Payne worked on developing Twitter for three years. When he started, it was a small side-project:... Read more...

Seth Godin: Big in the IT Business
 Seth Godin has transformed our understanding of marketing in IT. He invented the concept of 'permission... 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...

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

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

Why Join

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