SlideServe
Télécharger Obtenir Pro
Menu
Accueil Pro
Préférences
ApparenceLight Aide et commentaires
© SlideServe · v2026

SharePoint enhancements through SQL Server 2008

terris avatar
terris
39 diapositives · 539 Views · Jul 10, 2014

Significant enhancements in SharePoint arising from SQL Server 2008 RSS integration. Key features include elimination of IIS, performance improvements by reducing calls to the SharePoint Object Model, support for multiple SharePoint zones, and proactive monitoring capabilities. The update allows data-driven subscriptions, multi-server management, and a new server interface utilizing SharePoint user tokens. Additionally, innovations like backup compression, database mirroring, transparent data encryption, and resource management provide enhanced security and compliance, optimizing SharePoint's functionality.

SharePoint enhancements through SQL Server 2008 - slide 1
01 / 39SharePoint enhancements through SQL Server 2008
1 / 17

Télécharger la présentation

SharePoint enhancements through SQL Server 2008
Une image / un lien ci-dessous est fourni (tel quel) pour télécharger la présentation

Politique de téléchargement : le contenu du site vous est fourni TEL QUEL pour votre information et votre usage personnel ; il ne peut être vendu, concédé sous licence ni partagé sur d’autres sites sans l’accord de son auteur.Le contenu vous est fourni TEL QUEL, pour votre information et votre usage personnel uniquement. Téléchargez la présentation en cliquant sur ce lien. Lors du téléchargement, si vous ne parvenez pas à télécharger une présentation, l’éditeur a peut-être supprimé le fichier de son serveur.Pendant le téléchargement, si vous ne parvenez pas à obtenir une présentation, le fichier a peut-être été supprimé par l’éditeur.

F I N

Plus de contenu associé

Transcription de la présentation

  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)