Sights that just scream, “No!”
I’m at a conference, specifically a security conference. So I looked at the available WiFi connections. Among the conference and hotel specific...
2016-06-07
456 reads
Power BI Custom Visuals Class (Module 02 – Enlighten Aquarium)
In this module you will learn how to use the Enlighten Aquarium Power BI Custom Visual. While it might not...
2016-06-07
1,847 reads
Incomp…
This is about analytics.
This is about day to day life.
This is also about how the things should not being done.
Incomp…...
2016-06-07
561 reads
InsideSQL–The Deep Dive
There’s a new conference in London next week, the InsideSQL conference on June 14th. It’s at the CodeNode venue, near...
2016-06-07
485 reads
AG Worker Thread Blocked by Log Backup
We have an internal monitoring query that checks for system threads that are blocked. Recently, we received an alert email...
2016-06-15 (first published: 2016-06-06)
2,131 reads
PowerShell – Install PowerShell
Recently got a question regarding PowerShell installation hence this post took an existence.
How to Install PowerShell various versions
http://technet.microsoft.com/en-us/library/hh847837.aspx
http://social.technet.microsoft.com/wiki/contents/articles/21016.how-to-install-windows-powershell-4-0.aspx
Can we have...
2016-06-06
658 reads
Painting with PowerShell: SQL Server Administration
This blog post is just a quick follow from my presentation last week for the SQL PASS PowerShell Virtual Chapter.
Here...
2016-06-06
463 reads
SQLSaturday Iowa City is this weekend!
If you’re within driving distance of Iowa City, IA, I’d love to see you at SQLSaturday Iowa City this weekend!...
2016-06-06
439 reads
Monday Morning SQL Break – June 6, 2016
It’s Monday time for this week’s Monday Morning SQL Break. A chance to catch up on links I’ve shared and...
2016-06-06
422 reads
SQL Compare 12 Beta
The Beta is out. I’ve been waiting for this, and was glad to see Carly’s post on the product. I’ve...
2016-06-06
1,342 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