Click here to monitor SSC

Tony Davis

Simple-Talk Editor
News, views and good brews

Bar-Poo for DBAs and Developers

Published Friday, December 19, 2008 1:31 PM

DBAs and Developers seem to live in parallel universes. If and when they talk to each other, the air is often thick with misunderstanding. It seems that what we have here is a deep-seated communication problem. Although the two groups share a common technical language, they use terms slightly differently. A 'domain', 'transaction', 'object', 'entity' or a 'framework', for example, has subtly different meanings to the two camps. When a problem occurs, tensions can quickly rise as confusions in terminology get misinterpreted as accusations of blame. In short, communication between the two groups is shot through with a sort of cognitive dissonance, akin perhaps to a continuous Stroop effect.

 

I'm reminded of a short blog post by Seth Godin, in which an angry woman orders a "double double" and responds to the bemusement of the coffee shop attendant by simply repeating the same phrase, only louder. It's a pattern I see frequently in the interaction of DBAs and developers. Sometimes you need to find a different way to explain things.

 

Perhaps the answer is to create a new, mutually understood, language. When different cultures come together for a common purpose they often develop a new language to deal with the struggle. In the Great War, for example, the British army was peopled with a vast array of different cultures. In a spirit of camaraderie, they developed a private language, adopting words or phrases from different cultures, and giving them a new ironic meaning. Some of my favourite examples include archie, bar-poo, Asiatic Annie, belati (blighty), make a bogey, bondock, bun-strangler, cat-stabber, conk out, Dub-dub and Flaming Onions.

 

In the holiday spirit of enhancing kinship and fraternal feeling, we propose the development of a new common language for developers and DBAs. We encourage you to contribute your terms and definitions. The best entry, added as a comment to this blog, will receive a pair of Sennheiser noise-cancelling headphones, and the best runners-up will get Amazon vouchers or Simple-Talk gift bags.

 

To get things started, how about these:

 

Bar-Poo – To rush around prophesying that a project is doomed

BitHog – Memory intensive process

Bun-strangler– Teetotaller

Cookie – CPU

Cookie monster – CPU-hungry stored procedure

Data-dodger – Someone who is never around when the application hits data issues

DBA-AwayDay – DBA is closeted in the server room and won't come out

Deadlock holiday – Production system dies due to too many deadlocks

Doing a Gordon – Managing to break everything all at once

Domain Knowledge – Unhealthy interest in Middle-Earth

Dormouse – Anyone advocating, or using, Hibernate

Fluffer – Malfunctioning trigger

Freezing Temp DB – The effect of putting an exclusive lock on TempDB.

Gone Mae West (Syn: Gone dolly) – Database is bust, big time.

Grapeshot – Too many instructions and directives flying around everywhere

Heaphazard – Erratic indexing

Heaptastic – No indexing

Icarus – Anyone with a fascination for 'cloud' computing

Keyboard-junkie – Developer who types in code before planning

Kuntrachi – A contractor

Object of derision – Proselytizer of object databases

RastaBase – Any database prone to deadlocks

Serialisation – Turning a good book into a bad TV series.

Table-monkey – A developer who insists on access to base tables

Thremple – Endanger database by placing undue pressure on tempdb (e.g. to give a database a good thrempling)

TSQL Tourniquet – Code that encourages SQL Injection

 

Look forward to hearing your suggestions! Thank you to everyone who contributed to my previous "Grid" editorial; the winner of the voucher this time was Daniel Penrod.

 

On a wider note, I'd like to thank everyone who has contributed in some way to what has been a fantastic 2008 here at Simple-Talk. I wish you all a happy holiday season and the best of luck for the New Year.

 

See you all in 2009. Cheers!

 

Tony.

Comments

 

Posts about Internet Marketing Experts as of December 19, 2008 | The Lessnau Lounge said:

December 19, 2008 12:42 PM
 

GilaMonster said:

Chain Gang - a development team overly fond of Linq
December 19, 2008 3:22 PM
 

daftviking said:

I'm gonna have to object to "cookie", as you'll run into a namespace conflict talking with web developers, but the rest are lovely - I'm especially curious as to the etymology of "doing a Gordon".
December 20, 2008 12:15 PM
 

Phil Factor said:

Gordon Brown is a guy who, pretending to be shrewd and prudent with money,  has been doing gigantic Ponzi scheme for years which, it is now becoming apparent has been 'nothing but a sham',  has lost many billions of pounds and has caused an entire economy to go bust. Or am I getting confused?
December 20, 2008 12:44 PM
 

daftviking said:

Phil, would this be the same Gordon Brown currently occupying 10 Downing Street? Please pardon the perplexion of a poor Canuck, who has enough trouble keeping track of his own country's corrupt and/or inept politicians.
December 21, 2008 8:52 PM
 

timothyawiseman@gmail.com said:

Abomination - Database structure designed without thought, always horribly non-normalized

