SQL Server^® 2012:
Administration Skills Upgrade

Course 2105 • 3 Days

E-mail E-mail Print Print Q&A Q&A PDF PDF Facebook Twitter Twitter

You Will Learn How To

Leverage the new SQL Server 2012 administrative features
Build database high availability solutions with AlwaysOn groups
Implement user-defined server roles to delegate responsibilities
Take advantage of the FileTable capabilities for storing large object data
Configure a contained database to achieve deployment flexibility
Create a columnstore index to improve decision support query performance

Course Benefits

SQL Server 2012 includes an extensive array of capabilities for SQL Server administrators. Those migrating from SQL Server 2008 or SQL Server 2005 must upgrade their skills in order to leverage the enhanced feature set. This skills upgrade course provides the knowledge required to effectively take advantage of the new features in SQL Server 2012. You learn to build database availability solutions and exploit the wide range of administrator tools to gain maximum benefit for your organisation.

Who Should Attend

Experienced SQL Server administrators considering or currently migrating to SQL Server 2012. Practical DBA experience with prior versions of SQL Server databases is assumed.

Hands-On Training

Throughout this course, a series of extensive hands-on exercises provides you with practical experience administering SQL Server 2012. Exercises include:

Installing and migrating databases to SQL Server 2012
Leveraging the new features in Management Studio
Configuring AlwaysOn availability groups
Building, populating and querying a FileTable
Creating a contained database to avoid orphaned users
Troubleshooting waits and queues
Constructing a columnstore index to improve performance

Course Content

Introducing the New Database Engine Features

Preparing for installation

Selecting the appropriate edition
Defining a Managed Service account in Windows Server 2008 R2
Running SQL Server with a Managed Service account
Downloading and implementing the .NET framework

Installing SQL Server

Choosing installation options
Acquiring the AdventureWorks sample database

Upgrading to SQL Server 2012

Planning an upgrade

Installing the Upgrade Advisor
Analysing pre-2012 databases

Migrating a legacy SQL Server database

Comparing an in-place upgrade with migration
Transferring a database to 2012

Implementing AlwaysOn Availability

Demystifying AlwaysOn availability groups

Combining clustering, mirroring and replication
Choosing an architecture

Configuring an availability group

Creating the Windows cluster
Setting up the SQL Server group for high availability and disaster recovery
Monitoring with the Availability Group Dashboard

Offloading resource-intensive tasks to secondary servers

Taking full and transaction log backups
Checking database consistency
Running report queries

Securing SQL Server 2012

Taking advantage of user-defined server roles

Segregating roles and responsibilities
Constructing a user-defined server role

Applying new audit capabilities

Server vs. database audits
Filtering audit events

Developing FileTable Solutions

Contrasting file system data stores

Transactional vs. nontransactional processing
Integrating FileTable and FILESTREAM data stores

Establishing the prerequisites for FileTables

Enabling FILESTREAM at the instance level
Permitting nontransactional access at the database level
Specifying the directory for FileTables

Building and querying a FileTable

Creating, modifying and dropping
Populating
Querying

Managing Contained Databases

Comparing contained and noncontained databases

Considering the advantages of contained databases
Exploring the new security model
Handling temporary tables with a contained database

Developing and creating a contained database

Granting user access
Connecting to the database
Converting an old database to a contained database

Breaking Performance Bottlenecks by Monitoring Waits and Queues

Obtaining wait and queue information from dynamic management objects

Forming the query
sys.dm_os_waiting_tasks
sys.dm_os_wait_stats

Troubleshooting performance issues

Querying sys.syscacheobjects
Specifying the plan cache as the Database Engine Tuning Advisor (DTA) workload

Applying Columnstore Indexes to Decision Support Queries

Dissecting columnstore indexes

Comparing traditional and columnstore indexes
Determining when to apply a columnstore index

Improving query performance with columnstore indexes

Designing the index
Measuring the impact of the index

<< Back to SQL Server

Related Courses

Course Dates

Attend highlighted events in person or live, online via Learning Tree AnyWare^TM.

UK Dates
9-11 May	London enrol
22-24 Aug	London enrol
21-23 Nov	London enrol
US East Coast Dates
18-20 Apr	Washington, DC enrol*
30 May - 1 Jun	New York enrol*
13-15 Jun	Washington, DC enrol*

*New York and Washington DC Courses – Available online with a run time of 2pm to 9pm BST.

For AnyWare enrolments, please register at least 10 days prior to the start of the course.

More Dates and Locations.

Fees

£ 1,565	Standard Fee
Fee with a Savings Plan
£ 1,225	2-Course Passport
£ 1,085	3-Course Passport
£ 1,000	4-Course Passport
£ 1,600	Voucher 10-Pack

On-Site &
Custom Training

Bring this or any Learning Tree course to your location or have it customised for your organisation.

SQL Server 2012: Administration Skills Upgrade

Participants implementing availability groups in SQL Server 2012.

SQL Server® 2012: Administration Skills Upgrade