微軟經(jīng)典模板4(圖形篇續(xù)2)課件

1、Upgrade ArchitectureSQL 2000 AvailableSQL 2000 ShutdownSQL 2005 Full InstallTransfer SettingsDowntimeSQL 2005 Single User Core UpgradeSQL 2005 Multi UserComponent UpgradeSQL 2005 Partial Available“Lazy Upgrade” Full-TextSQL 2005 Full Available“Point of no return”Installer CommitTimeSQL 2000 Uninstal

2、lSQL Server 2000SQL Server 2000 64-bitSQL Server 2005 Beta1SQL Server 2005 Beta2Reporting ServicesSQL ServerAnalysis ServicesAnalysis ServicesSQL ServerSQLDTSAnalysisNotificationReportingSQLReportingAnalysisHow Unified Install Evolved“Media”Unified on the Media“Technical Dependency”Unified with rest

3、rictions“Just Make it Work”Unified with restrictions“Unified Experience“Unified with no restrictionsDTSNotification ServicesToolsToolsTools help migrationVB6 ApplicationVB6VB6VB.NETPrepare for upgradeVB6 Code AdvisorUpgrade and fix issuesMigration WizardEnhance with new featuresVB6VB6VB6Replace ADO

4、with ADO.NETReplace ActiveX controlsReflectionWeb-enableMobile front endAdd graphicsThreat TreesTheft ofAuth CookiesObtain auth cookie to spoof identityUnencryptedConnectionCookies travel over unencrypted HTTPEavesdroppingAttacker uses sniffer to monitor HTTP trafficCross-SiteScriptingAttacker posse

5、sses means and knowledgeXSSVulnerabilityApplication is vulnerable to XSS attacksORANDANDSQL ServerComprehensive, Integrated Data PlatformData Platform Pillars:Data Life CycleBirth to retirementBusiness Value throughoutAll forms of dataRelationalSemi-structuredObjectProgramming against the moving bit

6、sService Oriented Database ArchitectureEliminating business latencyNotification ServicesNotifications & AlertsData Transformation ServicesETLSQL Server EngineRelational Database EngineReporting ServicesEnterprise ReportingManagement ToolsDevelopment ToolsReplication ServicesData ReplicationAnalysis

7、ServicesOLAP & Data MiningMicrosoft BI ArchitectureManagement ToolsDeveloper ToolsPortalsDashboardsData AnalysisVisualizationMessaging ServicesProject ManagementWindows ServerWindows ClientMicrosoft Business Solutions Financial AnalyticsBusiness ScorecardsExcel Add-in for SQL ServerBI Solution Accel

8、eratorsSQL ServerRelational EngineReporting ServicesAnalysis ServicesOLAP & Data MiningOffice SystemQ4Q1Q2Q3Time DimensionProducts DimensionDallasDenverChicagoRegion DimensionApplesCherriesGrapesAtlantaSales FactMelonsOLAP QueriesAbout ScorecardsWhat is the strategy trying to achieve?How will the pe

9、rformance of the objectives be monitored?What performance level is required?What are the actions or programs to achieve the target?Increase customerconfidence in our advice% of customers surveyed who rate us as their topsource of advice 65% #190% #1 or #2Website Resource CenterConsultative SellingTr

10、aining ProgramObjectivesKPIsTargetsInitiativesKPIs = Key Performance IndicatorsQuantifiable measurements that reflect thecritical success factors of an organization Data Access TierBusiness Logic TierData Tier Stored ProceduresProcess BoundaryWeb serversDatabase serverInternet Information Server 6.0

11、ASP.NET 1.1SQL Server 2000Web 1SQLWeb 2Load BalancerNetwork Hardware SFU/Interix Color Legend3rd PartyWindowsApplicationsWindowsApplicationsX11R6serverUNIXApplicationsOpen Sourcetools: Apache,Tcl/Tk, bash, etc.MotifWindows And SFU ArchitectureWindows Kernelwin32k.sysHardware Abstraction LayerFATNTFS

12、Other device driversCDFSClientNFSServerGatewayWindows APIswinsockWin32 SubsystemWindows systemadmin, commandsand networkingWindowscommandShellWindowsGUIInterix SubsystemUNIX /POSIX APIsBSDSocketsUNIXSDK(gcc)UNIXshellstelnetdUNIX, XPG,POSIX.2commands and utilitiesX11WindowsUNIX And Windows Interopera

13、bility Win32 Subsystem.NETFrameworkFileSystemSecurityDirectoryCommonServices.NETAppUNIXAppWindowsAppWindows KernelEvolvedHybrid AppIntegration MethodsDirect invocationPipes Sockets Shared memoryCOMWeb serviceInterix SubsystemReference ArchitectureTransaction Recovery & Checkpoints TransactionsAction

14、 Requiredif restart recoveryNoneCheckpointSystem Failure12345Roll forwardRoll backRoll forwardRoll backLDL/DL/DLLTimeReport SourcesDeliveryChannelsSecurityServicesOutput FormatsReporting Services ArchitectureReport ServerData ProcessingRenderingSecurityDeliveryReport ProcessingProgrammatic Interface

15、sWeb UIMicrosoft OfficeCustom ApplicationsReport Server DatabaseBrowserReporting Server & CatalogReport ServerNT Service (Scheduling / Delivery):Scheduled requests (subscriptions & snapshots)Delivery (e-mail / fileshare)ASP.NET Web Service (Report Processing):Services report requests Execute, proces

16、s, render reportManage sessionsReport Server CatalogReport definitionsData sourcesUsers, policies and rolesReport snapshots & historyReportServerTempDB:ReportServer:Session dataCached reportsClientReport AuthorUserIIS Report ManagerReport ServerDeployment (Local Catalog)SMTPReport DesignerVisual Stu

17、dio .NETReport Server CatalogMSSQLUserDeployment (Remote Catalog)Report Server CatalogSMTPIIS Report ManagerReport ServerMSSQLUserDeployment (Clustered Web Farm)Clustered Web Farm - Virtual Report ServerMSRSSMTPIIS Report ManagerReport ServerReport Server CatalogMSSQLMSRSIIS Report ManagerReport ServerReport Server CatalogMSSQLFailover ClusterProcessIslandsConnectedProcessesManualSmartProcessesSystem Definition ModelLogical Datacenter DesignApplicationHostingMSMQTDSDCOMhttpSydneyTokyoReadingDublinSin