SharePoint 2013 and SQL Server 2012 "Rock Solid" Designs - On Demand

Price: $199.00

Presented by Colin Spence

Running Time: 203 minutes

This three-session boot camp will cover the key concepts required to fully design highly available, redundant, and high-performance SharePoint 2013 and SQL Server 2012 environments. Colin Spence will share design approaches and best practices that have been successfully employed with clients for SharePoint 2013 implementations. These sessions will focus on on-premises designs and cover critical topics such as Mirroring vs. AlwaysOn Availability Groups (AOAG), configuring fully redundant farms, configuring Office Web Applications, and extending the SharePoint environment to meet Business Intelligence requirements. As the sessions unfold, key decision points will be called out in “checklist” format, so attendees can create a high-level roadmap for their implementations as they go.


Session 1: Building the Foundation on SQL Server 2012

Since SQL Server forms the foundation of the SharePoint environment, it is critical that it be designed properly to scale appropriately and meet the organization’s needs. Topics to be covered will include these:

  • Overview of the benefits and advances in SQL Server 2012
  • Pros and cons of physical vs. virtual configurations, use of aliases, multiple instances, and other design decisions
  • Review of differences between SQL Server 2012 versions
  • Analysis of pros and cons of mirroring vs. AlwaysOn Availability Groups, the two most popular high availability (HA) configurations
  • Key performance optimization strategies, from drive configurations to maintenance plans to Windows PowerShell and third-party utilities


Session 2: Configuring “Rock Solid” SharePoint Farms

While the Configuration Wizard makes the SharePoint 2013 configuration process deceptively easy, there is much more to the configuration of a reliable and stable SharePoint environment. This session will cover critical areas that need to be addressed for enterprise deployments:

  • Most effective farm designs for medium and large companies
  • “Service Farms” in SharePoint 2013
  • App Store configuration essentials
  • Office Web Apps (OWA) 2013 configuration, and clustering
  • Best practices for service applications, site collection configuration, and security
  • Basics for hardening the SharePoint environment and restricting dangerous practices
  • Designing the core social components of SharePoint 2013, including My Sites and Sky Drive Pro


Session 3: Extending the Core Farm for Added Business Value

This session covers additional key topics that can provide great value to the core SharePoint environment to meet specific business needs and provide value to the organization:

  • Extending the farm for Business Intelligence purposes with a focus on the components of the BI stack, use of Kerberos, and SSRS configurations
  • Pros and cons for Remote Blob Storage (RBS)
  • Yammer integration
  • Challenges of replicating content
  • Key management tools you can leverage



Colin Spence is a partner at Convergent Computing and an MCP and MCTS SharePoint. His books on SharePoint technologies for Sams Publishing include Microsoft SharePoint 2013 Unleashed and Microsoft SharePoint 2010 Unleashed.


Customer Service

If you have any questions regarding this event, the registration process or would like to register more than one attendee, please contact us directly.


Phone: 800-262-1954 or 913-967-1719

Your Shopping Cart

Sponsored Introduction Continue on to (or wait seconds) ×