SQL Server stores most of the data for SharePoint. 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 performance, availability and security. Enjoy this demo filled Jump Start to help you optimize SQL Server 2012 deployment to protect your SharePoint environment.
Instructors | Bill Baer - Microsoft Senior Product Marketing Manager ; Brian Alderman - CEO & Founder, MicroTechPoint
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; Course 20331: Core Solutions of Microsoft SharePoint Server 2013; Course 20332: Advanced Solutions of Microsoft SharePoint Server 2013
Exploring Certification? Free SQL Server Certification Prep Tools
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.
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.
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.
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.
Please peruse this section for additional information that supports this Jump Start event. This is an opportunity for you to dive deeper into SQL Server and SharePoint at your own pace.