DAT250 SQL Server 2005: 消除开发和管理之间的鸿沟

Slides:



Advertisements
Similar presentations
Web Role 的每台虚机运行有 IIS ,用于处理 Web 请求 Worker Role 用于运行后台进程 Cloud Service 是什么? 支持多层架构的应用容器 由多个 Windows 虚拟机集群构成 集群有两种类型: Web 和 Worker Cloud Service 做什么 进行应用的自动化部署.
Advertisements

第2章 資料庫系統 2-1 資料庫環境的四大組成元件 2-2 ANSI/SPARC的三層資料庫系統架構
顏協邦 慧盟資訊 商業智慧導入服務部 資深經理
Database Architecture, not only DBA
控制流程實作 胡百敬 精誠公司恆逸資訊 二○一七年三月十九日
第6章 資料庫管理系統 6-1 關聯式資料庫管理系統 6-2 SQL Server資料庫管理系統
利用LoadRunner进行 性能测试.
Microsoft Application Platform 開發技術導引
關聯式資料庫.
WCL304 體驗全新桌面虛擬化App-V 5.0 & UE-V 佐藤大輔 Daisuke Sato.
第十五章 常見的資料庫管理系統 目的 Oracle 微軟SQL Server 微軟Access MySQL Oracle 應用伺服器
DAT301: XML数据和关系性数据的最终结合处 – SQL Server 2005
国家“十一五”规划教材 数据库原理与应用教程(第3版).
国家“十一五”规划教材 数据库原理与应用教程(第3版).
Windows Vista 操作系统最新安全特性
BizTalk Server 2004.
軟體原型 (Software Prototyping)
資料檔案的安全性管理 羅英嘉 2007年4月.
解振宇 客户技术经理 客户售前技术部 微软中国有限公司广州办事处
Mobile & Embedded DevCon 2005 朱敏博士 微软有限公司
OFC 302 InfoPath2007新特性及解决方案.
安全更新管理 精誠恆逸資訊 資深講師 職念文.
从UNIX到Windows的 电信软件移植实践
建置、升級與轉換您的資料庫 - Data Tier Applications
朝雲端專業DBA邁進: 深入剖析 Windows Azure SQL Database 完整資料庫管理、雲端報表建立、建置分散式雲端資料庫
什么是Microsoft Dynamics?
BizTalk Server 2004.
第4章(2) 空间数据库 —关系数据库 北京建筑工程学院 王文宇.
第1章 SQL Server 2005 关系数据库简介.
第5章 資料倉儲的資料建置.
SQL Server 2005 資料庫管理達人一日體驗營
OFC351 利用Office System开发复杂的商务解决方案 架构、模式、场景
SAP 架構及基本操作 SAP前端軟體安裝與登入 Logical View of the SAP System SAP登入 IDES
BizTalk Server 2004.
資料庫系統導論.
微软新一代云计算 面向企业的 Office 365 客户培训大纲
顧武雄 Jovi Ku Microsoft特約資深講師
第4章(1) 空间数据库 —数据库理论基础 北京建筑工程学院 王文宇.
凌宁 系统工程师 亚洲区嵌入式系统事业群 微软(中国)有限公司
2/24/2019 5:40 AM © 2009 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered.
Microsoft SQL Server 2008 報表服務_設計
資料結構 Data Structures Fall 2006, 95學年第一學期 Instructor : 陳宗正.

