Installing, Administering, and Configuring Microsoft SQL Server in Azure

This comprehensive guide provides a deep dive into the intricacies of installing, administering, and configuring Microsoft SQL Server in the Azure environment. Whether you're a seasoned database administrator or an IT professional exploring cloud-based database solutions, this guide equips you with the knowledge and resources to effectively manage your SQL Server deployments on Azure.

Installing SQL Server on Azure

Microsoft offers several approaches to installing SQL Server on the Azure platform, each catering to specific needs and deployment scenarios. Let's explore the key methods:

Azure Virtual Machines

One of the primary methods for installing SQL Server on Azure is by utilizing Azure Virtual Machines (VMs). This approach involves creating a VM within your Azure environment and subsequently installing SQL Server on the virtual machine, much like installing it on a physical server1.

To install SQL Server on an Azure VM, follow these general steps:

1. Select a SQL Server VM image: Begin by signing in to the Azure portal and navigating to the Azure SQL section. Choose a SQL Server VM image that aligns with your desired version of SQL Server and the operating system. You can opt for images with a free SQL Server license for conventional VMs or select specific images for confidential VMs6.

2. Configure the VM: Provide the necessary details for your VM, such as the virtual machine name, region, and availability options. Select an appropriate size for the VM based on your performance requirements6.

3. Configure SQL Server settings: On the SQL Server settings tab, configure options such as SQL connectivity, authentication method, and Azure Key Vault integration6.

4. Connect to the VM: Once the VM is created and running, connect to it using Remote Desktop. For enhanced security, consider using Azure Bastion, which provides secure and seamless RDP and SSH connectivity to your VMs directly through the Azure portal6.

5. Install SQL Server: After connecting to the VM, you can proceed with the SQL Server installation. You can use various methods, including the installation wizard, command prompt, or a configuration file7.

Azure SQL Managed Instance

Azure SQL Managed Instance is a fully managed platform-as-a-service (PaaS) offering that provides near-100% compatibility with on-premises SQL Server. This makes it an ideal choice for lift-and-shift migrations of your existing SQL Server workloads to the cloud8.

With Azure SQL Managed Instance, you get the following benefits:

• Fully managed: Microsoft takes care of the underlying infrastructure, including patching, updates, and high availability, allowing you to focus on your applications and data.

• Near-100% compatibility: Maintain compatibility with your existing SQL Server applications and tools, minimizing code changes and migration efforts.

• Enhanced security: Benefit from built-in security features, such as Azure Active Directory integration, VNet isolation, and threat detection.

• Scalability and performance: Scale your resources up or down based on your needs, and take advantage of performance optimizations for demanding workloads.

Azure SQL Database

Azure SQL Database is another fully managed PaaS database offering that provides a cost-effective and scalable solution for modern cloud applications. It offers various deployment options, service tiers, and purchasing models to cater to different needs and budgets8.

Service Tiers

Azure SQL Database offers several service tiers, each with different performance and feature characteristics:

Purchasing Models

Azure SQL Database offers two purchasing models:

Azure Arc-enabled SQL Server

Azure Arc allows you to manage your SQL Server instances, regardless of where they are running, including on-premises, multi-cloud, and edge environments. This provides a consistent management experience and enables you to extend Azure services, such as Azure Security Center and Azure Monitor, to your hybrid and multi-cloud deployments5.

With Azure Arc-enabled SQL Server, you can:

• Manage SQL Server instances from a central location: Use the Azure portal to manage your SQL Server instances across different environments.

• Apply Azure policies and governance: Extend Azure policies and governance to your on-premises and multi-cloud SQL Server deployments.

• Utilize Azure services: Leverage Azure services, such as Azure Backup and Azure Site Recovery, for your hybrid and multi-cloud SQL Server instances.

To connect your SQL Server instances to Azure Arc, you can use the following steps:

1. Generate an onboarding script: In the Azure portal, navigate to Azure Arc and generate an onboarding script for SQL Server5.

