最 低 价：￥205.00
定 价：￥475.00
作 者：SaraMorgan, TobiasThernstrom 著 著
出 版 社：Oversea Publishing House
出版时间：2007-4-1
I S B N：9780735623835
| 作者简介：Sara Morgan，Sara Morgan, an independent author and consultant based in Baton Rouge, Louisiana, is an MCSD and MCDBA and is certified in SQL Server 2000 and Visual Basic .NET. She specializes in devel-oping leading-edge Web-based applications using Microsoft tech-nologies. Since graduating from Louisiana State University with adegree in quantitative business analysis, she has been developingsoftware for a variety of industries, including a not-for-profit hospi-tal, a financial company offering mortgages, a major retailer, a soft-ware company that writes legislative software, and an applicationservice provider. Sara has written articles for MSDN Magazine, Enterprise Development, .NET Development, Visual Studio Magazine, and DevX.com. She has also co-written MCTS Self-Paced Training Kit (Exam 70-529): Microsoft .NET Framework 2.0 Distributed Application Development(Microsoft Press,2006) and MCPD Self-Paced Training Kit (Exam 70-547): Designing and Developing Web-Based Applications Using the Microsoft .NET Framework. Sara's articles about enhanced computing and her latest research efforts can be found at http://www.custsolutions.net. |
| Introduction Hardware Requirements Software Requirements Installing SQL Server 2005 Installing Visual Studio 2005 Installing the AdventureWorks Database Installing Microsoft Web Application Stress Tool Case Scenarios Case Scenarios and the 70-442 Exam Case Scenario Structure Using the CD and DVD How to Install the Practice Tests How to Use the Practice Tests How to Uninstall the Practice Tests Microsoft Certified Professional Program Technical Support Evaluation Edition Software Support 1 Designing a Data Access Strategy Before You Begin Lesson I: Designing Data Access Technologies Selecting a Network Protocol Selecting a Data Provider How to Connect by Using ADO.NET How to Connect by Using MDAC How to Connect by Using SQL Native Client Managing Password Policies Lab: Connecting to a SQL Server Service Lesson 2: Designing a Data Access Connection Designing Connections for Heterogeneous Client Computers Designing Connections for HTTP Web Services Designing Connections for Another SQL Server Instance Lab: Creating and Consuming HTTP Endpoints Lesson 3: Designing a Data Access Object Model What is the ADO Object Model? Using a Disconnected Model with ADO.NET Using a Connected Model with ADO.NET Lab: Selecting a Data Access Object Model Case Scenario: Selecting a Data Access Strategy Suggested Practices References Chapter Summary 2 Designing Database Queries Before You Begin Lesson 1: Writing Database Queries Write SELECT Queries Writing Full-Text Queries Lab: Writing Database Queries Lesson 2: Improving Query Performance.. Showing the Execution Plan Using Query Hints Using Plan Guides Using Searchable Arguments Lab: Tuning Queries Lesson 3: Retrieving Data from XML Sources. Working with XML Data …… 3 Designing A Cursor And Caching StrategyChapter 4 Advanced Query TopicsChapter 5 Data Integrity And Error Handling In SQL Server 2005Chapter 6 Designing Transactions And Transaction IsolationChapter 7 Optimizing SQL Server 2005 PerformanceChapter 8 Improving Database Application PerformanceAnswers Appendix A: ReferencesAppendix B: Sql Server 2006 Architecture And Internals |
内容加载中，请稍后...
商品评论（0条）