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

Geek of the Week - Rebecca Riordan

08 June 2005

An interview with Rebecca Riordan

by Douglas Reilly

In addition to writing articles and software, I sometimes write books, which is one of the most difficult things I do. If you think that getting the contract is the hard part, it’s not. It takes longer to write a book than you might think, and you have to deal with people who tell you a particular title is too simple, too short, too long, or too boring. Others have ideas about how you could have—should have—done the job better. The bottom line is: You place your ideas out in the world, in permanent form, and allow others to pick them apart.

Rebecca Riordan is someone who feels my pain. Although I don’t think I ever met Rebecca in person, I may have heard her speak at a conference before I knew who she was. My first interaction with her was when she was having trouble duplicating a problem that a reader was having with code from an early book of hers. The code in question certainly worked, at least for me. So I contacted her about that, understanding how difficult it is to get every reader on board with your vision.

Since then I have had the pleasure of reading a couple more of her books, as well as reviewing one or two of them, and I have come to appreciate her style. Her two recent books, Designing Effective Database Systems and Seeing Data: Designing User Interfaces for Database Systems Using .NET, are wonderful. The second title, especially, fills a gap in the books that have been available until now.

Software developers are notoriously poor user-interface designers. They are especially poor with respect to presenting data in ways that work for both users and databases. Reading Seeing Data will help developers become better database designers. (See and for additional information on Rebecca’s recent titles.)

The following questions were asked by me and answered by Rebecca via email.


: One of the biggest issues among SQL Server developers is whether or not to use stored procedures. Where do you come down on this issue?


: I’m on the fence, of course. There’s no one answer. "Who owns the data?" is an important question, particularly in corporate environments, so when it’s a question of data integrity, I’m absolutely in favor of SPs—it’s the right and responsibility of the data store to protect itself. But for data presentation, I prefer that the manipulation be done locally to maintain application flexibility. (I still remember six-week delays getting a system administrator to add a single field to a SELECT query.)


: When you program in .NET, do you favor VB.NET, C# or some other language?


: VB.Net, absolutely. I have to build samples in C# for my books, but frankly, I’d rather go to the dentist.


: There have been a number of blog posts, even petitions, to bring back official Microsoft support for VB6. Do you have any thoughts on the matter?


: VB6 and Jet both. Microsoft is marketing driven. By and large that’s a good thing, but it gives the company bias toward large corporate installations that I think is inappropriate. I saw a Microsoft marketing presentation a few years ago during which the guy was justifying the company’s "big app" emphasis by quoting sales statistics: 40-something percent of Microsoft’s customers are major corporations. I was the strange woman in the back of the room waving her arms and saying, "Yeah, that means 50-something percent of your customers are small guys, so why aren’t you paying attention to them?"

VB6 and Jet are wonderful tools for small applications, and without having done formal research, I’m convinced that the majority of applications are of the guy-building-a-customer-tracking-system-for-his-auto-parts-store variety. They’re not cool or sexy, but they’re important, and I hate like hell to tell these guys that they need to run SQL Server. It’s too big, too complicated, and requires too much housekeeping. And it’s not needed, not technically.


: What was your first database-related job?


: LOL! When I got out of university, I couldn’t get a job to save my life. I finally wound up as a word-processing operator for Wells Fargo Bank, back in the days of dedicated word-processing machines. When the bank brought in personal computers, they put me in charge of them because they looked more or less like word processors. My first database application was a customer list used for mail merge in Word Perfect 1.5. Normalized and everything, I was so proud of myself…


: How did you learn about databases?


: C.J. Date’s book. It’s still a classic, and one I recommend to those who are serious about learning database theory (after reading my Designing Relation Databases, of course ). Actually, on the newsgroups, I recommend that people start with Steve Roman’s Designing Access Databases before they read my book, and then move on to Chris Date afterwards. That is, if I haven’t turned them off the subject entirely.


: Have you done much with XML?


: No. I understand the "ASCII for data" theory, but I always think, "and I care about this because…?" And because the .NET Framework and SQL provide such great support for XML, I’ve never had to do more than simple "spit this out" or "pick this up" stuff.


: Your books are among the few that cover both Access and SQL Server. About what percent of your work is done with each? What do you miss when using Access, and vice versa?


: It’s about 50-50, I guess. Surprisingly, there isn’t anything I miss when switching environments. Triggers in Jet might be nice, but the interface environment is so closely integrated in Access, and I’m so used to working without them, that it isn’t a big deal.

I miss VB stuff when I’m working in VBA, though. Big time. And I miss .NET controls in Access. Although, to be honest, I don’t so much miss them, because Access has some wonderful stuff too, as I get myself confused about what’s available where.


: Have you had a chance to work with the betas of Microsoft SQL Server 2005 and Visual Studio 2005? What do you think about possibly using VB.NET or C# for stored procedures?


: You might say I’ve worked with them—I’m writing books on both of them. Using CLR languages in SQL Server seems like a good, convenient thing, and of course it’s a natural outcome of the Yukon rewrite, but I’ve heard too many non-database developers say, "Good, now I don’t have to learn SQL," and that would keep me up nights if I let it. Can you imagine what kind of database junk is going to be written by people who don’t know SQL, and therefore don’t understand how data sets work? Oh, heavens, that’s scary.


: Your recent book, Designing Effective Database Systems, covered dimensional databases (or OLAP databases). This was a topic I had not thought much about, even though I consider myself a database-savvy geek. You taught me something. How do you keep up with changes and stay ahead of our readers?


: Thank you. Being something of a recluse—if you heard me speak at a conference, it was a long time ago!—I mostly cruise the technical bookstores and Amazon to see what’s new and exciting, then do my research on the internet. The generosity of the Internet community never fails to amaze me.


: I independently "discovered" markup languages long after Tim Berners-Lee developed HTML . My markup language involved lots of @ signs and was not terribly device independent; I hard-coded things that should not have been. Have you ever "invented" anything, only to discover that something better already exists?


: Not with an entire language—I was never that ambitious—but I do remember one particularly cringe-making moment when someone pointed out that if I was calculating an 80-character line break, it was probably more efficient to start at character 79 and scan backward for a space than to start at character 0 and scan forward and then backward. It was then that I decided I really wasn’t cut out to be a programmer and moved into systems analysis.


: Are you in the process of writing any great developer-oriented books?


: I’m working on two books; whether they’re great or not isn’t for me to judge. I’m updating ADO.Net Step by Step for Microsoft Press, and working on a SQL Server 2005 tutorial for Addison-Wesley (title to be determined, along with a bunch of other things. You’re right: Getting the contract is the easy part!).


: Can you think of a cool tip or trick that many database developers do not know about?


: You’re probably looking for some snippy bit of code, but as I’ve said, I’m an "if it works, nail it" programmer; I leave the tricky stuff to guys like you. But one thing I really wish developers did more often is walk through the system from the user’s point of view. I talk about this (ad infinitum) in Seeing Data, but you should take an hour or so and work though it: "The user is going to get this piece of paper and enter information here and here, and…oops." Finding those "oops" places makes a world of difference in the usability of a system.


: What music do you listen to these days?


: I’ve always been a jazz girl, but much to my surprise, I’m listening to country these days. (It’s no surprise that there’s a man involved.) I always thought country was twang and whining and love songs to pick up trucks, but of course I was wrong. So these days it’s Keith Urban and George Strait more often than Jean-Pierre Rampal, Louis or Ella.

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 10 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:32 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.