2. Connect SQL Server instances: Execute the downloaded script on the target machine to connect your SQL Server instances to Azure Arc5.

Choosing the Right Deployment Option

When deploying SQL Server on Azure, it's essential to choose the right deployment option based on your specific needs and requirements. Here's a comparison of the key options:

Administering SQL Server on Azure

Effective administration of SQL Server on Azure involves implementing best practices to ensure optimal performance, security, and resource utilization. Here are some key considerations:

Performance Best Practices

Performance Monitoring

• Monitor resource limits: Carefully monitor resource limits, such as CPU, memory, and I/O, to avoid performance bottlenecks and unexpected restarts11.

• Utilize Azure Monitor: Use Azure Monitor to collect, analyze, and act on telemetry data from your SQL Server environment. This includes identifying infrastructure issues with VM insights and monitoring data with Log Analytics for deeper diagnostics11.

• Utilize Azure Advisor: Use Azure Advisor to address performance, cost, reliability, operational excellence, and security recommendations11.

Database Configuration

• Configure multiple tempdb data files: Create multiple tempdb data files to improve performance, especially in high-volume environments12.

• Use Clustered columnstore indexes: Leverage clustered columnstore indexes for efficient storage and querying of large datasets commonly encountered in IoT and edge scenarios12.

• Enable database page compression: Utilize database page compression to reduce storage requirements and improve I/O performance11.

• Enable backup compression: Enable backup compression to minimize storage costs and improve backup and restore times11.

• Move all databases to data disks: Move all databases, including system databases, to data disks to enhance performance and separate data from the operating system11.

• Set max SQL Server memory limit: Configure the maximum memory limit for SQL Server to leave sufficient memory for the operating system11.

• Choose the appropriate recovery model: Select the appropriate recovery model for your SQL Server databases based on your needs for data recovery and transaction log management. Simple recovery model is suitable for edge deployments with limited storage, while Full recovery model provides more comprehensive recovery options12.

Storage Optimization

• Place data, log, and tempdb files on separate drives: Separate data, log, and tempdb files onto different drives to optimize performance and avoid contention13.

• Stripe multiple Azure data disks: Utilize Storage Spaces to stripe multiple Azure data disks and increase I/O bandwidth13.

• Set host caching: Configure host caching appropriately for data and log file disks to improve performance. Set host caching to read-only for data file disks and to none for log file disks13.

Security Best Practices

• Control database and application access: Implement strong authentication mechanisms, such as multi-factor authentication (MFA) and Azure Active Directory (AD) integration, to control access to your SQL Server instances and databases. Azure AD authentication provides simplified user management, MFA enforcement, and integration with other Azure security features14.

• Protect sensitive data using encryption: Utilize encryption technologies, such as Transparent Data Encryption (TDE) and Always Encrypted, to protect sensitive data at rest and in transit. TDE encrypts your data files, while Always Encrypted protects sensitive data within columns14.

• Implement network access controls: Use virtual network (VNet) service endpoints, VNet firewall rules, and Network Security Groups (NSGs) to restrict network access to your SQL Server instances. This helps prevent unauthorized access and minimizes the attack surface14.

• Enable threat detection and response: Utilize Azure Defender for SQL to detect and respond to potential security threats and vulnerabilities. Azure Defender for SQL provides advanced threat detection, vulnerability assessments, and security alerts to help you proactively protect your data14.

• Enable auditing: Configure auditing to track database events and gain insights into database activity for security and compliance purposes. Auditing helps you monitor data access and identify any suspicious activities14.

• Use granular permissions and user-defined database roles: Implement least privilege principles by using granular permissions and user-defined database roles to control access to database objects. This ensures that users have only the necessary permissions to perform their tasks15.

• Use least-privilege role-based security strategies: Employ role-based access control (RBAC) to manage security and grant minimum necessary permissions to users and groups. RBAC simplifies security management and helps enforce least privilege principles16.

• Choose Active Directory over SQL Server authentication: Prioritize Active Directory authentication over SQL Server authentication for easier account management and improved security. Active Directory integration allows you to leverage your existing identity management infrastructure16.