OFC321 InfoPath在企业解决方案中应用的最佳实践
高正宗 System Consultant Manager
SQL Server Mobile 2005 程序开发(三)
橫跨電腦、手機與軟體的全方位端點管控解決方案
虚 拟 仪 器 virtual instrument
呂政周 精誠恆逸教育訓練處 資深講師 Windows PowerShell 呂政周 精誠恆逸教育訓練處 資深講師
從 ER 到 Logical Schema ──兼談Schema Integration
TechNet 技術講座 Entry Slide 0
模式与实践:Windows Mobile 5.0应用程序架构
光輪2000升級 升級SQL Server Analysis Services 2005
DEV 343 VS2005超快速开发方案/EEP2006控件包.
5/4/2019 4:42 PM © 2009 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered.
微軟資安稽核解決方案 System Center 2012
耿志刚 应用整合产品技术专家 专业解决方案部 微软中国
SQL Server Mobile 2005 程序开发(二)
MBL302 设计Windows Mobile应用程序的用户界面
SAP 架構及基本操作 SAP前端軟體安裝與登入 Logical View of the SAP System SAP登入 IDES
百万亿次超级计算机诞生记 姓名 Xiangyu Ye 职务 微软中国技术中心资深HPC顾问 公司 微软中国
DEV 343 VS2005超快速开发方案/EEP2006控件包.
蔺华 ISV开发合作经理 平台及开发技术部 微软(中国)有限公司
MGT 213 System Management Server的昨天,今天和明天
SQL Server 2005 Reporting Services報表設計
MSG 361 如何从Exchange 5.5迁移 胡义 咨询顾问 上海星移软件有限公司 2019年7月31日8时9分
Microsoft SharePoint Portal Server 2003 的部署、建置 與系統整合(上)
強化 Windows 平台 唐任威 資深講師.
高擴充高穩定高安全 企業級資料管理平台 Report Builder概論 錢曉明 資策會 資深講師 台灣微軟 資深講師.
Windows Workflow Foundation CON 230
Presentation transcript:

DAT250 SQL Server 2005: 消除开发和管理之间的鸿沟 2018年11月17日4时57分 DAT250 SQL Server 2005: 消除开发和管理之间的鸿沟 曹宇山 微软(中国)有限公司 © 2005 Microsoft Corporation. All rights reserved. This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.

2018年11月17日4时57分 © 2005 Microsoft Corporation. All rights reserved. This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.

飞速的创新 SQL Server 一个五人的小团队 (与Sybase一起工作) 2018年11月17日4时57分 飞速的创新 SQL Server 一个五人的小团队 (与Sybase一起工作) 到大约400人 (1998 SQL Server 7.0 发布时) 发展到将近1000人 (SQL Server 2005 和WinFS 项目) 微软继续在数据库方面进行巨大的战略投入 © 2005 Microsoft Corporation. All rights reserved. This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.

Cross-release objectives 2018年11月17日4时57分 SQL Server 的三代产品 创新历史 第一代 第二代 第三代 SQL Server 6.0/6.5 SQL Server 7.0 SQL Server 2000 SQL Server 2005 Differentiation from Sybase SQL Server Windows integration First to include Replication Re-architecture of relational server Enterprise-ready Extensive auto resource management First to include OLAP & ETL Performance, scalability focus XML support First to include Notification First to include Scale-out Clusters First to include Data Mining & Reporting Developer productivity focus More Availability options Security Native XML First to include Enterprise ETL & Deep Data Mining Cross-release objectives Reliability & Security Integrated Business Intelligence Lowest TCO Automatic Tuning © 2005 Microsoft Corporation. All rights reserved. This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.

SQL Server 2000 一个重要的版本 Column-level collations Virtual Cube Editor 2018年11月17日4时57分 SQL Server 2000 一个重要的版本 Column-level collations Virtual Cube Editor Linked cubes MDX Builder Dimensions Security in Analysis Services OLAP Actions Custom rollups Cascading referential integrity and actions INSTEAD OF triggers Indexes on computed columns Queued replication DTS enhancements Copy Database Wizard Log Shipping Parallel CREATE INDEX Parallel scan Parallel DBCC Failover clustering Failover cluster management 32 CPU SMP system support 64 GB RAM support VIA SAN support Indexed views ROLAP dimension storage Distributed Partitioned Cubes Online index reorganization Differential backup User-defined functions Server-less snapshot backup  SQL Query Analyzer debugger New data types XML support SELECT … FOR XML OpenXML XML Views XML Updategrams XML View Mapper XML Bulk Load URL and HTTP db access HTTP access to cubes Multi-instance support Integrated Data Mining Full-Text Search in formatted docs English Query for the Web C2 security rating (NSA) Installation disk imaging Active Directory integration Self-management and tuning Distributed Partitioned Views © 2005 Microsoft Corporation. All rights reserved. This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.

