Azure SQL Monitoring Fundamentals
2022TL; DR
Migrating you on-premises Database to Azure SQL DB was easy but now comes the hard part how do you setup monitoring and alerts?
Session Details
Migrating you on-premises Database to Azure SQL DB was easy but now comes the hard part how do you setup monitoring and alerts? While there are many 3rd party options what comes standard with Azure:
- How can you be sure your azure SQL Database isn't under or over allocated, so that your costs are optimized.
- How can you project what future costs maybe.
- Using Azure Log Analytics to monitor databases
- What tools from your on-premises SQL server toolkit will still work and what new capabilities exists.
3 things you'll get out of this session
Speakers
Jason Horner's previous sessions
Data Lake Design Patterns
Data lakes have been around for several years and there is still much hype and hyperbole surrounding their use. This session covers the basic design patterns and architectural principles.
Dimensional Modeling: Beyond the Basics
In this session, we will dive deeper into the art of dimensional modeling. We will identify the different types of fact tables and dimension tables and also review approaches to
creating rich hierarchies that simplify complex reporting.