TAILIEUCHUNG - The Best of Simple Talk: SQL Server Crib Sheet Compendium

The 'mission statement' for the Simple-Talk Crib Sheet is: 'For the things you need to know, rather than want to know' As a developer, DBA or manager, you may not want to know all about XML, replication or Reporting Services, but if you next project uses one or more of these technologies heavily then the best place to start is from the 'jungle roof'. Crib Sheets aim to give you the broad view. Each one tackles a key area of database development, administration or deployment and provides both a management view and a technical view of that topic. Each starts. | The Best of Simple Talk SQL Server Crib Sheet Compendium Amirthalingam Prasanna Grant Fritchey Phil Factor Robert Sheldon Robyn Page ISBN 978-1-906434-14-4 Shelving Development Computer Science 0 In association with .H reogate1 Page 1 of 90 Table of Contents Table of Contents Table of Chapter 1 SQL Server Security Crib Overview 5 Authentication The Login system 6 Authorisation The Permissions System 8 User Context 10 Chapter 2 SQL Server XML Crib XML 11 XML Support in SQL Server 12 Querying XML Documents 13 Transforming XML data 15 The Document Object Model 15 XML Web Services 15 Glossary 16 Happy reading 17 Chapter 3 Reporting Services Crib The design of SSRS 18 The components of SSRS 19 SSRS DataSources and Datasets 21 Conclusion 22 Further Reading. 22 Chapter 4 SSIS 2008 Crib SSIS Architecture 23 SSIS Designer Tasks and Components 28 Data Integration 31 Moving Forward 35 Chapter 5 SQL Server Data Warehouse Crib The Data Warehouse 36 The Data Model 38 The Fact Table 40 The Dimension 40 The Data 43 Conclusion 44 Chapter 6 SQL Server Database Backups Crib General Issues 45 SQL Server issues 46 Storage Issues 50 Backup History 51 How Backups should be done 52 Chapter 7 SQL Server Performance Crib Overview 54 Measuring Performance 54 Perfmon 54 Profiler 57 Third Party Tools 60 Page 1 Table of Contents Page 2 of 90 Table of Contents Tuning Performance 60 TSQL Performance 62 Client Access 63 Testing Performance 63 Suggested Reading 64 Chapter 8 SQL Server Replication Crib Replication topologies 66 Replication Methods 66 Replication Agents 68 Monitoring Replication 68 Articles 69 Programming Replication Topologies 70 Further reading 70 Chapter 9 Entity Framework Crib Entity Data Model 71 Storage Schema Definition SSDL 71 Conceptual Schema Definition CSDL 72 Mapping Schema MSL 73 Entity Classes 74 Working with the .

Đã phát hiện trình chặn quảng cáo AdBlock
Trang web này phụ thuộc vào doanh thu từ số lần hiển thị quảng cáo để tồn tại. Vui lòng tắt trình chặn quảng cáo của bạn hoặc tạm dừng tính năng chặn quảng cáo cho trang web này.