5 年的持续研发工作 Dev Focused DBA Focused SQL Server 2000 Initial XML support 2018年11月17日4时57分 5 年的持续研发工作 SQL Server 2000 Initial XML support Feature Enhancements SQL extensions: UDF Indexed Views Collation Support SQL Server 2005 Deep XML support Deep CLR support Developer/DBA toolset Service Broker Security tools Dev Focused DBA Focused © 2005 Microsoft Corporation. All rights reserved. This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.

SQL Server 2005 2018年11月17日4时57分 Management Tools SSMS MDX Query Editor Version Control Support SQLCMD Command Line Tool SQL Service Manager Database Maintenance Backup and Restore Enhancements Checksum Integrity Checks Dedicated Administrator Connection Dynamic AWE Fast Recovery Highly-available Upgrade Online Index Operations Online Restore Parallel DBCC\Index Operations Performance Tuning Profiler Enhancements Profiler/Perfmon Integration Profiling Analysis Services Exportable XML Showplan Exportable Deadlock Traces Full-text Search Indexing of XML Datatype Index files integrated with SQL backup MDAC Side by Side installation Microsoft Installer base setup Support for Active Directory Deployment SQL Client .NET Data Provider Server Cursor Support Bulk load support Security No default metadata access Fine Grained Administration Rights Separation of Users and Schema SSL Encryption at installation Data Encryption Code-signing .NET Framework Common Language Runtime Integration User-defined Aggregates User-defined Data Types User-defined Functions SQL Server .NET Data Provider Extended Triggers Data Types New XML Datatype n/varchar(max) SQL Server Engine New Message Service Broker HTTP Support (Native HTTP) Database Tuning Advisor Enhanced Read ahead & scan Online Index Rebuild Multiple Active Result Sets Persisted Computed Columns Queuing Support Snapshot Isolation Level Non-blocking Read Committed Table and Index Partitioning NUMA support Database Availability and Redundancy Fail-over Clustering (up to 8 node) Enhanced Multi-instance Support Database Mirroring Database Snapshots XML XQUERY Support (Server & Mid Tier) XML Data Manipulation Language FOR XML Enhancements XML Schema (XSD) Support MSXML 6.0 (Native) .Net XML Framework Support for XML and CLR integration Notification Services Replication Auto-tuning Replication Agents Oracle Publication Improved Blob Change Tracking OLAP and Data Mining Analysis Management Objects Windows Integrated Backup and Restore UDM, multi-fact table support DTS and DM Integration Eight new DM algorithms Auto Packaging and Deployment SQL Integration Services (SQLIS) New Architecture (DTR + DTP) Complex Control Flows Control Flow Debugging For Each Enumerations Property Mappings Full Data Flow Designer Full DTS Control Flow Designer Graphical Package Execution Immediate Mode and Project Mode Package (Advanced) Deployment Tools Custom Tasks and Transformations Reporting Services Multiple Output Formats Parameters (Static, Dynamic, Hierarchical) Bulk Delivery of Personalized Content Support Multiple Data Sources STS (Web Parts, Doc Libraries) Visual Design Tool Charting, Sorting, Filtering, Drill-Through Scheduling, Caching Complete Scripting Engine Scale Out architecture Open XML Report Definition Dynamic Management Views © 2005 Microsoft Corporation. All rights reserved. This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.

增强的和崭新的工具集 SQL Server “Properties” Server Network Utility 2018年11月17日4时57分 增强的和崭新的工具集 SQL Server “Properties” Server Network Utility Query Analyzer Analysis Manager Profiler Service Control Manager SQL Enterprise Manager SQL Management Studio BI Developer Studio Profiler SQL Computer Manager © 2005 Microsoft Corporation. All rights reserved. This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.

SQL Server 2005 Tools A First Look 2018年11月17日4时57分 SQL Server 2005 Tools A First Look Demo: 1. Management Studio: *. similar to visual studio *. Can manage SQL 2005, SQL 2005 Express, SQL 2000 from one console. *. Version number shown in the object explorer. *. Summary view: database node, tables node + reports *. filters *. Solution exploer a. create a new demo solution b. add a new project in the solution c. create a new demo sql script. d. add the solution into VSS, check-in, check-out. © 2005 Microsoft Corporation. All rights reserved. This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.

