SchemaDeployment IncrementalSchemaDeployment ModelBased DACPAC SQLScript RetargetingSupport SQLServer2005SQLServer2008SQLServer2012SQLAzure Format Engine API REDIST Connected CONNECTEDDEVELOPMENT PROJECTBASEDDEVELOPMENT SCHEMADEPLOYMENT Challenges Morepeopleusingthesystem PowerPivotforExcel UserExperience PowerPivotintheMicrosoftBISolutionStack PowerPivotCollaborationEnvironment ITProfessional Executive Analyst InformationWorker DecisionMaker MicrosoftSQLServer DataSources IBMDB2 Others OLEDB ODBC TextFiles ExcelFiles MicrosoftSQLAzure Teradata ReportingServices DataFeeds Oracle DataInfrastructureandBIPlatform CollaborationPlatform PowerPivotforSharePoint Trends INTEGRATE DEVELOP ACCESS TeamExplorerEverywhere EXTENSIBLEAPIs SharePoint ProjectServer SystemCenter SQLServer Office WebAccess WindowsAzure VersionControl BuildAutomation CustomizableProcesses RequirementsManagement TestCaseManagement ProjectManagement End to EndTraceability LabManagement Analytics DeveloperExperience TheToolforWindows WorkwithHTML5 EngineeringTrends BrowserInteractivity PowerPivotforSharePointFeatures ScheduledDataRefresh WorkbooksasaDataSource PowerPivotGallery ManagementDashboard BISMlinkfilesDatafeedlibrary UpgradingorPatchingMulti ServerFarmsMultiplePowerPivotApplicationServers PowerPivotAppServers 1 Installthenewversionorpatchaccordingtothedeploymentinstructions 2 RunthePowerPivotConfigurationTooltoupgradefeatures services applicationsandsolutions 3 MovetothenextPowerPivotapplicationserver BesuretobothpatchandconfigureeachinstancebeforecontinuingtothenextPowerPivotapplicationserver ThePowerPivotConfigurationToolmustcompletetheupgradetaskforthecurrentinstancebeforemovingontothenextinstance ItmustupdatetheserverversionintheSharePointconfigdb Afteryouupgradethefirstserver additionalserversthatarenotyetupgradedwillbecomeunavailable Agenda Packages AppModel WebPlatform WinRTPlatform ProcessLifecycle EnterpriseFeatures 1 5 2 3 4 KeyAppModelConcepts Apppackage Runningapp WindowsRuntime 1 2 3 Packages HTML CSS JavaScript Resources Manifest C ProgramFiles WindowsApps Apppackage Runningapp WindowsRuntime Lineofbusinessapps CapabilitiesprivateNetworkClientServerinternetClientServerenterpriseAuthenticationsharedUserCertificates Security PrivacyProtectHBI MBI andPIICryptographyWinRTAPIsRoamingHTTPS onlyconnections OfflineStructuralcontentDynamiccontent Windows8 Cloud connected Builtonasolidfoundation GetmoreattheWindowsStore Athomeandatwork Alltheappsyouwant ReimaginedbrowsingwithIE10 Windowsreimagined Greatexperienceacrosshardware TypesofMetroStyleApps Examples Consumer B2C LOBISV CustomLOB ExpenseApproval Headtrax CompanyNews Usedby Consumer Business Builtby Distribution TechCompany WindowsStore Enterprise WindowsStore TechCompany WindowsStoreorSide loaded Enterprise Side loaded PLM AuthenticationandSecurityMeetingenterprisestandards IntegratedWindowsauthentication AppCertificate MyandRootstores FederatedADFSAuthentication Multi factorauthentication SingleSignOnwithLive Facebook etc EnterpriseAuthenticationandPrivateNetwork Windows Security Cryptography Certificates CredentialPickerandSharedUserCertificates WebAuthenticationBroker AuthenticateAsync WebAuthenticationBroker AuthenticateAsync TestingLOBApps 3 2 VisualStudioToolsandDebugger Developerlicense 1 WindowsAppCertificationKit Support MetrostyleLOBappstools BLEND VISUALSTUDIO StylingPath editingAnimationVisualStatesTransitions ControlcreationLayoutPropertyeditingBasicdataViewauthoring CodeeditingRefactoringDebuggingCodeanalysisProfiling DESIGNTASKS COREAUTHORINGTASKS CODINGTASKS CloudDrivers CustomerScenarios PublicCloud PrivateCloud Traditional HighlyVirtualizedDatacenter SolutionsthatSpanCustomerScenarios HYBRIDCloud COMMONTECHNOLOGIES ActiveDirectoryIdentityVirtualizationManagementDevelopment TheEnterpriseAgreementSupportsYourCloud ContosoRetailandtheHostedPrivateCloudMovedBusinessIntelligenceSQLapplicationaglobalhostingpartnertoensure24 7accessandloweroperationalcosts BESTPRODUCTIVITYEXPERIENCEWorktogether smarter Office365 Bringingtogethercloudversionsofourmosttrustedcommunicationsandcollaborationproductswiththelatestversionofourdesktopsuiteallowingorganizationstosavetime money anddrivetheirbusiness Office365 KioskPlans TheEnterpriseAgreementSupportsYourCloud SmoothTransitiontoCloudServicesOverTimeEAflexibilityenablesthetransitiontoavarietyofcloudservicesoptimizedtouserrequirements Start 5000On PremisesDevices EndYear1 2500On PremisesDevices 2500Usersofcloudservices EndYear2 1500On PremisesDevices 3500Usersofcloudservices EndYear3 5000Usersofcloudservices ContosoRetailandtheCloud GatherIntelligenceEasilygatheradvancedBIdatatoanalyzeeachretailenvironments StreamlineInfrastructureAutomatethedeploymentofsoftwaretostores ControlOperatingCostsReducethenumberofphysicalseversateachstore ConnectAllEmployeesProvideaccesstocollaborationtoolstoeasilysharebestpracticesandinsight ManagePeakTimesProvidetoolstocontractorstaffduringpeaktimes IndustryTransformations Thelast50yearsofIT Todayand