• Require strong and complex passwords: Enforce strong password policies and regularly update passwords to minimize the risk of unauthorized access. Strong passwords help protect against brute-force attacks and password guessing16.

• Use firewalls and lock down ports: Configure firewalls to restrict access to SQL Server ports and minimize the attack surface. Firewalls help prevent unauthorized network access to your SQL Server instances16.

• Ensure the latest operating system and application security updates are applied: Keep your operating system, SQL Server, and related components up to date with the latest security patches to address vulnerabilities. Regular updates help protect against known security threats16.

• Use Azure confidential VMs: Consider using Azure confidential VMs to enhance the protection of your data in use and at rest. Confidential VMs provide hardware-level security features to protect your data from unauthorized access17.

• Use Azure Disk Encryption: Utilize Azure Disk Encryption to encrypt your data end-to-end, including the ephemeral disk, for enhanced security and compliance. Disk encryption helps protect your data even if the storage media is compromised17.

• Lock down management ports: Close unnecessary management ports on your VMs and use secure management tools like Azure Bastion to minimize security risks. Azure Bastion provides secure and seamless RDP and SSH connectivity to your VMs directly through the Azure portal17.

• Use VM extensions: Leverage VM extensions to enhance security with features like anti-malware, desired state configuration, and threat detection. VM extensions provide additional security layers and capabilities for your SQL Server VMs17.

• Consider Azure Key Vault: Utilize Azure Key Vault to securely store and manage application secrets, certificates, and encryption keys. Azure Key Vault provides a centralized and secure location for managing sensitive data17.

• Use Managed Disks: Utilize Azure Managed Disks, which are encrypted at rest by default, to enhance data security. Managed Disks provide simplified disk management and built-in encryption for your SQL Server VMs17.

• Consider trusted launch: Explore trusted launch features to ensure the integrity of the boot chain and protect your workloads. Trusted launch helps prevent malicious code from compromising your VMs during startup17.

• Create a unique local administrator account: Create a unique local administrator account with a strong password to improve security. This helps prevent unauthorized access to your VMs17.

• Disable the SA login: Disable the SA login or assign a new strong password if it must be used. The SA login is a high-privilege account that should be protected to prevent unauthorized access17.

• Use connection encryption and certificate validation: Ensure that all communications between SQL Database and your application are encrypted and that certificates are validated to prevent man-in-the-middle attacks. This helps protect your data in transit18.

• Prevent injection vulnerabilities: Use parameterized queries and conduct thorough code reviews to prevent SQL injection vulnerabilities. SQL injection is a common security threat that can be mitigated by using parameterized queries and secure coding practices18.

Configuring SQL Server on Azure

Configuring SQL Server for optimal performance in Azure involves fine-tuning various settings and leveraging Azure-specific features. Here are some key configuration considerations:

Performance Optimization

• Use Azure Marketplace images: Utilize Azure Marketplace images for SQL Server VMs, as they come pre-configured with optimized settings for performance11.

• Choose appropriate VM sizes: Select VM sizes with sufficient vCPUs and memory to meet your performance requirements11.

• Configure connection pool settings: Optimize connection pool settings in your applications to manage connections efficiently and reduce latency. Connection pooling helps reuse existing connections, reducing the overhead of establishing new connections19.

• Implement retry logic: Incorporate retry logic in your applications to handle transient connectivity failures gracefully. Transient errors are short-lived connectivity issues that can be addressed by implementing retry mechanisms19.

• Optimize token-based authentication: If using token-based authentication, implement proactive token renewal and adjust token lifetimes to minimize performance overhead. Proactive token renewal helps avoid delays caused by token expiration19.

• Monitor connection performance: Monitor connection performance and resource usage to identify bottlenecks and adjust configurations accordingly. Use tools like Azure Monitor and performance counters to track connection metrics and identify areas for improvement19.

Advanced Configuration