开发人员和数据库管理员 距离缩小 开发人员和数据库管理员传统上是通过以下的借口工作的: 表&视图定义 存储过程&结果集定义 2018年11月17日4时57分 开发人员和数据库管理员 距离缩小 CLR Development - Procedures - Functions - Triggers - Types - Aggregates XML Development UI Development Web Service Development Database Development Client/Server Development Database Development *. DBAs don’t like the CLR, they would say: “OK, that’s the first thing I’ll turn off.” Well, by default, it is off. *. A lot of designs today have the logic written in Stored procedure and triggers, and have to UI code to go through some middle tier logic to get to the back end database logic. This is not a bad design, but there is a lot of limitation on the way SP and triggers are written today. And the CLR gives a lot of flexibility and power to the database logic, and the fact that it is managed by SQL server makes it much safe to run than XPs etc. No memory leaks, no resource leaks, and object oriented. And the script to use: -- check if the clr is enabled -- need to enable the advanced option first sp_configure 'show advanced options', 1 reconfigure go --check if clr exists exec sp_configure 'clr enabled' GO Interface 开发人员和数据库管理员传统上是通过以下的借口工作的: 表&视图定义 存储过程&结果集定义 © 2005 Microsoft Corporation. All rights reserved. This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.

沟通障碍 Database Architect Solution Architect 2018年11月17日4时57分 沟通障碍 数据库管理员不理解 开发的优先级 开发人员不理解好的 查询语句设计 Database Architect Solution Architect 清晰的发布管理流程 降低了复杂性 产品集成提升了 沟通和协作 Pockets of information within disciplines Unclear delineation of responsibilities Conflicting best practices and architectures Conflicting strategic goals and objectives © 2005 Microsoft Corporation. All rights reserved. This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.

开发人员与数据库管理员 距离缩小 开发人员: 数据库管理员: 缩小鸿沟! 籍新工具提升开发效率 让数据库管理员更多的参与开发流程 2018年11月17日4时57分 开发人员与数据库管理员 距离缩小 开发人员: 籍新工具提升开发效率 让数据库管理员更多的参与开发流程 设计程序原则: 可支持的 灵活修改 保证安全和健壮的实现 数据库管理员: 仍然是数据管理者 理解并建议哪项技术最合适 设计数据库结构时考虑XML & CLR 保证安全和健壮的实现 缩小鸿沟! © 2005 Microsoft Corporation. All rights reserved. This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.

CLR 开发 Module 会装载到SQL Server中  与SQL集成在一起  不会丢失代码  “load”后文件就不需要了 2018年11月17日4时57分 CLR 开发 Code & Build Deploy Module 会装载到SQL Server中  与SQL集成在一起  不会丢失代码  “load”后文件就不需要了 A lot of ppl ask me whether the SQL CLR uses the GAC, if the files need to be available at all times, well, the answer is No. Once you deploy the DLL into the SQL server, that file is no longer needed. It can actually be deleted. It will be in the server, in the particular database where you register it. Even the backup and restore are gonna work just fine for those assemblies. © 2005 Microsoft Corporation. All rights reserved. This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.

