Getting AAD token with silent login

Sometimes devops need their apps to perform some operation as a human, such as stopping a virtual machine when monitoring system alarms, as traditional ways of azure authorization such as management certificates or profile file  grant too much permission and may cause security risks, ARM and RBAC is quite recommended to fully organize and control access to … Continue reading Getting AAD token with silent login

BCP to quick move data between SQL and Data Warehouse

A common need from real scenario is to sync data between SQL(either SQL Server in private environment or SQL Database on cloud) and SQL Data Warehouse, given SQL Data Warehouse decoupled computing(engine for running SQL queries and SQL  requests) and storage(data storage and indexing), using SQL Data Warehouse lets users have option to stop computing anytime for saving cost … Continue reading BCP to quick move data between SQL and Data Warehouse

Practice Reference with Redis Cache in China Azure

Some points of using Azure Redis Cache: By default, items in the cache do not expire, but an expiration can be configured on a per write basis using cache set overloads. For each cached item in Redis Cache, when storing that in Redis, there is option to set a sliding or explicit expiration time for … Continue reading Practice Reference with Redis Cache in China Azure

Invalid object name ‘dbo.vTargetMail’ in Adventure Works

when practicing Azure Machine Learning, Azure PowerBI or other DB based services, it is common to have a databased named Adventure Works as prerequisite in your SQL Server/Warehouse. However, even when following the tutorial https://azure.microsoft.com/en-us/documentation/articles/sql-data-warehouse-get-started-manually-load-samples/, you may still hit problem like “Invalid object name ‘dbo.vTargetMail’”, which indicates there was no such view(table) in the sample … Continue reading Invalid object name ‘dbo.vTargetMail’ in Adventure Works

Comparing service endpoints in Global Azure and China Azure

Here are some endpoints devops will connect and run customer calls, keep a note. Service Type Global Azure URI China Azure URI Portal http://manage.windowsazure.com http://manage.windowsazure.cn Cloud Service *.cloudapp.net *.chinacloudapp.cn Microsoft Azure Storage *.blob.core.windows.net *.queue.core.windows.net *.table.core.windows.net *.blob.core.chinacloudapi.cn *.queue.core.chinacloudapi.cn *.table.core.chinacloudapi.cn Service Management https://management.core.windows.net https://management.core.chinacloudapi.cn/ SQLDatabase *.database.windows.net *.database.chinacloudapi.cn SQLDatabase Management API https://management.database.windows.net https://management.database.chinacloudapi.cn Service Bus *.servicebus.windows.net *.servicebus.chinacloudapi.cn ACS … Continue reading Comparing service endpoints in Global Azure and China Azure

How to check version of Azure PowerShell and Azure SDK

Usually Azure DevOps need check version of Azure PowerShell and Azure SDK,that is to ensure the required PowerShell commands and Azure API are packaged there, here below are quick ways to go: Check version of Azure PowerShell launch Azure PowerShell as admin, then run commands below: $name=’Azure’ if(Get-Module -ListAvailable | Where-Object { $_.name -eq $name … Continue reading How to check version of Azure PowerShell and Azure SDK