I am delighted about the opportunity to present at the Rhode Island Business Intelligence User Group on April 27, 2016.
I look forward to seeing old friends and meeting new ones. I will presenting the following topic that night.
Best Practicesfor SQL Server on an Azure VM
This presentation goes over key concepts that relate to both on the on premise and in cloud deployments.
Database processing involves CPU, RAM and DISK. I will go over engine settings and architectural choices that will help you get the most out of your Virtual Machine.
Even if you VM is configured to run extremely well, bad coding by the developers can cause performance issues. I will talk about using standard alerting for such identifying such conditions.
In the past, the DBA or SYSADMIN was responsible for patching and maintenance. New services in Azure allow you to automate some of these tasks.
Regardless of where your SQL Server database lives, this talk has something thing for everyone.
- Design virtual machine
- Access virtual machine
- Configure windows settings
- Setup database engine
- Install database mail
- Enable basic alerting
- Provide maintenance plans
- Take system baseline