Audit All Select Statements
Legislation and regulation sometimes dictates that certain activities must be tracked within a database. On occasion, it will be required...
2016-08-15 (first published: 2016-08-08)
2,582 reads
Top 5 books on Enterprise Architecture
My post the top 3 books for becoming TOGAF certified punlished last week looked at books on preparing for the...
2016-08-08
443 reads
Current Running Queries
Following script is perhaps the most executed script in my 10 year Database Administration career. The script has been my...
2016-08-11 (first published: 2016-08-07)
3,082 reads
Create a Date Dimension in Azure SQL Data Warehouse
Most data warehouses and data marts require a date dimension or calendar table. Those of us that have been building...
2016-08-11 (first published: 2016-08-06)
2,460 reads
AlwaysON database NOT SYNCHRONIZED and RECOVERY PENDING
AdvertisementsAlwaysON database NOT SYNCHRONIZED and RECOVERY PENDING
I have recently come across an issue that, one of my alwaysON secondary replica...
2016-08-16 (first published: 2016-08-06)
16,376 reads
BIT9 PathNames
We live in a day and age when security (data, network, server, etc) is seemingly at the forefront of the daily news.
Related Posts:
Cannot Open Backup Device January 1, 2020...
2016-08-05
10 reads
BIT9 PathNames
We live in a day and age when security (data, network, server, etc) is seemingly at the forefront of the...
2016-08-05
1,052 reads
What is the Lambda Architecture?
Lambda architecture is a data-processing architecture designed to handle massive quantities of data (i.e. “Big Data”) by using both batch-processing and...
2016-08-08 (first published: 2016-08-05)
3,250 reads
Visual Studio Live!–Washington DC–Save with me
I’m going to be speaking this fall at Visual Studio Live, Washington D.C. edition on Oct 3-6. This is my...
2016-08-05
461 reads
2016-08-05
194 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