SUBSTRING, PATINDEX and CHARINDEX string functions in SQL queries

Read SQL Server Data into a Dataframe using Python and Pandas

Proton: Probing Schema Linking Information from Pre-trained Language Models for Text-to-SQL Parsing | Proceedings of the 28th ACM SIGKDD Conference on Knowledge Discovery and Data Mining

Filtering XML Columns using XQuery in SQL Server

Import XML documents into SQL Server tables using SSIS packages

How to parse JSON in SQL Server

How to identify and tune a problematic query with SQL EXPLAIN

Common SQL syntax errors and how to resolve them