2018年11月17日4时57分 CLR Development 101 Code, Deploy, Test Directly from Visual Studio to SQL Server © 2005 Microsoft Corporation. All rights reserved. This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.

 何时使用CLR 数据验证 & 降低网络流量 编写通用函数: Scalar 类型 发挥.NET Framework的强大功能 2018年11月17日4时57分 何时使用CLR 数据验证 & 降低网络流量 编写通用函数: 以参数的方式传递数据 无需或少量数据访问 对每行数据进行复杂的运算 Scalar 类型 发挥.NET Framework的强大功能 使用内置的丰富功能 替代Extended Stored Procedures (XP) CLR 更加安全: 再没有非法访问 没有资源和内存泄露使SQL Server 变慢 更好的性能和可扩展性 (managed memory model) 更完善的安全机制… *. Transact-SQL is specifically designed for direct data access and manipulation in the database. While Transact-SQL excels at data access and management, it is not a full-fledged programming language. For example, Transact-SQL does not support arrays, collections, for-each loops, bit shifting, or classes. While some of these constructs can be simulated in Transact-SQL, managed code has integrated support for these constructs. Depending on the scenario, these features can provide a compelling reason to implement certain database functionality in managed code. *. Not everything should be written in CLR. CLR is not a silver bullet.  © 2005 Microsoft Corporation. All rights reserved. This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.

 何时不该使用CLR 大量的数据访问 – Transact-SQL set 访问速度会更快 复杂数据类型 报表的统计预处理运算 2018年11月17日4时57分 何时不该使用CLR  大量的数据访问 – Transact-SQL set 访问速度会更快 不要使用 CLR 来写SELECT 语句! 复杂数据类型 8K 大小限制 当数据更新时是 读/重写的 报表的统计预处理运算 CLR 统计不能用在有索引的视图上 必须支持以前版本的SQL Server 为了用CLR而用CLR… © 2005 Microsoft Corporation. All rights reserved. This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.

Transact-SQL 增强功能 ROW_NUMBER RANK, DENSE_RANK Common Table Expressions 2018年11月17日4时57分 Transact-SQL 增强功能 ROW_NUMBER RANK, DENSE_RANK Common Table Expressions PIVOT/UNPIVOT CROSS APPLY and OUTER APPLY Error handling – TRY/CATCH DDL Triggers (synchronous) Event Notifications (asynchronous) Parameterized TOP © 2005 Microsoft Corporation. All rights reserved. This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.

2018年11月17日4时57分 Table-Valued Function Accessing local file, returning file content as table © 2005 Microsoft Corporation. All rights reserved. This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.

XML 开发 </XML> Native XML datatype XML Indexes 2018年11月17日4时57分 XML 开发 Native XML datatype Optimized on-disk structure (not “just a blob”) XML Indexes Entities & Attributes X/PATH Query Engine Integrated with core relational operators Schema Support Strongly typed XML CLR/XML Integration XMLTextReader Access to XSLT Full Text Search <xs:complexType name ="myelement" mixed="true">   <xs:sequence minOccurs="0">     <xs:element name="child1" type="xs:integer" />     <xs:element name="child2" type="xs:integer" />   </xs:sequence> </xs:complexType> <xs:element name="myelement" type="myelement" />  <myelement>   Some text   <child1>3</child1>   Some more text   <child2>4</child2>   Some more text </myelement> <xs:complexType name ="myelementWithChildren">   <xs:sequence>     <xs:element name="child1" type="xs:integer" />     <xs:element name="child2" type="xs:integer" />   </xs:sequence> </xs:complexType> <xs:element name="myelement" type="xs:anyType" /> </XML> © 2005 Microsoft Corporation. All rights reserved. This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.

XML 索引 Primary Index: Secondary Indexes off of the primary XML index 2018年11月17日4时57分 XML 索引 Primary Index: Requires a clustered primary key on the base table B-Tree of element and attribute names, node values, and node types, retains document order and structure, as well as the path from the root of the XML instance to each node for efficient evaluation of path expressions Secondary Indexes off of the primary XML index PATH  columns (path, value) PROPERTY  columns (PK, path, value) VALUE  columns (value, path) © 2005 Microsoft Corporation. All rights reserved. This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.

Accessing XML Data 2018年11月17日4时57分 © 2005 Microsoft Corporation. All rights reserved. This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.

  何时使用XML 半结构化数据, 少量固定数据,大量的随机的扩展属性 大文档,但是很少修改  使用索引 2018年11月17日4时57分 何时使用XML   建议使用: 半结构化数据, 少量固定数据,大量的随机的扩展属性 多植属性 复杂属性 “WordXML” 大文档,但是很少修改  使用索引 层次性的数据  常规表达式会有效的查找数据 不合适: 大文件,经常更新 文件更新有可能并发 结构化数据 考虑转换成关系型数据 包含大二进制数据对象 (2GB 限制) *. Note that the stored representation of xml data type instances cannot exceed 2 GB in size. © 2005 Microsoft Corporation. All rights reserved. This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.

