Shuttle Endeavor last mission STS-134: I felt the shockwave
I witnessed a piece of history today at 8:56am; the last voyage of shuttle Endeavor on its STS-134 mission. It was...
2011-05-16
639 reads
T-SQL: Identifying, inserting and removing spaces in strings
Frequently, when working with strings you will need to identify, insert or remove spaces before, after or in between characters.
For example, you may...
2011-05-11
3,764 reads
T-SQL UPPER(): Change an all lowercase string to uppercase
The T-SQL UPPER() command allows you to change a lowercase string to an uppercase string.
For example, it will allow you to change the word...
2011-04-05
1,707 reads
T-SQL LOWER(): Change an all uppercase string to lower case
The T-SQL LOWER() command allows you to change an uppercase string to a lowercase string.
For example, it will allow you to change the word...
2011-04-02
884 reads
Word Macro to load a Data Warehouse
Recently I came across a very specific requirement for a Data Warehouse project for one of our customers. Due to...
2011-04-01
548 reads
SSAS errors: Errors in the metadata manager. The dimension with ID of ‘xxx’ referenced by the ‘yyy’ cube, does not exist.
When deploying or processing a cube or dimension you may encounter an error similar to this:
Errors in the metadata manager. The...
2011-03-22
1,255 reads
SSIS Foreach File Enumerator returns more files than expected by appending a wildcard (*) to the file mask
While working on a recent project for a customer that involved importing both Excel 97-2003 and Excel 2007/2010 files, I was...
2011-03-21
1,301 reads
Differences between Merge and Union All transformations in SSIS
What are the differences between Merge and Union All transformations in SSIS ?
The first and most obvious difference is that Merge...
2011-03-03
1,521 reads
Blogs
A New Word: Etherness
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
4 CPE Opportunity (Virtual) for Charity
By Brian Kelley
Every year, the South Carolina State Internal Auditors Association and the South Carolina Midlands...
Forums
T-SQL in SQL Server 2025: The || Operator
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Your Value from a Conference
Comments posted to this topic are about the item Your Value from a Conference
UNISTR Basics
Comments posted to this topic are about the item UNISTR Basics
Question of the Day
UNISTR Basics
What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)
SELECT UNISTR('Hello 4E16754C') AS 'A Classic';
A: 
B: 
See possible answers