Data Platform

Insight-Based Administration for Microsoft SQL Server and Azure SQL Database


Visual Studio July 19, 2018 9:00 am - 6:00 pm

Bookmark and Share

Lonny Niederstadt

The number of databases we care for keeps increasing, and our busiest database keep getting busier year after year.
In this one-day workshop, let’s explore Microsoft Windows and database observation, investigation and governance tools.

Agile system administration decisions and actions are possible when enabled by the information from Microsoft tools.
We’ll discuss how insight from these tools can improve alignment with business initiatives and goals.
We’ll also discuss how these tools can improve communication and coordination with vendors, developers, and end users.

Extended Events and DMVs/DMFs available in all SQL Server editions and Azure SQL Database will be used.
Resource Governor will be included, as well as alternatives for SQL Server Express and Standard Edition.
Automation options for all SQL Server editions and Azure SQL Database will also be covered.

This workshop will include the following modules.

  • Inventory & Compliance Checking
  • Monitoring & Alerting
  • Workload Profiling
  • Capacity Planning
  • Resource Governor
  • Incident Response
  • Automation

In order to fully participate in the workshop, a laptop is required with SQL Server Developer Edition locally installed.