Last week you voted for “Developing on the Right Side of the Brain” as the post you wanted to see most. Here we are. Enjoy.
When learning to draw, I took a big step forward when I worked through the exercises in a book called Drawing on the Right Side of the Brain by Betty Edwards. I thought the premise was cool. She explains that we have to use our intuitive right side of the brain instead of the usual analytical left side in order to access untapped drawing skills.
But it’s pop-psychology. The premise probably makes neuro-scientists cringe (just like the following myth):
It’s possible that her whole book is like Dumbo’s feather. Something to hold onto that helps you believe you can draw. (And I can’t fault her for doing that. There are only two types of people: those who can draw, and those who just don’t believe they can yet.) But her book is more than just a placebo; her method works very well.
While going through her book again recently, I thought of some similarities between the world of drawing and art and the database world.
Fresh Points of View
One of the early drawing exercises the author has us complete is to copy a line drawing. But the drawing we’re to copy from is upside down. It’s counter intuitive but these upside-down drawings often turn out better than if the drawing was drawn normally.
The theory is that when drawing from a picture up-side down, it is less likely for students to use old drawing habits. So for example, instead of drawing a nose, the student will draw what they see. Probably because they have no experience drawing an upside down nose.
In the database world, I’d like to see new developers drop a few bad habits from the beginning. Two that come to mind:
- Tables are just Spreadsheets: These newfangled database tables seem almost exactly like the Excel spreadsheets that I’m more comfortable with. So if i’m storing my employee’s schedules in my database, it’s natural to define columns called Monday, Tuesday, Wednesday, Thursday and Friday because that’s the way I want it displayed.
One thing that might be a bit more subtle: It’s not too hard to convince people to define normalized tables. It’s a little harder to convince people not to pivot in the database either. In other words, don’t figure out how to write a query that returns columns Monday, Tuesday, Wednesday, Thursday and Friday. Figure that out in the application.
- T-SQL is just Programming: Okay, so I need to process this data. It shouldn’t be too much harder than C#. Oh look, there’s an IF statement and WHILE statement. Now all I need to know is how to access each element of a set. Lets see what this CURSOR statement does…
CURSORS have their place, but it’s not a particularly nice place. I’ve used them in the past but only in special circumstances. I see cursors written by others too and most of the time they’re not needed. Over 90% of the queries I write begin with INSERT, UPDATE, DELETE or SELECT
Practice Makes Perfect and Interest Makes Practice
For me the exercises in Drawing on the Right Side of the Brain helped me improve rapidly. The speed I improved was surprising. From zero to mediocre didn’t take me a month. It took me a week. From mediocre to good didn’t take me a year, it took me maybe a month. This fed my interest. The interest led to more practice. More practice led to even better results. It was a beautiful cycle and everything a hobby or passion should be.
Drawing sketches led to pastel paintings, life drawing classes and to digital paintings (not necessarily in that order). And I’m still learning and have a long way to go. (For example, Toronto artist Rosemary Travale drew this picture of Captain Picard and wish it were me. I want to be able to draw like that.).
So practice makes perfect and the database field is no exception. Once the basics sink in, it makes the next things easier. There’s always something new to learn. Hopefully the field is as interesting for you as it is to me. For me it makes the work a “chosen profession” instead of a job.
What’s your hobby? Piano? Chess? Frisbee Golf? Recreationally writing articles for mathematics journals?