• Configure using mssql.conf file: For advanced configuration of SQL Server on Azure, you can use the mssql.conf file. This file allows you to fine-tune various settings, such as memory limits and network configurations12.

Azure-Specific Features

• SQL Server IaaS Agent extension: Register your SQL Server VM with the SQL Server IaaS Agent extension to unlock features such as automated patching, license management, and integration with Azure services. The SQL Server IaaS Agent extension simplifies management tasks and provides access to Azure-specific capabilities2.

• Automated patching: Utilize automated patching to keep your SQL Server instances up to date with the latest security updates and bug fixes. Automated patching helps ensure that your SQL Server deployments are secure and reliable2.

• Change license type and edition: The SQL Server IaaS Agent extension allows you to change the license type and edition of your SQL Server instances. This provides flexibility in managing your SQL Server licenses and deployments2.

• Azure Key Vault integration: Integrate with Azure Key Vault to securely store and manage sensitive data, such as connection strings and encryption keys. Azure Key Vault provides a centralized and secure location for managing sensitive data2.

• Azure Backup: Utilize Azure Backup to protect your SQL Server data with automated backups and point-in-time recovery capabilities. Azure Backup simplifies backup management and provides reliable data protection3.

• Azure Site Recovery: Leverage Azure Site Recovery to implement disaster recovery solutions for your SQL Server deployments. Azure Site Recovery helps ensure business continuity in the event of outages or disasters3.

• Azure Data Factory: Integrate with Azure Data Factory to build data integration and transformation pipelines for your SQL Server data. Azure Data Factory provides a powerful platform for building data-driven workflows3.

• Azure Feature Pack for Integration Services (SSIS): Utilize the Azure Feature Pack for SSIS to extend SSIS capabilities for Azure services. The Azure Feature Pack provides connectors and components for integrating SSIS with Azure services3.

• Azure SQL Database: Explore Azure SQL Database, a fully managed platform-as-a-service (PaaS) database offering, for simplified management and scalability. Azure SQL Database provides a serverless option for sporadic or unpredictable workloads, allowing you to pay only for the actual compute resources consumed8.

• Azure SQL Managed Instance: Consider Azure SQL Managed Instance, a PaaS offering that provides near-100% compatibility with on-premises SQL Server, for lift-and-shift migrations. Azure SQL Managed Instance supports failover groups to configure a secondary SQL Managed Instance in another region for disaster recovery8.

Troubleshooting Common Issues

Troubleshooting common issues with SQL Server on Azure requires a systematic approach to identify and resolve problems effectively. Here are some common issues and troubleshooting steps:

Connectivity Issues

• Firewall configuration: Verify that firewall rules are properly configured to allow connections to your SQL Server instances. Ensure that the Azure SQL Database firewall and any client-side firewalls allow connections on port 143322.

• Network reconfiguration: Check for any network changes on the client-side that might be affecting connectivity, such as new IP addresses or proxy server configurations. If there have been any network changes, update your firewall rules and connection strings accordingly22.

• Connection string errors: Verify the accuracy of your connection strings and other connection settings. Ensure that the connection string specifies the correct server name, port, and authentication credentials22.

• Service health: Check the Azure service health dashboard for any regional outages that might be impacting connectivity. If there is a regional outage, consider using a different Azure region or implementing a disaster recovery plan22.

• Transient errors: Implement retry logic in your applications to handle transient errors, which are short-lived connectivity issues. Transient errors can occur due to temporary network issues or resource limitations22.

Performance Issues

• Monitor resource metrics: Utilize Azure Monitor and performance counters to monitor resource utilization, such as CPU, memory, and I/O, to identify performance bottlenecks. Azure Monitor provides detailed performance metrics and insights into your SQL Server environment23.

• Optimize queries: Analyze and optimize database queries to improve performance and reduce resource consumption. Use query profiling tools and techniques to identify and optimize slow-running queries23.

• Address blocking issues: Identify and resolve blocking problems that can hinder performance. Blocking occurs when one process holds a lock on a resource that another process needs, causing delays and performance degradation24.

