oe canyoureleaseaproduct

8/18/2019 OE CanYouReleaseAProduct

http://slidepdf.com/reader/full/oe-canyoureleaseaproduct 1/28

Can you Release a Product

?

-Chacko Daniel , Ti Jeferson and Grant Culbertson

SQL Release ana!ers



"!enda

#ntent $ To %ro&ide insi!ht into 'hat it takes torelease a %roduct like SQL(

)ill touch on the *ollo'in!+( &olution o* SQL n!ineerin! Princi%les

( a.or Phases o* a %roduct

/( Ter0inolo!ies, De%endencies, De*ect 1ars etc

2( Tools used

3( Q4"

526+/65++



&olution o* n!ineerin! Princi%les

7

8ld9 SS

Princi%les

7:e'9 "1Cn!ineerin!

Princi%les

Draft

526+/65++ /



Ty%ical 1o; Rhyth0

Ser&ices <"1C= Rhyth0

S"PL D"T"

526+/65++ 2



Product

De>nition

Product

;ecution

ProductRelease

Product

ser&icin!

a.or Phases o* the %roduct

Product

;ecution

ProductRelease

Product

ser&icin!

Product Denition

• Deter0ine &iable business reasons *or a Product release

• #denti*y !eneral ti0e *ra0es and release e&ents *or the %roduct(

• #t is ty%ical *or a @ision doc to be created at the end o* this efort

Ao' is it done ?

• 1y researchin! and antici%atin! technolo!y trends and business0odels, co0%etiti&e landsca%es, and custo0er needs

)hy ?

• To hel% en!ineerin! tea0s understand the &alue o* 'hat needsto be deli&ered(

Breuency De%ends <ty%ically $ + to 2 0onths=, re&isited e&erysi; 0onths or so *or releases tar!etin! the cloud(

526+/65++ 3



ProductDe>niti

on

Product;ecuti

on

ProductRelease

Productser&icin

!

a.or Phases o* the Product

Product Execution

• )e %roduce the %roduct %lan, Scenarios, ;%eriences, Story boards(

• " %rioritiEed *eature6#0%ro&e0ent list to !uides us on resourceallocation and %ro&ides 'orkFo' direction to achie&e esti0ated

release e&ents *or the i0%ro&e0ents <*eatures=(• The de&elo%0ent %lan, content %lan, test %lan, localiEation %lan,

8%eration %lan and ser&iceability %lan are %roduced as 'ell(

• The %roduct is de&elo%ed in an iterati&e 0anner usin! i0%ro&e0enttea0s(

•

ach i0%ro&e0ent is *ully tested *or uality and 0eetin! the end-to-end scenarios6e;%eriences(

• 8nce all i0%ro&e0ents are checked in *or a !i&en release e&ent,inte!ration tests are co0%leted and the tea0 certi>es a releasecandidate(

@STS SourceDe%ot

Re%ortin

!Ser&ices

SharePoint 8HceProducts ore(( Tools Ised 526+/65++



Plannin! Ter0inolo!y

Scenarios

;%eriences

Storyboards

•

What business%roble0 does acusto0er ha&e and

• Why 'ould so0eonebuy our solution <the&alue %ro%=

• How our usersinteract 'ith our%roducts

• )e can co00unicatee;%eriences throu!hStoryboards

Product;ecuti

on

526+/65++ K



Plannin! 4StaHn!

;ecution

Plannin! 4

StaHn!

;ecution

Plannin! 4StaHn!

;ecution

T i 0 e

#0%ro&e0ent De>nition

Scenario

Conce%tion

;%erienceDe>nition

(((

Product Plannin!

#0%ro&e0ent De>nition #0%ro&e0ent De>nition

'ork continues only 'hen%riorities dictate and resourcesallo'

Scenarios, ;%eriences 4#0%ro&e0ents

Product;ecuti

on

526+/65++



#0%ro&e0ent Li*ecycle

Plannin!4StaHn!

;ecutionDe>nition

"%%ro&al"%%ro&al "%%ro&al

R#Check%ointCheck%oint

Product;ecuti

on

De>nition• Part o*

%roduct%lannin!

• #0%ro&e0ent is de>ned

;ecution• 1uild #0%ro&e0ent• Docu0entation 4

collateral

• R# into 0ain

• Ael% resol&e %ost-R#

conFicts

Plannin! 4

StaHn!• #0%ro&e0ent

stafed, %lannedand s%ecMd

@STS SourceDe%ot )TT SharePoint 8HceProducts 1uildSyste0

Tools Ised 526+/65++ N



1ranch6Quality 1reakout

• ain 1ranch• #0%ro&e0ents R# into ain• :o direct check-insO• Tests GQL Suites

• StabiliEation 1ranch• Pur%ose continuously test 4 >;

%roble0s in ain 'ithout blockin!#0%ro&e0ents

• "%%ro&ed de*ects in ain !et >;ed• Tests Bull *unctional, stress and

%er*or0ance, Playbacks etc

•

PreRelease 1ranch• Burther stabiliEation• 7"l'ays N 'eeks *ro0 shi%9• CTPs6RCs are built out o* this branch

and released• Tests "dhoc, *ull lon!-haul

StabiliEation

CTP+QB CTPQB RC

RTQB

PreReleas

e

ain

#0%ro&e0ent

"

#0%ro&e0ent

GPC 1u!Bi;

@STS SourceDe%ot

Re%ortin!

Ser&icesSharePoi

nt8Hce

Products1uild

Syste0 Tools Ised

Product;ecuti

on

526+/65++ +5



1uild Rhyth0 - Sa0%le

@STS SourceDe%ot

Re%ortin!Ser&ices

SharePoint

1uildSyste0

Tools Ised

Product;ecuti

on

526+/65++ ++



;a0%le @STS Query

;a0%les o* 8ther )ork ite0s in @STS• Check%oint• Criterion• De*ect• #ssue• Release• Resource• Scenario• Task•

((

Product;ecuti

on

526+/65++ +



;a0%le @STS#0%ro&e0ent Aierarchy

Product;ecuti

on

526+/65++ +/



;a0%le @STS Custo0er TabProduct;ecuti

on

526+/65++ +2



SharePoint

•Release %rocess, %rocedures,co00unication

• )ikis, re%orts, lessons learned, etc(

•;a0%les

Product;ecuti

on

526+/65++ +3

• ili0an.aro htt%66slser&er

6%ro.ects6ili0an.aro6de*ault(as%;• Denali

htt%66slser&er6%ro.ects6Denali6de*ault(as%;

• Jakarta htt%66slser&er6%ro.ects6d%u6de*ault(as%;

http://sqlserver/projects/Kilimanjaro/default.aspx


http://sqlserver/projects/Denali/default.aspx


http://sqlserver/projects/dpu/default.aspx











Product Quality

• 8&erall $ 0ake 0easure0ents at t'o le&els – "t the *eature6i0%ro&e0ent le&el $ Quality !ates6R#

Criteria

– "t the %roduct le&el $ ;it6Release Criteria

• Breuency – Quality Gates $ Quality 0in-bar that each ne' *eature

6i0%ro&e0ent or chan!e has to 0eet %rior to bein!added to the %roduct

–

;it Criteria $ Product uality 0in bar at e&ery Releasee&ent( s%ecially the ones that 'ill be e;%osed6Released to the custo0er

@STS SourceDe%ot

Re%ortin!

Ser&icesSharePoi

nt)TT "rubaools Ised

Product;ecuti

on



Quality Gate/RI riteria !rief Descri"tion

"P# Re&ie' :e' or chan!ed 0ana!ed "P#s si!ned of by the )inB "P# Re&ie' tea0

1usiness Co0%liance This uality !ate *acilitates a'areness, trackin!, and &eri>cation o* business%olicies and le!al reuire0ents afectin! all so*t'are that is released e;ternally*ro0 icroso*t( Co0%liance 'ith all a%%licable %olicies 0ust be 0et %rior to anyso*t'are bein! released(

Code Co&era!e " 0ini0u0 code co&era!e bar *ro0 the tests 'ritten by the *eature tea0 ensureshi!h uality check-ins

#ntellectual Pro%erty Protection The %atent re&ie' %rocess %rotects our intellectual %ro%erty in the %roduct

Bunctional S%ecs The s%eci>cation 0ust includeU " Technical Docu0entation License "!ree0entU " section relatin! your s%eci>cation to the end-to-end scenarios and e;%eriencesassociated 'ith your *eatureU " ter0inolo!y section( U The si!ned-of #ns%ection ChecklistU The si!ned-of Beature Co0%lete #ns%ection ChecklistU Reuire0ents, includin! constraints, !oals, non-!oals, and scenariosU De%endencies , U Desi!n

Per*or0ance Re!ressionPre&ention This !ate ensures that 'e donMt i0%act %roduct %er*or0ance unintentionally( Thecore set o* RPS tests 0ust run 'ithin their s%eci>ed %er*or0ance 0etrics %rior toR#( Beature Cre's are res%onsible *or the %er*or0ance o* their *eature and itsi0%act on o&erall %roduct %er*or0ance

Pseudo Loc The !oal o* the Pseudo Loc Quality Gate is to &alidate that the %roduct has beenauthored and desi!ned a%%ro%riately *or the international &ersions( The intent is toaddress localiEability issues at the source and to !et early and in-de%th testin!co&era!e( Ai!her uality at the source localiEation %roduction cost reductionand %roduct uality increase(

8ther Co00only usede;a0%les

1uild @eri>cation Tests, Static "nalysis, Test %lan, De& Desi!n s%ec, Threat 0odel

Product Quality Quality Gates6R# Crite<;a0%les $not a co0%lete list =

Product;ecuti

on



Exit riteria !rief Descri"tion

Code #nte!rity @irus Scannin!Product Grou%s are res%onsible *or shi%%in! +55V &irus-*ree code( Code Si!nin!"ll icroso*t so*t'are >les 0ust be di!itally si!ned usin! a icroso*t di!ital certi>cate 0ana!edby Product Release Ser&ices <PRS=( Custo0ers and %artners 0ust be able to &eri*y that so*t'are>les 'e distribute ha&e been %roduced by icroso*t and ha&e not been 0odi>ed(

Geo%olitical Geo%olitical Risk "ssess0ent"s assess0ent o* the %roductMs o&erall susce%tibility to !eo%olitical risk should be co0%leted bythe Geo%olitical a!ent( :on-Te;t le0ent Re&ie'

"ll :on-Te;t le0ents should adhere to the Guidelines *or Gra%hics 4 #0a!es <incl( "LL non-te;tcontent like audio and &ideo= Se&erity + Geo%olitical 1u!s Bi;edProduct Grou%s are res%onsible *or shi%%in! so*t'are 'ith 5 Se&erity + Geo%olitical 1u!s( Te;t le0ent Re&ie' <PoliCheck=Product Grou%s are res%onsible *or shi%%in! so*t'are 'ith 5 Se&erity + Geo%olitical 1u!s(

Security The Security De&elo%0ent Li*ecycle <SDL= contains the 0ini0u0 security reuire0ents *or 0osticroso*t so*t'are releases( 1e*ore >nal release, e&ery so*t'are release *or 'hich the SDLa%%lies 0ust success*ully co0%lete a Binal Security Re&ie' and recei&e a%%ro&al *or theso*t'are release(

GlobaliEation "ll %roduct6*eature scenarios 0ust %ass usin! n!lish W%roductXon !lobaliEation %lat*or00atri; under the *ollo'in! conditions <e;ce%t 'here li0ited by the host %lat*or0 and6or e;ternalde%endencies=• "ll *eatures 0ust su%%ort Inicode and Inicode surro!ate %airs•"ll *eatures 0ust su%%ort 1iDi scenarios•Y((

"ccessibility "ll *eatures 0ust con*or0 to the Section 35 criteria, and all bu!s in any ne' *eatures that0eet these criteria 0ust be >;ed by Yaddition, any 'eb content !enerated by W%roductX 0ust0eet Le&el Z"M Con*or0ance as set by the )eb Content "ccessibility Guidelines <)C"G= +(5( <htt%66'''('/(or!6TR6)"#-)1C8:T:T6=

"ny e;ce%tions to su%%ort *or Section 35 standards 0ust be re&ie'ed and si!ned of on byW ((X((

Product Quality ;it Criteria6Release Criteria<;a0%les $not a co0%lete list =

Product;ecuti

on



De*ect 1arsProduct;ecuti

on

!#G !$R P% P& P' P()ell *ode

$S+ *ode

Recall *ode

*edia Puller

*ode

)ell *ode,• ana!ed by 0ail

@STS SourceDe%ot

Re%ortin

!Ser&ices

SharePoint 8HceProducts 1uildSyste0 Tools Ised

$S+- Recall . *edia Puller *odes,• Daily Shi%roo0 as :eeded to 0ana!e

reuests

526+/65++ 5

http://var/www/apps/conversion/tmp/


http://www.w3.org/TR/WAI-WEBCONTENT/

http://www.w3.org/TR/WAI-WEBCONTENT/




Product

De>nition

Product

;ecution

Product

Release

Product

ser&icin!

a.or Phases o* the %roduct

Product Release / Hostin 0as a ser1ice2 The si!ned of release candidate is then released

to 8%erations to be rolled out as a %ublic ser&ice<"Eure= or6and is released to )eb6anu*acturin!(

Product Ser1icin This %hase also *ocuses on

the on!oin! sustainability and 0aintenance o*the %roduct <includin! issues related to ourser&ice6"Eure =

Tools Ised

R8QSu%%ort Tools RS CP DS Connect

)inBabric

)in"Eure526+/65++ +



@STS

CP;

R8Q

"P

)TT

Re%ortin!Ser&ices

SharePoint

PC Tool6eys

DS

Connect

Source De%ot

8Hce Products

RS

Su ort tools

Tools 'e use

526+/65++



CTP 6RT8 6RT) 6RT

CP; Su%%ort Tools RS R8Q DLC Connect )inBabric )in"Eure

Tools Ised

ProductRelease

526+/65++ /



#te0s 'e did not co&er

• Borecastin!

• eys

• SIs

•

IL"• Channels <BPP, 8, @L=

• 18

• Product Launch

• SD:, Tech:et, C"R

• CC

• "nd a host o* other 0o&in! %arts((

526+/65++ 2



Discussion6 Q 4"

526+/65++ 3



Thank [ou

526+/65++



S%eaker 1ioMshac3o Daniel, chac3dan45icrosoft6co5

Chacko is senior %ro!ra0 0ana!er 'ith 0ore than +3 years o* e;%erience s%read o&er %roductde&elo%0ent and consultin! in the in*or0ation technolo!y industry, *ocusin! on lar!e-scale syste0sinte!ration, desi!n, de&elo%0ent, testin!, and i0%le0entation in the %ublic sector, insurance,teleco00unications, and 0anu*acturin! industries( Ae has success*ully 0ana!ed co0%le; issues in theareas o* %roduct de&elo%0ent and release, %ro.ect 0ana!e0ent, strate!y and o%erations, %ro%osalde&elo%0ent, 0arketin!, &endor relations, ne!otiations, technical in*rastructure, desi!n, construction,testin!, uality control, uality assurance, %ost-%roduction su%%ort, ser&ice le&el a!ree0ents, anda%%lication chan!e control re!i0es(

Currently, Chacko is the release %ro!ra0 0ana!er *or SQL Ser&er Code-:a0ed \Jakarta(\ Pre&iously, he'as the release %ro!ra0 0ana!er]SQL Ser&er 5++ <no' transitioned to Ta0ara=, the release %ro!ra00ana!er *or SQL Ser&er 55 R, %artner %ro!ra0 0ana!er]SQL 1usiness Init to 8Hce Di&ision( 1e*ore

.oinin! icroso*t in 55, he 'orked *or Deloitte Consultin! LLP and 'orked in the lar!e scale auto0ationsin the areas o* %ublic sector, elections 0ana!e0ent, edicaid, and teleco00unications(

)i 7e8erson, t9e8ers45icrosoft6co5 Ti is currently the release 0ana!er *or SQL Ser&er "Eure and )indo's "Eure arket%lace Dataarket( She

has been on the SQL tea0 since January 55N( Prior to that, she 'as a release 0ana!er *or SQL Ser&er55 R and icroso*t 8Hce Per*or0ance Point Ser&er 55K ana!e0ent Re%orter( Ti has been 'ith theco0%any *or +5 years, and has been a release 0ana!er *or N years(

526+/65++ K



$PPE:DI;

526+/65++



N

0<n=Pre5ises2

Infrastruct

ure0as a Ser1ice2

Platfor5

0as aSer1ice2

Stora!e

Ser&ers

:et'orkin!

86S

iddle'are

@irtualiEation

Data

"%%lications

Runti0e

Stora!e

Ser&ers

:et'orkin!

86S

iddle'are

@irtualiEation

Data

"%%lications

Runti0e

[ o u 0 a n a ! e

an a ! e d b y s er &i c e %r o&i d er

an a ! e d

b y s er &i c e

%r o&i d er

[ o u

0 a n a ! e

[ o u 0 a n a ! e

Stora!e

Ser&ers

:et'orkin!

86S

iddle'are

@irtualiEation

"%%lications

Runti0e

Data

Software

0as aSer1ice2

an a ! e d b y s er &i c

e %r o&i d er

Stora!e

Ser&ers

:et'orkin!

86S

iddle'are

@irtualiEation

"%%lications

Runti0e

Data

Plat*or0 "bstraction

oe canyoureleaseaproduct

Documents