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.

-10% for workshops booked in 2014!

dbi_icons_10_percentProfit from our special training offer and get a discount of 10% for all dbi InSite workshop trainings booked in 2014! This price deduction also applies to workshops taking place in 2015 and can be combined with the SOUG discount.



Instructors

stephane_haby_dbi_servicesdavid_barbarin_contact

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

Topics

  • 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

Method

  • 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