No Live Blogging
The PASS Summit opens today with the first keynote. This is one of the few times that I’ve declined the...
2015-10-28
563 reads
Azure SQL Database
What hasn't received any TLC is Extended Events from the Azure SQL Database perspective. You may be wondering why it matters since I just said that Extended Events is...
2015-10-28
11 reads
Azure SQL Database
So far I have strictly focused on Extended Events for SQL Server installations. This means I have been looking at Extended...
2015-10-28
764 reads
Who’s on call
Of all the posts I’ve written I think this one is my favorite, even though it’s not a technical post....
2015-10-28
504 reads
PASS 2015 Session Report – Optimize “All Data” with a Modern Data Warehouse Solution
PASS 2015 has kicked off in Seattle, well the precon’s have anyway on Mon & Tue. The actual conference starts on Wed-Fri! I attended a precon session today called Optimize...
2015-10-28
12 reads
PASS 2015 Session Report – Optimize “All Data” with a Modern Data Warehouse Solution
PASS 2015 has kicked off in Seattle, well the precon’s have anyway on Mon & Tue. The actual conference starts on...
2015-10-28
489 reads
2015-10-27
384 reads
Hyper-V The trust relationship between this workstation and the primary domain failed
Note this fix only works on Windows Server 2012/Windows 8 or later. A different method is required on Windows Server...
2015-10-27
12,031 reads
A Great SQL in the City 2015 Seattle
Yesterday was the Seattle edition of the 2015 Redgate Software SQL in the City tour. I was in London a...
2015-10-27
539 reads
A Great SQL in the City 2015 Seattle
Yesterday was the Seattle edition of the 2015 Redgate Software SQL in the City tour. I was in London a...
2015-10-27
690 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