Saturday, December 8, 2007

SQL Server 2005 White Papers

  1. What's New in FOR XML in Microsoft SQL Server 2005
  2. Introduction to XQuery in SQL Server 2005
  3. Overview of Native XML Web Services for Microsoft SQL Server 2005
  4. Performance Optimizations for the XML Data Type in SQL Server 2005
  5. Usage Scenarios for SQL Server 2005 Native Web Services
  6. XML Best Practices for Microsoft SQL Server 2005
  7. XML Indexes in SQL Server 2005
  8. XML Options in Microsoft SQL Server 2005
  9. XML Support in Microsoft SQL Server 2005
  10. Physical Database Storage Design
  11. Working with tempdb in SQL Server 2005
  12. Database Engine Tuning Advisor (DTA) in SQL Server 2005
  13. Accessing External Data Sources with Microsoft SQL Server Analysis Services 2005
  14. Add Custom Data Mining Algorithms to SQL Server 2005
  15. Analysis Services 2005 Processing Architecture
  16. Building a Localized Report on a SQL Server 2005 Analysis Service Cube Data Source
  17. Building a Rule Engine with SQL Server
  18. Building Ad-hoc Reporting Solutions with SQL Server 2005 Report Builder and Analysis Services OLAP
  19. Building Reliable, Asynchronous Database Applications Using Service Broker
  20. Connectivity and SQL Server 2005 Integration Services
  21. Data Access Tracing in SQL Server 2005
  22. Data Integration Solutions for Master Data Management
  23. Data Quality Solutions
  24. Data Transformation Services for SQL Server 2005 Frequently Asked Design Questions
  25. Deployments and Tests in an iSCSI SAN
  26. Designing and Delivering Rich Office Reports with SQL Server Reporting Services 2005 and SoftArtisans OfficeWriter
  27. Developing Report Navigation and Drilldown
  28. Editing Transact-SQL Code in SQL Server 2005 Beta 2
  29. Enabling Drillthrough in Analysis Services 2005
  30. Extending SQL Server Reporting Services with SQL CLR Table-Valued Functions
  31. Fuzzy Lookup and Fuzzy Grouping in Data Transformation Services for SQL Server 2005
  32. Get More Out of SQL Server Reporting Services Charts
  33. Handling Data Integrity Issues in Analysis Services 2005
  34. How to Implement an Automatic Sliding Window in a Partitioned Table on SQL Server 2005
  35. Integrating Reporting Services into Your Application
  36. International Features in Microsoft SQL Server 2005
  37. Introduction to MDX Scripting in Microsoft SQL Server 2005
  38. Introduction to SQL Server 2005 Data Mining
  39. An Introduction to SQL Server Service Broker
  40. Introduction to the Unified Dimensional Model (UDM)
  41. Introduction to XQuery in SQL Server 2005
  42. Managed Data Access Inside SQL Server with ADO.NET and SQLCLR
  43. Many-to-Many Dimensions in Analysis Services 2005
  44. Microsoft Jet 4.0 Sorting APIs: DBCompareStringW and DBLCMapStringW
  45. Migrating from Business Objects Crystal Reports to SQL Server 2005 Reporting Services
  46. Monitoring Report Execution Performance with Execution Logs
  47. Multi-User Considerations in Data Synchronization for SQL Server 2005 Mobile Edition 3.0
  48. Multiple Active Result Sets (MARS) in SQL Server 2005
  49. Optimizing Microsoft Office Access Applications Linked to SQL Server
  50. Overview of Native XML Web Services for Microsoft SQL Server 2005
  51. An Overview of SQL Server 2005 for the Database Developer
  52. Overview of the Analysis Services Development and Management Environments
  53. Partitioned Tables and Indexes in SQL Server 2005
  54. Processing XML Showplans Using SQLCLR in SQL Server 2005
  55. Reducing Database Size by Using Vardecimal Storage Format
  56. Report Design Tips and Tricks
  57. Reporting Services: Using XML and Web Service Data Sources
  58. SQL Server 2005 Beta 2 Transact-SQL Enhancements
  59. SQL Server 2005 Full-Text Search: Internals and Enhancements
  60. SQL Server 2005 Integration with Microsoft SharePoint Products and Technologies
  61. SQL Server 2005 Row Versioning-Based Transaction Isolation
  62. SQL Server Data Mining: Plug-In Algorithms
  63. SQL Server Data Mining Programmability
  64. SQL Server Optimization
  65. A Technical Comparison of Replication and Remote Data Access Features in SQL Server 2005 Mobile Edition 3.0
  66. Trace and Replay Objects: A New API for SQL Server Tracing and Replay
  67. Troubleshooting Integration with SharePoint Products and Technologies
  68. A Tutorial for Constructing a Plug-in Algorithm
  69. A Tutorial for Constructing a Plug-In Viewer
  70. Using CLR Integration in SQL Server 2005
  71. Using SQL Server 2005 Reporting Services with SAP NetWeaver Business Intelligence
  72. Using Table Valued Functions in SQL Server 2005 to Implement a Spatial Data Library
  73. Using Visual Studio 2005 to Perform Load Testing on a SQL Server 2005 Reporting Services Report Server
  74. Accessing SQL Server 2005 Databases with PHP
  75. Embedding SQL Server Express into Custom Applications
  76. SQL Server 2005 Express Edition Overview
  77. Managing a Music Collection Using Visual Basic Express and SQL Server Express
  78. Securing Your SQL Server 2005 Express Edition Server
  79. SQL Server 2005 Express Edition User Instances
  80. Teacher Sample Application Guide
  81. Using SQL Server 2005 Express from Visual Basic 6
  82. Web Development with Visual Web Developer 2005 Express Edition and SQL Server 2005 Express Edition, Part 1
  83. Web Development with Visual Web Developer 2005 Express Edition and SQL Server 2005 Express Edition, Part 2
  84. Web Development with Visual Web Developer 2005 Express Edition and SQL Server 2005 Express Edition, Part 3
  85. Writing SQL Queries: Let's Start with the Basics
  86. Advantages of a 64-bit Environment
  87. Advantages of Microsoft Merge Replication for Mobile and Distributed Applications
  88. Business Intelligence Meets Business Process Management
  89. Business Value of Upgrading to SQL Server 2005 for Mid-market Organizations
  90. Business Value of SQL Server 2005 Business Intelligence for SQL Server 2000 Users
  91. Choosing Between SQL Server Compact and SQL Server Express
  92. Choosing Microsoft SQL Server 2005 for Data Warehousing
  93. Comparing SQL Server 2005 and IBM DB2 v8.2 as a Database Platform
  94. Comparing SQL Server 2005 and IBM UDB DB2 8.2: Focus on Developer Productivity
  95. Comparing SQL Server 2005 and Oracle 10g as a Database Platform for Microsoft .NET Developers
  96. Critical Business Intelligence Platform for the Agile Enterprise
  97. Empowering Enterprise Solutions with SQL Server 2005 Enterprise Edition
  98. Fibre Channel and iSCSI Performance Comparison for DSS Workloads Using SQL Server 2005
  99. Guide to Migrating from Oracle to SQL Server 2005
  100. Guide to Migrating from Sybase ASE to SQL Server 2005
  101. Managing SQL Server Express with SQL Server 2005 Management Studio Express Edition
  102. Microsoft SQL Server 2005 Compact Edition Overview
  103. Microsoft Access or SQL Server 2005: What's Right in Your Organization?
  104. Putting Enterprise Information to Work with Microsoft SQL Server 2005
  105. SAP with SQL Server 2005: Best Practices for High Availability, Maximum Performance, and Scalability
  106. Should You Migrate from Oracle to SQL Server?
  107. Should You Migrate from Sybase to SQL Server?
  108. Siebel on SQL Server 2005
  109. Solutions for Highly Scalable Database Applications: An analysis of architectures and technologies
  110. SQL Server 2005 for Oracle Professionals
  111. SQL Server 2005 Management Tools Overview
  112. SQL Server and Oracle Total Cost of Administration
  113. SQL Server Runs the Security Table
  114. Upgrading MSDE 2000 to SQL Server 2005 Express
  115. Using SQL Server 2005 in a Virtual Environment
  116. What’s New in SQL Server 2005 Integration Services
  117. When to Migrate from Microsoft Access to Microsoft SQL Server
  118. Why Consider a Service-Oriented Database Architecture for Scalability and Availability
  119. Why Upgrade to SQL Server 2005
  120. Why Upgrade to SQL Server 2005 Business Intelligence: A Technical Overview
    • SQL Server 2005 delivers technology that works tirelessly to support your business—technology that integrates seamlessly and scales to support your enterprise demands. SQL Server 2005 can take your organization to the next level of business intelligence (BI) with integrated tools, faster performance, more reliability and availability, and an easy, low-cost upgrade path. If you are considering upgrading your BI solution, read this white paper to find out why you should switch to SQL Server 2005.
  121. The Impact of Changing Collations and of Changing Data Types from Non-Unicode to Unicode
  122. SQL Server I/O Basics, Chapter 2
    • As the administrator of a SQL Server 2005 installation, you will find that visibility into the SQL Server I/O subsystem has been significantly increased. A primary focus of the SQL Server 2005 I/O design was overall stability of performance and data integrity related to the outside influences of the I/O subsystem/path. The new and extended features provide both more visibility and more capabilities.

    This white paper introduces new terms, discusses maintenance and configuration issues, new and improved error messages, and I/O enhancements. After reading this document you will better understand SQL Server I/O needs and capabilities in SQL Server 2000 Service Pack 4 and SQL Server 2005.


Bookmark and Share
Posted by jacob.sebastian at 5:40 AM

0 comments:

Post a Comment

Subscribe to: Post Comments (Atom)