• Troubleshoot slow-running queries: Investigate and optimize slow-running queries to improve overall database performance. Slow-running queries can be caused by various factors, such as missing indexes, outdated statistics, or inefficient query logic24.

• Address I/O issues: Troubleshoot and resolve I/O-related performance problems. I/O bottlenecks can occur due to slow storage, excessive disk activity, or inefficient data access patterns24.

• Troubleshoot query time-out errors: Investigate and address query time-out errors to ensure efficient query execution. Query time-out errors can occur when queries take longer than the configured timeout period to complete24.

• Address memory issues: Troubleshoot and resolve memory-related issues, such as out-of-memory or low memory conditions. Memory issues can cause performance degradation and application instability24.

Other Common Issues

• Database size limitations: Monitor database size and adjust storage limits or implement data management strategies to prevent exceeding storage quotas. Each service tier in Azure SQL Database has a maximum database size limit25.

• Tempdb usage: Optimize tempdb usage and configuration to avoid performance issues related to temporary object storage. Tempdb is a system database used for storing temporary objects, and its performance can impact overall database performance25.

• Transaction log issues: Monitor and manage transaction log file size and health to prevent performance degradation and storage issues. Transaction log files can grow excessively if not managed properly, leading to storage consumption and performance problems25.

Troubleshooting Resources

Microsoft provides various resources to help you troubleshoot common issues with SQL Server on Azure:

• SQL Server documentation: The official SQL Server documentation provides comprehensive information about troubleshooting, performance tuning, and best practices24.

• Azure SQL Database documentation: The Azure SQL Database documentation provides specific guidance on troubleshooting connectivity issues, performance problems, and other common errors25.

• Microsoft Q&A: The Microsoft Q&A platform allows you to ask questions and get answers from Microsoft experts and the community24.

• Microsoft Support: Microsoft Support provides various support options, including online resources, phone support, and incident submission24.

Here's a table summarizing some common error messages and their solutions:

Cost Optimization

Managing costs effectively is crucial when deploying and running SQL Server on Azure. Here are some cost optimization strategies:

Understanding Cost Factors

Several factors contribute to the cost of running SQL Server on Azure:

• Service tier: The service tier you choose for Azure SQL Database (e.g., Basic, Standard, Premium) significantly impacts cost. Higher tiers offer better performance and features but come at a higher price26.

• Compute size: The compute size you select for your VMs or Azure SQL Database instances affects cost. Larger compute sizes provide more resources but also cost more28.

• Storage: The amount of storage you consume for your databases and backups contributes to cost. Optimize storage usage by removing unnecessary data and implementing data compression techniques27.

• Licensing: The type of SQL Server license you use (e.g., pay-as-you-go, bring-your-own-license) affects cost. Azure Hybrid Benefit allows you to use your existing SQL Server licenses for discounted rates on Azure20.

Cost Optimization Strategies

• Right-size resources: Choose the appropriate service tier, compute size, and storage options based on your workload requirements to avoid overspending. Analyze your workload characteristics and select the most cost-effective resources that meet your needs26.

• Implement auto-scaling: Utilize auto-scaling features to dynamically adjust resources based on demand, ensuring you only pay for what you need. Auto-scaling helps optimize resource utilization and reduce costs during periods of low activity26.

• Optimize queries and indexes: Optimize queries and implement appropriate indexes to improve performance and reduce resource consumption, leading to cost savings. Efficient queries and indexes minimize the amount of compute and storage resources required26.

• Consider database consolidation: Consolidate multiple databases into a single database or server to improve resource utilization and reduce costs. Database consolidation can help you reduce licensing costs and optimize resource allocation26.

• Use cost management tools: Leverage Azure Cost Management and Azure Advisor to gain insights into your spending patterns and identify cost optimization opportunities. Azure Cost Management provides detailed cost analysis and reporting, while Azure Advisor offers personalized recommendations for cost optimization20.

