Products dbi InSite Workshops SQL Server 2012 New Features
dbi InSite Workshops

SQL Server 2012 New Features workshop · 3 days

You have little or no experience in Microsoft SQL Server 2012 database administration and want to know what is new in this new version of SQL Server? Then you should attend our SQL Server 2012 New Features workshop training. In this three-day course, you will learn all about SQL Server 2012 new features and tools, changes, and enhancements – including ColumnStore Indexes, Contained Databases, Sequences, and AlwaysOn.




Training objectives

  • Understand the new features of SQL Server 2012
  • Get acquainted with the new installation and configuration options
  • Experience the new T-SQL enhancements, e. g. Sequences, Contained Databases, FileTables, and ColumnStore Indexes
  • Learn all about the new maintenances features and tools, such as the Database Recovery Advisor or the new DMVs (Dynamic Management Views)
  • Experience the new high availability features AlwaysOn and Availability Groups


  • Installation and configuration on Windows Core, new update
  • SEQUENCES,  CONCAT, EOMONTH, TRY_PARSE, and other T-SQL enhancements
  • SQL Server Management Studio (SSMS): snippets, T-SQL debugger, task list
  • SQL Server Data Tools (SSDT) , Powershell 2.0, and SQLCMD enhancements
  • Database security: Contained Databases and user defined server roles
  • Database objects: FileTables, ColumnStore Indexes, Geospatial Support
  • Maintenance: Database Recovery Advisor, Resource Governor, Distributed Replay
  • Troubleshooting: extended events, new DMVs, online operators
  • High Availability: AlwaysOn, Multi-database failover, Multiple Secondaries, Availability Groups


  • Presentation with countless practical exercises and trainings
  • Case studies, live demos, discussions
  • Networking during coffee break, lunch, and apéro on last day (included in price, except for on-site workshop courses)

Target groups

  • Database administrators (DBA) as well as network, system, and application administrators responsible for or supporting SQL Server databases

Language & documentation

  • Workshop training normally held in English; French or German possible instead as course languages
  • Documentation: content details, scripts, case study solutions as PDF file (in English)

Book dbi InSite Workshop training now!

* VAT in addition. Members of the SOUG (Swiss Oracle User Group) are entitled to a discount of 5%. soug_web_logo
AddThis Social Bookmark Button
Deutsch (DE-CH-AT)   French (Fr)

Stéphane Haby

Stéphane Haby

Questions on this topic? Contact me!

Stéphane Haby - LinkedinStéphane Haby - E-mail

Fixed Price Services

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

A safe investment: our IT services at fixed prices!

Your flexible SLA

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

ISO 20000 certified & freely customizable!

dbi services Newsletter