Opinions, tips, and news orbiting Microsoft
Azure Log Analytics and Automation Account (Update Management)
Introduction
Many of our customers would like to start patching servers as soon as possible using a single Update Management Solution deployed on a single Log Analytics Workspace. To a… Continue reading Azure Update Management (Log Analytics Agents & Automation Accounts)
Introduction
As security continues to be at the forefront of technology implementations, customers are looking for guidance to secure client interaction with the cloud. One such approach is to use mutual authentication (mTLS) to authenticate not just t… Continue reading Client Certificate Mutual Authentication with Application Gateway V2
I made a test in my testing environment. Below are my test results
I have 3 nodes in this Alwayson. CPS2019VM3 is DR node. I set firewall rules in VM1 and VM2 to block all network traffics from/to VM3. You can see VM3 became ‘Resolving’ state.
… Continue reading AG force failover to DR, then reconnect to Prod nodes. Will AG keep Prod data or DR data ?
1. Customer wants to use a non-sysadmin user — Test to execute ‘xp_cmdshell’. Below scripts works fine in my testing environment.
USE master;
GO
IF NOT EXISTS (SELECT 1 FROM sys.credenti… Continue reading sp_helprotect is very useful in permission issue
Are you concerned about connection failures? Are you interested in connection patterns, connection health or connection drilled down?
Getting this information can be challenging. This blog describes how to create a dashboard for monitoring purposes hav… Continue reading Create a Connectivity Dashboard for Postgres Single Server in Azure
Before implementing data extraction from SAP systems please always verify your licensing agreement.
After five episodes of going through basic data extraction scenarios, we finally can deep dive into a more advanced topic. I already explai… Continue reading Extracting SAP data using OData – Part 6 – Introduction to delta extraction
Microsoft published guidance regarding Log4j 2 vulnerability for customers using Azure Data services. Please find the latest information here:
Microsoft’s Response to CVE-2021-44228 Apache Log4j 2 – Microsoft Security Response Center
The published list… Continue reading Guidance on Apache Log4j Remote Code Execution Vulnerability
Numerous times I’ve experienced misunderstanding on licensing around constrained vCPU VMs. Sometimes the confusion is on the term, “constrained”, (I would have named this VM type, “Same CPU, bigger chassis”.) We’ll go over how we can confirm how … Continue reading Constrained vCPU and Oracle Licensing in Azure