Universal SQL Installations Framework (Script review and Demo)
on 19th sep 10.00 am pst, i will be speaking on “universal sql installations framework” @ sqlsaturday, san diego!!, if you...
2015-09-18
685 reads
Recommendations, Endorsements, and More on the 2015 PASS Election
We have four good candidates this year, of which two are incumbents. I was asked by Argenis and Tim to...
2015-09-17
632 reads
Getting data into Azure Blob Storage
If you have on-prem data and want to copy it to Azure Blob Storage in the cloud, what are all...
2015-09-17
1,135 reads
PASS Election Questions Answered 2
Today I am going to continue with my PASS Election Questions and Answers series. Here is where you can find...
2015-09-17
618 reads
Data Types in Extended Events
Today I get to talk about data types within Extended Events. This also means, I hope to be able to bring a little more clarity to the topic.
Related Posts:
Implicit...
2015-09-17
13 reads
Data Types in Extended Events
Today I get to talk about data types within Extended Events. This also means, I hope to be able to...
2015-09-17
637 reads
Reblog: The Magic Alt Button
SQLKover update: I love this trick! I use it daily, no kidding (except in weekends). Want to see it in live...
2015-09-17
649 reads
Voting in the PASS Election 2015
Another year, another set of elections. It’s that time where those who care about their industry and the future of...
2015-09-17
652 reads
#ITDevCon15 Conner Cunningham Keynote
On Wednesday morning, Conner Cunningham from Microsoft was the keynote speaker for IT/DevConnections in Las Vegas. His talk focused on...
2015-09-17
419 reads
#MDXMonday: Finding the Current Day
This week I’m teaching the Pragmatic Works Intro to MDX virtual training class. A student in the class asked how...
2015-09-16
469 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