Tame Those Strings Part 6 - Bending Results
Continuing with Steve Jones series on string manipulation, this article looks at an interesting facet of the SELECT operator.
Tame Those Strings Part 8 - Quoting
Continuing Steve Jones' series on string manipulation in T-SQL, this article examines how quotations are handled in T-SQL.
Tame Those Strings Part 9 - Dynamic SQL
Steve Jones continues his series on string manipulation. This articles examines the issues of quotes when implementing dynamic SQL.
Expensive CPUs
Adding non-core database features to a system can expand its capabilities, but it can also be an expensive use of your hardware and software licenses.
Level 28: DAX Text Functions: The DAX Extract & Modify Functions: LEFT(), RIGHT(), MID(), REPLACE(), SUBSTITUTE()
Business Intelligence Architect, Data Analyst, CPA, and author Bill Pearson introduces a subseries surrounding the DAX Text Functions, including LEFT(), RIGHT(), MID(), REPLACE(), and SUBSTITUTE() and breaks out the operational groups of functions involved. Next, he introduces the “Extract and Modify” group of text functions as the focus of this Level. Finally, he identifies and examines each functional member of the “Extract and Modify
Tame Those Strings Part 1 - Using SUBSTRING
In this article by Steve Jones, he shows you how to manipulate strings.
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.
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.
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
How to change the FDLaunch Error log file location
The file FDLAUNCHERRORLOG gets created in the default <instance>\MSSQL\Log folder. So far, I've found...
what data type i should use for roversion col and can i use less than greater
can i use Rowversioncol ( in my database it's synonyme timestamp is used) to...
Radius Latitude Longitude
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
Question of the Day
A Fun Computer Quote
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers