1 / 39

SharePoint enhancements through SQL Server 2008

SharePoint enhancements through SQL Server 2008. RSS integration with SharePoint What’s New. Elimination of IIS http://blogs.msdn.com/bwelcker/archive/2007/12/04/everybody-why-leave-iis.aspx Performance Enhancements

terris
Download Presentation

SharePoint enhancements through SQL Server 2008

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. SharePoint enhancements through SQL Server 2008

  2. RSS integration with SharePointWhat’s New • Elimination of IIS http://blogs.msdn.com/bwelcker/archive/2007/12/04/everybody-why-leave-iis.aspx • Performance Enhancements • makes fewer calls to the SharePoint Object Model on each report-rendering request •  Passing SharePoint User Token • new server interface (IRSSetUserToken) allows retrieving of data from a site by using SharePoint credentials • Data-driven subscriptions and job management on report servers configured for SharePoint integrated mode  • Support for Multiple SharePoint Zones

  3. Proactive Monitoring • Performance Data Warehouse • Performance Data Collector

  4. Multi-Server Management • Gain insight into resource utilization through policy evaluation • Manage Servers as groups

  5. Multi-Server Management (R2 EE) • Provides dashboard and drill down utilization views of instances and applications • Gain insight into resource utilization through policy evaluation and analysis of trending instances and applications—streamlining consolidation efforts • A new single unit of deployment, Data-tier Application, packages database schema (database, tables, stored procedures, etc)

  6. Backup Compression • Set Backup Compression at the Server Level • all backups including those made with the SharePoint UI or with STSADM will be compressed.

  7. Database Mirroring • Performance improvements • Auto recovery of corrupted pages

  8. Security • Common Criteria Compliance • Residual Information Protection (RIP) • The ability to view login statistics • That column GRANT should not override table DENY

  9. Auditing SQL Server Audit was designed with the following primary goals in mind: • Enables compliance with security regulations • Simple configuration using SQL Server Management Studio • First class object that can be created and manipulated by DDL • Minimal impact on performance because audit data is stored outside of SQL Server database files

  10. Transparent Data Encryption (TDE) • TDE operates at the I/O level through the buffer pool. Thus, any data that is written into the database file (*.mdf) is encrypted. • All snapshots and backups created by the database will be encrypted by TDE

  11. Extensible Key Management (EKM) Allows for key management with third-party enterprise key management products

  12. Policy-based Management • Define configuration policies and apply them to servers, databases, tables, and other targets • Enforce policies proactively, on a scheduled basis, on change, or real-time • Apply policies to the groups of servers

  13. Resource Governor • Control resource utilization (CPU and memory) • Ensure mission-critical database workloads are not adversely affected by other database activity

  14. Resource Governor CREATE FUNCTION adhocQueryClassifier() RETURNS SYSNAME WITH SCHEMABINDING AS BEGIN    DECLARE @grp_name AS SYSNAME      IF (APP_NAME() LIKE '%MANAGEMENT STUDIO%')          OR (APP_NAME() LIKE '%QUERY ANALYZER%')          SET @grp_name = 'groupAdhoc'    RETURN @grp_name END GO

  15. Gemini • SQL Server 2008 R2 Analysis Services brings large scale data analytics to the Office 2010 desktop, with full SharePoint integration so that you can share and manage your data from SharePoint sites.

  16. Filestream Data • FILESTREAM is a new feature in the SQL Server 2008 release. It allows structured data to be stored in the database and associated unstructured (i.e., BLOB) data to be stored directly in the NTFS file system. You can then access the BLOB data through the high-performance Win32® streaming APIs, rather than having to pay the performance penalty of accessing BLOB data through SQL Server. • FILESTREAM maintains transactional consistency between the structured and unstructured data at all times, even allowing point-in-time recovery of FILESTREAM data using log backups. Consistency is maintained automatically by SQL Server and does not require any custom logic in the application.

  17. SQL Server Features Summary • RSS integration with SharePoint • RSS 2008 elimination of IIS • Proactive Monitoring (EE) • Multi-Server Management (EE) • Backup Compression (EE) • Database Mirroring (EE) • Security (EE) • Auditing (EE) • Transparent Data Encryption (EE) • Extensible Key Management (EE) • Policy-based Management • Resource Governor (EE) • Filestream Data (EE) • Gemini (EE)

More Related