SQL & KQL
Comparison of Azure SQL Managed Instance, Azure SQL Database, Azure SQL Server
Azure offers several SQL-related services, each tailored to different use cases and requirements. Below is a comparison of Azure SQL Managed Instance, Azure SQL Database, and Azure SQL Server (often referred to as a logical SQL Server in Azure)
Configuring Azure Entra ID Authentication in Azure SQL Database
Azure SQL Database can be integrated with Azure Entra ID to provide identity and access management. more …
Using SQL Server Change Data Capture (CDC) in pipeline to implement incrementally UPSERT
SQL Server Change Data Capture (CDC) is a feature that captures changes to data in SQL Server tables. more ...
SQL Query Across All Databases to Find the Object
The sp_MSforeachdb procedure is an undocumented procedure that allows you to run the same command against all databases. more …
Kusto Query Language (KQL) – quick reference
It is for the new KQL engineer to quick reference only. more …
KQL query map SQL query
The following table shows sample queries in SQL and their KQL equivalents. more …
Summary of Commonly used T-SQL Built-in Functions
Summary of Commonly used T-SQL queries
Locking Mechanisms in Relational Database Management Systems (RDBMS)
In relational databases, locks are essential mechanisms for managing concurrent access to data. They prevent data corruption and ensure data consistency when multiple transactions try to read or modify the same data simultaneously.