Part 1 SQL Server install in Azure VM Azure SQL DBA

Real time use case :

Client have requirement to build and install SQL Server 2019 , whare the the client has existing SQL Software with him , Part of cloud cost optimization we have taken decision follow deploy only Azure VM post that we have installed SQL Server Evaluation edition 2019 server .The client has a requirement to deploy and install SQL Server 2019, and they already possess existing SQL software. As part of our cloud cost optimization strategy, we have decided to deploy only Azure Virtual Machines (VMs). Subsequently, we installed SQL Server Evaluation Edition 2019 on these VMs. We successfully implemented a proof of concept (POC) for this approach, resulting in an impressive cost reduction of nearly 80%.



IF You feel better alter native solution provide in comments


Please note that this is a high-level overview, and specific details may vary depending on your environment and requirements.


Step 1: Prepare Your Azure Environment
1.1. Log in to the Azure Portal (https://portal.azure.com/).


1.2. Ensure that you have an Azure subscription with the necessary permissions to create VMs and associated resources.


1.3. Choose or create a virtual network (VNet) where your VM will be deployed.


Step 2: Create an Azure Virtual Machine
2.1. In the Azure Portal, click on "Create a resource."


2.2. Search for "Windows Server" and select a Windows Server image compatible with SQL Server 2019 (e.g., Windows Server 2019 Datacenter).


2.3. Click "Create."


2.4. Configure the VM settings, including the VM name, region, resource group, and authentication method (SSH key or password). Ensure that you select an appropriate VM size based on your workload and cost considerations.


2.5. Review and create the VM.


Step 3: Configure VM Network Settings
3.1. Associate the VM with the VNet created in Step 1.


3.2. Configure network security groups (NSG) to control inbound and outbound traffic to the VM.


Step 4: Install SQL Server 2019
4.1. Connect to the Azure VM using remote desktop (RDP) or Azure Bastion.


4.2. Download the SQL Server 2019 Evaluation Edition installer from the official Microsoft website.


4.3. Run the installer and select the desired SQL Server components and features to install.


4.4. Follow the installation wizard, specifying the necessary configuration settings such as instance name, authentication mode, and SQL Server administrators.


4.5. Complete the installation process.


Step 5: Configure SQL Server
5.1. Open SQL Server Management Studio (SSMS) on the VM.


5.2. Connect to the SQL Server instance.


5.3. Configure database settings, security, and permissions based on your application requirements.


Step 6: Optimize Cost
6.1. Implement cost-saving strategies within Azure, such as:


Rightsize the VM based on actual workload requirements.
Use Azure Reserved Instances (RIs) for longer-term cost savings.
Implement auto-pause and auto-resume for dev/test environments.