Using RDM gives more flexibility to the developer in terms of what their applications can do without a dependency on maintaining a connection to an Azure instance. Conclusion Azure SQL Database Edge comes with
Azure SQL Managed Instance Azure SQL Database tuning recommendations are generated by Azure SQL Databaseautomatic tuning. This solution continuously monitors and analyzes workloads of databases providing customized tuning recommendations for each individual database related to index creation, index deletion...
Change Azure SQL Server connection policy to proxy Create a Global Secure Access application for the Azure SQL server Validate the configuration Next steps Access Azure services using Microsoft Entra Private Access with a virtual network service endpoint. The combination provides direct connectivity ...
We are primary focusing on the most common tasks, with the first group of posts focusing on the SQL Managed Instance Service Discovery, but with the time more functional and more advanced topics will be landing in this series soon. You can find and reference the whole series with the followi...
We have SQL MI with these settings: Service Tied: Critical vCores: 16 Storage GB: 320 I ran the query to know the database file sizes as shown in the image down below: And there are a few things that pay my attention: 1. I am getting "-1" on my F...
One of my Application server has been restarted yesterday, we would like to know how to find the login information and the IP details of the server. Please help me how to get the information who did restarted SQL services!Thanks in advance,...
Even though Azure SQL Database provides built-in backup, you may still want to create a local copy of your Azure SQL database. This could be handy for example when you want to keep database backup copy for free longer than allowed by Microsoft Azure built-in tools which are usually 7 ...
using a server application or service to access the blob storage, you can create IP restrictions to make the key more secure. If the service is on Azure, I would build a private network first. In this example, you are running the queries from the Synapse Workbench, so leave the field ...
Find your subnet using Azure portal, go to details and make sure that: You have a Managed Instance Route table assigned to the subnet There should be no Networks Security Groups in your subnet. There should be no service-endpoint in your subnet. There are no other resources in su...
One of the reasons that SQL Azure is such a powerful tool is that it's based on the same database engine as SQL Server. For example, you can connect to the Microsoft SQL Azure Database with the sqlcmd command prompt utility that is included with SQL Server. The sqlcmd utility ...