SQL Server stores most of the data for SharePoint.
Associated Certification(s) | MCSE: SharePoint; MCSA: SQL Server; MCSE: Data Platform;
Related Course(s) | Course 20465: Designing Database Solutions for Microsoft SQL Server 2012; Course 20467: Designing Business Intelligence Solutions with Microsoft SQL Server 2012; Course 50478: SharePoint 2010 Advanced Foundation Development
This Jump Start training focuses on how these two products are integrated. Join two of the industry’s most popular SharePoint experts,
Bill Baer and Brian Alderman on an exploration of SQL Server settings, SQL Server system database settings and configuration options that will improve SharePoint 2013
Dean Of Colleges
01 | Key SQL Server and SharePoint Server Integration Concep…
This session provides an overview SQL Server deployment options & database types; understanding SQL Server and SharePoint integration, schema overview, database structure, schema restrictions and SharePoint database descriptions. Learn more on how to efficiently manage multiple instances on one physical server.
02 | Best Practices: SQL Server Database Settings
Get ready to understand model & Tempdb database settings, database file placement, and determining number of content databases. This module goes over how to modify model database to reflect configuration of new databases and configure Tempdb for improved performance, and much more.
03 | Server Settings for SQL Server
In this segment you will learn how to modify memory settings to control memory usage by SQL Server, how to change default file locations, how to leave MAXDOP at 1 for SharePoint and how to verify operating system set to 64KB allocation unit size. Get ready for some great demos and rich dialogue.
04 | SQL Server and SharePoint availability
This module will show you how to avoid ginormous T-Logs by performing regular T-Log backups, how to have multiple copies of your backups, how to configure AlwaysOn for high availability and verify integrity of SQL Server databases. Lastly the instructors will cover SQL Server for SharePoint best practices.
Pierre Erol GIRAUDY