2026-02-04 (first published: 2026-02-03)
102 reads
Steve Jones
- Interests: yoga, reading, biking, snowboarding, volleyball
- Twitter: @way0utwest
- Website: https://www.voiceofthedba.com
- LinkedIn: https://www.linkedin.com/in/way0utwest
- Bluesky: way0utwest.bsky.social
- Threads: @way0utwest
Tame Those Strings Part 1 - Using SUBSTRING
In this article by Steve Jones, he shows you how to manipulate strings.
2026-02-04 (first published: 2004-04-05)
17,833 reads
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.
2026-02-04 (first published: 2007-02-13)
12,942 reads
Tame Those Strings! Part 2 - Using CHARINDEX
The second part of Steve Jones's series on programming and manipulating strings in T-SQL.
2026-02-04 (first published: 2002-05-31)
15,734 reads
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.
2026-02-04 (first published: 2001-04-18)
17,203 reads
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...
2026-02-04 (first published: 2026-01-26)
255 reads
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...
2026-02-03 (first published: 2026-02-02)
21 reads
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.
2026-02-03 (first published: 2001-04-18)
9,664 reads
Tame Those Strings! Part 5 - Using STUFF
The fifth part of Steve Jones's series on programming and manipulating strings in T-SQL dealing with STUFF.
2026-02-03 (first published: 2001-06-21)
10,929 reads
Tame Those Strings! Part 7 - Proper Casing Strings
Need to proper case names? Want a quick way to reformat a series of words? This article examines a SQL approach to quickly proper casing all words in a field.
2026-02-03 (first published: 2001-10-24)
12,673 reads
Blogs
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Designing a Storage Load Test for SQL Server
I’ve been doing storage load tests for SQL Server for a long time, both...
Forums
A question about how to store the address in the database
I have an app that has an address field on the customer and the...
SSIS package failing intermittently on last Excel Component
Good Afternoon, I have a Job which "fires" off an SSIS package (that is...
T-SQL in SQL Server 2025: JSON_ARRAYAGG
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Multiple Sequence Values
How do I easily get the next 12 sequence values from a sequence object?
See possible answers