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.
Common SQL Server Problems: Invalid Length
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.
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.
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.
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.
Deploying SQL Server Developer Edition in Kubernetes: A Cost-Effective Alternative to RDS
This article shows how you can deploy SQL Server Developer Edition in an AWS Kubernetes configuration.
SQL Server 2022 Build List
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 […]
SQL Server 2025 Build List
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 […]
Blogs
A New Word: los vidados
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB 2026
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
Forums
query to track time spent on individual tasks in SSIS
Hi everyone I am looking at building a query to determine how much time...
SQL Server Transactional Replication from Always On Availability Groups to Azure SQL Database
Comments posted to this topic are about the item SQL Server Transactional Replication from...
Hidden Heroes
Comments posted to this topic are about the item Hidden Heroes
Question of the Day
Identities and Sequences I
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which are explicitly linked to increment a number in a table when a new row is added?
See possible answers