Contents

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.

Speaker: Lonny Neiderstadt

Lonny has worked with databases for Epic, a major electronic health records company in Wisconsin, for over 20 years.

His current work focuses on best practice research and development, as well as performance intervention.

Lonny lives with his wife and two daughters just outside of Madison, Wisconsin.