Azure SQL Elastic Database Query and Cosmos DB

I’ve found functionality and tutorials that describe how to link an external Cosmos DB database to SQL server: https://samtran.me/2017/10/07/linked-servers-for-azures-nosql-cosmosdb/ Which would be really fantastic in joining IoT data I have with relational data about the customer. However, I’ve yet to find if this functionality exists using Azure SQL server. Does anyone have any insight or […]

Vsts build and release is confusing

Hello, I have a repo that when ever I commit code, I want it to copy the new code somewhere else. So I followed this tutorial https://docs.microsoft.com/en-us/vsts/pipelines/apps/cd/deploy-webdeploy-iis-deploygroups?view=vsts and when I commit new code it deploys the script but I added it to create a new directory in the C drive but it does not do […]

Azure Static IP for VPN?

I am establishing a site to site vpn from on prem to Azure, however, i cannot assign a static public ip to it. Per this link, https://docs.microsoft.com/en-us/azure/virtual-network/virtual-network-ip-addresses-overview-arm, it’s designed that way. “VPN gateways An Azure VPN Gateway connects an Azure virtual network to other Azure virtual networks, or to an on-premises network. A public IP […]

[IMPORTANT] repair RDP (Windows based VM)

sometimes, after a VM subscribes to an AD, is unsubscribed and then subscribes to the same AD, or the machine as been patched, the RDP connection is loss. to fix this, go to Extension list, add, choose “Custom Script Extension” , and then upload a .ps1 file with Set-ItemProperty -Path ‘HKLM:SYSTEMCurrentControlSetControlTerminal ServerWinStationsRDP-Tcp’ -name “SecurityLayer” -value […]