Microsoft Premier Workshop: SQL 2012 Advanced Management and Monitoring

Beschreibung

Der 4-tägige Workshop richtet sich an Teilnehme, die ihr internes Know-how SQL Management und Monitoring Bereich vertiefen wollen.

Anhand praktischer Übungen lernen SQL Server Administratoren, Entwickler, Datenbankarchitekten und Supporttechniker die neuen Features von SQL Server 2012 kennen , insbesondere in den Bereichen SQL Server Cloud, Virtualisierung, Automatisierung, Policy Managment, Security und Monitoring

Agenda

Module 1: SQL Server Internals and Base Technologies

This module provides an overview of SQL Server 2012 SQLOS architecture and engine internals such as improvements to memory management. Additional topics focus on managing and monitoring with PowerShell and using XML to analyze system health records and more.

Lesson 1 - SQLOS Architecture and Overview

Lesson 2 - PowerShell and Windows Management Instrumentation (WMI)

Lesson 3 - Extensible Markup Language (XML)

Module 2: SQL Server Cloud and Virtualization

This module provides an overview of managing virtualization with SQL Server on Hyper-V and monitoring SQL Server on Windows Azure Database. Additional topics cover SQL Server Management Studio and Data Tools used to manage these technologies.

Lesson 4 - SQL Server and Virtualization

Lesson 5 - Windows Azure Database with SQL Server Data Tools

Module 3: SQL Server Automation and Configuration

In this module we will cover recommended SQL Server best practices, leveraging table partitioning for large databases, and considerations around SQL Server settings. We will cover the reasons behind SQL Server best practices, when it makes sense to adjust SQL Server settings, what to watch for and why.

Lesson 6 - Automating SQL Server

Lesson 7 - SQL Server Database Settings

Lesson 8 - SQL Server Settings

Lesson 9 - Table Partitioning

Module 4: Resource Governance and Troubleshooting

This module covers additional technologies used to manage SQL Server such as proper use of the dedicated admin connection, leveraging Resource Governor for predictable performance. Lesson 10 - Resource Governor

Lesson 11 - Dedicated Admin Connection

Module 5: Extended Events, Policy Based Management, and Enterprise Policy Management Framework

In this module, we will combine the knowledge learned about SQL Server settings, WMI, and T-SQL in order to leverage Extended Events, Policy Based Management, and EPMF in the enterprise. We will cover how logging and alerting can be accomplished using PBM and how EPMF can help you gain awareness across your SQL Server installations.

Lesson 12 - Extended Events Enhancements

Lesson 13 - Policy-Based Management

Lesson 14 - Implementing Enterprise Policy Management Framework

Module 6: Advanced Monitoring Tools

This module covers additional monitoring tools and services such as Management Data Warehouse (MDW), Utility Control Point (UCP), SQL Server Performance Dashboard, System Center (SCOM) Management Packs for SQL Server, and the new System Center Advisor (SCA) service.

Lesson 15 - MDW, UCP, and Performance Dashboard

Lesson 16 - SCOM Management Pack for SQL Server

Lesson 17 - SQL Server System Center Advisor (SCA)

Module 7: Security

This module covers SQL Server security topics such as locking down the SQL Server instance, proper use of SQL Server auditing, and transparent data encryption.

Lesson 18 - SQL Server 2012 Auditing

Lesson 19 - SQL Server 2012 Security

Zielgruppe  

IT-Profis, die immer wieder mit SQL Server in Kontakt kommen wie zum Beispiel Helpdesk Techniker, Systemadministratoren, Sharepoint und SystemCenter Spezialisten

Level 300

(Level Skala: 100= Strategisch/ 200= technischer Überblick/ 300=tiefe Fachkenntnisse/ 400= technisches Expertenwissen)

Anmeldung

Zur Anmeldung wenden Sie sich bitte direkt an Ihren Microsoft Technical Account Manager oder besuchen Sie unseren Microsoft Services Blog. Dort finden Sie eine Gesamtübersicht aller offenen Workshops, für die Sie sich dort auch gleich anmelden können.