SQL Server – Web Service? 2018年11月17日4时57分 SQL Server – Web Service? SQL Server 2005 kernel mode HTTP.SYS 能够监听HTTP数据流 无需依赖 IIS 缺省是 Off 客户端可以通过SOAP 来访问 SQL Server 当没有SQL中间件支持时非常有用 注意性能会打折扣 Trade-off of flexibility of generic client access for performance © 2005 Microsoft Corporation. All rights reserved. This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.

SQL Server as a Web Service Intranet access via non-SQL client 2018年11月17日4时57分 SQL Server as a Web Service Intranet access via non-SQL client © 2005 Microsoft Corporation. All rights reserved. This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.

SQL Server as a Web Service 2018年11月17日4时57分 SQL Server as a Web Service   适用: Intranet 通过非标准的客户端来访问存储过程 客户端和SQL Server之间没有中间件 [注意,速度会慢一点] 取代SQLXML 3.0 datagrams 不适用: Internet 用于构建完整的复杂应用 已经有数据访问中间层 在SQL Server之间传递数据 对于具有大量客户端的应用 *. You don’t want expose the web services to the internet. *. In Intranet, you can expose some SPs to non-standard client. *. The performance is slower, so you don’t want to expose everything as web services. * Should not use Web Services for applications with large numbers of clients that might require scale-out of application logic © 2005 Microsoft Corporation. All rights reserved. This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.

选择合适的技术 T-SQL CLR XML Computation & Framework access 2018年11月17日4时57分 选择合适的技术 Computation & Framework access T-SQL CLR XML To summary up when to use what option. Semi-structured data access Relational data access © 2005 Microsoft Corporation. All rights reserved. This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.

选择技术时的注意事项 在引进新的技术时需要仔细计划 新的功能应该是缺省off,到完全掌握并需要使用时才激活 不要为使用新功能而使用新功能: 2018年11月17日4时57分 选择技术时的注意事项 在引进新的技术时需要仔细计划 新的功能应该是缺省off,到完全掌握并需要使用时才激活 不要为使用新功能而使用新功能: 是否能够为我们解决新的业务问题? 对安全和技术支持有什么新的影响? 性能问题? 与现有的技能符合码? 需要改变客户端/中间层码?  列出清晰的使用条件 考虑对第三方程序的影响 *. No “technology for technology’s sake” © 2005 Microsoft Corporation. All rights reserved. This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.

问题分析 核心管理工具现在提供增强的信息,更好的监控系统运行情况: 2018年11月17日4时57分 问题分析 核心管理工具现在提供增强的信息,更好的监控系统运行情况: SQL Profiler (with Perfmon integration) Debugger support for T-SQL & CLR Complete cleanup of error messages Dynamic Management Views Flight Recorder SqlClient/OLEDB tracing XML Showplan © 2005 Microsoft Corporation. All rights reserved. This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.

Correlating System Monitor Logs with Profiler Trace 2018年11月17日4时57分 Correlating System Monitor Logs with Profiler Trace © 2005 Microsoft Corporation. All rights reserved. This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.

但是… 新的功能的确不错! 我打算深入研究一下! 我想在原型或者小型应用中使用这些新功能! 但是… 需要买SQL Server! 2018年11月17日4时57分 但是… 新的功能的确不错! 我打算深入研究一下! 我想在原型或者小型应用中使用这些新功能! 但是… 需要买SQL Server! 别担心,有一个价格十分适宜的版本! © 2005 Microsoft Corporation. All rights reserved. This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.

Microsoft Express Product Range 2018年11月17日4时57分 Microsoft Express Product Range © 2005 Microsoft Corporation. All rights reserved. This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.

SQL Express 还记得 MSDE 吗? 限制: 2018年11月17日4时57分 SQL Express 还记得 MSDE 吗? Express 带有管理客户端 UI! 限制: 单 CPU, 1GB RAM, 4GB maximum database size… SQL Server Express是一个轻量级的SQL 2005版本,包含了SQL Server 2005数据引擎的丰富的功能,如stored procedures, views, triggers, cursors, CLR支持,XML支持等等。另外,SQL Server Express还有一个免费的管理前端工具。 SQL Server Express 不包括一些高级功能,如 Analysis Services, Reporting Services, Integration Services, and Notification Services. © 2005 Microsoft Corporation. All rights reserved. This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.

