New Functions of SQL Server 2012 from an Administrator’s Perspective


SQL Server 2012 has been designed to provide highest data availability and predictable database performance, while reducing the costs of CTA maintenance. The purpose of the training is to prepare administrators for the upgrade of database systems to SQL Server 2012 version and its effective management. To do this successfully one needs not only be able to use administration tools, but also be familiar with the new functions of SQL Server 2012. While designing this specialized training, we had in mind both our long-standing hands-on administration experience, and comments and problems reported by our participants and customers. This has resulted in a course which will enable the participants to independently and successfully upgrade SQL Server to its 2008 version and manage the database systems based on it.


  • Course level: 400
  • Start date: as required
  • Duration time: 2 days

Price: 2800 zł

  • Open training
  • On-site (costumer's premises)
  • Customer’s computer


We are addressing this course to database administrators, but also all those who have been working with previous versions of SQL Server, and are keen to find out about the new functionality of 2008 version. Its participants will acquire hands-on skills necessary to be able to upgrade databases to 2008 version and manage a database system fully using SQL Server 2008 functionality.


The basic training is comprised of 9 modules. Just like all the other courses on our offer, it has been designed by our experts, therefore we can freely customize it to suit the individual needs of the participants. We would like to encourage you not only to choose modules which you find relevant for your needs, but also to feel free to contact us with your suggestions and questions you would like to hear answered throughout the course. Our trainings are exceptional also because we limit the time set aside for laboratory type classes customarily conducted after the completion of each module, to the benefit of exercises done with the assistance of the trainer and demonstrations. We believe in this manner we can equip you with substantially more practical information and tips, and focus on dealing with the issues directly within your scope of interest. However, each day of the training is finished with a laboratory class of approximately 1hr, so that you can do self-practice and do exercises of your choice.


Duration: Level:
Module 1

Upgrade planning
  • Business Benefits Evaluation
  • Collecting Data Concerning Current Configuration (Microsoft Assessment and Planning Toolkit, Best Practices Analyzer)
  • Choosing Upgrade Strategy (in-place upgrade vs. migration)
  • Evaluating the Compatibility of the Application and Database with SQL Server 2012
  • Preparing Test Environment
  • Advanced Tools and Techniques for Testing a Database System (ACT Toolkit)

90 minutes 300
Module 2

Preparing Production Environment
  • Planning Input-Output Subsystem and Processor Performance
  • Choosing Hardware Configuration
  • Partition Alignment
  • SQL Server Requirements
  • SQL Server Licensing and how to Choose a Suitable Edition
  • Collation Considerations

60 minutes 300
Module 3

SQL Server Upgrade
  • Things to do before an Upgrade
  • OLTP Database Upgrade
  • Data Warehouse Upgrade
  • Analysis Database Upgrade
  • SSIS Package Upgrade
  • Things to Do after an Upgrade

60 minutes 400
Module 4

SQL Server Migration
  • Things to Do before a Migration
  • OLTP Database Migration
  • Data Warehouse Migration
  • Analysis Database Migration
  • SSIS Package Migration
  • Things to Do after a Migration

60 minutes 400
Module 5

Failover Clusters
  • Geographically Dispersed Clusters
  • Configurable Server Failover Policies
  • Enhanced diagnostic functions
  • Windows Server Core Compliance
  • Support for NAS
  • TempDB Enhancements

60 minutes 300
Module 6

AlwaysOn Technology
  • High Availability Groups (Architecture, Topologies, Configuration)
  • Switching Databases between High Availability Groups (Contained Databases, database level Authorization)
  • Virtual Access Points (Backward Compatibility, Creating and configuring Access Points)
  • Making Database Replicas Available for Reading( routing Configuration, Efficient Query Execution on Database Replicas, Database replica Backup)

180 minutes 400
Module 7

Columnstore Indexes and Data Processing Block Mode
  • Overview of Columnstore Indexes
  • Creating Columnstore Indexes (Recommendations, Requirements, Acceptable Data Types)
  • Managing Table Indexes (Switching Partitions))
  • Block Processing Mode (Requirements and Constraints, IGNORE_NONCLUSTERED_COLUMNSTORE_INDEX Directive)

90 minutes 400
Module 8

SQL 2012 Relation Engine Enhancements
  • Changes in Partitioning (Increased Partition Limit, Improved method for Generating Statistics)
  • Extended Events (Graphical Tools for Creating XE Sessions and Analyzing Stored Data, New Event Types. New Development Interface)

60 minutes 400
Module 9

Security Enhancements
  • Configurable User Group Schemas
  • Configurable Server Role (Creating and Managing Groups on the Server Level)
  • All Action Audit (Responding to Failures, Defining One’s Own Security Events, Filtering Stored Data)

60 minutes 400


Ask Question