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,915 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,722 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,201 reads
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)
252 reads
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)
20 reads
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,659 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,927 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,652 reads
2026-02-02
153 reads
At Redgate, we’re experimenting with how AI can help developers and DBAs become better at their jobs. Everyone is asking for AI, as well as the ability to turn...
2026-02-02 (first published: 2026-01-23)
96 reads
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
We have two "identical" instances of an ASP.NET web service (or so I have...
Comments posted to this topic are about the item OPENQUERY Flexibility
Comments posted to this topic are about the item A Full Shutdown
Which of these are valid OPENQUERY() uses?
See possible answers