How to Become a SQL Server Database Administrator
I wrote How to Become a SQL Server Database Administrator (email address required for download) a few years ago as a project...
2017-04-03
533 reads
Olcot and Arratoon Ancestry
I have spent a fair amount of time researching the Olcot and Arratoon ancestry and I am very interested in the family tree, especially pre 1900 in India. If...
2017-04-03
38 reads
Tuga IT 2017 Tickets are on sale
I am glad to announce thatTuga IT 2017 Tickets are finally on sale!
Wait a second, you might think – on sale?...
2017-04-03
342 reads
Monday Coffee 2017-04-03
Last week Pass announced changes to how speakers are going to be selected for their annual conference (you can read...
2017-04-03
141 reads
Monday Coffee 2017-04-03
Last week Pass announced changes to how speakers are going to be selected for their annual conference (you can read...
2017-04-03
282 reads
Preconference Session at SQL Nexus – SQL Server Virtualization
If you are attending this year’s SQL Nexus conference in Copenhagen, Denmark, from May 1st to 3rd this year, I...
2017-04-03
424 reads
Custom Handling Flat File Output of an SSIS Package with the Script Component
I recently had a requirement to remove the last Carriage Return <CR> and Line Feed <LF> characters when outputting a...
2017-04-02
3,817 reads
Can I tune the tempDB of an Azure based SQL Server database…
Yip. You can.
I was originally going to write this post about tuning tempDB in our Azure SQL database. Which would...
2017-04-02
392 reads
Columnstore Indexes – part 101 (“Estimated? Similar! Similar How?”)
Continuation from the previous 100 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blogpost will focus on warning you...
2017-04-01
408 reads
SQL Server DBCC CHECKDB
A quick video clip where I show two things. Firstly I show how since SQL Server 2014 SP1+ the snapshot...
2017-04-01
382 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