SQL Server Central is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 

Easy or Hard

By Steve Jones, 2008/04/28

Total article views: 58 | Views in the last 30 days: 58

Should we make SQL Server easy or hard? Does it make more sense to make things easier for people to do. OR will this lead to more problems because people will pick these features, enable them, and not understand how they work.

I've talked a lot about the tools and how they work over the last few weeks and as much as I hear that the platform is easier than ever for people to install and get working, I feel that it is also more and more complex with every release, actually requiring more DBA resources over the lifecycle of an application.

As new tools are designed, I think it's important to conduct usability tests. I know that as new screens and features are built, actual DBAs are brought in and their use of the tools tracked and my employer, Red Gate Software, actually does a lot of usability testing in their development. However my feeling is that there's always a goal of making things easier to use, which is good, but is it what we want?

I often see and hear of people using tools incorrectly and making bad choices (often accepting defaults) without understanding the implication of what they are doing. It's easy to say that someone should read the documentation or research their choices, but that's not how things often work. And my making things easier to use and marketing them that way, you imply they are simple systems.

And they're not.

My vote is that the tools we use should be ergonomic, but not simplistic. They should smooth the process of doing something, but not simplify to the point that very inexperienced users get into trouble. Defaults should make sense for 80% of the people out there and advanced users should deal with that. I think we're OK with that, just be sure that you don't make it cumbersome to get around the defaults when we need to do so.

Steve Jones

PS: If you're attending the 2008 PASS Summit, be sure to use "SSC6" as your discount code in the registration. We'll have a great party for you in Seattle with the SQLServerCentral.com crew. Register today!!!. You can save $800 off the full rate until April 30. You can save an additional $200 with a $99 PASS Membership as well.


The Voice of the DBA Podcasts

Everyday Jones

The podcast feeds are now available at sqlservercentral.podshow.com to get better bandwidth and maybe a little more exposure :). Comments are definitely appreciated and wanted, and you can get feeds from there.

Overall RSS Feed: or now on iTunes!

Today's podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at www.everydayjones.com.

I really appreciate and value feedback on the podcasts. Let us know what you like, don't like, or even send in ideas for the show. If you'd like to comment, post something here. The boss will be sure to read it.

By Steve Jones, 2008/04/28

Total article views: 58 | Views in the last 30 days: 58
Your response
 
 
Related tags

Editorial    
 
Related content

What Should A DBA Be Doing?

By Steve Jones | Category: Editorial
(not yet rated) | 620 reads

Not Just At Home

By Steve Jones | Category: Editorial
(not yet rated) | 235 reads

Dog Food

By Steve Jones | Category: Editorial
(not yet rated) | 145 reads

Halo 3

By Steve Jones | Category: Editorial
(not yet rated) | 158 reads
Already registered?  

Free registration required

To read the rest of this article, and access thousands of other articles, we ask you to register on the site and subscribe to our newsletters.

Register

E-mail address:
Password:
Password (confirm):

  

Subscriptions

We ask you to register on the site and subscribe to our newsletters. Subscribing to our newsletters gets you:

  • ALL of our content (thousands of articles, scripts, and forum postings)
  • A daily newsletter (example)
  • A weekly news round up (example)
  • The opportunity to ask and answer questions in our forums
  • A daily Question of the Day to test and help you increase your knowledge of SQL Server.

We ask that you give the newsletter a try for a week. Over 200,000 SQL Server Professionals a day find it entertaining and useful. If not, you are welcome to unsubscribe at anytime.

Steve Jones
Editor, SQLServerCentral.com