3 Day(s)


  • Migrating databases to SQL Server 2012
  • Leveraging the new features in Management Studio
  • Configuring AlwaysOn availability groups
  • Defining SQL Server Audits
  • Creating a contained database to avoid orphaned users
  • Analyzing waits to troubleshoot performance problems

Your Choice

Customize your hands-on Learning Method with your choice of PC usage: Pair Up or Sole Use. Learn More ยป


Experienced SQL Server administrators considering or currently migrating to SQL Server 2012, who have practical DBA experience with prior versions of SQL Server databases.

Skills Gained

  • 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 Specifics

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
  • Maximizing virtualization opportunities

Upgrading to SQL Server 2012

Planning an upgrade
  • Installing the Upgrade Advisor
  • Analyzing 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
  • Analyzing 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

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

Upcoming Dates

Course Location Days Cost Date
3 1500 £1500 2018-09-17