Secure sensitive data with pgcrypto extension in Azure PostgreSQL Flexible Server

The pgcrypto module is a cryptographic extension that provides a number of hashing and cryptographic functions using MD5, SHA, HMAC, AES, BLOWFISH, PGP, and CRYPT, as well as DES and 3DES. 
When encrypting data, one must take into an account the m… Continue reading Secure sensitive data with pgcrypto extension in Azure PostgreSQL Flexible Server

Lesson Learned #265: Deadlock due to Non-Optimized Queries

Today, I worked on a performance case where our customer got the following error message: (‘40001’, ‘[40001] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Transaction (Process ID NNN) was deadlocked on lock resources with another process and ha… Continue reading Lesson Learned #265: Deadlock due to Non-Optimized Queries

Lesson Learned #265: Deadlock due to Non-Optmized Queries

Today, I worked on a performance case where our customer got the following error message: (‘40001’, ‘[40001] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Transaction (Process ID NNN) was deadlocked on lock resources with another process and ha… Continue reading Lesson Learned #265: Deadlock due to Non-Optmized Queries

How to reduce the total cost of ownership (TCO) of your Azure Kubernetes Service (AKS) cluster

This article contains a few recommendations for reducing the total cost of ownership (TCO) of your Azure Kubernetes Service (AKS) cluster. If you want to minimize the number of unused cores, you can use the following general guidelines to improve the d… Continue reading How to reduce the total cost of ownership (TCO) of your Azure Kubernetes Service (AKS) cluster

Getting started with Apache Log4j and Azure Data Explorer

Logging is an essential component of any good software development process. Through logging, we can detect and fix issues, understand the behavior of users, and obtain valuable business insights. However, logging involves many complex problems that we … Continue reading Getting started with Apache Log4j and Azure Data Explorer

Auditing for Named replicas and Geo replicas of Hyperscale Azure SQL Database

In this blog, we will explain how auditing works for some of the latest features for Hyperscale Azure SQL Database I.e. Hyperscale Named replicas and Geo replication & auto failover groups. 
 
Auditing for Named Replicas:  
&nbs… Continue reading Auditing for Named replicas and Geo replicas of Hyperscale Azure SQL Database