Azure SQL Archives - Jonathan Crozier

How to get the email address of the current user from an Azure SQL Database

When working with an Azure SQL Database, you may find the need to determine who is currently connected. This could be for auditing purposes, for populating a ‘Created By’ column, or simply for troubleshooting a permissions issue. If your users authenticate using Microsoft Entra ID (formerly Azure Active Directory), the identity in question is usually…

How to generate batches of SQL Server INSERT statements with the maximum allowed number of row values

InSQL

When working with SQL databases, you may find the need to copy data from one table into another table with an identical or similar schema, either within the same database or across different databases. Often in these cases, the volume of data you need to copy will be quite large, and therefore, performance will be…

Working with JSON functions in SQL Server

InSQL

JSON has become the de facto standard for data interchange and its ubiquity in modern software applications makes the support that SQL Server offers for working with JSON more relevant than ever. Whether you’re developing APIs, dealing with semi-structured data, or storing configuration, the ability to handle JSON natively at the SQL level will help…

Finding and deleting duplicate records from a SQL Server database

InSQL

Sometimes duplicate data can make its way into a database, whether it be due to a software defect or as the result of an error that one or more users have made. Regardless of the cause, you may find yourself in a position where you need to find and delete duplicate records from a database….

Query to find table names in a SQL Server database

InSQL

When working in a SQL Server or Azure SQL database containing many tables, I often find the need to search for tables with names that contain a specific keyword. This is particularly true when working with an unfamiliar schema. While tools like Azure Data Studio provide easy ways to search by table name, I find…

Tag: Azure SQL

How to get the email address of the current user from an Azure SQL Database

How to generate batches of SQL Server INSERT statements with the maximum allowed number of row values

Working with JSON functions in SQL Server

Finding and deleting duplicate records from a SQL Server database

Query to find table names in a SQL Server database

How to get the email address of the current user from an Azure SQL Database

How to create a reusable Blazor Text component with a customisable HTML element

How to create a reusable Blazor Tooltip component with CSS anchor positioning