Type to search LearningTree.co.uk

Do you mean "{{response.correctedQuery}}" ?

Sorry, no results were found for your query.

Please check your spelling and try your search again.

 

SQL Server









Preferred method of contact?

SQL Server 2012: Administration Skills Upgrade

COURSE TYPE

Hands-On

Course Number

2105

Duration

3 Days

Enrol

About This Course: 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 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
  • Resolve performance problems by examining waits
  • Configure a contained database to achieve deployment flexibility

Course Outline

  • Introducing the New Database Engine Features

Installing SQL Server

  • Assigning service accounts
  • Choosing installation options
  • Acquiring the AdventureWorks sample database

Exploring Licensing

  • Core vs. Server and CAL licenses
  • Maximising virtualisation opportunities
  • 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

  • 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
  • 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-level audits
  • Auditing database events
  • Filtering audit events
  • Managing Contained Databases

Comparing contained and noncontained databases

  • Considering the advantages of contained databases
  • Handling temporary tables with a contained database
  • Avoiding collation conflicts

Developing and creating a contained database

  • Granting user access
  • Converting an old database to a contained database
  • Breaking Performance Bottlenecks in SQL Server 2012

Querying important dynamic management objects

  • sys.syscacheobjects
  • sys.dm_os_waiting_tasks
  • sys.dm_exec_query_stats
  • sys.dm_os_wait_stats
  • sys.dm_os_volume_stats
  • sys.dm_os_performance_counters

Exploring the plan cache

  • Viewing cache contents
  • Building a Database Engine Tuning Advisor (DTA) Workload

Monitoring waits and queues to improve performance

  • Contrasting waits and queues
  • Analysing significant wait types
  • Correlating waits and queues

Simulating concurrent users

  • Investigating SQL Server Distributed Replay
  • Preprocessing the workload
  • Executing on multiple threads

Employing extended events for performance tuning

  • Modules
  • Packages
  • Events
  • Predicates
  • Constructing packages
  • Resolving blocking problems with Extended Events
  • 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

  • Designing the index
  • Measuring the impact of the index
Show complete outline
Show less

Course Schedule

Attend this live, instructor-led course In-Class or Online via AnyWare.

Hassle-Free Enrolment: No advance payment required.
Tuition Fee due 30 days after your course.

Nov 16 - 18 New York/AnyWare Enrol Now

How would you like to attend?

Live, Online via Anyware
In-Class

Guaranteed to Run

Bring this Course to Your Organisation and Train Your Entire Team
For more information, call 0800 282 353 or click here

Tuition Fee

Standard

£1695

Course Tuition Fee Includes:

After-Course Instructor Coaching
When you return to work, you are entitled to schedule a free coaching session with your instructor for help and guidance as you apply your new skills.

Free Course Exam
You can take your course exam on the last day of your course and receive a Certificate of Achievement with the designation "Awarded with Distinction."

Prev
Next

Questions

Call 0800 282 353 or click here »

An experienced training advisor will happily answer any questions you may have and alert you to any tuition fee savings to
which you or your organisation may be entitled.

Training Hours

Standard class hours:
9:00 a.m. - 4:30 p.m.

Last day class hours:
9:00 a.m. - 3:30 p.m.

Free Course Exam – Last Day:
3:30 p.m. - 4:30 p.m.

Each class day:
Informal discussion with instructor about your projects or areas of special interest
4:30 p.m. - 5:30 p.m.

AFTERNOON START class hours:
2:00 p.m. - 9:30 p.m.


Last day class hours:
2:00 p.m. - 8:30 p.m.


Free Course Exam – Last Day:
8:30 p.m. - 9:30 p.m.


Each class day:
Informal discussion with instructor about your projects or areas of special interest
9:30 p.m. - 10:30 p.m.

- ,

Prev
Next