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,849 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,132 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
423 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
Split Large Queries in Athena with a Simple Modulo Trick
Comments posted to this topic are about the item Split Large Queries in Athena...
Finding Trailing Spaces
Comments posted to this topic are about the item Finding Trailing Spaces
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