SQL Code Guard 2.9 released
Nothing special - just signed with renewed code sign certificate, small fixes, etc
Have fun!
Wait a minute! Almost forgot.
More great news coming...
2017-02-22
809 reads
New developer build of SQL Code Guard released
Issues fixed since last developer build
[*] fixed incorrect binding of MI008 to MI007
[*] fixed xtra EI028 in case with named...
2016-03-09
1,022 reads
SQLSaturday 426, Lviv, Dec 05 - only few days left!
Last changes and preparation for SQLSaturday in Lviv - http://sqlsaturday.com/426/EventHome.aspx
You still have a time to register and attend it.
Great city, great...
2015-12-01
546 reads
Support for SSMS 2016 now available
Good news!
Red-Gate published new version of its SIPF framework with support of SSMS 2016!
Now you can simply download and install...
2015-11-11
568 reads
Catching specific statements using new MI008 "Statement used" rule
Imagine that you want (for some reason) prohibit usage of some statement (or statements), eg - CURSOR
How can you find if...
2015-11-05 (first published: 2015-10-30)
1,867 reads
I'm alive!!!!
Hi all!
Sorry for long delay but i was a pretty busy preparing SQLSat
Now mission is accomplished and i'll return to...
2015-09-21
458 reads
ExpressProfiler: say "Hi!" to new developer!
I glad to introduce new member of Express Profiler team - Chris Moore!
He has many ideas and eager to implement them.
Welcome...
2015-06-25
549 reads
SQL Code Guard - Developer build: just as planned
Well, not exactly just as planned, but at last!
Few minor fixes
[*] fixed unparsed with CONTAINS condition[*] fixed xtra "ST010 Use...
2015-06-24
631 reads
SQL Code Guard - developer builds
Hi all
Unfortunatelly I'm pretty busy now and will be busy till end of the year
So I have not so much...
2015-06-16
582 reads
SqlSaturday 377, Kiev, May 23 - only 3 days left
Hello everyone!
As you may already know - on 23rd May in Kiev will be held SqlSaturday 377.
Hurry up!
You can meet many...
2015-05-20
485 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