Birdie - Developer who spends so much time on twitter and related services they get no work done.

Litterer - someone who creates permanent tables as temporary working space and then leaves them in production

December 22, 2008 11:18 AM
 

dgrace said:

Saint Pancras - One who creates a table that conains everything they need in one "easy to query" place, rather than normalizing it properly.
December 22, 2008 11:54 AM
 

imassi said:

Contraptionized Import - An data import process that uses multiple jobs that call jobs, temporary tables, triggers on tables, row by row processing and God-knows-what-else to bring data from one data source into a database.  In short, a Rube Goldberg machine that imports data.

Fredified - A project that is so bogged down in the minutiae of documentation, meetings and waiting for decision makers to make decisions that all progress has stopped.

Running the Gauntlet - Asking stakeholders to clarify functionality requirements while trying to avoid having them change the core requirements.

Project Rollback - Stakeholders change the requirements so much that progress moves backward.  Typically happens when running the gauntlet.
December 22, 2008 12:02 PM
 

imassi said:

Forgot one,

Naked Twister - An application or system that is so convoluted, poorly documented and/or otherwise painful to work with that you'd rather play Twister with your manager - naked, than continue to work on it.  As in "This application is completely Naked Twister" or "Hey man, the project I'm on has gone Naked Twister.  Any job openings where you are?".
December 22, 2008 12:11 PM
 

ScottR said:

Surprise Pee - The unexpected (and ferquently physical) effect of a stored procedure that suddenly deletes all your Invoicing subsystem
December 23, 2008 5:53 AM
 

nandu said:

.NET - I would like to see that dot on the Internet. Please show me one.

network - How many hours world wide web aka Internet works per day?

Browsing Internet - How can I browse outernet?

MSDOS - Microsoft denial-of-service

SQL - Structured Quick Language

Microsoft Exchange - When did Microsoft opened the telephone exchange?

Blogs - Beware of logs

Forums - I want 4 bottels of Rum

Windows Live - Can you please tell me the channel number so that I can tune in to watch

Windows?

Outlook Express - Is it a train?

Start | Run - I can see a small dialog when I click on it but it is not running.
December 23, 2008 6:19 AM
 

MacMcCabe said:

Trigonometry – Practice of creating more triggers than there are tables in a database

Back-Up – What you physically do when the DBA tells you to “allow him to have a look at the problem”

Suspect – The person who ran the DELETE statement without highlighting the WHERE clause

Terabyte – What you get when some of the electrical cables in the server room aren’t as insulated as they should be when touched

Recursor – a developer who use cursors to do absolutely everything in a database

Memory Dump – What a business user does when trying to explain his requirements to a developer

OCNC – (Obsessive Compulsive Next Clicker) – The disorder associated with running an installation and clicking “next” without reading the dialogs

Woosh – The sound a deadline makes when rushing past

Back to the Future – “You start building the solution, I’ll go get the spec..”

Acronymatrix – The situation you find yourself in when an external “expert” consultant walks in throwing around so many acronyms that you have to duck and dive before they’ll kill you.  Eventually you realise none of what he said was “real”
December 23, 2008 6:29 AM
 

KevDog said:

Securi-Drone: A DBA who insists on the strictest security possible, regardless of circumstances.
December 23, 2008 7:21 AM
 

codegumbo said:

Seagull: anyone who swoops in, makes a lot of noise, craps all over the project, and flies away.

BLOCKS: What a DBA does when they say they'll "review the code".
LOCKS:   When a DBA takes away developer rights to read data
LATCHES: The clicking sound made when escorting a developer back to their "pen"

Business logic: that mythical realm somewhere between the application and the database where unicorns roam free, puppies are happy, and performance costs have nothing to do with business decisions.
December 23, 2008 7:24 AM
 

raibeart said:

Martha: Your one user that can find any soft spots in your software and break it.

Martha Proof: Programming so that your "Martha" cannot break it.
December 23, 2008 7:29 AM
 

MacMcCabe said:

more... (guys in the office yelling out additional comments.  It's becoming a team effort.)

Cluedo - the process of finding the culprit that breached security..."It was the senior developer with sp_helptext in query analyzer!"

Data Minor - the new guy....revoke all access to production servers

A Jackson - a stored procedure that has been changed/added to by so many developers that the original is not recognizable any more

Fabrication - The actual time a query will take to run on production.

HoseHippo - A query accessing a 500 million row table via a linked server (sucking a hippo through a hose pipe)

A Nancy - A developer who insists that other developers comment their stored procedure code....if was hard to write, it should be hard to understand!

SSISy - A predictable SSIS package

Like yours codegumbo!
December 23, 2008 7:40 AM
 

BEACHDBA said:

Arial Sharon - someone who complains each time they run MS Word because their font defaults to Arial
December 23, 2008 7:59 AM
 

ssgoat said:

Fonzie - the guy that stays cool no matter how many servers come crashing down.

*seagull gets my vote
December 23, 2008 8:20 AM
 

r_honey said:

Boot-a-Bush: Having to boot up a server due to a problem out of the bush
December 23, 2008 9:00 AM
 

JonRobertson said:

Many of these are good, although most are slanted against developers.  :)

