Automating Azure Resource Management Authentication
I love Azure and I love PowerShell. They are a perfect marriage. It’s amazing how much automation you can do...
2016-06-23
545 reads
Comparing databases using SSDT
Another Twitter-born blog post! I love getting new ideas from the community. Real world ideas for solving real world problems!
The...
2016-06-23
1,284 reads
Selecting Speakers for the Summit
This is a series of posts on the PASS Summit and SQL Saturdays. I’m outlining some thoughts here, sometimes for...
2016-06-23
498 reads
Azure SQL Data Warehouse pricing
The pricing for Azure SQL Data Warehouse (SQL DW) consists of a compute charge and a storage charge. For compute, it is...
2016-06-23
917 reads
I’m speaking at Summit!
I’m excited to announce that I have been selected to speak at PASS Summit again this year! I’ll be presenting...
2016-06-23
347 reads
What if Your Employer Won’t Support Your Career?
I’ve had a lot of luck in my career, especially as it pertains to my work environment. Although I can’t...
2016-07-01 (first published: 2016-06-23)
2,046 reads
Comparing databases using SSDT
Another Twitter-born blog post! I love getting new ideas from the community. Real world ideas for solving real world problems!
The...
2016-06-23
329 reads
Azure Cortana Intelligence Suite – with Azure Data Catalog
[read this post on Mr. Fox SQL blog] I presented at our local Melbourne SQL Server User Group (SSUG) this week on Azure Cortana Intelligence Suite – and the integration with the...
2016-06-23
21 reads
Azure Cortana Intelligence Suite – with Azure Data Catalog
[read this post on Mr. Fox SQL blog]
I presented at our local Melbourne SQL Server User Group (SSUG) this week on Azure Cortana...
2016-06-27 (first published: 2016-06-23)
1,888 reads
PASS Nominating Committee Update
Today PASS released a bunch of stuff for the upcoming election including the attributes of an “ideal candidate”. We put...
2016-06-22
421 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
Forums
ALAMAT BCA KCU SURYOPRANOTO Tlp:08218520154
WhatsApp CS 628218520154 Jl. Suryopranoto No.40, RT.12/RW.7, Petojo Utara, Kecamatan Gambir, Kota Jakarta Pusat,...
Alamat BCA KCP Sentral Cikini Telp:08218520154
WhatsApp CS 628218520154 Jl. Pegangsaan Timur No.1, Cikini, Kec. Menteng, Kota Jakarta Pusat, Daerah...
Alamat BCA KCP Pintu Air Telp:08218520154
WhatsApp CS 628218520154 Jl. Pintu Air Raya No.36 Q, RT.6/RW.1, Ps. Baru, Kecamatan Sawah...
Question of the Day
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