Welcome back to my series on Power Platform quick tips! In this episode you will learn how to document your flow logic with comments.
2019-12-17 (first published: 2019-12-06)
523 reads
Maybe you’re using DevOps within your database development and deployment. Maybe you’re not. Maybe you’re automating all the things or maybe you’ve got a completely manual set of processes....
2019-12-06
55 reads
Heading to PASS Summit… It is Sunday the week of PASS Summit and I am at the airport after a relaxing morning with my wife and son. Unfortunately, I...
2019-12-06
17 reads
A few weeks ago I attended the annual PASS Summit conference in beautiful Seattle, Washington. This is an event that I look forward to every year. Being able to...
2019-12-06
8 reads
This is for me, not necessarily for you, but I decided to go with the HP Spectre again. I saw an email from Best Buy over the Thanksgiving weekend,...
2019-12-06
55 reads
This is the fourth and final post in a series about modern Data Lake
Architecture where I cover how we can build high quality data lakes using
Delta Lake,...
2019-12-06
95 reads
This is the fourth and final post in a series about modern Data Lake
Architecture where I cover how we can build high quality data lakes using
Delta Lake,...
2019-12-06
93 reads
This is the fourth and final post in a series about modern Data Lake
Architecture where I cover how we can build high quality data lakes using
Delta Lake,...
2019-12-16 (first published: 2019-12-06)
1,199 reads
We just had our final event of the year and looking back, not bad at all. No event in June or November, but 18 overall (16 listed below, plus...
2019-12-05
35 reads
I love this error. Primarily because it demonstrates two very important things. Errors matter. Make sure when you ask someone ... Continue reading
2019-12-11 (first published: 2019-12-05)
670 reads
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
Comments posted to this topic are about the item Split Large Queries in Athena...
Comments posted to this topic are about the item Finding Trailing Spaces
I have some data in a SQL Server 2025 database. It looks like this for the dbo.Customer table:
CustomerID CustomerName PreferredName 1 Steve Steve 2 Andy Andy 3 Brian Brian 4 Allan Allan 5 Devin Devin 6 Steve Steve 7 Sally SallyI want to detect which names have a single trailing space. The CustomerName is a varchar() and the PreferredName is a CHAR(). Does this query detect the problem rows?
SELECT
CustomerID,
CustomerName,
PreferredName
FROM Customer
WHERE CustomerName <> RTRIM(CustomerName)
OR PreferredName <> RTRIM(PreferredName); See possible answers