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.