Azure SQL Archives - Jonathan Crozier

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

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 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

Getting started with GitHub Copilot in Visual Studio

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

Treat Blazor component Warnings as Errors: Found markup element with unexpected name