How To Get Fired from an ETL Developer Job
Through the course of my 8-someodd years of building and fixing ETL processes, I’ve had the opportunity to see a...
2015-05-15
2,056 reads
Through the course of my 8-someodd years of building and fixing ETL processes, I’ve had the opportunity to see a...
2015-05-15
2,056 reads
Dear vendor:
Dear Vendor: Keep My Information Secure
If you’re reading this, we have done business together, either directly or indirectly. You...
2015-05-08 (first published: 2015-04-27)
5,949 reads
Object variables in SSIS are incredibly versatile, allowing the storage of almost any type of data (even .NET objects). In...
2015-04-30 (first published: 2015-04-20)
12,189 reads
In my most recent post in this series, I talked about how to use the SSIS object variable as an...
2015-04-27
4,764 reads
Everybody wants to be liked, to some extent. Being disliked by others feels like a deficiency, a shortcoming in oneself...
2015-04-24
567 reads
Some time back I wrote about how to use the script component to parse out ragged data files in SSIS....
2015-04-22 (first published: 2015-04-13)
5,999 reads
“He’s a screw-up. Always trying things that don’t work.”
I’ll be honest: I used to be afraid of being the person...
2015-04-17 (first published: 2015-04-09)
5,687 reads
The answer: It Depends.
One of the more common problems I encounter when managing data quality, especially in an ETL process,...
2015-04-15 (first published: 2015-04-06)
7,570 reads
This week, PASS announced the Best of PASS Summit 2014, a collection of the 10 highest-rated sessions from last fall’s...
2015-04-13 (first published: 2015-04-04)
5,944 reads
When I think about Baltimore, I think about Edgar Allan Poe. Baltimore was Poe’s one-time home, and in fact there...
2015-04-10
618 reads
By Steve Jones
If someone is trying to convince you it’s not a pyramid scheme, it’s a...
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
Hi experts, I have a 3+ TB database on a 2019 sql server which...
Comments posted to this topic are about the item The North Star for the...
Comments posted to this topic are about the item Multiple Escape Characters
In SQL Server 2025, I run this code (in a database with the appropriate collation):
SELECT UNISTR('%*3041%*308A%*304C%*3068 and good night', '%*') AS 'A Classic';
What is returned? See possible answers