• Consider reserved capacity: Utilize Azure Reservations to pre-purchase compute capacity for one or three years and obtain significant cost savings compared to on-demand pricing. Azure Reservations provide discounts for committing to long-term usage of compute resources27.

• Implement auto-pause and auto-scale: Configure auto-pause and auto-scale features to automatically adjust resources based on workload demands, reducing costs during idle periods. Auto-pause allows you to pause databases during periods of inactivity, while auto-scale dynamically adjusts resources based on workload fluctuations27.

• Use serverless options: Consider serverless options for sporadic or unpredictable workloads to pay only for the actual compute resources consumed. Azure SQL Database serverless automatically scales compute resources based on demand and charges you based on the actual compute used per second20.

• Optimize data storage: Evaluate data storage requirements, remove unnecessary data, and implement data compression techniques to reduce storage costs. Data compression and efficient storage management can help minimize storage costs27.

• Use Azure Hybrid Benefit: Leverage the Azure Hybrid Benefit to maximize the value of your on-premises SQL Server licenses and obtain discounted rates on Azure. Azure Hybrid Benefit allows you to use your existing SQL Server licenses with Software Assurance to reduce the cost of running SQL Server on Azure VMs or Azure SQL Database20.

• Take advantage of free extended security updates: For applications that rely on SQL Server 2008 or 2008 R2, activate three years of free extended security updates when you migrate to Azure Virtual Machines. This helps you save on security update costs while maintaining the security of your legacy applications20.

• Use Azure Site Recovery for migration: Utilize Azure Site Recovery for easy migration of SQL Server 2008 and 2008 R2 to Azure Virtual Machines. Azure Site Recovery provides pre-configured SQL Server images in the Azure Gallery, simplifying the migration process20.

Conclusion

This guide has provided a comprehensive overview of installing, administering, and configuring Microsoft SQL Server in an Azure environment. By understanding the different deployment options, such as Azure Virtual Machines, Azure SQL Managed Instance, and Azure SQL Database, you can choose the best approach for your specific needs. Implementing best practices for performance optimization, security hardening, and cost management is crucial for successful SQL Server deployments on Azure.

Remember to leverage Azure-specific features, such as the SQL Server IaaS Agent extension, Azure Backup, Azure Site Recovery, and Azure Monitor, to simplify management tasks and enhance your SQL Server deployments. Regularly monitor your resources, optimize queries, and stay informed about the latest updates and best practices from Microsoft to maximize the benefits of running SQL Server in the cloud.

Works cited

1. SQL Server Downloads | Microsoft, accessed on February 4, 2025, https://www.microsoft.com/en-us/sql-server/sql-server-downloads

2. SQL Server on Azure VM documentation - Microsoft Learn, accessed on February 4, 2025, https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/?view=azuresql

3. Deploy SQL Server on Azure Local, version 23H2 - Microsoft Learn, accessed on February 4, 2025, https://learn.microsoft.com/en-us/azure/azure-local/deploy/sql-server-23h2

4. learn.microsoft.com, accessed on February 4, 2025, https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/sql-vm-create-portal-quickstart?view=azuresql#:~:text=Sign%20in%20to%20the%20Azure,Select%20SQL%20deployment%20option%20page.

5. How To Install SQL Server on an Azure VM | Niels Berglund, accessed on February 4, 2025, https://nielsberglund.com/post/2021-02-14-how-to-install-sql-server-on-an-azure-vm/

6. Quickstart: Create SQL Server on a Windows virtual machine in the Azure portal, accessed on February 4, 2025, https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/sql-vm-create-portal-quickstart?view=azuresql

7. Install SQL Server from the Installation Wizard (Setup) - Microsoft Learn, accessed on February 4, 2025, https://learn.microsoft.com/en-us/sql/database-engine/install-windows/install-sql-server-from-the-installation-wizard-setup?view=sql-server-ver16

8. Azure SQL documentation - Microsoft Learn, accessed on February 4, 2025, https://learn.microsoft.com/en-us/azure/azure-sql/?view=azuresql

