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,897 reads
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,696 reads
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,189 reads
This is another part in my series designed to offer guidance around common issues in SQL Server. Today, let’s talk about the all-too-common error: invalid length.
2026-02-04
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,636 reads
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,917 reads
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,639 reads
This article shows how you can deploy SQL Server Developer Edition in an AWS Kubernetes configuration.
2026-02-02
997 reads
This is a list of the builds for SQL Server 2022. There are other build lists available here. A list of all the builds that I can find and install on my Build VM. If you find a build not listed here, please let the webmaster know (webmaster at sqlservercentral.com). All builds are listed in reverse […]
2026-02-02 (first published: 2022-09-01)
4,709 reads
This is a list of the builds for SQL Server 2025. There are other build lists available here. A list of all the builds that I can find and install on my Build VM. If you find a build not listed here, please let the webmaster know (webmaster at sqlservercentral.com). All builds are listed in reverse […]
2026-02-02 (first published: 2025-11-24)
842 reads
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Comments posted to this topic are about the item GPX distance and time analysis...
Comments posted to this topic are about the item The DBA is Dead; Long...
Comments posted to this topic are about the item Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers