DEVDBA

vs

WHAT YOU’LL LEARN:

• Nothing• Of• Value

READY?

LET’S START BY DISPELLING SOME MYTHS

FIRSTLYDevelopers don’t know jack about databases

SECONDLYDBA’s know nothing about development

THIRDLYThey can each do the others jobs

FINALLYThey can’t work together

you?who areSo

Phil Winstanley

Plip

$41T

to your development teams

microsoft expertisewe add

get their apps built and deployed

we help customersbut mostly

is attached to a database.application we see

and nearly every

from the DBA & DEV relationshipsthe pain

so we see

EVERYDAY

the problem?what’s

so,

this?itis

do we fix it?

howand,

to that…come back

we’ll

what we hatelook at

let’s,

about each other.

hate about developers?

do youwhat

well?

your database?to querythey dare

the consequencesdon’t understand

that they

of their queries?

their SQL?can’t tweak

that you

is a null.an empty string

that they think

for live application issues?

they blame youperhaps

up at 11 PM fixing apps.you are the one

do you resent that

pub?are in the

when they

your lovely schema.

the Schema,Oh,

they place on your schema.

demandsthe crazy

developers are a pain in the…

fair to sayIt’s

hate about DBA’s?do youwhat

really, we do.we love you DBA’s,

well,

of things we don’t like…a couple

but, there are

no permissions on the database.

when we havewe love it,

almost have enough permissions.

as much as when wealthough, not quite

drive us insane.‘conventions’

your naming

are_you_fixated_with_underscores?

oh why,why,

we’re on naming ‘conventions’ … and while

oh

like you need your namemakes you look

tbl_customers

underpantsinto your

sewn

mumyour

by

about the same time as …went out of fashion

hungarian notation

they’re really hard to work with!null values

what about,

the painDBA’s knew

if only

the suffering

the torment

the grief

developers.they cause

that

we’re in this together.you do,well

is the real problem.none of thisbut

is only going to get worse.the real problem

and

are one of the main culprits.microsoftwe,

you’re perfect!it isn’t so microsoft,

say

to make our minds up.can’t seem

we

when you can have …data access technology

why have one

RecordSets

XML

ADO

ADO.NET

DataSet’s

Adapters

Readers

DAAB

LINQ to SQL

Enterprise Lib

SQLXML

DynamicData

ORM

Entity Framework

technology focus?our new

and

OData

Oh Dear

of chocolates at a party.a massive pile

like

with data access methods.you’re spoiling us

ambassador

why should you care?you’re DBA’s

but

critical.this will become

more, and more

now.we have controlsorry DBA’s but

as the only way, is over.stored procedure

the time of the

are becoming the standard.

and other ORMsentity framework

they’re here to stay.and for worsefor better

anytime soon.won’t changelegacy systems

storythey’re a differentbut new systems,

not to have a database at all.

common practiceit’s now

dah!dah

dah

from the audience.of horror

gasps

is we’ll generate the schema...

for DBAswhat’s worse

we’ve built the app.after

from the code

to change anything.too late

when it’s

forever more.your problem

then make it

aren’t you?you’re listening now

yeah,

this situation?should we fix

so why,

this.ask yourselves

developers

a database server?cluster

how do you

of tempdb files?

optimal numberwhat is the

session?suspended

what’s a

want to know?do you really

and,

apps.you want to build

no,

about...what do you know

DBAs

environments?statefull

stateless and

viewstate?optimize

how best to

system is?source control

what a

(just for reference, you should know that one)

want to know?do you really

and,

it is that DBAs do for fun.

do whateverno, you want to

drowning kittens

badger baiting

watching ready steady cook

that.like

stuff

this.need to fixwe

too late.before it’s

now,

this situation?how do we fix

so,

guidance.marriage

we need

problem.a technology

this isn’t

more technology.fix it with

we cannot

we follow…the processit’s about

we have…the peopleand

to this.is key

communication

get together…of projectsright at the beginning

be handledwill reallytalk about how data

as onethe whole system

and treat

and databaseapplication

it isn’t

solutionit’s a

fits all.one size

there is no

to help.some tips

here are

lists.e-mail distribution

setup

to sign up.involved

get everyone

alike.and DBAs

developers

your knowledge.in a constructive way

and share

on relevant topicsquick presentations

deliver

and discuss them.whole teamto the

program.to pair

don’t be afraid

together.applicationstest

each otherjust talk toand please

each other.educate

so,

together…work

and,

one another.against

not,

if you can’t get on with your DBA’s

developers,and

to keep them busy.

you can dohere is something

going homejust before they’re

wait until

and add this…from a production boxopen a proc

RAISERROR ('Transaction (Process ID 53) was deadlocked on lock resources withanother process and has been chosen as the deadlock victim. Rerun thetransaction', 16, 1 );

RETURN;

fin.

but suck lesslike this one

there are other sessions

We have many open positions in the UK

http://careers.microsoft.com/

hi@plip.ms

@plip