9. Azure SQL vs SQL Server: Differences & Best Practices - OpsRamp, accessed on February 4, 2025, https://www.opsramp.com/guides/azure-best-practices/azure-sql-vs-sql-server/

10. What is the Azure SQL Database service? - Microsoft Learn, accessed on February 4, 2025, https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview?view=azuresql

11. Checklist: Best practices for SQL Server on Azure VMs - Microsoft Learn, accessed on February 4, 2025, https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/performance-guidelines-best-practices-checklist?view=azuresql

12. Performance best practices and configuration guidelines - Azure SQL Edge, accessed on February 4, 2025, https://docs.azure.cn/en-us/azure-sql-edge/performance-best-practices

13. Storage: Performance best practices for SQL Server on Azure VMs - Microsoft Learn, accessed on February 4, 2025, https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/performance-guidelines-best-practices-storage?view=azuresql

14. [Guide] Azure SQL And Security Best Practices - Red9, accessed on February 4, 2025, https://red9.com/blog/azure-sql-security-best-practices/

15. Playbook for addressing common security requirements - Azure SQL Database & Azure SQL Managed Instance | Microsoft Learn, accessed on February 4, 2025, https://learn.microsoft.com/en-us/azure/azure-sql/database/security-best-practice?view=azuresql

16. SQL Server security best practices - Microsoft Learn, accessed on February 4, 2025, https://learn.microsoft.com/en-us/sql/relational-databases/security/sql-server-security-best-practices?view=sql-server-ver16

17. Security: Best practices - SQL Server on Azure VMs - Microsoft Learn, accessed on February 4, 2025, https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/security-considerations-best-practices?view=azuresql

18. Azure SQL Database Security Guidelines and Limitations - GitHub, accessed on February 4, 2025, https://github.com/Huachao/azure-content/blob/master/articles/sql-database/sql-database-security-guidelines.md

19. Tune applications and databases for performance in Azure SQL Database - Microsoft Learn, accessed on February 4, 2025, https://learn.microsoft.com/en-us/azure/azure-sql/database/performance-guidance?view=azuresql

20. Eight ways to optimize costs on Azure SQL | Microsoft Azure Blog, accessed on February 4, 2025, https://azure.microsoft.com/en-us/blog/eight-ways-to-optimize-costs-on-azure-sql/

21. Features comparison: Azure SQL Database and Azure SQL Managed Instance, accessed on February 4, 2025, https://learn.microsoft.com/en-us/azure/azure-sql/database/features-comparison?view=azuresql

22. Troubleshoot connection issues to Azure SQL Database - GitHub, accessed on February 4, 2025, https://github.com/uglide/azure-content/blob/master/articles/sql-database/sql-database-troubleshoot-common-connection-issues.md/?WT.mc_id=academic-96223-cyzanon

23. Troubleshoot Azure SQL Server Performance Issues - Site24x7, accessed on February 4, 2025, https://www.site24x7.com/learn/troubleshoot-azure-sql-server-performance-issues.html

24. SQL Server troubleshooting documentation - Microsoft Learn, accessed on February 4, 2025, https://learn.microsoft.com/en-us/troubleshoot/sql/welcome-sql-server

25. Troubleshoot common connection issues - Azure SQL Database & Azure SQL Managed Instance | Microsoft Learn, accessed on February 4, 2025, https://learn.microsoft.com/en-us/azure/azure-sql/database/troubleshoot-common-errors-issues?view=azuresql

26. Azure Database Pricing Examples & 5 Ways to Reduce Your Costs - Spot.io, accessed on February 4, 2025, https://spot.io/resources/azure-pricing/azure-database-pricing-examples-and-5-ways-to-reduce-your-costs/

27. How to Optimize Azure SQL Database Costs? - Turbo360, accessed on February 4, 2025, https://turbo360.com/blog/azure-sql-database-cost-optimization

28. Plan and manage costs - Azure SQL Database - Microsoft Learn, accessed on February 4, 2025, https://learn.microsoft.com/en-us/azure/azure-sql/database/cost-management?view=azuresql