What's New in SQL 2019? at the Santa Fe SQL Server User Group
Hi Santa Fe! My first remote presentation for the Santa Fe SQL Server UG was on "What's New in SQL Server 2019?" Thanks to my friend Adrian Mee for...
2020-02-13
43 reads
Azure Data Studio extension – help wanted
I’ve created a sample ads extension that checks TSQL syntax in real-time for potential bad practice. Right now the extension is using regex, which isn’t the best for parsing...
2020-02-13
82 reads
Is it really that hard to be polite, kind and respectful of those around you?
I dislike the term Politically Correct. Not because the original idea of it is a bad one, but it’s been ... Continue reading
2020-02-13
68 reads
Data Events in Australia and New Zealand in early 2020
Over the course of the next few weeks there are some significant events taking place that reflect technologies on the Microsoft data platform and beyond. Thursday 13th and 14th...
2020-02-12
65 reads
Welcome to Azure Synapse at SQL Saturday Tampa 2020
SQL Saturday Tampa is coming up again in a couple of weeks on February 29th and I’m excited to announce that I’ll be there and presenting my session Welcome...
2020-02-12
48 reads
Top 3 Database Life Hacks
Three very powerful but simple hacks that can give you back dozens of minutes per day.
Related Posts:
Best New(ish) SSMS Feature December 26, 2017
Puzzles and Daily Trivia May 14,...
2020-02-12
31 reads
Top 3 Database Life Hacks
Three very powerful but simple hacks that can give you back dozens of minutes per day.
Related Posts:
Best New(ish) SSMS Feature December 26, 2017
Puzzles and Daily Trivia May 14,...
2020-02-24 (first published: 2020-02-12)
1,459 reads
Quick tip: Quickly bulk edit lines in SSMS
Have you ever needed to bulk edit a table from excel to change it into a group of insert statements or change multiple query lines? In SQL Server Management...
2020-02-12
4,296 reads
Change Outlook sender mailbox with PowerShell – A workaround
The idea of this blog post, like many others I write, is to document a workaround solution to my problem. Hopefully I can also help someone that may be...
2020-02-21 (first published: 2020-02-12)
3,047 reads
Dealing with rejection
“Dear speaker This serves as notice that your session submission was not selected for our upcoming event. We had a lot of sessions to sort through, and unfortunately there...
2020-02-12
37 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