Overview

Mindsharp offers the only SQL Server 2005 Administration / SharePoint 2007 class that discusses several SQL Server Properties configured in a default SQL Server installation that have a significant impact on the security, performance, and recoverability of SharePoint.

This four-day custom class, offered only by Mindsharp, discusses several SQL Server configuration settings, and planning decisions that you have to consider prior to installing SQL Server and SharePoint in your organization. Often issues arise after the installation of SQL and SharePoint because people aren’t aware of how to perform an installation of SQL and SharePoint so that they complement each other. Furthermore, there are settings that can be changed to improve the integration between the two products.

In this class we’ll discuss hardware and software considerations, SharePoint database settings (collation, sizing, location, others), SQL tools for managing SharePoint databases, securing information, monitoring SharePoint activity in SQL Server, transferring data from your content databases to other locations (another SQL Server instance, Excel, even a flat file), SharePoint reporting using SQL Server Reporting Services (SSRS), backup and recovery process minimizing SharePoint down time, and of course different options for you to implement high availability of your SQL Servers to maximize SharePoint’s uptime.

Online

The online option is held in conjunction with the instructor-led course, with other students in the classroom and online, via Live Meeting technology.

For all labs to work, and to make the most of the event, you will need to set up your computer with the following:

• Operating System: Windows 2000, Windows XP, Vista or Windows 7
• Microsoft Office Live Meeting 2007 client - This should be downloaded (http://office.microsoft.com/en-us/help/HA101733831033.aspx) and installed in advance of the event.

Prerequisites

• SQL 2000, 2005, or 2008 proficient use from a DBA perspective
• Understanding of Microsoft Office SharePoint Server 2007
• Have reviewed site taxonomy for existing implementation or
• A clear understanding of the current security model for SharePoint
• SQL (data security) and how the firm is implementing like security groups and permissions

Audience

The primary audience for this course is a DBA or data architect who intend to manage the 2000, 2005 or 2008 SQL server installation that is integrated with SharePoint. It is optimal for those whose role includes setting defaults for the databases that SQL creates for SharePoint, setting database size and how to creating and maintain multiple databases for web application and control, and providing high availability of your SQL Server.

To register for these events, click on the registration icon below.

Attend In Person

Attend Online