From portal.azure.com … Go to “Networking” section of VM. Add Inbound port rule … Port: xxxxx Protocol: Any Note: There maybe firewall port that needs to be open as well. For this, go to “Windows Defender Firewall with Advanced Security” to add new inbound rule for port xxxxx.
From portal.azure.com … Go to “Networking” section of VM. Add Inbound port rule … Port: 1433 Protocol: Any Check List: SQL Server Properties -> Connections -> “Allow remote connections to this server” is checked SQL Server Network Configuration -> TCP/IP is enabled and set to port 1433 Windows Defender Firewall with Advanced Security -> Inbound... » read more
Error: OLE DB provider “SQLNCLI11” for linked server “xxxxx” returned message “Unspecified error”. Msg 40515, Level 16, State 2, Line 1 Reference to database and/or server name in ‘xxxxx.sys.sp_tables_info_90_rowset_64’ is not supported in this version of SQL Server. Fix: Create linked server to SQL Azure Database using script. Sources: http://yasqlsb.blogspot.com/2014/07/sql-azure-linked-servers.html
Core storage services The Azure Storage platform includes the following data services: Azure Blobs: A massively scalable object store for text and binary data. Also includes support for big data analytics through Data Lake Storage Gen2. Azure Files: Managed file shares for cloud or on-premises deployments. Azure Queues: A messaging store for reliable messaging between... » read more
Today’s landscape for data warehousing is a rapidly evolving space and most of that evolution is happening in the cloud. The cloud has long offered ways to scale analytic workloads for data warehousing with services like Azure SQL Data Warehouse. However, this only solves one part of the data warehousing workload and as the complexity... » read more
https://azure.microsoft.com/en-us/features/storage-explorer/ Azure Storage Explorer Free tool to easily manage your Azure cloud storage resources anywhere, from Windows, macOS, or Linux Secure access to storage accounts Every request to Azure Storage must be authorized. Azure Storage supports the following authorization methods: Azure Active Directory (Azure AD) integration for blob and queue data. Azure Storage supports authentication and... » read more
Visual Studio Nuget Manager PM>Install-Package WindowsAzure.Storage Samples: https://azure.microsoft.com/en-us/resources/samples/storage-blobs-dotnet-webapp/
https://azure.microsoft.com/en-us/pricing/details/storage/ Blob storage is much less than file storage. Block Blobs Scalable object storage for documents, videos, pictures, and unstructured text or binary data. Choose from Hot, Cool, or Archive tiers. Prices for locally redundant storage (LRS) Archive Block Blob start from:$0.001/GB per month See Pricing Azure Data Lake Storage Combines the power of a... » read more
Expanding disk space is a common task for a Virtual Machine. This article describes the process of expanding an existing Azure Virtual Machines Disk. Please note prior to the steps described in this guide, all processes should be shutdown as the the Virtual Machine will need to be stopped and Deallocated. Azure Portal 1. Using... » read more
You can schedule the execution of Windows application using Azure WebJobs. Steps Copy .exe and supporting files to a directory. Zip up the directory. Go to Azure Portal -> App Services -> UserApp01 -> WebJobs Add Name NameOfYourJob File Upload Zipped up file Type Triggered Scale Single Instance Triggered CRON Expression Expression Frequency 0 0... » read more