DB Nazi:  DBA who would rather gas developers rather than work with them.

Sentry:  DBA that prevents developers from touching "their" database.

Jigsaw - DB so excessively normalized that you can't see anything without JOINing all the pieces together.

Rubiks cube - OLAP cube that takes longer to process than a Rubiks cube takes to solve (without cheating).
December 23, 2008 9:56 AM
 

Funker said:

voodoo/black magic - n. what developers and DBAs accuse each other of; syn:mojo
mojo - n. what developers and DBAs think the other lacks; syn:voodoo, black magic

caltropic - adj. a database so normalized that a developer can't execute a simple query without stepping through multiple joins


I like 'seagull'.

December 23, 2008 10:05 AM
 

Funker said:

jigsaw = caltropic
must have come from a developer's perspective ;)
December 23, 2008 10:07 AM
 

Rodney said:

DB(A)M: Prounounced D-BAM or DBA-M - The actually time the on call DBA arrives to work in the AM after being up from 11:00 PM to 2:45 AM chasing job failures.

right-right: Usually followed by "but...".  Found in conversation with DBAs and developers when they both know for certain that their line of argument is correct as to what the problem really is:

Dev: As you said, this is a virtual system for the website, so obviously there could be some bottlenecks with the CPUs that are causing some latency with the data and therefore some locking.

DBA: right-right, but...you can see that utilization is low on the SQL side, which obviously is physical.


December 23, 2008 10:20 AM
 

Aloha DBA said:

If you haven't done so, check out this Simple-Talk Editorial by Tony Davis, in addition to all the
December 23, 2008 1:12 PM
 

Peter DeBetta said:

Oh Tony, do you have nothing better to do before the holidays? ;-)
December 23, 2008 1:51 PM
 

Tim Ford said:

Vend-stanza: Vendors who insist on setting autoshrink=ON in their supplied databases.  (cross reference George Costanza / Shrinkage)


December 23, 2008 2:28 PM
 

far_terrace said:

Mapkin - Drawing your enterprise architecture on a napkin.
December 23, 2008 3:17 PM
 

Andrew Clarke said:

Posted on behalf of Robert Kam

I didn't see a link where I should add to the list of DBA-developer techie bridge words.
Here are mine:
bobfuscator:            One who bobs and weaves when asked questions to avoid addressing issues through use of obscure jargon.
                       (Bobfuscation can be played as a team sport too!)
Black hole:             Consultant who can only answer questions after contacting their tech support group
Screen flipper:         Developer playing solitaire
flatliner:                      Server that does not respond to ping
paperweight:            Dead server

By the way, my favorite is table monkey. It's a funny article in any case.
December 23, 2008 3:45 PM
 

kgh said:

A bit late to the party... Catching up on post-Holiday mails.

Group Fornication:    A Cluster F... well, I think you can figure out the other letters.
While not really be a bridge word/phrase as such, it's a rather more office friendly euphemism for the state most projects are in by the time bridge words are needed.
December 29, 2008 10:19 AM
 

Phil Factor said:

Management Decision:   To  'make a management decision' was a euphemism so ingrained in my family that when my baby sons had filled their potty, they proudly said they'd 'made a management decision'. or.. 'The dog has made a management decision on the carpet!'. they were very reproachful to me on getting home after mistakenly asking their teacher if they could make a management decision.
December 29, 2008 10:48 AM
 

pjones said:

Foggy or fogged up - a stored procedure or query written by a developer that queries a view (not the indexed kind) which queries another view which in turn refers to another view which......


Fogbound - the database full of the above views and stored procs which as a result performs like a dead slug!

This is definitely a "Naked Twister" and I'm trying to unravel one :-(

January 9, 2009 10:19 AM
 

Managing Monsters in Meetings - Part 6, Deadlocked Discussions said:

February 16, 2010 11:11 AM
You need to sign in to comment on this blog
<December 2008>
SuMoTuWeThFrSa
30123456
78910111213
14151617181920
21222324252627
28293031123
45678910
Migrating from OCS 2007 R2 to Lync: Part 4
 Having migrated the rest of our users and legacy resources across, and start getting ready to... Read more...

Automated Script-generation with Powershell and SMO
 In the first of a series of articles on automating the process of building, modifying and copying SQL... 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...

Using SQL Test Database Unit Testing with TeamCity Continuous Integration
 With database applications, the process of test and integration can be frustratingly slow because so... Read more...

Converting String Data to XML and XML to String Data
 We all appreciate that, in general, XML documents or fragments are held in strings as text markup. In... Read more...