1 / 18

SQL Server ® 2008 ® Native Client

SQL Server ® 2008 ® Native Client. Agenda. Introduction to SQL Server Native Client Building High-Performance Data Access Solutions Going Beyond Relational Data Migrating Applications to SQL Server 2008. SQL Native Client Overview. Choosing a Data Access Technology. Agenda.

thad
Download Presentation

SQL Server ® 2008 ® Native Client

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. SQL Server® 2008® Native Client

  2. Agenda • Introduction to SQL Server Native Client • Building High-Performance Data Access Solutions • Going Beyond Relational Data • Migrating Applications to SQL Server 2008

  3. SQL Native Client Overview

  4. Choosing a Data Access Technology

  5. Agenda • Introduction to SQL Server Native Client • Building High-Performance Data Access Solutions • Going Beyond Relational Data • Migrating Applications to SQL Server 2008

  6. SQL Native Client Performance

  7. Table-Valued Parameters • Improved programming model • Significant performance benefits • Cleaner, more maintainable code • Better scalability for large data volumes

  8. Agenda • Introduction to SQL Server Native Client • Building High-Performance Data Access Solutions • Going Beyond Relational Data • Migrating Applications to SQL Server 2008

  9. FILESTREAM Data Store BLOBs in DB + File System • Storage Attribute on VARBINARY(MAX) • Unstructured data stored directly in the file system (requires NTFS) • Dual Programming Model • Transact-SQL (Same as SQL BLOB) • Win32 Streaming APIs with Transact-SQL transactional semantics • Data Consistency • Integrated Manageability • Back Up / Restore • Administration • Size limit is the file system volume size • SQL Server Security Stack Application BLOB

  10. Sparse Columns SPARSE SPARSE SPARSE • Enable NULL data to consume no physical space • Access sparse columns directly or as XML-encoded name-value pairs

  11. User-Defined Types

  12. Spatial Data Types Spatial Operations E.g. find streets that intersect the Microsoft campus SELECT StreetName FROM Streets WHERE Streets.StreetGeo.STIntersects(@ms) = 1

  13. ORDPATH Data Type

  14. Agenda • Introduction to SQL Server Native Client • Building High-Performance Data Access Solutions • Going Beyond Relational Data • Migrating Applications to SQL Server 2008

  15. Migrating from SQL Server 2005 • Migrate only as needed • SQL Server 2008 Native Client supports previous versions • SQL Server 2005 Native Client supports SQL Server 2008 • New features are unavailable SQL Server 2000 SQL Server 2005 SQL Server 2008 SQL Server 2005 Native Client SQL Server 2008 Native Client All features supported New features unsupported

  16. Date and Time Data Types

  17. Summary

  18. © 2004 Microsoft Corporation. All rights reserved. This presentation is for informational purposes only. Microsoft makes no warranties, express or implied, in this summary.

More Related