Tame Those Strings Part 9 - Dynamic SQL

Steve Jones continues his series on string manipulation. This articles examines the issues of quotes when implementing dynamic SQL.

Creating JSON I

Expensive CPUs

Adding non-core database features to a system can expand its capabilities, but it can also be an expensive use of your hardware and software licenses.

Tame Those Strings (Series)

A series of articles that deal with string manipulation techniques.

Tame Those Strings Part 1 - Using SUBSTRING

In this article by Steve Jones, he shows you how to manipulate strings.

Tame Those Strings! Part 10 - Finding Carriage Returns

Expanding on his series of string manipulation in T-SQL, Steve Jones takes a look at how you go about removing those unseen characters from your strings.

Tame Those Strings! Part 2 - Using CHARINDEX

The second part of Steve Jones's series on programming and manipulating strings in T-SQL.

Tame Those Strings! Part 3 - Using REPLACE

The third part of Steve Jones's series on programming and manipulating strings in T-SQL dealing with REPLACE.

Using AI for Git Hooks

Recently I had someone internally ask about whether SQL Source Control supports Git Hooks. Since it was after UK work hours, I decided to run a quick test. One...

Monday Monitor Tips: SQL Auditing Preview

One of the features we advocates have been advocating for is a better way to track security changes in your SQL Server instances. The first slice of this work...