Express 语言特性 Feature Express Professional 2018年11月17日4时57分 Express 语言特性 Feature Express Professional Database design tools: "Data Connections" node Local All Data access Web services & local databases Documentation 10MB core 200MB optional Full MSDN Library Extensibility Tools menu Class designer and object test bench No Yes Debugging Local/Remote XML designer support XML only XML/XSLT Deployment support Mobile development support Reporting Reporting Services, Crystal Reports 64-bit compiler support Office development support Server Explorer: "Servers" node Source code control SCCI User experience Streamlined Full Size for installation 80MB Multiple CDs © 2005 Microsoft Corporation. All rights reserved. This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.

总结 使用合适的技术解决不同的问题 – 先评估问题,再选择技术 注意验证数据类型,正确设计 有很多工具可供选择 关系型 半结构化 非结构化 2018年11月17日4时57分 总结 使用合适的技术解决不同的问题 – 先评估问题,再选择技术 注意验证数据类型,正确设计 关系型 半结构化 非结构化 有很多工具可供选择 © 2005 Microsoft Corporation. All rights reserved. This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.

SQL Server 2005 工具集 SQL SQL XML FTS Service Broker Transact SQL 2018年11月17日4时57分 SQL Server 2005 工具集 Service Broker Transact SQL CLR Programs & Types 关系型数据 SQL SQL XML FTS © 2005 Microsoft Corporation. All rights reserved. This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.

SQL Server 2005 工具集 SQL XML XML FTS 半结构化数据 XML type XML Schema X/Query 2018年11月17日4时57分 SQL Server 2005 工具集 半结构化数据 SQL XML XML FTS XML type XML Schema X/Query XML Indexes © 2005 Microsoft Corporation. All rights reserved. This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.

Integrated with database backup 2018年11月17日4时57分 SQL Server 2005 工具集 FTS Microsoft Search Office Documents Integrated with database backup 非结构化数据 SQL XML FTS © 2005 Microsoft Corporation. All rights reserved. This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.

More about Visual Studio 2005 More about SQL Server 2005 2018年11月17日4时57分 More about Visual Studio 2005 http://lab.msdn.microsoft.com/vs2005/ More about SQL Server 2005 http://msdn.microsoft.com/SQL/2005/default.aspx XML Developer Center http://msdn.microsoft.com/xml/default.aspx Microsoft Express Product Range http://lab.msdn.microsoft.com/express/ © 2005 Microsoft Corporation. All rights reserved. This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.

The SQL Server 2005 Developer Center on msdn 2018年11月17日4时57分 The SQL Server 2005 Developer Center on msdn http://msdn.microsoft.com/SQL/2005/default.aspx “SQL Server 2005 Webcasts” contains links to 15 webcasts recorded in December to help get you started “SQL Server 2005 Articles” contains links for 25+ articles/whitepapers on Beta II Keep watching the Developer Center, there are new resources every week! © 2005 Microsoft Corporation. All rights reserved. This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.

您的反馈对我们非常重要 请抽时间填写反馈表 2018年11月17日4时57分 © 2005 Microsoft Corporation. All rights reserved. This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.

相关问题 SQL Server 2005 将与微软的哪个开发工具一起发布? SQL Server 2005 提供哪种新的服务器端编程方式? 2018年11月17日4时57分 相关问题 SQL Server 2005 将与微软的哪个开发工具一起发布? SQL Server 2005 提供哪种新的服务器端编程方式? SQL Server 2005 Web Services是否依赖于IIS? © 2005 Microsoft Corporation. All rights reserved. This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.

© 2005 Microsoft Corporation. All rights reserved. 2018年11月17日4时57分 © 2005 Microsoft Corporation. All rights reserved. This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary. © 2005 Microsoft Corporation. All rights reserved. This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.