Question : I have a stored procedure which returns results from an indexed view via a covering index. Usually, it […]
Tag: azure-vm
Why is my Azure SQL Server so slow?
Question : We currently have a VM that is very underpowered and are proposing to move to an Azure VM […]
Azure VM backup best practice
Question : I have a customer who has just lifted-n-shifted their 1TB SQL Server 2008 R2 production, and QA servers […]
Backup SQL Server to Google Drive
Question : I have Microsoft SQL Server 2014 on an Azure VM (Windows Server 2012 R2) with one database. Is […]
Does SQLBackup2Azure delete the blobs as well?
Question : I am not sure if this questions belongs here or in server fault, apologies if it belongs there. […]
Backing up databases on SQL Server hosted in Windows Azure VM
Question : One of the clients at my workplace asked me to find out information on what would be the […]
Is it possible to Increase storage performance in azure vm using disk striping?
Question : Given the following Azure VM: E8s_v3 (8 cpu, 64 GB RAM, 12800 IOPS, 192 MBps) I added 2 […]
What is limiting the batch requests per sec
Question : We have a newly created Azure SQL Server 2014 instance. The specs for the server are as follows […]
Do I need a separate server for Quorum?
Question : We are working on setting up AlwaysOn Availability Group for SQL Server 2014. There will be 2 nodes: […]
Change default collation when provisioning a SQL Server VM in the Azure portal
Question : Is there a way to change the default SQL collation directly from the “Create virtual machine” wizard in […]