Class Info

Online Course: SQL Server 2012 Delta for the DBA

Get Full Access for Only $49.00  

Course Overview

In a partnership agreement with Pragmatic Works, SSWUG.ORG’s virtual class is designed to introduce SQL Server DBA’s to the new and exciting features available in SQL Server 2012 . We use a variety of lab exercises to ensure lecture sessions are backed up by hands-on experience.  With the hands-on labs, you will experience how the new features can be utilized in your everyday DBA work. This course will cover topics such as AlwaysOn, ColumnStore indexes, SQL Server Data Tools, the FileTable feature, Azure and administering the BI platform within the context of SQL Server 2012.

Sessions

Module 01 – Deprecated and Discontinued Features –

  • Discontinued features
  • Features not supported in the next version of SQL Server (after 2012)
  • Features not supported in a future version of SQL Server
  • Licensing & Editions changes

Module 02 – ColumnStore Indexes –

  • ColumnStore Index (CSI) basics
  • Description and How-to DEMO
  • Best Practices
  • Data types
  • Restrictions

Module 03 – DMV’s & Extended Events

  • New and Improved DMV’s
  • New and Improved Extended Events
  • Session Wizard or Session UI
  • XEvent Tools

Module 04 – Security –

  • Default Schema for Windows Groups
  • Contained Database Authentication
  • User-defined Server Roles
  • Audit Enhancements

Module 05 – SQLOS –

  • Memory Managerchanges in SQL Server 2012
  • Resource Governor
  • sp_server_diagnostics
  • Table Partitioning

Module 06 – Central Management and DRU –

  • SSMS & SQL Server Configuration Manager
  • Catalog Views
  • Distributed Replay Utility

Module 07 – Availability Groups (Part 1) –

  • Setup
  • Configuration
  • AlwaysOn DMV’s

Module 08 – Availability Groups (Part 2) Demo –

  • Setup
  • Configuration
  • AlwaysOn DMV’s

Module 09 – Configuring a Listener using Availability Groups –

Module 10 – Disaster Recovery Enhancements –

  • AlwaysOn Active Secondaries

Module 11 – Clustering Enhancements –

  • Multi-site clustering

Module 12 – T-SQL Enhancements –

  • Conversion Functions
  • Date and Time Functions
  • Logical Functions
  • String Functions
  • Sequences
  • Ad-hoc Query paging
  • Metadata discovery
  • EXECUTE statement

Module 13 – FileTable and Full-text Semantic Search –

  • Enabling the Prerequisites for FileTable
  • Working with FileTable
  • Full-text Symantec Search

Module 14 – SQL Server Data Tools (SSDT) –

  • What is SSDT?
  • SQL Server Object Explorer
  • Productivity and Tools
  • Schema Compare
  • Visual Studio SQL Menu
  • Command Line tools
  • Off-line database projects

Module 15 – Data-tier Applications (DAC Packages) –

  • Deploy / Upgrade a Data-tier Application
  • Monitor a Data-tier Application
  • Export / Import a Data-tier Application

Module 16 – SSIS Administration –

  • Deployment Models
  • Integration Services Catalog
  • Package Execution

Module 17 – SSAS Administration –

  • Backup & Restore
  • Deploy & Process
  • Configuration
  • Security

Module 18 – SharePoint Administration –

  • Content databases
  • Tuning
  • DR

Speaker

 

GaGarethS-picThumbreth Swanepoel is a sysadmin-turned-SQL Server DBA. He has been working in the IT industry doing support and administration for over 20 years. He enjoys solving the complex problems that his clients encounter when deploying SQL Server in a data warehouse environment. He is originally from South Africa and currently lives in the quiet outskirts of Jacksonville, Florida. He is a member of the Pragmatic Works SEAL Team with a focus on Fast Track Data Warehouses, PDW and Infrastructure Tuning. Current projects include contributing content for the Professional SQL Server 2012 Administration book, SQL Server 2012 for the DBA virtual training class for SSWUG.org and various high-volume data warehouse speaking engagements at user groups, SQL Saturdays and other technical conferences.

 

Facebooktwittergoogle_plusredditpinterestlinkedinmail