Topic:
SQL Server instance running on Azure VM is similar to running it on-premises in terms of functionality and application compatibility but there are certain administrative configurations, best practices and optimizations specific to Azure platform which every DBA, database consultant and architect needs to be aware of to improve the performance, reliability and availability of their SQL Server instance in Azure.
The session aims to cover the following topics for the attendees:
- Common scenarios where running SQL Server on Azure VM is beneficial.
- Optimal Azure VM configuration settings for SQL Server.
- Understanding storage considerations, limits and configuration settings impacting the performance of SQL Server in Azure VM.
- How to tune and optimize SQL Server when running on Azure VMs.
- High Availability considerations in Azure.
- Backup\Restore options in Azure.
- Network and firewall configuration settings in Azure.
- Best practices for running SQL Server in Azure VM.
- DBA checklist to migrate your existing on-premises SQL Server workload to Azure VM.
At the end of the session, attendees will go back with a playbook with all the know-how for optimizing and successfully running their SQL Server on Azure VMs.
Speaker:
Parikshit Savjani, Senior Program Manager Microsoft
Parikshit Savjani is a Senior Program Manager with Microsoft SQL Server Product Group, working on making the customers and SQL community successful on Microsoft Data platform. He has more than 9 years of experience with Microsoft and SQL Server. He started with Microsoft CSS providing support assistance to Premier customers of Microsoft and then moved on to become Premier Field Engineer (PFE), working with large enterprise customers providing best practice guidance, performance tuning, consulting, and proactive assistance to improve the overall health of SQL Server deployments. He contributes to the community via his blog, slideshare & by presenting in various SQL community events.