T-SQL in SQL Server 2025: Concatenating Strings

Like many of you, I have often put strings together (concatenation) with a simple arithmetical operator: +.  We have a few other ways to put strings together, but in SQL Server 2025, we have a new operator that allows us to put strings together. This is the double pipe (||) operator. This article looks at […]

JSON_CONTAINS Function in SQL Server 2025

I have data coming into my SQL Server database as JSON. Before I start parsing it which is quite intensive, I need to check if some values are present in the JSON. Is there a function I can use to do this? Let’s see what the new JSON_CONTAINS function in SQL Server 2025 can do.

Unlocking the Power of FULL OUTER JOIN in SQL: Performance, Use Cases & Examples

Discover how the FULL OUTER JOIN in SQL can simplify queries, improve performance, and solve real-world data problems

SQL Server CROSS APPLY and OUTER APPLY Helpful Examples

Microsoft introduced the APPLY operator in SQL Server 2005. Similar to a JOIN, it allows correlation between two table expressions. The key difference between the JOIN and APPLY operators is when you have a table-valued expression on the right side and want to evaluate it for each row from the left table expression. Since they produce similar results, when do you choose an APPLY versus a JOIN?

T-SQL in SQL Server 2025: Substring Changes

This article takes a look at the changes in SQL Server 2025 to the SUBSTRING function.

Regular Expressions in SQL Server 2025

This article examines the new regular expression functions added to T-SQL in SQL Server 2025.

SQL EXISTS Use Cases and Examples

I’ve seen the SQL EXISTS keyword in Microsoft SQL Server T-SQL code and don’t understand it well. What does it do? How do I use it? Are there best practices around SQL IF EXISTS?

T‑SQL BULK INSERT vs OPENROWSET: CSV Imports, File Access Gotchas, and A PowerShell Script

Most SQL bulk insert and SQL Server openrowset tutorials skip file access issues that can stop imports cold. Both the bulk insert statement and openrowset function rely on the SQL Server service account to read a source file. The SQL Server service account must have read permission on the file or its folder. It is also convenient to have read & execute as well as list folder content permissions.

PWDCompare

Use SQL to Find a String in Database Tables, Stored Procedures, and User Defined Functions

Searching for a string in database tables has been discussed over the years. There are several approaches to the problem (see References at the end of the article). See how to use SQL to find a string in different types of SQL Server objects and data.