Chopping Off Data
An ETL issue with Excel causes issues, because the users didn't realize a limitation.
2026-01-03 (first published: 2020-10-19)
312 reads
An ETL issue with Excel causes issues, because the users didn't realize a limitation.
2026-01-03 (first published: 2020-10-19)
312 reads
We need data that represents the problem we want to solve, or we might not achieve our aims.
2026-01-03 (first published: 2021-01-21)
107 reads
If someone is trying to convince you it’s not a pyramid scheme, it’s a pyramid scheme – from Excellent Advice for Living For sure. As much as I am...
2026-01-02
9 reads
2026-01-02
186 reads
2026-01-02
39 reads
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t do this natively, as this really needs an XEvent session. I decided to see if...
2026-01-02 (first published: 2025-12-17)
1,576 reads
Business Intelligence (BI) tools like Power BI are used by a wide range of professionals, creating diverse and complex scenarios, and finding the right solution can be daunting, especially when multiple approaches exist for a single use case. The author distills his 17 years of experience on various data platform technologies in this book to walk you through various Power BI usage scenarios.
2025-12-31 (first published: 2025-05-27)
3,778 reads
2025-12-31
54 reads
2025-12-31
1,026 reads
I was looking back at my year and decided to see if SQL Prompt could help me with some analysis. I was pleasantly surprised by how this went. This...
2025-12-31
28 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