You know you shouldn't have production data in test environments. But every time you look at fixing it, the options feel impossible: enterprise tools that cost six figures and take months to implement, or DIY scripts that sort of work until they don't. Join this webinar on Mar 18 to learn more.
2026-03-09
This is part of a look back at the history of SQL Server Central as a part of our 25-year celebration in Feb 2026. "They want how much?" That was a question I got from Andy one afternoon as we discussed how we were going to manage the growth of SQL Server Central. I had […]
2026-02-06
2,205 reads
Continuing with Steve Jones series on string manipulation, this article looks at an interesting facet of the SELECT operator.
2026-02-05 (first published: 2001-07-04)
8,942 reads
Continuing Steve Jones' series on string manipulation in T-SQL, this article examines how quotations are handled in T-SQL.
2026-02-05 (first published: 2004-03-25)
9,093 reads
Steve Jones continues his series on string manipulation. This articles examines the issues of quotes when implementing dynamic SQL.
2026-02-05 (first published: 2002-04-04)
7,700 reads
2026-02-04 (first published: 2026-02-03)
100 reads
In this article by Steve Jones, he shows you how to manipulate strings.
2026-02-04 (first published: 2004-04-05)
17,809 reads
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
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
Hi, I have a SQL Server instance where users connect to via Windows Authentication,...
Comments posted to this topic are about the item Multiple Deployment Processes
Comments posted to this topic are about the item How to Use sqlpackage to...
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers