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

Tame Those Strings! Part 4 - Numeric Conversions

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