daniel norwood sr. product manager quest software session code: dev301 terry clancy business...
TRANSCRIPT
ALM for Oracle Developers using Microsoft Visual Studio 2010Daniel NorwoodSr. Product ManagerQuest Software
SESSION CODE: DEV301
Terry ClancyBusiness Development ManagerMicrosoft Corp.
IntroductionsDaniel NorwoodSr. Product Manager Quest Software
Daniel brings over 10 years experience in the software industry specializing in relational database systems and related technologies. In addition to product management, Daniel has worked in support, testing and project management capacities, constantly focused on understanding and meeting customers’ needs. He spends much of his time speaking and interacting with customers around the globe, ensuring Quest’s tools exceed their expectations.
IntroductionsTerry ClancyBusiness Development Manager Microsoft Corporation
Terry Clancy is a Business Development Manager in the Visual Studio Industry Partner (VSIP) team at Microsoft Corp. Terry works with partners to drive their development of products that extend Visual Studio, Visual Studio ALM tools and Team Foundation Server. Terry joined Microsoft in 1992 as a Server Product Manager in Australia and moved to Visual Studio Marketing at MS Corp in Redmond WA USA in 1995. Prior to Microsoft he worked for Network Solutions (Australia), IntraOptics (USA) and Honeywell (Australia, Malaysia and Papua New Guinea). His has a Bachelors Degree in Electrical Engineering and a Masters Degree in Biological Technology.
Session Objectives
Understand:A new approach to Oracle development The benefits of integrating Oracle into your ALM
Learn:How to create your first Oracle projectHow to manage schema changesHow to build & deploy your project
Agenda
Oracle development today
ALM & database support in Visual Studio 2010
Agile Oracle development for .NET developers
Resources
Oracle Development TodayA painful process: case study
Traditional Oracle development challenges the agile environment.
Oracle Development TodayThe “Risk” of online development
Age-old problems:Live DB development = breaking changesImpact analysis is nonexistentCannot refactor code or objectsLittle or no unit testing!Poor source controlBuilding change scripts: Dev > Test > ProdDon’t even think about reverting!
!
Requirements
The three pillars of an Agile approach to database development:
Visual Studio 2010 Premium or UltimateTeam Foundation Server 2010Toad Extension for Visual Studio
Team Foundation Server 2010
A collaboration server for the entire application lifecycle
SQL Server basedSupport for branch, merge, label & shelveTrack changes with work itemsManage builds and unit testing framework
Visual Studio 2010
“[…] an integrated application lifecycle management (ALM) product family with the tools and processes that help development teams work more effectively together”
--source: MSDN.com
Toad® Extension for Visual StudioExtending Visual Studio Development to Oracle
Supports Visual Studio 2010 data featuresManage schema changes with Team Foundation Server 2010Support Agile and iterative methodologiesOracle 9i – 11gR2
Agile Oracle Development for .NET Developers
“Agile” is a pragmatic approach to software development
Individuals and interactions over processes and toolsWorking software over comprehensive documentationCustomer collaboration over contract negotiationResponding to change over following a plan
Visual Studio ALM supports an agile methodology
-- source: Wikipedia, AgileManifesto.org
To Be Agile…
In our development projects, we must have:
To be agile, we must be able to adapt in order to meet customer’s needs
CONTROL FLEXIBILITY CONSISTENCYControlling the environment establishes the foundation
Flexible processes allow you to respond to change
Consistency in testing and the environment result in quality
Database Development in Visual Studio 2010
“Offline” database developmentProject-based, part of your solutionAutomatic impact analysisNo more manual change scriptsSource control becomes the new “master”Application and DBMS code in syncImproved project visibility
ControlEstablish a Foundation
Good change management promotes flexibility and supports consistent quality
Control schema objects, not change scriptsAllow application developers to be innovativeQuickly compare the environment
Demo: Control
DEMO
Create your first Oracle project Add the project to Team Foundation Server Set up version control
FlexibilityRespond to Change
We must provide the freedom to move quickly and the flexibility to try new things
Respond to changing requirementsCustomer & value drivenFoster innovation
Principles of the Agile Manifesto:
“Welcome changing requirements, even late in
development. Agile processes harness change for
the customer's competitive advantage.”
-- source: AgileManifesto.org
ConsistencyDeliver Quality, Every Time
Automate processes for repeatability and consistent quality
Application & DMBS code should be tested in the same harnessTest environment should be consistentAutomated build processAutomated unit testing
Principles of the Agile Manifesto:
“Working software is the primary measure of progress.”
“Our highest priority is to satisfy the customer through early and
continuous delivery of valuable software.”
-- source: AgileManifesto.org
To Be Agile…
In our development projects, we must have:
To be agile, we must be able to adapt in order to meet customer’s needs
CONTROL FLEXIBILITY CONSISTENCYControlling the environment establishes the foundation
Flexible processes allow you to respond to change
Consistency in testing and the environment result in quality
Resources
www.microsoft.com/teched
Sessions On-Demand & Community Microsoft Certification & Training Resources
Resources for IT Professionals Resources for Developers
www.microsoft.com/learning
http://microsoft.com/technet http://microsoft.com/msdn
Learning
Professional Scrum Developer Program
ANNOUNCING
An innovate program for developers fromMicrosoft and the founders of ScrumLearn how to use modern engineering practices to develop an increment of complete, potentially shippable functionality using Visual Studio 2010, ALM, and the Scrum frameworkTraining course, assessment, and certification availableVisit MSDN for more details: http://bit.ly/dppXd0
© 2010 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries.The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to
be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.